Select specific text from field in query
Thu, 13 Nov 2008 10:08:42 -0600
I need to query or filter on a field that has various characters and I am
unsure how to do this. I am not skilled in VBA so i am trying to use the
criteria builder in Access on that field. Here is what I am trying to do.
The data in the fields look something like this:
FIELD1
22N 3 33N
4 5 22N
3
3N
4 ...
|
Macro for specific number of characters in a cell
Wed, 12 Nov 2008 08:28:01 -0800
Hello! I have a list of account numbers (some of which include letters) and
most of them currently have 3-5 characters in the cell. However, I need for
each cell to have 9 characters. Thus, I need to have zeros before the
account numbers in order to make the cell have 9 characters.
ex: currently the acc ...
|
??????
Wed, 12 Nov 2008 09:16:32 -0700
zugeerspam@yahoo.com
...
|
??????
Wed, 12 Nov 2008 02:05:34 -0700
...
|
Registry values to disable all macro security warnings in Access2007
Tue, 11 Nov 2008 12:28:52 GMT
Hi,
Am unable to run all macros even after doing registy editing as shown below.
Please advise. Some macros are appearing with an information symbol in design
mode(means won't be executed) Please advise.
Regards,
Charley
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Of ...
|
floundering - help with generating territory data
Mon, 10 Nov 2008 18:06:24 -0600
I am having difficulty with MS Access and I am not sure how to go about
getting assistance. At this point I have considered just hiring someone
locally to do this work but ultimately I just need the quickest solution so
I thought I would post to see if it was somehow easily explainable (and I
really don't k ...
|
Turn_off confirm message"Table will be deleted" inside a Macro
Mon, 10 Nov 2008 13:31:03 -0800
I am running a Macro that opens a MkTb Query. This Macro is Sub to a
RunMacro command that repeats a calculated number of times. I can not get
the Macro to run without the confirm message "Table ... will be deleted"
appearing and having to click yes on the confirm message. This Macro will
cycle as many as ...
|
|
|
Re: Import/Export Multiple Excel Files to Access
Mon, 10 Nov 2008 09:13:00 -0800
OK Ken I think we are getting closer, however here is the error message that
I get now: COMPILE ERROR; INVALID INSIDE PROCEDURE. This message comes at
the Option Explicit line. Attached is what my code looks like now.
Option Compare Database
Public Function ImportExcelMultipleFiles()
Option Explicit
...
|
Problems with edithyperlink macro action
Mon, 10 Nov 2008 08:06:02 -0800
I use Access 2007. I have created a macro to enable users to hyperlink files
to their newly created records. The user clicks on the default link, which
contains the full path to the server. The macro open the edit hyperlink
window, with the default location, already selected, and then the user clicks
on brow ...
|
????
Mon, 10 Nov 2008 12:09:09 +0200
ëÁË ÖÉÚÎØ?
...
|
