Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / November 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Changing printer config in VBA01 Nov 2006 19:04 GMT9
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 wheel01 Nov 2006 18:41 GMT6
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 Field01 Nov 2006 18:26 GMT2
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() function01 Nov 2006 17:49 GMT2
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 tabl01 Nov 2006 17:25 GMT4
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 Offset01 Nov 2006 17:16 GMT3
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 Attributes01 Nov 2006 17:09 GMT5
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 Error01 Nov 2006 15:47 GMT2
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 Button01 Nov 2006 15:06 GMT5
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 them01 Nov 2006 13:58 GMT3
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 GMT3
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 Command01 Nov 2006 09:26 GMT17
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 ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.