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 / March 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Switchboard Macro15 Mar 2005 20:53 GMT4
I have created an AutoExec Macro, which opens the switchboard but this also
allows the user to get to tables, forms, queries options.
How can i hide these from the user everytime the database is opened and how
could i display them when i need them.
Give a letter automaticly a letter-number and put it in an Access.15 Mar 2005 18:56 GMT2
If I make a letter I have to give it a documentnumber in a separate
Access-file. Is it possible to give automaticly a number to the outgoing
letter and automaticty put this number in a Access-database and in the same
record of that number should be automaticly take over from the ...
VB Code of a Macro15 Mar 2005 18:45 GMT1
Is there a way to see the VB Code of a macro?
Thanks
Using OUTPUTTO and saving to folder for backup15 Mar 2005 17:08 GMT2
I am trying to use outputto to send a snapshot of my report to another
server/folder for a backup.  How do I bypass to get Yes to auto reply when
promp another file by the same name already exists?
Thank you
Macro open query action with action fail15 Mar 2005 01:18 GMT1
I have macro to open a query with the query input prompt. It works. However
if I decided to cancel the query, I got the action failed screen then I have
to click on Halt or 'X' to close the macro.
It is annoying. Please help me to fix that action fail
Creating Excel Spreadsheet within Access VBA14 Mar 2005 21:08 GMT1
I set up the code listed below to create an Excel spreasheet from within
access VBA which worked successfully except it displayed a warning message
when I wanted to save the file.  I entered DoCmd.SetWarnings False which did
not work.  I then entered:  xlApp.Application ...
AutoExec Macro12 Mar 2005 04:28 GMT5
My AutoExec macro will not make my files "Read-Only" it goes to the beginning
form properly, but won't put it in a read-only mode, I use Find Form,
GoToControl,
please help, no one ever responses to my questions!
Need macro to enable a control based on value in another11 Mar 2005 23:44 GMT1
pretty straight forward stuff, I know.  Can someone tell me how to do this?
Signature

MV in LA

macro to send query results to excel11 Mar 2005 21:41 GMT2
I'm a macro novice.  Is it possible to create a macro that
opens Access 2000, runs a query, sends the results to
Excel, and then sends the Excel file to a mail recipient?
thx
Command Button for Macro works once11 Mar 2005 21:37 GMT2
I have a command button that runs a macro sendobject. If I
hit the command button again it doesn't do anything. What
action would make this button work again? Right now, I
have to get out of Access to have it work again.
Open a Word document11 Mar 2005 20:36 GMT2
I am trying to have a macro open a Word document. Is it possible to open a
Word document from a macro? If not, is there some alternative that can be
utilized to do this (forms, switchboards, etc.)?  Thanks, in advance, for
the help.
Edit query macro11 Mar 2005 19:03 GMT1
I have a query that includes a field called "state". I need a macro that will
open the query, change the state to each state in the query, and then export
each state specific query to an excel file. I've figured out the export
function, but cannot figure out the edit query ...
AutoExec Macro11 Mar 2005 17:57 GMT2
I've written an AutoExec macro so my database will open in a "Read-Only" mode
and its not doing it, what am I doing wrong..Shelia Simpson 16
Signature

M.Simpson

Time date stamp10 Mar 2005 22:40 GMT2
In a form...  I would like for a time date stamp to be
placed in a text box at the exact time that a macro (enter
button)is ran.
TFTH
use command button in access to open excel file10 Mar 2005 21:21 GMT9
I would like to have a command button on a form that I could click that would
open a specific file in Excel.  So far, all I have been able to do is create
a button that opens a blank document in Excel.  Is there a way to do this
using a macro, or would a code have to be written?  ...
Pages: 1 2 3 4 5 6 7 8 February, 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.