Search results

Thanks this looks like it is going to be very useful. I am going to read up on it now and see if I can get the locking to work.

I have a Memo box where the user puts comments and then I have a check box that if check automatically puts a specific phrase on the first line of the Memo box (before any other text currently in the box). What I am trying to do is have it so that if the "check box" is UN-checked it will remove...

I don't think this is what he is asking. From the original post it looks like he already has it set as "Limit to List". It sounds to me like what he wants to do is have it so that NO text can be entered into the combo box (whether it be on the list or not on the list) Making it so that if the...

Here is my dilema. I have a database where I have implented security levels (1-10) I have code on the "OnOpen" event that checks the users security level and then compares that level to a table called "Application Fields - NE" it then from this table determines which fields on the form are...

Won't set focus back to CCN-LU field Ok so I got this working using the DLookup function, but now my problem is that it won't set the focus back to the "CCN-LU" field when it detects a duplicate. Did I code this wrong? Private Sub CCN_LU_AfterUpdate() On Error GoTo Err_CCN_LU_AfterUpdate Dim...

Any idea on how to use DLookup function to find the duplicate? I know how to use it to fill in another field based on what it finds in the table.

I had the similar problem, but mine is with 2 databases linked to the same tables. So what I did was have a custom error message when opening the form if it was stating that the record was locked by another user: On Error GoTo Err_Open_Click Exit_Open_Click: Exit Sub Err_Open_Click...

I have a form with a field called "CCN" and what I need to do is have some sort of code that will look at the table "Application Data - NE" and check to see if there are any duplicate records for that CCN on the "AfterUpdate" function and if so; spit out an error message saying "CCN already...

Anders do you have a version that you could share with me so that I could take a look at it? It might make my life a lot easier. Thanks for the info.

I have the users name and ID setup in the security table. I am not very good with the VBA coding.. how would I use the Environ() and also how can i have the recordsource look at a table and a query at the same time? THanks for your help.

What I have is a database that I am using for 3 different sites; NE, NCA, & SCA. What I want to do is have the form ONLY show information for the specific site that the Leader is a member of. I have a security table that contains the persons name, & site location. For example: John Smith works...

If you read my posts Keith you should get the basic idea of how to accomplish this. Use notepad to create the .bat file.... when you go to save the file go to save as: and save it like such: Update.bat or whatever you want the file to be named.

Hello MsLady I am glad that this thread has been informative for you :) If you want to send a shortcut to the desktop the best thing to do is create the shortcut locally and then save it server side so you just give the .bat a command to copy that .lnk file to the users desktop G: CD\ CD...

Thanks :) That helps

What I have is a form with a combo box that lets a user select the Letter Type. For 1 letter in particular I want it to open up a subform(s) that holds "options" that users can click on. My question is how would I get these options / multiple options to link to 1 record that correlates with the...

Because when the database senses an update is needed it brings up a form that says to Update.. when you click on the "Update" button there is code in the "OnClick" function that tells it to run a macro called "Version Update" Here is the layout of that macro: Action: RunApp Command Line...

The way I have it is I have the FE in the users local database. so when you update the "master database" you change the FE version in that.. Then I use a .bat file to execute the update for the user. If it sees a new version is available it closes the database, runs the .bat file (which...

Thanks for the help :) It is a network printer, but I that wasn't the issue. I figured out what was causing the problem. I had created a custom toolbar for "printing" and I created an autokey macro ^P to give the user the option of the number of pages, etc. to print, but it seems that is what...

Page width is only 6.5" with a 1" margin all around so it should be within the confines of the page limits.

No Page Breaks. I used the Report Wizard to create it. It is a one page report. :\