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 / January 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Macro Errors18 Jan 2006 18:21 GMT2
When I click a button on a form I get an error saying that a field
can't be defined more than once.  It then goes to give infomation on 2
macros that I have (name, action, arguements).  If anyone could tell me
how I could fix this problem it would be greatly appreciated.
Macro's date criteria doesn't work for "last month"18 Jan 2006 18:19 GMT7
I have a form that uses a combo box for filtering dates... when clicked the
combo calls a macro and shows records that match e.g. "Today", "This Week",
"Last Week", etc.
This works great on a single form... however, I now integrated a subform
Go to specific mail merge record in Word18 Jan 2006 18:14 GMT1
Is there a way to go to a specific mail merge record in a Word document after
the document is opened using the RunApp Access macro query command?  The
record to go to in Word will be the same record that is selected on the
Access form
Passing a parameters to a macro18 Jan 2006 18:13 GMT1
I have a macro that executes several queries.  In one of the queries I
prompt for a value to be used within my query.  I would like to run my
macro without prompting for a value but yet retain that portion within
my query.  How do I automate this process?  Thanks.
Need help with Excel macro18 Jan 2006 18:03 GMT1
I need some help with this problem.
I have four ranges in the same worksheet.
For example:
rangeA (d5:d15)
Import udated data tables18 Jan 2006 12:10 GMT2
Can any one help me with a macro that will import updated data tables into
current tables of another database.
Thanks
Russ
report with combo box17 Jan 2006 23:03 GMT2
I want to dispaly my reports listing (10-20 reports) through a combobox to
run it. How can I do that.
Please help
find all records within a specified zio code radius in Access17 Jan 2006 21:56 GMT3
How do I create a way to key in a zip code and specified radius in order to
have all records in my Access database within that radius come up? I am not
an experienced programmer. Thank you!
use combo box /macro to sort17 Jan 2006 18:11 GMT6
I want to be able sort a form by two fields. I don't want to add another
command button to the form, so I thought I would use a combo box to select
the sort field and then exectute a macro on change.
So far, my attempts to exectute this have been futile. I'm able to get the
Import data from a single sheet on an Excel workbook17 Jan 2006 17:31 GMT1
I'm using the TransferData command in an ACCESS macro to import an Excel
spreadsheet as a table, and I'm having trouble telling it which sheet to
select. Can you give me the syntax? Thanks.
AutoExec Macro problem with ODBC connection failure17 Jan 2006 13:21 GMT7
I have an autoexec macro that exports 2 different queries using TransferText
to .txt files.  The queries are built on tables that are linked via ODBC to
outside product.  The first query always transfers/executes right away.  The
second one fails and I get the ODBC ...
Common Code16 Jan 2006 14:11 GMT5
Access is great for linking tables between databases to share common data
bretween databases.  Is there any way to share code between databases?  
I tried to put the code in a comon database and
1 - Delete the module if it exists.  This fails because the subroutines and
refresh15 Jan 2006 23:40 GMT1
hi, its me again
finally i think my problem is a refresh problem, so:
i cannot find any command to refresh my subform.
the only thing i could find is runcommand --> refresh, but that wont refresh
Set column width in a datasheet vith VBA15 Jan 2006 06:37 GMT1
Is it possible to set column width for each field in a datasheet with VBA
code?
Is it possible to hide/unhide columns to?
//Lasse
Running DELETE queries from code with no Confirmation prompt14 Jan 2006 23:41 GMT6
I'm running a DELETE query using the DoCmd.RunSQL method.
This runs OK, but it comes up with a-
     "You are about to delete xxx records, continue?"
prompt. How can I turn off these prompts for VBA-initiated actions only?
Pages: 1 2 3 4 5 December, 2005
 
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.