|
Macro to respond to Empty Field or Control
I am printing to a report which is actually a contract that auto fills the
info from a form.
EX- John A Smith And Mary B Smith
John A Smith is a control concatenated
And is a label
Mary B Smith is a control concatenated
When John is not married and I only want John A Smith to appear theres "And"
left.
The name of the label for And is And
The name of the Wifes control is Sbuyername
...
|
2 |
3/7/2007 6:26:11 PM |
|
|
Automating Data Import From Excel
Hi all-- there's a large number of threads on this topic in the
archives, which has yielded (what seems to be) working VBA code that
will let the user pick an Excel workbook from which to import a range
of data. My problem is that I don't understand, conceptually, where
to insert relevant VBA such that the user can start the process. For
instance, I'd like to be able to process
---
strL...
|
1 |
3/7/2007 6:06:32 PM |
|
|
Admin password to Individual protected worksheets by users
I have an excel workbook where each individual sheet is protected by
unique user.
I want to add a admin id & password to this workbook so that the admin
can access all sheets at the same time. (unprotect, unhide all
sheets).
The code I m currently using comes from here:
http://exceltips.vitalnews.com/Pages/T0087_Protecting_Individual_Worksheets_by_User.html
...
|
1 |
3/7/2007 2:34:01 PM |
|
|
Start Excelmakros inside Access
13:44 2007-03-07
Hi,
Is there some help in cyber space...
to deploy a Access file including a autom. Excel start
If I include a Reference inside the AccessModule like Ms Excel 9 object lib
"EXCEL9.OLB"
I works just fine at this very computer , but I want this to bee possible
from every Pc that will start the Accesss application
I got an error message when try to load the reference to ...
|
1 |
3/7/2007 1:52:38 PM |
|
|
Scripting
Does anyone have a script that will combine the first initial of the first
name and the entire last name to make a username??? The first name and last
name fields are two different fields in the DB table. I have created a
"username" field in the same table....
|
3 |
3/6/2007 10:14:43 PM |
|
|
call command
I have a macro that calls a command to run a batch. However, in order for it
to work correctly we need to have Quick Books open. Since our Access
application and quick books connect w/ data. Once the command is complete
quick books stays open. Is there a macro command I can use to close the quick
books application?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/...
|
2 |
3/6/2007 10:09:34 PM |
|
|
Importing Macro
Hi all,
I am currently trying to import an Excel spreadsheet to an access table that
is linked to my currant database with a “TransferSpreadsheet†access macro.
The Excel spreadsheet contains 785 lines of info. I run the macro and I get
a halt massage followed by a “Numeric overload†error. I do not get this
error if I run the same macro in the original database of witch the t...
|
1 |
3/6/2007 6:31:00 PM |
|
|
Set form navigation buttons property
Reviewed earlier post on problems of setting the Visible property in Access
2003, and followed directions in MS Knowledge base article 841916 in creating
a module, and then running via a macro. But I still can't set the Visible
property of the Navigation buttons on my "VisitsFrm". Staying as close to
the directions as possible, created the module and named it "SetVisible".
Then had a ...
|
2 |
3/6/2007 1:00:18 PM |
|
|
macro print to pdf
I have a number of reports that I want to set up in a macro and then print to
a pdf file. Can I do this and also how do I define the "save as" for the PDF...
|
7 |
3/6/2007 1:50:13 AM |
|
|
macro for selective printing
we have created a switchboard which takes care of all tasks from
entering data, generating various reports and viewing those reports.
We want to write a macro which asks the user for the dates i.e. from
date and to date for which the reports need to be printed.
can this be done? if yes, will anyone guide us in this?
if not, can it be so done that last 10 records are printed from the
la...
|
3 |
3/6/2007 1:47:58 AM |
|
|
Check if data exists in database.
Hi!
I’ve a form (F_OE_Ideas_FillIn) with a couple fields where users can put
their data in. After they put their data in, I’ve a submit button witch
select all the data from the fields on this specific form and put it in the
database table (T_OE_Ideas).
What I want:
Is a check if the data is already in the database, if so: ask the user
conform this operation and then continue o...
|
2 |
3/5/2007 6:14:04 PM |
|
|
Send Macro - Need to add field from report/form to the subject lin
How do I add a field from the report/form to the subject line of a send
macro?
...
|
2 |
3/5/2007 6:02:19 PM |
|
|
print view
I am using a macro builder/wizard to create my macro.
My first action is: open report in print view
My default printer is print to pdf.
The "open report" in print view results in a screen requiring me to enter a
file name for saving.
How do I tell the macro what to enter as a file name (I could make it a
default entry or default to the name of the report) and then click the save
button....
|
2 |
3/5/2007 5:58:25 PM |
|
|
Import spreadsheet with pop up
Hi,
I have a macro that I run through my switchboard that imports data from one
specific file. Unfortunately this can cause duplicates if a user clicks the
swithboard button without updating the spreadsheet.
I would like a pop-up that identifies if a record is duplicated. Something
like "This record already exists, do you still want to import?"
Is this feasible and if so what is the best ...
|
10 |
3/4/2007 4:34:18 PM |
|
|
Transfer Spreadsheet from Query
I have a macro that does a TransferSpreadsheet from a Query. In this query,
I have set up CAPTIONS for all the fields. These provide a better
description for the field; one which the users will recognize. When I run
the marco and TransferSpreadsheet occurs, the result is that the columns are
named with the "actual field name" and not the "Caption" that was set up in
the query.
Is t...
|
2 |
3/3/2007 6:32:19 PM |
|
|
Simple MsgBox question
I am trying to set up a MsgBox function in a form I have designed for the
management of contracts. However, I am having trouble getting it to return
the message in the way I need it too. The database has over 50 contracts with
numerous pieces of information on each. One of which is the expiration date
of the contract. While scrolling through all contracts, I need MsgBox to
return the mes...
|
7 |
3/2/2007 3:00:05 PM |
|
|
Exporting selected rows of data from database table
Hi,
I have a database table with several rows of data. How do I use a macro to
select only a few of the rows of data and export them to microsoft word? When
I looked at the "creating macro" feature in help, I found only entire tables
or queries can be exported. I will be selecting the rows manually... also
will it be possible select some of the forms and export them alone...
thanks for y...
|
2 |
3/1/2007 9:15:05 PM |
|
|
Need help with Debug issue
I was hoping someone could help me out here I have a macro that debugs on the
same spot. But it's not everytime it's just like once everyother time. It's
basically saying it can't find a certain worksheet but...it's right there, if
you get what I mean. If your intrested in trying to help me out please
respond to this with your email so I can send you the Macro so you could see
if you can f...
|
2 |
2/28/2007 11:04:05 PM |
|
|
Open forms in full screen mode on click/open
Hi, I have been attempting to get all of my form screens to open full screen.
From my Main Navigation form all forms are opened by command buttons. How do
you set a macro to open forms full screen.
--
Mark N...
|
2 |
2/28/2007 11:01:19 PM |
|
|
Test
begin 666 Page de test.pdf
M)5!$1BTQ+C,-)>+CS],-"C8@,"!O8FH-/#P@#2],:6YE87)I>F5D(#$@#2]/
M(#@@#2]((%L@,3$U,R R,C(@72 -+TP@-C0X,#(@#2]%(#8S,3(W( TO3B Q
M( TO5" V-#4V-2 -/CX@#65N9&]B:@T@(" @(" @(" @(" @(" @(" @(" @
M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @("!X<F5F#38@
M,S8@#3 P,# P,# P,38@,# P,# @;@T*,# P,# P,3 V-" P,# P,"!N#0HP
M,# P,# Q,S<U(# P,# P(&X-"C P,# P,#$U-SD@...
|
1 |
2/28/2007 2:58:42 PM |
|
|
Testing
Just a testing
...
|
1 |
2/28/2007 8:19:03 AM |
|
|
run macro in Access to start DTS package
I would like to run a macro in Access once a month to run a DTS package on
SQL server 2000 -- does anyone know how to do this?...
|
1 |
2/27/2007 10:25:05 PM |
|
|
Merging Data from MS Outlook to Access?
Can you bring data from Outlook contacts into Access by merging or importing?
...
|
4 |
2/27/2007 2:43:28 PM |
|
|
Form macro
Continuing from last week, I am adding more buttons to my video library
Switchboard, which in turn takes me to various Report Previews. Two things I
would like help with.
First, I would like to structure a query using the
[Forms]![PopUpForm'sName].[People] formula that was given to me earlier. It
works fine when there is only one name in the People field. Sometimes,
however, the field...
|
2 |
2/27/2007 3:56:00 AM |
|
|
MACRO QUERY - how to enable user to "browse" for the "file name"
I've set up a transfer spreadsheet macro to import data automatically into my
Access database.
In the macro section, I have to enter a file name...
I know how to get a lookup box to ask the user to manually enter the
filename. However, what I would prefer is to give the user the opportunity to
BROWSE for the file rather than have to manually enter the path for the file.
Is there a ...
|
9 |
2/26/2007 11:56:05 AM |