filtered form to export to excel and excel row format as text
Fri, 5 Dec 2008 15:01:22 -0800
Hi,
I have a form that I would like to filter first and export the report it
generated to an existing excel file. Can the macro perform this command?
I also tried exporting using vba, and one of my problem is the excel cell
format will change to general when I want it to be text format.
Thanks in advance.
R ...
|
Backup between two times
Fri, 5 Dec 2008 12:08:02 -0800
I have a program that performs a backup automatically. But I want it to only
back up between 12pm and 6am. Currently it will back up if the time is <12pm.
How should the condition look to only backup between 12pm and 6am?
Current Condition:
Time()<#12:00:00 PM#
...
|
Do back up between two times
Fri, 5 Dec 2008 12:01:02 -0800
...
|
NEWBIE Needs To Import All Records From A Folder
Fri, 5 Dec 2008 11:29:03 -0800
OK - First things first... This is literaly like the 5th time I have ever
even opened Access - so Access terms and methods are still foreign to me. I
do a lot of VBA in Excel and I am told that Access VBA is very similar, so I
am reaching out for help. Again, I would have searched this out first, but I
don't ...
|
Backup OEL Object
Fri, 5 Dec 2008 08:13:01 -0800
I built a DB with an auto Backup function. I backup the table to an Excel
File. In my table I have an OLE Object, this is used to store external files
related to the record.
The table backs up fine except for the OLE Object. This item is left out
completely. Is the something special I need to do to ge ...
|
Hidden macro: already tried tools>options>view
Thu, 4 Dec 2008 20:30:00 -0800
Hi:
I inherited this database (Access 2000). There is a form, which has a button.
"on-click" the button runs a macro. I have the name of the macro, because
in the design fiew of the form, once I select the button and look at the
properties, I can see an event launched "on-click."
But when I look for the ...
|
Stopping the "Action Failed" msg when Autokeys macro interrupted
Thu, 4 Dec 2008 09:18:00 -0800
Hi,
Using Access 2003, I have an Autokeys macro which sets key F10 to shut down
the active form. However on one form I have some code in the Form_Unload
event which can cancel the unload and therefore the close of the form
(depending on certain conditions).
If I use F10 to close the form and the conditi ...
|
|
|
i am business man i want to search nice buyer
Thu, 4 Dec 2008 07:38:36 -0800
...
|
Auto-Generate File Name with Field Content...
Wed, 03 Dec 2008 14:19:20 -0800
Hello all!
I have a DB with a query that I need to get the data out to excel while autogenerating the file name with a field. Initially, I wanted a date range if possible...
IE. NewGradList_01-01-08_to_11-01-08.xls
Previously, I was using a date stamp ->
="NewGradList_" & Format(Date(),"mmddyy") ; howe ...
|
OpenForm macro with 2 criteria
Wed, 03 Dec 2008 21:37:55 GMT
Greetings,
I have a form [PartLookup] which is basically a master list of all [PartNo]
with corresponding [InquiryNo] and customer. There are multiple part numbers
per inquiry, and the same partno may exist in multiple inquiries. I have
another form [NewInquiry] (inquiry overview) with a subform
[NewInquiry ...
|
