Recent content by moori

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