| Thread | Last Post | Replies |
|
| Changing printer config in VBA | 01 Nov 2006 19:04 GMT | 9 |
Client has a macro to print a report. Is there a way to add some code to turn off duplex printing? I'm not very fluent in VBA. Thank you!
|
| Disabling mouse wheel | 01 Nov 2006 18:41 GMT | 6 |
I visited Stephen Lebans site (http://www.lebans.com/mousewheelonoff.htm) and downloaded his solution for disabling the mouse wheel in Access 2000. I put it in the Load event of a form. However, when the form is loaded, I get the following error ( braces {} my clip, brackets [] ...
|
| Open Outlook and Reference a Field | 01 Nov 2006 18:26 GMT | 2 |
I created a database that is being used by several departments. When a record is created, the user notifies the person in the next department via email that their is a record ready to be coded. The user will be able to search for the Item ID that is referenced in the email. ...
|
| Now() function | 01 Nov 2006 17:49 GMT | 2 |
On form when staff enter that a task is completed then in the underlining table the completed date is automatically entered. In the field [Completed Date] the Default Value is the Now() function. So this is what is entered into the [Completed Date] field: 11/1/2006
|
| Append Query in VBA - to append VBA variable values to Access tabl | 01 Nov 2006 17:25 GMT | 4 |
I want to run an append query to append data to an existing Access table calculated from procedures run against a recordset. This doesnt work: DoCmd.RunSQL "INSERT INTO Results ( [AXA Ref] ) SELECT [Axaref] AS [AXA Ref]" ..even though "AXA Ref" is definately a valid field in table ...
|
| DAO.Recordset Offset | 01 Nov 2006 17:16 GMT | 3 |
I'm used to program in VBA Excel where I can move through spreadsheet with OFFSET. Is there any way to use Offset in Access Table? I already know to move with:
|
| Getting File Attributes | 01 Nov 2006 17:09 GMT | 5 |
Access 2003. How can I programmatically retrieve file attributes (properties) of any file (not just Access files)? I want to query a specific property of a file, in particular the "Revision Number" found under the Summary tab>Advanced. Thanks for any help you can give. God ...
|
| Run-Time Error | 01 Nov 2006 15:47 GMT | 2 |
When running a report, i get an error "Run-time error '-2147352567 (80020009)': You can't assign a value to this object." I have a text field, rptAlloy, and want to fill it with a field from a query
|
| Find Command Button | 01 Nov 2006 15:06 GMT | 5 |
On my main form I have a command button for the function Find Records. However I want it only to search one field. Screen.PreviousControl.SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
|
| Access DB - How to have records approved before others can see them | 01 Nov 2006 13:58 GMT | 3 |
I have a database where someone enters data onto the database. I dont want anyone else to see the records until they have been approved by someone who is a member of the admins group. I dont know where to start with this. The database has already been
|
| ADO need help with this assignment? Help. | 01 Nov 2006 12:33 GMT | 3 |
OK I need your help, I need to do this assignment for a class and am getting nowhere with it. I need to use ADO to display information on a form from the current database and another database.
|
| stAppName Command | 01 Nov 2006 09:26 GMT | 17 |
What's wrong with this line, File not file. I know this has to be so easy... stAppName = "C:\Customers\ & Me.CustomerID" & "MerchantApplication.tif" I have a folder in C named Customers. Their CustomerID from the table, I want that to be their folder name, like 1998 in Customers ...
|