Search results for query: *

Similar to this posting thread705-441707 you haven't assigned a password for a user when you set them up how do you force them to go to the change password form and enter one the first time they enter the db? You would need to access the data contained within the mdw file which is where the code...

The shortcut that is used to access the db determines what workgroup will be used. Therefore, you can locate all of the db's on the same server. I would also place the workgroups on the server as well and reset the shortcut properties to that location. Autoeng

I am using Data Access Pages to interface with an Access backend. The need is to initiate a download of data created by a query. Autoeng

Is it possible to execute a VBA procedure from VB Script? Autoeng

But using the code I had previously posted the right click is disabled. That is what I was trying to get around. How to have no menu bar but the right click still works. Autoeng

I don't want any menu bars as that would require that I relayout my form to accomodate the area that the menu bar uses. I have found a way around it but it quite lengthly. If anyone has the need for it let me know and I will post it. Autoeng

I have a form with several "columns" that resembles an Excel spreadsheet. Because it is a form when you paste information into it you can only do one field (cell) at a time. However if I right click on the form and select (Change to datasheet view) I can paste entire rows. Now for the...

What do you mean by the original db? If you have security on the db it is not only in the workgroup but also on all of the items in the db as well and it won't let in a user who is not accessing the db without joining the correct workgroup. Unless you didn't delete the rights under...

I am trying to integrate this (http://www.mvps.org/access/forms/frm0007.htm) into my db but am not sure as to what event to assign the code to. I created my multiselect list box pulling values from my query. Created a hidden test box to store the WHERE clause. Created a command button to run the...

After making some changes to my db last week when I select to print a report it comes out blank. All of the report fields are there but there is no data shown in the corresponding text boxes. Control sources are correct. The report is created by pressing a command button from the only form in...

I was just getting ready to post when I received yours. I was able to solve the problem when I dicovered that Microsoft had reported a bug in Access that it would sometimes lose it's references even though they showed as selected and the path was correct. By unselecting the references, exiting...

Just updated my db, which was working fine, with some new features. Now some of my users are not able to get into it because it "Cannot find project or library" for the below module. This module checks the currentuser to see if they are a member of a certain security group so that...

Access can handle up to 255 users at the same time all working on the same table if everything is set up correctly. Autoeng

Hold down the shift key while entering the database. Autoeng

Michael: I had printed out your Faq prior to posting but I am a novice at queries and don't have a clue as to where to start to combine this into my existing query or to how to make use of the return that it would generate to use in my query. If you could be so kind as to give me a starting...

I have a query that generates a report for records found between start and stop dates for workdays only (4 day week). I would like to add holidays to the query. As I work in an industrial manufacturing setting our holidays (at least not all of them) cannot be calculated via code as we are...

That short cut that you have that gets you in is what Jeremy is referring to. Access creates it when you run the security wizard and is now the only way to open your db. You have to distribute the shortcut to every user that will be using the db. You need to read up on security more. Go to the...

I use a batch file as well to distribute my FE each time the user starts the db and have never had a problem. I don't even wory about version comparison, I just do it every time. Works very well with about 6 users full time and 30 users on occasion. Autoeng

One thing that I have found is that when you are working on your form design that if you have a subform the resizer will mess with your layout on form save. Disable the resizer by placing a 'before the code lines that reference it, make your form changes, save the form and then remove the '...

I usually distribute the FE of my database via a batch file that when fired copies the FE to the users machine and then starts the database with the appropriate security workgroup. I would like to move away from the copy everytime batch file and use code to compare version of local FE to version...