|
Access 2007 runtime error 287 application-defined...
I have a simple access database used to track members, print lists and send
email, developed using Office 2007 on Windows Vista. When I click the email
button it pops up a form to prompt for selection criteria then loads an
outlook email. Works fine. But when I install the runtime on a Windows XP
everything works fine except the email. After the selection form pops up and
I click co...
|
8 |
12/30/2008 1:33:29 AM |
|
|
Load List Box when loading form
I posted this question before, but I can't see the response so I apologize in
advance if you answered before. I have a list box which displays all
products, but it takes a few moments to load into memory the first time I
access it. Is there a way to get it to load the data as soon as the form is
loaded? Thanks.
...
|
3 |
12/30/2008 12:54:02 AM |
|
|
Getting List Box to load on startup
I have a listbox on my main form that shows all products in the system. The
first time you access it and scroll down, it is slow - probably the items are
being read from the table into memory at that point. Once you've scrolled
all the way to the bottom, the items are all loaded and you can find any
product quickly and easily. My question is - is there a way to get the items
to load i...
|
3 |
12/30/2008 12:48:01 AM |
|
|
Import Multiple Files using VB
I have multiple .XLS files in a directory that have the same name except for
the last character that I'd like to import into a table.
I can use this code:
DoCmd.TransferSpreadsheet acImport, 8, "Bill Direct", [SubDirectory] &
"pclI083D001.xls", True, "A4:D254"
to transfer a specified file name, but would like to import all files at once.
I've tried using:
DoCmd.TransferSpreads...
|
4 |
12/29/2008 11:04:28 PM |
|
|
Filtering for a record using VB
I previously asked how to autonumber using vb...
I thought more about my question - autonumbering is not really what I am
having difficulties with, but instead filtering for the specific record to
use for the autonumbering...
This is the code I am currently running to get the wallNo field to increment
based on the last number found in the table.
Private Sub Form_Current()
Dim db A...
|
7 |
12/29/2008 10:18:05 PM |
|
|
Error 3141 Cannot resolve
First let me wish "the group" a very Happy New Year. Lang may yer lum
reek!
The following SQL code was created using "SQL Formatter". Although a
different sequence than usually shown I don't see why it won't work.
I deliberately show two "WHERE" lines as I am also trying to get the
user to input the WHERE criteria as in a normal query. The "fs*j" came
out of the original query.
I also can...
|
4 |
12/29/2008 7:54:25 PM |
|
|
Intrinsic Constant Value
I'm printing a list of controls on a form.
Using the ControlType property I get the numeric value of the Intrinsic
Constant as in 100 for a Label, 104 for a Command Button.
How do I have the Constant's Name display rather than the Constant's Value?
For Counter = 0 To MyCount - 1
With frm.Controls(Counter)
Debug.Print .Name & vbTab & .ControlType
End With
Next
Thanks fo...
|
3 |
12/29/2008 5:59:01 PM |
|
|
unbound field
hi,
i have an unbound field in a continuous form. users can type whatever
number they want to in it. i noticed that if there are more than 1 record in
the continuous form, when they type the number for one record, it changes in
the field in the other records too. how can i make it to where the number
typed only affects the number in the current record?
thanks in advance,
geebee
...
|
3 |
12/29/2008 5:29:11 PM |
|
|
Using Microsoft Office Spreadsheet 11.0 in access
Hi all,
Been looking for documentation but cant find any. Any ideas where to look?
Does anyone know if its possible to use validation in this spreadsheet?
Best Regard,...
|
3 |
12/29/2008 2:45:01 PM |
|
|
Filtering using a button
I have a continuous form with a button on it. What I’m trying to do is when
the button is clicked open the record of the button that was clicked. I’ve
been playing, but the more I play the worse it gets. Would someone point me
in the right direction?
--
NotGood@All...
|
3 |
12/29/2008 4:17:00 AM |
|
|
Determine lastest minor version of A2007 in VBA
I have the latest Access 2007 Version (12.0.6211.1000) SP1 MSO
(12.0.6320.5000)
My filedatetime() works on my machine but not other machine with SP1. I
guess it's the minor hotfix (12.0.6320.5000) makes the difference.
How to detect user's Access version and MSO number in VBA?
Thanks
...
|
10 |
12/28/2008 10:36:49 PM |
|
|
.FIRST in a MATCH Query
JOHN,
I HOPE YOU WILL RESPOND AS YOUR LAST ADVICE WORKED GREAT AND I WAS ABLE TO
UNDERSTAND YOUR STYLE OF EXPlANATION.
I have a query now that outputs the records I am interested in. However,
the query will not let me update any of the fields. Specifically, I wish to
"mark TRE" the PRINTFLAG field so that I can run a report and print of only
the records I am interested in.
I assume th...
|
1 |
12/28/2008 9:48:01 PM |
|
|
beginer help pls
I am pretty much good enough in exel programing, macro, and userforms to help
my self with a good extend...
I now want to take it a bit further with access database.
Any good sites with tutorials or examples for beginers?
Thanx guys
--
Helpful advice on posting to newsgroups here...
http://www.cpearson.com/excel/newposte.htm...
|
3 |
12/28/2008 7:48:44 PM |
|
|
Open One Access application with the other
Hello,
I'm using the following VBA code to open with one Access application another
Access application (Office 2003, Windows 2000) and it works great:
Dim acc As New Access.Application
'Open the database
acc.OpenCurrentDatabase "Path.mdb", False, "Password"
'Make the application visible
acc.Visible = True
I have another computer (Office 2007...
|
1 |
12/28/2008 1:15:13 PM |
|
|
Access 2003 Command Line /cmd xxx and Command()
I open a database with a command line ending ....... /cmd xxx or
......... cmd "xxx" or ..... ; xxx etc
I have a startup form and in the form open code I have
Dim abc as string
abc = command ' uses the command function which is supposed to the
return the value piped through the command line after /cmd
I expect the value "xxx" to be placed into abc. I get an e...
|
8 |
12/28/2008 6:06:01 AM |
|
|
Reading the Record Locking File
I have a database with a one Backend and identical copies of the Frontend
placed on the desktop of 12 different computers. I would like to monitor
which computers are accessing the Backend at any time and display that
information using a Form. I would like to "read" the Backend's Record Locking
File and get the computer names that are currently accessing it. (I dont want
to manually open...
|
4 |
12/28/2008 5:00:30 AM |
|
|
call function from string var
Access 03/winxp
I have a function which sets a string variable to the name of a public
procedure based on a case statement. How do I then execute the procedure
when the procedure name is stored in the string variable?
strGetProc = oCalc.GetRdTemplate(NumberOfTeams)
GetRdTemplate is the function which executes a case statement to determine
which procedure should be run. NumberOfTea...
|
3 |
12/28/2008 1:57:01 AM |
|
|
File Format
When a A-2007 .accdt file is converted to the old .mdb format, does that mean
A-2000 can then open the file, import, and connect to it via automation ?
Thank you.
--
BrerGoose
Moose-Tech Software:
http://ourworld.compuserve.com/homepages/webspace/MTS/Home.htm...
|
2 |
12/28/2008 12:51:33 AM |
|
|
Call custom help file
Hi,
In my database I have multiple forms all linked to a custom help file. I
would like to place a button on each of these forms to call up the index of
the help file.
I have tried creating a module with a function that can be called up 'on
click' from each form. For some reason all attempts have failed at this.
I am using Access 2007, and the help file is created using a Help File
Comp...
|
1 |
12/28/2008 12:10:01 AM |
|
|
Record Set Question
I am currently creating a recordset as follows:
strSQL = "SELECT * from CHospital ORDER BY ID"
Set rs = db.OpenRecordset(strSQL, dbOpenDynaset, dbSeeChanges)
Close #1
Open "u:\interfaces\uif\" & Format(Time, "HHMMSS") & "_" & strOrigFile
For Output As #1
strClientNum = Right(rs.Fields("ClientCode"), 3)
I then have a program that takes the recordset and I create a fi...
|
1 |
12/27/2008 3:57:00 PM |
|
|
Generate Random numbers
Do I have any function similar to randbetween() function of Excel in MS
Access? ...
|
2 |
12/27/2008 12:37:08 PM |
|
|
report to pdf: hidden mode seems to toggle
In Access 2003, I have a report that I want to use with a Where Condition to
create a file. It doesn't much matter whether the destination format is rtf
with OutputTo or pdf using Steven Lebans' ConvertReportToPDF module; what
does matter is that the report is filtered using a coded Where condition and
that the report preview window NOT open.
I've tested this:
dtMyDate = Now()
...
|
3 |
12/27/2008 4:55:16 AM |
|
|
Light up information
I´m developing an application at access, in need to light up some records
according to some percentage defined by the user. For example, I want to
remark the records with the values that represents the 80% of the incomes. In
excel I can use the conditional formatting tool over a column with the
calculated percentage, but in access I have not found how to use the total
value of the repor...
|
3 |
12/27/2008 1:21:02 AM |
|
|
Auto Numbering...Default Value: =DMax("[Task#]","[QryTask#]")+1
Please, not again, you might think...!!!
It works perfectly assigning a new Task# to a new record in a subform in
single mode view, but not in continuous mode view, since a new record is
created before the current one is fininshed.
The numbers dbl up.
As soon as I run out of space in the subform and need to use the add rec
button, it works.
Is there a way not having to write the code ...
|
5 |
12/27/2008 12:06:13 AM |
|
|
Using the $ after functions
This is a general question...Is there any difference using a function in the
expression builder that ends with the $ and one that does not?
--
Ken...
|
6 |
12/26/2008 10:41:42 PM |