Search results

Good morning everyone, I think I am slightly confused... I split my database into front- and back-end and set up user level security (for the back-end, I think). Now I have front-end, back-end and the workgroup info file. In which of these do I administer my user and group accounts? Or does it...

User Level Security: Table access Hello everyone, I have a question about user level security / access control. For my database I have a back-end containing the tables and a front-end with forms, queries and everything. I have set up the access user level security. Dependent from the access...

Hello everyone, is there a possibility to close a form that is in dialog box style by code? DoCmd.Close acForm, "frmQuery"does not work. I am afraid that I can´t do anything by code until the user closes the form, right? Is there no way around, maybe by addressing the vbFormControlMenu? I...

Hi everyone, I need a VLookup in my VBA code, but neither nor works. Neither of them appears in the Applications list, I get a "Method or data member not found" message, and the help files contains no related entries. What am I missing? What I'm trying to do is the following: in a form, the...

Hello everyone, today I have a design problem: I have customers in my database who have more than one customer number, but every other information (Name, Categories,...) is the same - please don´t ask me why they need more than one number, I don´t get it myself! So for some customers I have...

Hi guys, I want to run a query based on a list box entry. For more user friendliness I want the list box to show both an ID number an a name, but the query shall only run on the number. Is there a (VBA-) way to read only part of the list box entry into the query? Or can I somehow concatenate...

Hello everyone, I have a query that I want to take its criteria from a text box (which is a form). The user shall put data into the box, hit the "calculate" button and get his result. The query works just fine when I enter my data in the box and open the query "manually". On pressing the...

Hi everyone, with no experience in database design and only little in programming (actually, I am a mathematician), I am about to create a database for my current job.. this is bound to create some difficulties! So thanks for adding me! Moori