"Range" values
Thu, 25 Sep 2008 15:27:01 -0700
I am importing data from an excel spreadsheet into an Access table. I only
need the data from columns A, C, and E. If I set the range to A1;E20 I get
data from columns B and D also. How do I write the range so it only imports
A, C and E? ...
|
autopopulate information in another table
Thu, 25 Sep 2008 15:22:00 -0700
Access 2002
Here's what I want to do:
When I check a box(name = attachment problems) on a form (name = Roof
Inspection), I want another form to open (Action Items),with a text box (name
= Item with error) to autopopulate with: roof edge attachment problems that
is stored in tblActionItems. This new forms h ...
|
Send a reminder message and import a due date into Outlook Calenda
Thu, 25 Sep 2008 12:28:11 -0700
I am trying to create a database that will track corporate sponsorship
opportunities, goals, money, open due dates. In addition, I want to import
due dates from access database into Outlook. Is this possible? If so, please
explain how and simply.
Thank you, in advance for your replies.
--
Lea ...
|
copy record to clipboard
Thu, 25 Sep 2008 05:55:02 -0700
I have a form which contains IP addresses for devices in a network.
I need to create a Button which will copy the current records IP address to
the clipboard and then run a application which logs on to the device.
The application I use is SecureCRT and I have a script which used the
clipboard to automaticall ...
|
MsgBox Module Help
Thu, 25 Sep 2008 04:32:38 GMT
Hello,
I'm trying to fumble my way through a module to create the following sub.
Can you tell me what I'm doing wrong and how I can call this from a macro?
Or let me know if I'm totally off base... Thanks so much!
Option Compare Database
Option Explicit
Private Sub Append1_MsgBox()
Dim intAnswe ...
|
MsgBox Response Actions
Thu, 25 Sep 2008 02:53:17 GMT
Hello,
I need a little help ... I'm not an expert in VB Code, but I manage to get
around. I can write macros farily well but I'm stuck on this task.
I'm trying to set up a macro that utilizes the MsgBox function with Yes, No,
and Cancel responses. Based on what the user clicks, I want it to perform
diff ...
|
Macro to run refresh of linked tables automatically
Tue, 23 Sep 2008 14:17:22 -0700 (PDT)
I am having problems trying to automate the refresh of linked tables.
I have two tables linked to Excel spreadsheets. Since these
spreadsheets are exported from different files in the same program,
they need to be refreshed just in case the user doesn't name the
exported Excel files the same and/or doesn't puts ...
|
|
|
Create macro to run linked table manager automatically
Tue, 23 Sep 2008 14:12:18 -0700 (PDT)
I am having problems trying to automate the refresh of linked tables.
I have two tables linked to Excel spreadsheets. Since these
spreadsheets are exported from different files in the same program,
they need to be refreshed just in case the user doesn't name the
exported Excel files the same and/or doesn't puts ...
|
Text length in the macro "Send object"
Tue, 23 Sep 2008 08:22:23 -0700
As I can see I only have the possibility to use 256 signs in teh "Text
Message"-box in abovementioned macro.
Is there a way to expand this so I can wite more predefined text in my mail ??
...
|
Message Box after data import
Tue, 23 Sep 2008 07:54:03 -0700
Hi,
I have a macro setup that imports data from excel using the
transferspreadsheet method. This works fine for me. What I want is a meesage
to the user notifying them of how many records they have imported to the
relevant table.
I have tried using dcount in the condition but can't get my head around it. ...
|
