almost 30 years computer software experience both in systems and application programming
worked in many projects mainly retail and aviation
40 Posted Topics
 | [QUOTE=reevenz;828688]Hi All, I am going to write a small inventory tracking app for a small company. What they need is only to keep track goods in, goods out, supplier, customer, and purchase price and sell price so we are able to calculate purchase price, sales price, and stock value. [LIST=1] … |
| | Re: POS Design [QUOTE=Lady_Dex;1190607]Hi Poymode Option 2 is a much better approach. How about renaming the ORDER table to be PURCHASE_LINE or PURCHASE DETAIL, something like that so it indicates that the table is the related to the purchases. Depending on how complex the business requirements are, you may need to look at … |
 | in my country Indonesia and I think may be in the other developing country XP is still widely used. the people don't consider security threat very seriously because most hoem computers or laptop don't connect to the internet or may be only occasionally. and as we know XP is very … |
| | first of all are u sure it is a case study, for me it seems to be a complete inventory system in retail. As far i understand retail inventory is one of the most complex inventory system. But I will try to help u. I will address the issues one … |
 | [QUOTE=ana_eht;1184897]Hi it's me again with the silly problems in my vb .net codes :( I have a serious problem with combo box i need to use the selected item in combo box when user selects for example GREEN from be drop down list after than i need to put that … |
| | [QUOTE=Oxiegen;1208214]Why not locate and remove any reference to Global.ExampleProject.My.Resources.Resources alltogether? Is it essential for either your projects or the functionality of VS2010 Express in any way?[/QUOTE] also u can check just to ensure that u don't refer to example.png if it still don't work maybe u could ask Microsoft whether … |
| | Re: Which Database? for this magnitude of data i think you need a real database not like MS-Access, which sometimes called as database also but actually it is not |
| | 1. i think you need transaction type because negative not only caused by refund but some times of loss, stock adjustment and so on 2, for location may be it should be grouped like warehouse and shop floor  |
| | of course there is a differences in performance but in my opinion, unless your application is really mission critical where second counts and u have hundred thousand of records and may be more than one hundred tables u don't need to be worried about performance ahmad |
| | actually u only need three tables 1. main category with key main-category-key and other fields 2. sub category with primary key : sub-category-key with foreign key main-category-key and other fields 3. item with primary key is item-key with foreign key sub-category key, and other fields alternatively because ur data is … |
| | usually what i did is to load login form when the application loaded. MDI form will be loaded only after successful login when user logout close MDI form and show login form hope it will help |
| | random files is a file type with the following characteristic - has a fixed length record - it can be accessed directly by record number so if we want to access record number 8 we can go there directly instead of reading from record 1 as we do in normal … |
| | first u have to decide wether u will cover in-patient or just clinic with out-patient. It is a good idea to imagine the operation of local hospital. So u can imagine which department to be used. Based on this operation u can try to determine the table needed and all … |
| | i will to provide the table for seat only, u have to determine other tables table name: Seat parent table : FlightNumber Field: - record ID: record identifier - flight number: flight number of the trip (including flight number and date) - row id - seat number in the row … |
| | actually it is not clear what u means by corrupted records do u really means records in one table or corrupted tables or corrupted database please clarify |
| | why don't u go to university's library and find out what previous students do in their thesis U can compare several thesis to give u an idea Usually Table of Contents is similar to outlines |
| | because different database has different error code and description, pls state which database and version that u use U can also try to find the description of that error in the documentation |
| | Re: proposal Before deciding which proposal i think you should choose between popular business application or others. For popular business application the easiest way is retail application, but you have to find the company to collect the data because it has many different type like supermarket, chemist and other it has specific … |
| | i think it is better you put your code so we can see where is the problem |
| | |
| | [QUOTE=sanz;1193479]thnx.[/QUOTE] actually ebanking is a big and complicated projects u need to understand the banking operation and the most important thing is security and communication security they are absolute prerequisite in my opinion |
| | Actually it is not very clear for me your question but i try to help if you mean two fields in table A map to the primary key in table B I can give u an example in retail If an item is received in boxes but is sold as … |
| | in my opinion it is too difficult to make this kind of application in VB6 too many things we have to do ourselves, because VB6 was developped when internet is still at early stages in my experience VB6 tools is good as browser only |
| | 1. fpr attendance monitoring, if you only means absentee record you better start to design it by design employee table, absent table and so on. Try to present it so we can help you if if it is correct 2. Material management is a quite complex database, pls clarify your … |
| | You can find the information through search engine like yahoo, google or others |
| | Re: timer1 control try to put this on method Timer1_Tick if relay = on then relay = off else relay = on end if hope it will help  |
| | usually the performance is not a single one, but it is done several times a day or several days so i think we need an extra table to performance-time an make relationship customer-(performance-time)-seat for the seat, if there is several types of seat for examples stalls, balcony yes we need … |
| | based on assumption : one clients can have many projects expenses is type of payments payments depends on projects and expenses i suggest to design database: Clien: Id, Name, address and so on with Id is primary key no foreign key Projects : Id, ClientId, and so on with Id … |
| | if we consider the purpose to use foreign key is to link one key to another table so we can keep look up the detail information in separate table but it has consequences: if will speed up searching but it will slow down the update. if the parent table has … |
| | u can use function Split to separate each parts into fields and insert them into database hope it will help |
| | [QUOTE=hoofbeats95;1211846]Hello. I need to include an excel file in the installation project of an application. I've added it to the install project under application folder. I need to read that file into a dataset during runtime. The file needs to be included on install so that the customer can change … |
| | [QUOTE=vb5prgrmr;1214179]What you are talking about there Al, may I call you Al, is decompiling a program. Now, if you use your friends (yahoo, google, ask, answers, bing) and search for decompile vb6 programs, you will find a bunch of various programs out there from free to commercial grade that will … |
| | the best way if u cud use debugger which can determine which line cause an error, i am still online and will try to help u ahmad |
| | to store the information in a sequential file u need to use file access function from VB i.e. FileOpen, FileAccess, FileGet, FilePut I have done in VB6 the sequence is like this FileOpen filenumber,filename FilePut filenumber,recordstring to write to a file i hope it will help |
| | in internet programming i.e. to show our data to the world, normally we don't use Excell but some kind of database like MySQL or MS-SQLServer and we write the program to display it in appropriate layout for the beginning u can browse through the internet the site who has the … |
| | [QUOTE=mahdoum;1197441]Hello everyone, I currently manage hosting for a number of customers and started created a system to manage the customers and their hosting accounts / domains. I have the following setup currently: Tables -Customers (Customer name and contact info) -Customer Accounts (An account links domains + hosting in one account) … |
| | [QUOTE=andydeans;1185316]hi, fairly new to mysql. i have been working on a site which would have say 100 + agents. basically the agents clients are their own so i thought the best way would be to get a dedicated server and create a mysql database for each agents company. the database … |
| | if performance is the problem i propose u read the whole data into memory as a string and make necessary calculation in the memory i assumes u have the fixed length record so what u have to do prepare the buffer for 3000 records x recordlength and read the sequential … |
| | [QUOTE=y2_sub;1185431][CODE]Dim s As String = "SOME STRING" s = s.ToUpper ' Converts String To Upper Case s = s.ToLower ' Converts String To Lower Case [/CODE][/QUOTE] just additional comment u can put it in the KeyPress method so every time u press a key it will be automatically converted |
| | Re: flexgrid [QUOTE=cabsjonel;1172178]folks what i need is a demonstration and a explantion can u help me ? pls repz asap.......:([/QUOTE] u can find many example by searching using search engine like [url]www.google.com[/url] or yahoo.com u can put flexgrid vb6 in the search box there are many sites which provide u with sample … |
The End.