Search results

Thanks for that info Pat. Ill definately use that MsgBox trick often. Thanks, Jason

That did the trick Pat, and thanks for the help from every one else. Glad thats all fixed up, now I can get on with the rest of my database. Cyas Jason

whoops... sorry about that, Ill change it and give it another try.

Thanks for the info Wayne. I ran the debugger as you said and found some interesting info about it. Apparently the On_Print event fires twice, once when you open to preview, and another one when you press print. Ill paste my code below and you can check it out. (Note: the textfilter string...

I gave your ideas a go and they half worked. By this I mean that it will now show the quanities properly in Print Preview mode. However, the moment I actually print the report, the same problem that I mentioned arises. This confuses me to no end, as I thought print preview only showed what was...

Thanks for the replies guys. Ill give it shot when I get into work, and tell you how it goes. Ta Jason

Heres some more info, it might help you see what I mean. So heres an example of a test report: (in design view) Header Part No Description Qty ... detail [Part No Field] [Desc] [Qty] ... Now the Qty field isnt bound, its actually a calculated field, with the code I did 2 posts...

A little problem has arising when trying to display particular values in a report. The setup is like this: the report displays a part number, and then any orders for that part. (Important part is underlined.) For example: SS1010: Control Box Issued: 1/2/04 Some info Quanity Issued: 2/2/03 Some...

Thanks for the reply. I gave the requery a try on the form. I had it requery before editing the Record Set, and then ran DoCmd.runcommand accmdsaverecord (I think thats the command) and it now works perfectly. Cyas Jason

I have this database that has a form and a subform. The main form governs the OrderID, and the subform contains the parts listing. Each order can have many parts, and a part can have many orders (many -many). Now I have to check for duplicates within the orders, meaning just after you enter an...

Hey everyone, just hoping someone can answer this problem that I have with a many to many subform. The subform is already set up, but I need to change it over to a way Ill show below, but I dont have any idea how. The list is a list of a persons skills (in a factory), and is many to many because...

It works perfectly now, so thanks for the all the help fellas. Thanks Jason

Ill give it a shot Wayne, and tell you how it goes. Ta Jason

Just asking for a little help with a strange problem that seems to be occouring with one of my DCount functions. The problem is as follows: DCount is returning different values in an identical situation. The first case is in a subform, the second case is in its own form. The arguments I use are...

It worked perfectly, thanks for the help. Cyas Jason

I got the tab control all setup, although now Im stumped with another problem. (ill call the subforms A and B. I turned the form into a subform and put it onto a new tab. Now I need to control subform B from subform A. By this I mean that subform A has multiple records, and when you select one...

Thanks for the reply, i'll give it a shot Thanks Jason

This is a problem for all you Access gurus out there, perhaps you can help me, since Im stumped. So this is the problem: I have a large database that handles personnel data, and it happens that one particular section is very complex. So there are 2 tables, Personnel and Review, with one...