Search results for query: *

How to explain this ! I have sales reps on the road, the boss wants them to count their house and stocks and sold items on a daily basis and calculate their comissions for each product! So i have a table called repsales with repid (primary), name, account#, date, amountscollected and a bill#...

You could create an event procedure on the lost focus of the status field to have it write todays date within the completed date! ie: dim st as string dim cd as date st = me!status if st = "completed" then cd= now() me!CompleteDate = cd end if end sub Hth André

First thing you can go to the menu click tools, options, select the edit/find tab , and uncheck the confirm action queries check box. This will remove the first pop up you receive. Now if your append query is correctly built you should not receive the second part telling you about the...

Craig Ok so we can make a one to one but this is unaceptable for various reasons which would end up in a long discussion! Of course here the situtation here would be one to one based on the fact that the invoice gets written before the payment! So back to the original question (rephrased) ...

Right the invoice comes first! Now the cheques comes next ! but for each cheque i can pay many invoices! So the way i saw it was to use the invoice table which already contains the information to pay them! Create a new table called cheques and link to the invoices this is where my backward...

I have a situation where i need to fill the many side of the table before the one side! Will this pause a problem! Past present or futur! I see no other possible venues to make this work! ex: to pay bills i need to fill what needs to be paid first! Any suggestions !

Syntax for main/subforms For these examples: Mainform is the name of the top level form Subform1 is the name of the subform CONTROL on mainform Subform2 is the name of the subform CONTROL on the 1st subform. If you are on Main form Sub 1 To refer to a form property, like...

Need to know the name of your main form and field and subform name and field to help It should look like this: me.parent.recordsource= me![total] Hope this helps Hope this helps

On a form with a subform how does one handle the undo record, i have tried with the docmd but it will only undo the sub form, not the main form, basically what i am looking for is a rollback... Is there a way to do this programaticaly ???

You are correct of course Steve on your assuming the inventory system! Basicly a very simple system to evaluate what is on hand within the product form ! Which is actualy the same form as the inventory ! Since i have succeeded in obtaining the sum of good bought and the sum of goods sold, a...

Minor problem caused in form ! My form opens and goes to a new record. private sub docmd.gotonewrec now at the bottom of the form i have a macro wich calls another sub performs calculations and then goes to a new record ! I am not sure why but this causes 2 records to be added ! one blank...

I am having a problem with a combo who should filter the second combo ! The problem is that the second combo is a lookup field with a column count. Now because the value is numeric although it shows the text value. My combo 1 does not requery the second combo. Any one have a work around for...

Thanks you so much Jim for clearing this up for me! the problem was i was filling the amount field and trying to send the result to another field ! Not working beautifully ! Thanks again André

Thanks Isadore, I see this is not going to work ! I did say update query ! So how does the query obtain the a b c as you stated ? better yet i could always loop through the form when it is open to trigger the calculation if i knew how to do it ? So let's try the later ! a = me!bought b=...

Ok let me be blunt here ! Where does the private sub go ? Where does the function go ! What do I call the function of the private sub ? My field containing the value i want into text is called amount! And finally how do i get to write the results into the text field called text9. Hope...

DSum("[Quantity]","Order details","[ProdID] = " & Me![ProdId]) minus the below DSum("[Quantity]","Stock ordered","[ProdID] = " & Me![ProdId]) Using an update query to return the differencial values! In other words what I have bought...

Sublime ! Thanks you lameid !

I am using an update query to show the quantity of orders! Table products ProdId (key field) Table order details¨ProdId (key field) also lookup field bound column1 column count 2. The problem i have is that the bound column is 1 in the table with a column count of 2 to show the description...

My append query shows the correct results ! However the table i am appending to receives all the information except the currency values which a switched back to $0.00. Yet when i look at the query the amounts are not $0.00. Are there any special considerations to take into account when...

I have a subform with a key field set to no duplicates! Is the user accidently enters the same key number on another line in the subform, there is a violation of duplicates! The problem is that the subform will not allow me to change that number to another! Is there any way to handle this ...