query is asking for parameter value
Wed, 27 Aug 2008 09:02:01 -0700
Thank you all for looking. I am running an update query and for some reason
Access is prompting me for a parameter value for
"qry_original_atm_model!model" I have has no luck making this message box not
pop up. The query seems to run fine if I just hit enter, but I would like
the message box to not appear. ...
|
Multiple Offenders of Parking Violations
Wed, 27 Aug 2008 08:27:01 -0700
First, I'd like say I'm sorry if this question has been answered before for a
similar situation.
I"m trying to create a Parking Ticket Databaste for a Corporate Headquarters.
One of the things I would like to do is keep track of those with multiple
offenses and run a report based off a query.
I would like t ...
|
Incorrect sort results within query
Wed, 27 Aug 2008 07:49:01 -0700
Is there a limit of the number of sort items one can have within a query. We
are using MS Access 2002. I am using the following query but getting
incorrect sort results. The 6th sort item is not sorting correctly. See
query below...
SELECT [regulation parents].*, [pseudo countries].[Region name]
FROM ...
|
Adding * to the possible parameter values selected in a Combo Box
Wed, 27 Aug 2008 07:31:01 -0700
I have created a form that is used to select filter criteria for a variety of
reports. The form has three combo boxes which have cascading dependencies
i.e., the results of the second are dependant on the selection made in the
first and the results of the third are dependent on the selection made in the
sec ...
|
Make Table Query to external ODBC SQL Server database
Wed, 27 Aug 2008 07:20:39 -0700 (PDT)
Hi All,
Is it possible to create a Make Table query in access (2.0 and 2003)
that creates the table into a SQL Server database?
Following the steps:
1- Create New Query
2- Set Query Type as Make-Table query
3- Enter table name
4- Click "Another Database", click Browse, then I cannot see anything
about da ...
|
two table query
Wed, 27 Aug 2008 06:46:01 -0700
have tblinvoice with fields [id] [date] [Customer] {invoice#] [amount] and
tblcreditcard with fields [id] [date] [customer] [gross] [fee]. I want to
setup query to get [date] [customer] [invoice#] [amount] and [gross] and
[fee] they sometimes do not have same dates. I can get info from one or the
other tried ...
|
Show form record number in query results
Wed, 27 Aug 2008 06:01:01 -0700
I have a database with around 4,400 records. The main form I use to manage
the data combines all these records into 360 "pages". I have the main form
and included sub-forms designed to show the record ID for the record being
displayed. As an example, the main form will show a field for companies table
record ...
|
|
|
part of multi search query non-functional
Wed, 27 Aug 2008 01:58:01 -0700
In a database I have 2 name fields 1 for last name and 1 for first name.
FOr each field I have the following criteria:
Like [Forms]![searchscreen]![author] & "*"
Like "*" & [Forms]![searchscreen]![author] & "*"
Like "*" & [Forms]![searchscreen]![author]
And I have a column [Forms]![searchscreen]![author] that ...
|
Format Report
Tue, 26 Aug 2008 23:27:00 -0700
Hi, how do it translate this data
ID-----NAME-----COUNT-----LOC
10-----PETE-----300----------NORTH
10-----PETE-----20-----------EAST
10-----PETE-----5------------WEST
15-----JACK-----20----------EAST
15-----JACK-----10----------SOUTH
into this format
ID-----NAME-----TOTAL_COUNT-----COUNT_LOC1-----LOC1- ...
|
Run Sql
Tue, 26 Aug 2008 21:58:01 -0700
I am updating records from an update form.
Unbound Textboxes in the form header allow the user to enter the values
that they want to update specific fields to. Each Unbound Textbox will
update a specific field in the underlying record source.
The user clicks a button to update the records based on a filt ...
|
