Search results

Turn off the system warnings with the following line of code preceding your append/update query: DoCmd.SetWarnings False Dave Mack Saratoga, NY

I have exhausted my resources on this issue: In an error handling routine I capture the user's entire screen by having a message box appear instructing them to press the "Print Screen" button on their keyboard. I then invoke the clipboard via code and write the bitmap immage to table as an OLE...

I have a database which has a table containing two OLE fields: 1)Database 2)Shortcut Each record contains a database and a shortcut to the database. I would like to know how to copy the imbedded database to a file location such as D:\Data\My Documents. This should be executed by code. If I...

Judith, Just what I was looking for! Thank you very much for your response. Dave

Judith, Just what I was looking for! Thank you very much for your response. Dave

I have a module which produces staistical data which is then fed to a detailed report. I currently use a form filter on which a user selects custom criteria for their reports. Our upper management likes to have a report which shows the statistics for every unit, which is a total of as many as...

I have an auto grading examination form. Recently, I added a countdown timer which ultimately will warn the student when there are two minutes left and save and exit the exam when time runs out. For the two minute warning I have been using the "Beep" from Access. I would like to know how to...

I would run a delete query to remove the existing data in however many rows you want evacuated. What is the function of your database? I think it's odd to have data entry then not commit the information. Are you using some kind of template? If so, the above will do what you want. Are any...

You can save yourself a lot of trouble by teaching your users to use Filter by Form. You would incur no overhead by using this functionality. You can easily save a couple of steps by running a macro or code behind your "search" button. Paste the following two lines after you create a new...

Create a query, then base your form on the query instead of the table. In the query do not add the column 18 table item, instead create an expression like this on the QBE design grid: Column 18: [Your Table]![Column1]+[Your Table]![Column2]+[Your Table]![Column3]+ etc... Enter a text box on...

I've been compelled to work on a data entry form our users have been using for quite some time. I have designed a cleaner version but our users do not want to use it. (It was based on ideas and help from Mr. Hartman--Thanks Tom!) My version uses continuous form with data entry occuring from...

I'm hoping someone will be able to help both of us. In the interim, I was able to use some example code from the Access Developer's Handbook. The following code can be added to a button or even on your form after criteria is selected in Filter by Form to return the filter string...effectively...

I posted a similar question to yours. Read mine in the "Query" section. Dave Mack 2/2/00. simple way: If you do a FBF in Access, you can save the filter as a Query and base your reports on that Query. Harder way: You can find the FBF filter string (if you don't close the FBF Form) in the...