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

Thanks Ed! This will work well for me because I have only a handful of tables to test.

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

Thanks Remou for your response to both of my posts to the dreaded combo box problems! Your code above has given me something to think about in working around these problems. I will give it a try!

Thanks Remou. Using the Before Update event will definately solve the problem. I'm just surprised that Microsoft has not provided a built-in way to handle this scenario, which seems to be something that is quite common when dealing with active/inactive employees.

I tried this Remou. The problem is that if the data does not display as an item on the drop-down list, it also won't display in the text portion of the combo box. I want the data to display in the text portion of the combo box when a user views the record, but I don't want the data to be a...

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

Blorf and PHV, Thanks so much for your suggestions!!! I will test both methods to see which provides the speediest output.

Here is the code: Function CalcTTime(BegDate As Date, EndDate As Date) As Integer Dim i as integer Dim DaysToSubtract as long Dim DaysBetween as long DaysToSubtract=0 DaysBetween=(EndDate - BegDate) - 1 For i=1 To DaysBetween 'Check if date is a weekend If (Weekday(BegDate +i)=1) or...

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

You are correct Ed2020. I did not give the complete details, but I am indeed opening a snapshot recordset on a one record, single field table. I think your method of maintaining a flag for each individual user is an excellent idea and I think I will try it. Thanks for the excellent advice!!!

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

Thanks Eupher, I already have a custom toolbar set up so I guess I will have to disable the filter buttons or set some type of criteria to limit the records before the filter is applied.

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

crobg, you are a genius. It works great!!! I've seen other posts with the same question but this is the first correct response I've seen. Thanks a million!

Thanks crobg, but I forgot to mention that I am opening the template from within Access using a macro - not from within Excel. How can I open it from Access?

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

Thanks earthandfire. I was able to record your suggestion to get the VBA equivalent and it works great! Thanks.