Query prompt to change field retrieved
Mon, 29 Dec 2008 13:46:04 -0800
I'm working with a table with a field for each month of the year. (can't be
changed) I need to query data for last month and I would like to be able to
prompt for a field. Does anyone have some code that would allow me to do
this?
...
|
Find ranges or series of integers
Mon, 29 Dec 2008 11:57:01 -0800
I have an integer field named "section". I need a routine that will query
that [section] in a manner like the way Microsoft Word accepts page numbers
for printing. I envision having a search box on a form and entering either
single values (like "18"), multiple values separated by commas (like
"18,23,25") or ...
|
How to reuse the Access 2007 ribbon buttons
Mon, 29 Dec 2008 11:53:01 -0800
Is it possible to reuse the Access 2007 ribbon buttons in a new ribbon?
I know I can create a USysRibbons table to save some new ribbons. I know how
to define groups and buttons with XML. I know how to create VBA subroutines
to handle user clicks on these new ribbons. However:
1) Everything was easier if I can ...
|
Import Multiple Files using VB
Mon, 29 Dec 2008 18:08:50 GMT
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 woul ...
|
Code not working correctly
Mon, 29 Dec 2008 09:49:01 -0800
I have the following code running from a command button, and it ignores the
section after the "&" sign in the strTableName statement, so it just gives me
a Table called tblBackupEnhancedCodes without the date. I can't figure out
what I am doing wrong. I want to run this periodically and create a backup
of ...
|
unbound field
Mon, 29 Dec 2008 08:40:01 -0800
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
...
|
Intrinsic Constant Value
Mon, 29 Dec 2008 08:29:01 -0800
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(Count ...
|
|
|
Error 3141 Cannot resolve
Mon, 29 Dec 2008 07:08:58 -0800 (PST)
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 cri ...
|
OpenRecordset SQL using wrong SQL statement
Mon, 29 Dec 2008 13:43:59 GMT
I have an issue where I am using 3 different SQL statements strSQL, strSQL1
and strSQLUp in a Do Loop:
strSQL = "Select OpCode " & _
"FROM R2ROpCodes " & _
"WHERE R2RPerfID=" & Me.R2RPerfID & ";"
Set rec1 = CurrentDb().OpenRecordset(strSQL)
...
|
.FIRST in a MATCH Query
Sun, 28 Dec 2008 13:48:01 -0800
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 ...
|
