Search results

Hello Access Specialists, I just noticed that the following statement produces the wrong record count: "Set rstPersons = db.openrecordset("select * from Persons where LastName like '" & strLastName & "'", dbOpenDynaset)" In the Persons file I have two records where the LastName = "Hurni"...

Hello experts, I am looking for a personnel and shift scheduling application for a fast food/caterer restaurant concept. Currently 2 locations in one city, but expanding to different cities in near future, to different countries later. The idea would be to link a solution to an ERP system which...

Hello Access experts, I have a company form on which I put a command button that opens a purchase order form. The idea is that the company form creates a purchase order heading and opens the form on the new purchase order record. My problem is that the openform command ignores the where clause...

Hello experts, I prefer working with tabbed documents in my DB. Every new form opened, opens to the right of the previous one. Is there a way to control that behaviour, and for instance open a certain form between two forms (between two tabs)?

Hi Access Experts, I use temporary files a lot, which sit in a linked database so as to avoid DB bloat. Since I may re-use them over the course of a session, I start by deleting all records in the temporary file. See attached doc. When I subsequently import an Excel sheet into that...

Hello Experts, what am I not seeing? It must be so obvious that it baffles me.I am trying to add a "T" in front of an article number and write this new number to a table. Access cannot find the new Article strArt because it does not exist. When I put a msgbox after "if .nomatch then" it...

Hi Access experts, I read a lot about Access database bloat when using temporary tables that reside in the front end, which was where I created and used temporary tables before reading about bloat. I therefore wrote a routine on startup that creates a temporary database and then copies the...

Hi Access experts. My problem is the following: when I receive say 5 computers in a purchase form, I want to register the serial number of each of them in another form, bound to another table. If I receive 2 units in the purchase form, my user should only be able to input 2 records in the serial...

Hello Experts, Access has been giving me some problems lately. The problem is the following: either after a change to the dictionary, or a change to a procedure, or after the PC having gone to sleep, some functions completely disappear from my screen, like the menu bar, or do not work, like the...

Hi there, I have been receiving error 3197 lately "stopping the db engine because another user attempts to change the same data". There being only one user, the reason must be bad programming. Here is the situation: I have a main form and subform which displays the Purchase Order Header (main...

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...

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...

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...

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...

Hello Access aficionados. In the following code to add an article to a purchase order line table and then open the form on the purchase order in question , I had to open the window “frmPurchase” twice in succession. If I omit the first docmd.openform statement, the form would open at the first...

Can anyone help me? I use Susan Harkin’s Simple solution for tracking changes to Access data. When I call the routine from my Company form it works (a record is created correctly on a change) When I call the routine from my Article form it does not, it gives a Type mismatch error 13 Yet: 1. I...

Can anybody help me with a filtering issue? I have a bound form, in its heading I have a combo box which lists three choices. Basically I want to filter all my purchase records by checking a field PUOrderNb (Example: PO200100025) against the choice made in the combo box, namely DE (for demand)...

Hi, I am a bit puzzled by the statement under my identity as a newly registered user that I posted 6 statements, and zero thanks. I guess I missed the procedure for doing this explicitly, for I did thank the person who helped me in each of my 2 replies on a problem I had. Please help, cause I do...

Hello Access experts. I have a main unbound form frmArticle on which there is a tab control with 2 pages. On the first page is a subform frmArticle1, on the second another subform frmArticle2. Both subforms are bound to the same table tblArticle, and both subforms show the Recordkey Artno and...

I am pulling my hair out as I keep getting “ Run-time error ‘2465’: Microsoft Access can’find the field 'frmCompanyNamesSubfrm" and I am not seeing the wrong syntax. I have a main form frmCompanyNames on which is one subform called frmCompanyNamesSubfrm . The fields on the subform come from a...