Search results for query: *

Easyit posted the batch file code below a while back (thanks Easyit!)as a method to copy versioned front-ends to the user's computers. I like this approach but have one problem. I will not have mapped network drives (usually) on the users computers. Is there a way to do this using unc naming...

Nevermind everyone, I figured it out. Thanks anyway.

I have a continuous form with a combo box on it as one unbound field. If I click on the combo box I want to drop down a list of items that come from another table but use three fields from the current record on the continuous form as the search criteria. The problem I'm having is that the data...

I have a listbox that contains a list of people's email addresses. I programmatically select all entries in the box. Then I loop through the box and send out the emails. After each email is sent I unselect the item. This gives the user the visual affect of seeing the progress of the task...

Well, If a listbox has say 100 values in it, it is possible to have a selected item out of the view in the listbox. You would then use the mouse to scroll down or up to view the selected item. I would like to know if there is a way to do this by code. Thanks.

Can anyone tell me how I can make a listbox scroll programmatically? Thanks.

I am currently using the following code that will log the user out if a specified period of time elapses without changing the current form. The problem is that sometimes a user is using the same form for for longer than the set idle time and the application closes not saving the information...

Hi Jaaret, I'm having the exact same problem. If I remove the .requery the error goes away but I don't get the desired affect. The thing that's getting me is that my front end is installed on about 50 different computers. None of them have this symptom. I would be interested if you find an...

Hi GDGarth, Well I've just removed all references and then reassigned them except for two: Visual Basic For Applications and Microsoft Access 9.0 Object Library. I couldn't delete these because it said they were in use. I'm still seeing the problem.

Hi Ken, I'm not sure what you mean or what to check about the Network connection. The recorsource does include the Right() function. I've checked the references of the working and non-working pc's and they are the same. I've also verified that the exact same version and service pack is...

Thanks for your reply FancyPrairie. The tables are all linked using UNC not mapped using drive letters. I should also mention that when the form initially opens the data in the fields is correct. It is only after a requery command that the fields change to #Name.

Hello all. I'm having a bit of a problem with a database. It is in a F/E B/E configuration. The frontend is copied to the local computer with a batch file. We have over 50 computers that this frontend is functioning on. Yesterday one of the compters died. The IT people brought us a new...

Thanks Ginger that worked!! Have a star for your trouble!

Thanks Ginger for the reply. File Number is a text field. It is a field name in two tables; Inventory, and Standards Service. What I want is the Dlookup to pull out the Model info from the Inventory table. The File Number field is common to both tables. Thanks.

It looks like you have more than the one bracket missing. At the end of _rate I believe there should also be brackets.

I am trying to construct a query where one of the fields is a looked up value based on the value of a field in the query. I am having trouble referring to the fiel in the Dlookup statement. Here is what I have..that isn't working [neutral]. Model...

In the database window of your database choose Tools then Options, click on the View tab and un-check the Windows in Taskbar block. That should do it.

Thanks Ziggurat for the reply, I looked at the info in your link but don't understand. I attempted to place the code into my database but get error messages. I get the impression from that thread that you would have to run that code, exit the database, and log back in for the desired results...

I've created a database that has a custom menu bar. The database window is hidden on startup and the shiftkey is disabled. I would like to place a button on the main form that when pressed will prompt the user for a password. When the password is entered, the database window will be displayed...

I have a form with a gray background and black text. When I print the form the page comes out shaded as well, of course. I would like to have the form background color white on a print preview or print without making my form's background color white. Is it possible to change the form's...