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

Oh, ok... yes, that makes sense :-D

No, it is an access database. What I meant is just that the company has a professional server (which I assume to be SQL, but if I am talking nonsense: don't mind me, I am just an amateur). The database I created is just for my department and stored on what everyone calls "the server"

PS: how do I mark the thread as "solved"?

Yes, this was what I was looking for! I didn't think it would be so easy, I thought I would have to add the password to every query and VBA module or something like this. Thanks for the security hint, but these measures are sufficient at the moment. The Database itself is stored on a SQL...

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

Ross, you are a genius! Thanks for this old post!!

Oh no, I really would not want to appear rude, Pat ;-) Smig, this will also restore down my other open forms. I´ll stick to Fuse3k´s nice and easy solution! Gracias!

Thanks Fuse3k, that was it! I didn´t know you can check the query without opening it, haha - duh! :D Bert, your approach did not work, I could still not close the form. Thanks for your answers!!

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

Thanks for your efforts!! I´ll try it next time - surely I will come across a similar problem soon! Saludos de México!

John, we are talking about a vlookup in Excel via VBA that is called by Access... Kiwiman, nothing worked, so in the end I used a different approach: read my data into a temporary Access table and then fill the Excel Sheet via dlookup. Might not be very straight, but it works ;-) Thanks for...

But I am working on Excel Sheets, not in Tables. Can I refer to a Excel file in DLookup? I tried this too, but couln´t get the syntax right. Something like: ?

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

Thanks for your new input! The more I read and think about it, the more obvious it becomes that I should delete the duplicates. There is no way to keep all data accessible for my users AND sustain data integrity. I could try a message box on update: "Please be sure to update this information for...

I was afraid that would be the answer ;-) Yes, there is some significance in "real life" for the multiple numbers, but it doesn´t play any role in the database. Hm, I´ll work on this one.... thanks for your answers!!!

They share every information that is relevant for the database - the name, an agent, and categories for different product families (that determine discounts). They do not share the customer number, that´s all. So it would be good when updating the categories for one number, all other numbers of...

No, the multiple customer numbers were assigned intentionally for reasons I don´t really get, but my boss insists that it must be so. When creating the database, I made a separate entry for each customer number rather than for every customer name, because the number is unique...

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

Hm, this possibility never crossed my mind... but you're right, that would be more flexible! Thanks!