Search results for query: *

I changed the Module that the code was in and it still does not hold the variables. The Variables are set to Public in the global code module and I loose the variables when I go from a form to it's sub form. SO that seems to be the link. I still have no clear understanding of why. Please Help.

yes, compiling the code works without a hitch. The module the variable is in is called UserSettings. I doubt this has any bering. Again please help if you can. I am lost!

ALL the global variables are getting lost but what ever Form I am currently on does not loose it's vars. I assume this is because the form has not lost scope yet. I thought that global variables held their settings until the project was closed? The variables are global variables that I am...

I have been using variables for a while. Now when the database is running (Access 2003), some of the variables will lose their information and revert to empty. If anyone can help I would be thankful. There are no errors that I can see that are stopping the code. Please help if you have any...

Go to the properties of the service and check the Log on tab. Is the log on using the Local System Account or other. Also check the dependencies. Make sure all dependant services are running. Stephen Ludwig

Are both accounts using the same login script? You said they wern't. Can you post a copy of both scripts? What are the member groups of both accounts?

I have the database open on startup and I would like it to logoff the computer when Exiting Access. Can someone Please help me with this. I can make it work if I start Access with a batch file and have the batch file logoff the system when I exit access but I was hoping for a Macro or VB Code...

I created a module called Security this is what is in the module: Option Compare Database Dim m_UserName As String Public Sub SetUserName(MyUsername As String) m_UserName = MyUsername End Function Public Function GetUserName() As String GetUserName = m_UserName End Function...

I have a form that initially ask for the username and password. So when the user enters their information I want it to be stored in a variable. This will allow me to verify the accesws permissions for each form my validating the fnUserName variable against a certain set of criteria. If some...

I have a form that acts as my login screen. I need to set the values entered as username and password to as variable that will be accessable in other forms. I would like to use the variable names fsUserName and fsPassword. Can anyone Please help me. Currently, after the Username and...

I have a button on a form that prints two different reports two printers. I use the on click event to trigger a macro. The macro uses the OpenReport action with the view property set to print. You can use two OpenReport actions in a row to specify the two reports you want to print. On the...

I have a form that ahows the sales person information like customerID, CustomerName, AddressInfo, QuoteNumber, FollowUp Dat, Ect.. On that Form I have Embeded another form in Datasheet view. That embedded Form in datasheet view displays limited information about other quotes for that same...

I have a main form named QLSalesFollowup. This Form has a subform in datasheet view. The Subform's name is QLSalesFollowupSF. If I open a quote on the main form the subform displays all the quotes we have sent to that customer. The two forms are linked with the customerID field. I would...

I have a main form named QLSalesFollowup. This Form has a subform in datasheet view. The Subform's name is QLSalesFollowupSF. If I open a quote on the main form the subform displays all the quotes we have sent to that customer. The two forms are linked with the customerID field. I would...