Search results

D/David I thought of the same and was planning to have separate tables for outsiders which will be maximum of 5 to 10 entries a month. If I have separate tables then I have to have all the queries I made for staff also available for outsiders. That means I will have two sets of tables...

D/David Thank You. The names are not needed to be stored. But needed to retain for monthly accounting of sales and presentations. For example: Charlie and smith are staff and entries are fine bcos their names are in the list. But if it is outsiders then I have to enter like 'pilot at...

Dear Mister Namliam Thank you for the guidance. I have already tried with -limit to list- set to 'no'. But when I enter a name not in the list, I get a message saying "text entered is not an item in the list". What must I do? Somehow managed to read y o u r white fonts. So you do advice me...

How to deal with a known and unknown list of names? D/SIRS I have completed the tables, queries and reports to a major extent thanks to this forum. Pity is that after I have almost completed the project, I realise that I have two sets of people. One is staff list and another is unknown...

D/BILL Very thoughtful of u. Bcos of the month end papers and cargo inventories, I will devote the time in a day or two and first thing that will be done immediately is to put that nz in the equation.

D/Namliam Trust me. If this was not pointed out, I would not hv been aware. I read ur point and will keep in mind. From where I started, I hv gotten a long way and now close to completing the program and handing it over to the officers. Thanks for the assistance.

D/BILL BINGO!!!! Thanks to ur record time responses, I was able to figure it out and now the thread can be considered closed. I tried both and both worked. 1. SaleAmt: IIf([ITM_TYPE]=1,(([TSLOP_LIST].[AV_PRICE]*[T_SALES_DETAILS].[QTY])*1.1),([TSLOP_LIST].[AV_PRICE]*[T_SALES_DETAILS].[QTY]))...

D/BILL Good day. SaleAmt: IIf([ITM_TYPE]="1",[AV_PRICE]*[QTY]*1.1,[AV_PRICE]*[QTY]). I studied last night about iif and also ur suggestions. As I understood the formula I worked it out like above but still getting error. I am still at it and will revert after some more trials. I hv tried...

D/BILL Well explained n thnks. I got the mistake or the misconception. You have got my exact mistake in using the av-price. Got the concept to use it as sale-price. If a sale is made I have to use the av-price but how to convert that as sale-price. I will redo it tomoro as I am going for...

D/BILL The bracket error is not coming for the below one but getting "the expression u entered has a function containing the wrong number of arguments." SaleAmt: IIF(ITM_TYPE([TSLOP_LIST].[AV_PRICE]*[T_SALES_DETAILS].[QTY])*1.1)=1,([TSLOP_LIST].[AV_PRICE]*[T_SALES_DETAILS]).[QTY])) If u can...

D/BILL Apologies as I hv missed out to thank you for the immediate guidance. I am checking the brackets. I see in ur response colored brackets in red, green. U telling me something thro that colors?? Is it ok to have same field in two tables in a query?? I did that bcos I am basing the...

D/BILL SaleAmt: IIF(ITM_TYPE(([TSLOP_LIST].[AV_PRICE]*[T_SALES_DETAILS]).[QTY])*1.1)=1,[TSLOP_LIST].[AV_PRICE]*[T_SALES_DETAILS]).[QTY] I think I have to redo the query bcos I seem to have av-price in two places. One time in 'tslop_list' and another one in table 't_sales_details'. Or can I...

D/Sirs Thanks to this forum and thanks to mr boblarson, mr. hitechcoach, mr. bill, and mr namliam I have started from scratch and managed to link names table and stores table and got going on various forms and queries successfully. Now I am onto the reports to make sales report and stock in...

D/SAM It is very kind of u and thnks for the trouble u hv taken. With all the help, I hv completed the project and was unable to use it from networked comps. That is also solved after loading office 2003 also into the same system. Mr. Bill -- pls accept my thanks and I am almost there now...

D/Missinglinq Thank you. Will keep this in mind. I was in control room to try out the program and bit disheartened. It worked fine from cabin. When I tried from control room comp, getting many errors like 'activex component cant create object'; 'ole is not registered'; 'cant create dao...

D/BILL Thank you. Will keep this in mind. I was in control room to try out the program and bit disheartened. It worked fine from cabin. When I tried from control room comp, getting many errors like 'activex component cant create object'; 'ole is not registered'; 'cant create dao objects'...

D/BOB I Was only checking for enabled. Now I am able to enter after changing the combo box locked as 'no'. It is my own trouble. In one visual basic module, I have locked it on opening the form. It only struck after ur suggestion. Thanks. Let me start to enter and create records etc...

D/Sirs I got the three tables 1. crew details; 2. store items details and 3. crew sales tables which has saleid, name_code, item_code etc. The above I got something constructed on the lines of 'orders entry' for the crew who purchase stores. I am able to see the various sales for each record...

D/SAM I got crew table, items table and purchase table which has the prime keys of items and name code for the staff. Using this I got a form and sub form like the ones in Northwind-orders or invoice sample. What I am doing is adding one combo box with all crew names and using macro to find...

Yes. your understanding of my requirement is exact. So what I am trying is to get the data of purchases and total amount of the staff who made the purchase and at the same time by giving a command button can use the same combo box to use the new staff who will buy one item or more items. It...