Search results for query: *

I created a shortcut to an Access application on the desktop using a batch file with the following command: Copy "C:\OldPath\AccessDB.mdb.lnk" "C:\Documents And Settings\UserName\Desktop" How do I change the icon (the picture displayed) of the shortcut using the batch file. I'm using Access...

I created a shortcut to an Access application on the desktop using a batch file with the following command: Copy "C:\OldPath\AccessDB.mdb.lnk" "C:\Documents And Settings\UserName\Desktop" How do I change the icon (the picture displayed) of the shortcut using the batch file. I'm using Access...

I have an Access 2000 database that will link to an ODBC table. I would like to verify that the link to the ODBC table will not create an error before the front-end database is opened. For instance, if the ODBC database is down for some reason, I would like to be able to detect this when the...

I just posted another question on combo boxes, but think there may be a different response to this one - so I'm posting separate questions to keep the responses separate. How do you add an item to a field that uses a combo box control without displaying the data on the visible drop-down list...

I have a combo box control on a from that allows users to select from a list of managers. Once the manager is no longer active, I don't want the manager's name to be available for selection from the combo box. However, If you return to a previous record containing data when the manager was...

I have a query that calls a custom function to calculate the difference between two dates, which are fields in the query. Each record in the query calls the function, making for very, very slow run-time for the report bound to the query because the query can return hundreds of records. What...

I need to be able to log approximately 50 users out of an Access 2000 database at any given time so that maintenance can be performed. I am using the standard method of setting up a back-end table with one field that toggles between True, when I need the users out of the database, and False...

I have a form with its property settings set to allow additions, deletions, and edits. The Data Entry property is also set to true because I want the user to see a blank form with no existing records when the form opens. When the form is opened, the data mode argument is left out so that the...

I need to open a working copy (.xls) of an Excel Template (.xlt). Using the RunApp command in a macro opens the actual template file, but not a working .xls copy. I've seen previous posts for this topic, but no suitable answer. Anyone have any idea how to do this? Thanks, EJ

I would like to convert all formulas in a worksheet to values. The code below works for one specific range, but I need to cycle through all the ranges in the worksheet to convert the formulas to values. Dim c As Range For Each c In ThisWorkbook.Worksheets("Sheet 1").Range("B5") If...

I would like to know if there is a way to simulate the way the Windows File Explorer bar works. You can view the folders in the window to the left and the details of the folders in the window to the right. You can open and close the left window at any time. I would like to use it to simulate...

I would like to have Access automatically close all databases at 11:59pm each night if the user has forgotten to exit before they left for the day. I know that I have to use the timer event. Can anyone tell me what value I need to use that equals 11:59pm and the specific code that will...

The database version I am using is Access 2000. I have two tables that have a primary key set to Autonumber. These tables are populated with data. Problem- I need to append records that were entered into an offsite database to the tables mentioned above. The offsite database has the same...

I know how to print a report based on the current record displayed on a form. I need to print a report based on all the records in the form's recordset but not all the records in the table's recordset. For example, if I want to print all records for 02/19/05, there are some records in the...

I have a UserForm that I use to collect data. I'm trying to assign text to a form field from two separate text boxes on the UserForm. It should work like this: Enter Text1 from UserForm on 1st line of Form Field Enter Text2 from UserForm on 2nd line of Form Field If the user were entering...

I am using custom navigation buttons and want to simulate the "(Filtered)" label that normally appears next to the navigation buttons when a filter is applied and disappears when the filter is removed. When a user clicks the "Apply Filter" or "Filter By Selection" button, I can use the "Apply...

I have one custom menubar and one custom toolbar that should both be visible at the same time with the same form. The problem is that when the form opens, the toolbar and the menu bar keep changing their positions, seemingly at random. Sometimes the menubar is on top of the toolbar, and...

I have a table that contains approximately 80 fields - alot of which are Yes/No and Date fields. When each record is updated by the user, there will be groups of fields that will remain blank. My question: Should I combine the fields into logical groups and move them to separate tables...

I am getting a "Module not found" error and a "You cancelled the previous operation" error when I try to open a report that was previously working correctly. The report name shows in the database window but I can no longer open it in design view or run it. I ran a compact and repair on the...

I have a report based on a crosstab query. I'm using fixed column headings showing each month of the year. I also need to have fixed row headings so that if there is no data for a field in the row headings, the field name should still display and then just show zero values for each month of...