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...

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...

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...

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...

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...

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...

I have some code that reads a listbox and outputs a report via outlook to an email. recipients are selected in the listbox and then a specific report is genertated and emailed to them. This was working until today. Now what happens is only 7 reports go out. On the eighth I get the following...

How do you move the focus not select, move the thin dotted line around the item in the listbox?

First of all thanks to everyone here at Tek-Tips. This site is great! I have a listbox that contains the names of people I would like to send an attached report via email to. The listbox is set to have multiple selections. I have a button at the botton of the screen that when pressed will...

I have a continuous form that I can sort and filter. When I get the data the way I want it, I want to push a button to open a report that has the same record source, order by, and filter as the continuous form. How do I do this? If I switch back and forth between the form and report and apply...

I have a .wav file I want to play when a button on a form is pressed. how do I do it? Thanks

I'm using Access 2000 in Windows 2000. I have some VBA code that is supposed to play a sound. Here it is. Me![found].action = acOLEActivate. [Found] is an OLE Class Microsoft Sound Recorder Server. I used the command above to activate and play the sound. It worked great on WinNT with...

This is probably an easy question to answer but I'm having a bit of a problem with it. I have a combobox that has the LimitToList property set to true. When a user types something in the combobox that is not on the list, they can't leave the field until they select something off the list...

I have a multi-select listbox. I have a query with criteria from two colums in the listbox. How would I loop through the listbox of selected items running the query for each one? I'm having trouble referencing the listbox columns.

Can you set a reference library using code? I have a front end database that will now use the Microsoft Outlook 9.0 Object Library but each of the computers it is used on doesn't have that refernce library set. During the OnOpen of my main form is there a way to set that reference if it is not...

I think I'm close to figuring this out. I'm trying to set my application up so that when a button is pushed a report is attached to email and sent. I have everything working except the attachment part. How do you tell Outlook that you want to attach an Access Report? I get the message that...

I have a listbox that allows multi-selection. I would like to store the values of column(1) and column(2) into an array. Can anyone help me with this?

I would like to set the focus to one of the items in my listbox. I don't want to select it just move the focus to it(that light border line that appears around the item). Can anyone help me with this? Thanks.