Search results

To jdraw, thank you very much for your fast response. I will look into the issues you point out right away.

Hi Spikepl, first of all, thank you very much for your mail. Sometimes solutions can be simple, and yet we do not see them. This is the beauty of this forum and the participants like you. I will correct my code. Have a nice day.

Hello Access Experts. I have an unbound form with a list box, 2 text boxes, and a command button. As soon as I select a line in the list box, the first text box is being fed the quantity appearing in the second column of the list box. The idea is you can transfer the whole quantity in stock...

Hi gemma-the-Husky, No, this is a simple db on one single computer. Today I copied forms from my test database to my live one, compiled the live database with no issues, ran the same program and the whole thing crashed again. I then compacted and repaired the db, ran the same program without any...

Hi Minty, Being self taught in Access (fortunately not in programming) I know I am missing out on a few things. Was not even aware you could compile a program, but I will certainly start doing this. That certainly might take out some loose ends which I have left floating around and that could...

Access extremely unstable on my PC I need some urgent help or advice. Thanks to good advice from some participants to this forum, I was well on my way to developing an ERP in Access. This morning I have had a number of crashes in a large program. When that happens, I comment out every line and...

Is it normal that you are using Forms!frmResourcing.cmb_Training_Type) in your second combo. Should the first = statement not refer to training_typeID?

Hello JHB, just gotten back from a trip abroad, which is why my reply is late. Thanks a lot for your reply. My problem was that when I reached the right number of records processed, I tried to leave the form, but there was always an extra record created. I think I now solved the issue by setting...

Please help. I always have a problem with input forms in Access in that I usually end up with an empty excess record which is being created because I do not know how to program this correctly. I have a Purchase Order Receipt form (frmPurchase). When I receive a certain quantity of an article...

Solved! I used the expression builder and of course put in a test for strings =DLookUp("[Desc]";"tblArticle";"Artno='" & [Forms]![frmPuLines]![PuLineArtno] & "'") Thanks Uncle Gizmo and JHB for leading the way.

I tried putting the DLookup in the record source and keep getting error messages. The syntax, which I ended up coying en adapting from forums is: =DLookUp("Desc", "tbArticle", "Artno = " & forms![frmPuLines]![PuLineArtno]) What is wrong with it?

Hi JHB, Thank you for your reply. Should the DLookup function be written in the recordsource? How would I have to write it?

Hi Uncle Gizmo, I cannot see why this is happening. Indeed all article lines are separate records, tied through a common field to the main order header form and table. This is a continuous form constructed to look like a datasheet. I noticed that when I changed this sub form to Datasheet, it...

Hi, I have a Purchase Order Subform which contains the Order lines listing the different articles. I would like the Subform to display each article’s description. I have the following code in the on current event of the subform (copied from one of the Northwind examples) and on the after update...

Hi vbaInet, if it were not for this forum and your expertise, I would still be digging. I understand I have to move the code in question to the on load event of the form itself. However, how would I get my criteria to the form then? Would I need to pass the form identification and the criteria...

Hello vbaInet, looks like this thread is not finished. In another module,I consistently cause Access to crash whenever I use a variant of the "second method" discussed above as follows: Forms("frmSale").Recordset.FindFirst "SACompID = " & CompRecid & " AND SAContact = " & PersRecid...

Yes sure, one has to be an optimist!

vbaInet, be sure I really appreciate this forum and your help. I hope I can graduate to the level I could be helping others.

Thank you for your quick reply. Point 1 must be a bad habit I took over from Progress, but I would only have used it for boolean. I take your point. Point 2: looks like the second method is the better one then. The good thing with Access is: it is readily available. The bad thing is: I tried...

Im am not sure I understand your comment "be explicit in your criteria". As for the results: I did not notice a difference. What I want is to find the first open Purchase Order for a particular supplier and that is exactly what both methods accomplish. Only, the first seemed odd and...