Search results for query: *

I am having trouble with this. I have a table that contains a column named "month_year". I have pre-filled the column with dates, ie 01/01/03, 02/01/03, 03/01/03...and so on. I have a form named "frmMetrics" that contains a field named "Period" that displays the...

I have a database that I have inherited, so I am not very familiar with it. Someone has shown me something that I do not have a solution to. One of the fields in a form contains data from a memo field. When you try to highlight the text with your mouse, it will only let you select about the...

It seems simple, but I am having troubles. I have a form that captures information. This information has a "requested by date" field that the user will enter whenever they complete the information. What I want to do is have the "requested by date" text box appear on this form...

We have users that are saving filenames with a date at the end of the filename, for example c:\file0207.txt. The 02 is the year and the 07 is the month. Is there a way to have Access 2000 in a macro or module allow me to import the file for the current date? For example, if the month is July...

I am attempting to send 5 different reports via email to 5 different recipients from a module or Macro. The first report sends just fine, but I get an error message that says "Output to not avaialable". I get this regardless if I run the output to process or the send object process...

I have a report that runs from a query that contains one name column and 4 other data columns. I have done a lot of processing to get the data in its current state(some good....some probably bad!) I have suppressed the duplicates in the report, but that leaves blank spaces...I have searched the...

I have a directory D:\Monthly Log\ . This directory contains folder names like "2002 - 02 Feb" and "2002 - 03 Mar". What I want to do is when a user clicks a button on a form, have the folder that is the month previous to the current month and import a file called...

I have a table named tblMultiple that (might) contain temporary data for a report. When the user selects a report button I had created, I want to verify if there is any data in that table prior to pulling up this report. If there is not any data, I want to give them a message that there is no...

I have two databases, one called db1 and the other called db2. db1 is distributed to a handful of users on their own machines. When the user closes db1, I want it to open db2, which will then close db1, so db2 can force a compact on the database on the users whenever they close. My problem is...