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 / Macros / November 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Access Ver 2.0 Adding days to a date to give target date excluding weekends?30 Nov 2006 02:20 GMT1
Not sure if i'm posting in the right spot so sorry if its not, please
direct me to the correct location :)
I have three fields in a form, [quote accepted], [days to results] and
[target date]. I need to calculate the target date by adding the [quote
Pause macro to enter parameter29 Nov 2006 22:31 GMT7
Hello to all.
I need to run a query weekly with results based on beginning and end dates
as criteria in one field.  I then need to export the resultant dataset to
Excel.  Creating the macro to export the dataset was easy.  However, what
Truncate the first 2 characters contained in all cells within 1 column of a table in access28 Nov 2006 13:44 GMT3
I hope the title is descriptive enough.
My problem is as follows:
I am trying to truncate the first two characters from all cells
contained in a specific row within a table in an Access DB.  All
ERROR 3011 when running a macro28 Nov 2006 13:30 GMT1
The Microsoft Jet database engine could not find the object Customer Order
Backlog. Make sure the object exists and that you spell its name and the path
name correctly. (Error 3011)
I get this error when running a 23 step macro.  If I take the 22 step, which
Can User Input Be Used in a TransferDatabase MACRO ???28 Nov 2006 13:25 GMT1
I posted a question similar to this in the Import/Linking forum....and
received a possible VBA coding solution.
This may be the more appropriate forum and am posting here, just in case.
Since I'm not real familiar with VBA coding...I'm hoping there may be some
where are wombats?28 Nov 2006 13:10 GMT1
Can someone tell me whether Wombats live only in Australia,
or also on other continents?
Apart from zoos, of course.
We all know that Wombats are to be found in Zoos.
Multi Select on a Form27 Nov 2006 22:27 GMT1
Hi everybody! I am trying to multi select in a list box but i get this error
message:
The field <name> cannot contain a Null value because the Required property
for this field is set to True. Enter a value in this field. (Error 3314)
Select from List Box26 Nov 2006 21:24 GMT4
Have a list of names & Phone# in list box on Form1, want a macro to copy
selected names and paste to a table. Table is a subform in Form1(no
relationship). All field names and format are similar)
I have
Data from Access25 Nov 2006 15:50 GMT2
Good morning
In the following Macro, we are trying to get all the fields from a connected
database. If you look at the macro, you'll see that there are mising field
names (refer to the portion where you only have ' ' ' ' ' '  in the Array
append delete query25 Nov 2006 07:36 GMT1
i wrote an append and a delete query for a table to move and delete records
by looking up the name field in a record by the statement like 'Enter Name".  
i combined the two queries into a macro.  i am looking for a way to only type
in the name one time to run both queries on the ...
custom macros in normal.dot wont load24 Nov 2006 22:04 GMT1
Custom macros (keyboard) show up in macro listing in normal.dot file but they
will not respond to keyboard commands.  Windows XL Ofice 2003
Expression builder limitation24 Nov 2006 17:55 GMT4
I've run into a limitation in number of characters that can be used in the
Expression Builder the following expression:
[Forms]![MONITORING_DATA_ENTRY]![Abbr]
& "-" &
Copy contents of a field does not copy complete field24 Nov 2006 15:16 GMT3
I have an EventProcedure to go to a field and copy the contents. The first
part copies the text, then the Notify Macro is a Send Object Macro. The idea
is to have the text from the ResumeTXT field in the Clipboards so it can be
pasted into the Message of the Email. I
Auto yes/no replies24 Nov 2006 14:22 GMT3
I'm trying to run queries that create/delete queries. I want the yes/no
question that pops up to be automatically answered as "yes" but I don't want
to use the "Tools->options" option that does this (need it for other stuff)
I believe that, using a macro, theres's a macro ...
exporting query with parameter24 Nov 2006 13:52 GMT4
I have a procedure in the access' module and I want it to export a query to
an xls file:
>>> Application.DoCmd.OutputTo acOutputQuery, ExportingQuery, acFormatXLS,
>>> XLSOutputFile
Pages: 1 2 3 4 5 October, 2006
 
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.