Search results

Sorry, did a compact and repair and now it works. This drives me crazy.

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 jdraw, Thanks for sending these links. I had found them, but do appreciate your help very much.

Thank you CJ_London, this very clearly answers my questions. I can go on from here. I do delete the DB on leaving, and I use the User's name in creating a temp DB, so it is unique to each user.

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 jdraw, The business case is as follows. On machines we build, certain components are valuable and you want to track their serial numbers. If you do not link a serial number of a valuable component, customers will start sending a lot of defective components back, and as by magic, they are all...

Thank you jdraw for your answer, which leaves me a bit puzzled though. My question is and has been all along what the most efficient access programming technique would be. I would not even know how to create x spaces on the fly. I know how to create and use some forms, until I hit a limit...

Thank you very much TimW This is certainly a very good way to go on a single user system. Is it also applicable on a multi user system? If other people add to the Serial number file at the same time as you, would your count not be reached prematurely?

Thank you jdraw for your message. Being the founder/owner of a machine building company (we need to trace the serial numbers of important parts we build into our machines), and having maintained an ERP package in another company, I can pretty much visualize what I have in mind, but do not know...

Hi MarkK, thanks for your comment. I guess I have not expressed myself clearly enough. Tables: 1. tblPurchaseHeader 2. tblPurchaseLines : Artno, Qty, QtyReceived, ...(linked with Purchase Header through order number) 3. tblArticle in which one field indicates the need for a serial number (per...

Thank you very much TimW. Being a self-taught Access programmer, I may ask very basic questions. Where would you put the counting and the control of the number reached? I could count in one procedure/form and open the form anew for as long as I have not reached the number of entries, but this is...

Thank you jdraw for your very fast answer. You answered the business side of the question, which to me is not an issue, but which I will try to explain better, so as to get to the programming question. I have a purchase order screen, with lots of funtionality. For example, when I fill in 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...

CJ_London, thank you so much for your help. I was vaguely aware of break points, but have not used them up to now. I relied on the somewhat cryptic messages of the debugger of find my mistakes, but this time I got stuck. Thanks again for helping us neophytes along.

Hi CJ_LOndon, thank you for your reply. I am not sure I understand your words: "if it is displaying the records in edit mode, this can cause a conflict". The form is bound to an underlying Table, and so is the subform. So all records can be updated in the form. Do you mean that I could have...

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 JHB, just went through the thread you sent me, and it looks very promising. It sure looks very useful. Thank you very much for taking the time to share your knowledge. Have a nice day!

Hi Minty, thank you for your reply. I had Name autocorrect on, so now switched it off. I am using Access as a signe user database, front end and Access database all in one. The plan is to migrate to SQL server or similar, as soon as we have a server. The crash has been happening when I press a...

cyberman, thank you for your message. Something to definitely consider if things become problematic.