Search results

How do you have your switchboard? using the built in switchboard or did you make your own using a blank form? Mine main switchboard is an actual form with buttons and labels for each button. I'm thinking that might be your problem if you are using the built in switchboard funtion in access...

Try putting an underscore _ in the form name "SW_2" or rename your form to "SW2" with no spaces.

Dim stDocName As String Dim stLinkCriteria As String Dim PassWord As String stDocName = "SW 2" PassWord = InputBox("Enter Password") If PassWord = "Ice" Then ' Open Form DoCmd.OpenForm "SW 2" Else MsgBox ("Sorry, You are not authorized access...

Is "SW 2" a form? do you have a button that you click to open "SW 2"? If you have a button to open "SW 2", then put what I gave you and only what I gave you on the "on click" event for the button. There should be nothing else but that VB for the password prompt.

It is backed up daily and I work on a copy on my desktop. split the data from code? data is on a backend "named_be.mdb"; queries, forms, etc in the other front end.

a) Yes I am aware of that and is why I work on it at nite when it is not in use. b) At most, there are two or three at a time using it. Why I need to get this done. I had not choice but to get what I had out and into use at the time. Now based on input for requests to do this or that, or...

Great, so when I get done tweaking the things I need. And finally finished .. I will have them copy it over their desktop.:)

I have split it correctly, just it is still residing on the network until I get the tweaks that I want done. Then I can have everyone copy the front end to their desktop. So what your are saying is that.... if they had their own copy, it would be used by just that person where the front end...

I need you to explain more on how and where to put what you posted earlier. And do I need to change any text that you posted to match a field that I have?

Ok, here goes again.... I have a form that displays data from two tables based on a query that pulls the data together for the form. I have two fields in the query that prompt the tech for information to search for each record. I have a VB script that loops the query until the tech has...

stDocName = "SW 2 Macro" PassWord = InputBox("Enter Password") If PassWord = "Ice" Then ' Open Form DoCmd.OpenForm "SW 2" Your stDocName and DoCmd.OpenForm should be the same. If your form is SW 2 then that is what should be in both places. Try that and let me know.

Sure try putting this on the button that takes you to the second form. Of course you will have to give the users the password that you create. Dim stDocName As String Dim stLinkCriteria As String Dim PassWord As String stDocName = "SecondFormNameHere" PassWord =...

Hi all, I have a form that is constantly used by several people at the same time. I would like to be able to have one user have the form open, and lock others out from using it until the one user closes it. When the one user does have it open, and someone else tries to open it. I would...

Yes, the form is based on the query that pulls the data from both tables. The query itself has to fields that prompt the tech for input and I have a VB script that loops the query until the tech has pulled all the records they desire. Those records I dumped into a temp table for editing before...

Gotcha.... Let me rephrase on my last. The form is displaying data from two tables. That is why I had to create the query to have the user enter the criteria from the specific field to find the record and dump it into the temporary table. The data is then changed and then the changed fields...

Allright, I will try that. This is the biggest DB I have made or really the second ever. I am learning as I go. So any help is appreciated and this forum is the greatest.

Oh yes, please keep in mind that what I posted is just an action based on a button the user clicks. The data, per say, is already in a temp table waiting to be viewed, changed and updated. The code is to manipulate changing some of the fields in the temp table based on the Y/N answer. Maybe...

hmmm I am new to VB and have been learning as I go. Basically, if I did not have the loop. The data is pulled from a query, dumped into a temp table, then displayed on the form. Then the user interacts with the data changing some of the fields based on the situation (the Y/N part) where based...

Hello, I have a query that pulls data from a table based on user input. The data is stored in a temp table. After the user selects the data, could be from 1 to 5 or more, it puts it in a continuous form. What I would like to have happen is before the data is loaded into the form. loop...

Do you have an example of what you are suggesting? I currently have a query setup to ask the user for only one value. If I can do it directly from the table and populate the form that would be great. I am tweaking the database based on user input and this is one of the suggestions. You can...