Being Asked For A Parameter That I Cant Find

Jan 9, 2008

Ok, I reckon there's a gremlin in this damn db...

For a form, i have a series of check boxes. One of these had a & symbol in the name, i originally had this working, but with some extra functionality added it no longer became possible, as it recognised it as a special character. The checkbox, and relating table reference was Inform_Q&FS I changed all references of it to Inform_QFS. However, im getting a parameter window pop up asking for the original reference. I've tracked it down to a point between a button being clicked and the begining of the following forms load Sub. The point of the button method triggering the parameter window is the line where the button changes the subform to the new form.

Here is the db..

Could somebody please take a look and see whats going on... im starting to get really frustrated with databases. :(

Also, any general comments regarding the db are welcome, as i'm assuming im doing things the right way there. and excuse the messy coding

View Replies


ADVERTISEMENT

I Know It's Been Asked Before, But I Can't Find It

Feb 15, 2007

Small project for the local police dept. They want an easy small program to track overtime and who gets it, got it, doesn't want it, etc.

All good, but they want to be able to generate a list (report or on screen) of all those who has received OT and their balance to date, with he/she with the least OT first and ascending from there. In a report I can easily use the sum function in the section footer but how can I sort by that? Or, harder yet, how can I add the numbers in a column in a table/query since the field which contains the "OT hours assigned" will be for each assignment?

So, I guess I need to add a given field value to the other values for a running balance (of coarse this will need to be seperated by each employee).
Thanks

Jim

View 2 Replies View Related

Can't Find Parameter

Mar 11, 2008

Hi!
I was out of the office yesterday and today I came back and got into the database and now it's asking for a parameter. As I didn't set parameters for anything I have no clue where this could have come from. I have checked everywhere and cannot find this. Is there a way it will tell me where this is so I can get rid of it.

View 6 Replies View Related

Can't Find Parameter To Delete. . .

Sep 7, 2004

I have a query that asks for the start date and end date in order to generate the results. I have a report built off of it.

I changed the name of the fields so that there are no spaces. The query still runs correctly. However, when I try to open the report, I get asked for the start date, the end date, and the start date again. I assume is is somehow still looking for the original start date--the one with the space. I have checked the sorting and grouping and the fields on the report, but I can't find where it might be. Does anyone know where else to look?

View 2 Replies View Related

Get A Field Only If It Equals What I Asked

Sep 18, 2005

I have a table with data of people, in which table two fields contain two (not necessarily different) jobs.

I want to build a query (and later a report based on that query) which will return the name, address, phone of the person, plus only the field of the job that I asked for it.
when executing the query, the user should enter the asked job in a popup-box using the below formula.

Like "*" & [job] & "*"

Note, that there may be records containing in both job fields the same job. I want to get the field only if it contains the asked job.

Any ideas?

Thanks

View 12 Replies View Related

Just Update It, No Questions Asked!!

Aug 19, 2004

When you run an Update Query using RunSQL, it always comes up with a box telling you the number of records you are updating and if you want to update. Is there a way to stop this box coming up and just perform the query.

Ed

View 1 Replies View Related

Interesting Question Asked Of Me...

Jul 28, 2005

I'm not looking for your expertise in "how to" do this (not yet, anyway) but a friend asked me if Access could do certain functions. Like "automatically fill-in some of the
more routine letters/forms such as basic letters of
representation, medical bill/record requests"
(routine for his biz) and "basic calendaring
functions, such as keeping track of monthly deadlines, reminders, and other
important dates."

I figured that if so, the app would have to be running in order track deadlines and such.

So, are these things that are Access able functions?

Tx
-Jim

View 3 Replies View Related

Viewing Asked Questions At Same Time

Nov 13, 2005

Is there a way within this forum I could view all my questions/posts asked at the same time?

Thanks.

View 1 Replies View Related

Possibly The Easiest Question Ever Asked

Feb 1, 2008

This is probably blindingly obvious but I'm unsure about it.

We'll refer to three tables, call them Table X, Table Y and Table Z.

Basically, I have a database with 10 tables. Table X links to Table Y via the Primary Key. Another field in Table X has a relationship with the Primary Key in Table Z (a foreign key).

Now, does the field in Table X that has a relationship with the primary key in Table Z need to be the primary key as well?

Put another way, does Table X need two primary keys?

View 1 Replies View Related

Simple Question Probably Asked And Answered Previously

Sep 12, 2005

Trying to fix a simple problem with some tables.

In my department, we recently switched servers and from Windows 98 to Windows 2000. We had a database that got converted somehow during the transition. One person didn't get their computer switched until about a month later.

In essence we had 2 databases of the same information going for a while. Now everyone has the same database. Problem is the following:

Simply put:

We have 10,000 records autonumbered in one of the databases. The other database has 9,500 with the last 100 or so being information that the 1st database does not contain. How can I update my main table to have all 10,100 records? I have tried an append query and it doesn't seem to be working right. I have also tried to 'find unmatched' but can't seem to make that work either. There has to be an easy solution to make it work in one step.

Any help would be great. Thanks in advance. :confused:

View 1 Replies View Related

Reports :: Data Range Asked Twice For A Field When Open Report

Mar 26, 2014

I am in the process of making some changes to an inherited database. One of the things I need to do is to fix an issue with the reports. The reports have a field which asks for the data range (from xx/xx/xx to xx/xx/xx) as soon as the report is opened, but then the query that fills that report also asks for the same data range so you end up entering it twice.

What do I need to do to enter the data range only once and have it show up on the report and also be used on the query?

View 3 Replies View Related

Capturing Parameter From Parameter Query

Jul 12, 2005

I have a form whose data source is a select query, q3, that is built from 2 other select queries. I'll call them q1, q2, and q3. q1 is a parameter query where I enter a "Cutoff Date" that the 3 queries manipulte and generate the desired results that appear in the form. The problem is that I don't know how to capture the parameter "Cutoff Date" from q1 to display on the form.

View 2 Replies View Related

Queries :: Find A Way For Access To Find Unique Dates And Unique Names?

Aug 1, 2014

I have been working on a simple data base for some time now (beginner level) and am still trying to improve it. I would like to do something but before that I would like to have your opinion to know if it is even possible?I have a query QryMainReport:

Start Date/Time
End Date/Time
Employee

At the moment this is what the format of my report looks like (I removed other unnecessary fields):

StartTime----------EndTime---------------Employee
12/06/2014 01:00--12/06/2014 03:00------John Smith
12/06/2014 04:00--12/06/2014 06:00------Jane Doe
13/06/2014 02:00--13/06/2014 05:00------John Smith
13/06/2014 08:00--13/06/2014 08:00------Jane Doe

I would like to do as a report. (Dates would always be from Sunday to Saturday). I am not sure it is possible to do that. I suppose first it would mean:I would have to do a query to separate the times from the dates?I would have to find a way for Access to find the unique dates and unique names?Does it mean I have to use cross tab queries?

View 2 Replies View Related

Parameter Query Asking For Parameter More Than Once!

Nov 9, 2006

Hi,

I have a query that requires a Start-Date and an End-Date to be input by user for the Where clause. It is asking for both over and over. I've had it ask from 1 up to 4 times! :eek: Shouldn't it store the input and only ask for it once? I'm thinking that the way my query is arranged may be causing it to have to loop through that section more than once to find the data, but that's just my theory. Any help would be great!

Here is my code (abbreviated slightly):

SELECT DISTINCTROW C1.*, C2.*
FROM Pen AS C1 INNER JOIN Jobs AS C2 ON C1.subno=C2.[Jobs Acct]
WHERE ((C1.typ="SS" Or C1.typ="CC" Or C1.typ="PP" Or C1.typ="TT") And C1.stdate>=[Enter Start Date] And C1.stdate<=[Enter End Date] And C2.[Type]<>"EE" And C2.[Type]<>"QQ" And C1.entdate<=C2.[ChangeDate]+60);

I'm selecting rows from "Pen" and "Jobs" that have the same subno/Jobs Acct numbers (text), then there are criteria for "Pen" types, user inputs criteria for date range (Start Date and End Date) and there are criteria for "Jobs" types. Finally, there's a cross-table criteria based on a date field ("Pen" entdate should not be more than 60 days past the "Jobs" ChangeDate). Tables are in quotes in my explanation here.

So running the above, it asks for user input "Enter Start Date", then again for "Enter End Date"...but then it asks for each again...and again...and sometimes again!

Help! :confused:

P.S..I didn't notice this repeating until I made it user input (parameter query) because it was using whatever dates I hard-coded in there before.

View 2 Replies View Related

A Word Find Can't Find

May 23, 2005

A customer's name is SZEE. Seek him through the SName textbox with Find, and Access can't find him. (Same in the table.) Seek him with a wildcard Sz* and there he is.

I've tried it on another machine - also with Access2k - and it's the same.

Is it an Access quirk? Is there an answer? (The client asks why. Be good to be able to say.) Cheers.

View 3 Replies View Related

Parameter

May 28, 2005

Hi all,

Can i populate a parameter just like i populate a combo box?

I want to have a FIXED value for parameter. May I know how to do this.


Thank you

View 3 Replies View Related

Parameter Value

Jul 31, 2007

Hi,

I am creating a database for work and I keep getting a message that pops up when I opn my form that says "tblClientBFinfo.ClosedReason". Then there is a place to enter a value and and it says "ENTER PARAMETER VALUE." I know it is a problem with one of my tables, specifically the "closed reason" field in the table. But I odn't know why it is asking me to enter a parameter value. Could anyone offer help?

Thanks!

View 3 Replies View Related

Parameter

Jul 6, 2005

I need a new parameter in my query. When I open the query i need the parameter to be asked in a combo box or drop down box or any way to select the value from the groupo other than typing.

View 1 Replies View Related

Help On Parameter

Jul 6, 2005

I need a new parameter in my query which enables me to select from a field in the table rather than typing .

View 1 Replies View Related

Parameter Help Please

Feb 9, 2006

I want to run a query automatically in the gotfocus event of a field within a form.
Prior to the gotfocus, a value is entered in an unbound text box on the form and I want to use that value for the maximum value in the parameters. I will set the minimum to zero.

My code errors in the where, it has no problem with the serial number but I can't seem to set the deliv_no to pull the value entered on the form.

SELECT Sum(VOLTEST.unc_del) AS SumOfunc_del
FROM VOLTEST
WHERE (((VOLTEST.SERIAL_NO)=[Forms]![largeVolume1]![serial]) AND ((VOLTEST.DELIV_NO)>0 And (VOLTEST.DELIV_NO)<=([Forms![largeVolume1]![No_del])));

I figure this is a syntax problem. Can you guys see where I have gone wrong?

I need the value to write to the table, not the form when this runs.

Thanks, GG

View 1 Replies View Related

Yes/no Parameter

Aug 10, 2006

In my chart I have a yes/no field that I would like to set up a query to for. I want the user to be able to input yes or no and then the data be displayed. Whenever I enter yes or no when the prompt comes up, I get an error saying the expression is typed incorrectly or the data is too complex. How do I set it up so the user can select yes or no in some way? thanks

View 5 Replies View Related

Parameter Box

Feb 1, 2005

Hi all.I have a form that links to another form using the following macro "[homerid]=[Forms]![Homer Input]![homerid]" so when I click on form 2 the homerid from form 1 is automatically displayed. However on my switchboard I have a direct link to my Form 2 but when I click on this i get a box come up which is titled "enter parameter value" and then the subtitle is "[homerid]=[Forms]![Homer Input]![homerid]", this is fine, but I would like to change the subtitle to something i write myself such as "please enter homerid". Is their a way of doing this? Thanks.

View 2 Replies View Related

Asking For A Parameter

Sep 22, 2006

Hi,

I have been programing SQL for almost 3 years now but, am a newbie with access. I have just added a field to a form used by employees to enter time and am getting a parameter request when the user clicks Add Entry. I placed a msgBox before the insert line and noticed the field data (type memo) is being sent by the insert query as an integer (without quotes). Any ideas how I might get the insert to pass the Comments field as a string?

Thanks,

~Leo


Private Sub AddTimesheet()

On Error GoTo Err_AddTimesheet

Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim strSQL As String
'
Set db = CurrentDb()
'

strSQL = "SELECT * FROM tblTimeCard "
strSQL = strSQL & " WHERE [EmpID] = " & Me.cboEmp
strSQL = strSQL & " AND [Category] = " & Me.cboCategory
strSQL = strSQL & " AND [Week] = " & Me.cboWeek & ";"


'

Set rst = db.OpenRecordset( _
strSQL, dbOpenDynaset, dbReadOnly)

'
With rst


If Not .EOF Then

MsgBox ("Time sheet for this employee, category, and week already exists. Please click the record at the bottom of the screen to edit.")
Exit Sub
End If

End With

strSQL = "INSERT INTO tblTimeCard (EmpId, Category, Week, Hours, Comments, CreateDt, CreateID) SELECT "


If IsNull(Me.cboEmp) Then
strSQL = strSQL & "null, "
Else
strSQL = strSQL & Trim(Me.cboEmp) & ", "
End If

If IsNull(Me.cboCategory) Then
strSQL = strSQL & "null, "
Else
strSQL = strSQL & Trim(Me.cboCategory) & ", "
End If

If IsNull(Me.cboWeek) Then
strSQL = strSQL & "null, "
Else
strSQL = strSQL & Trim(Me.cboWeek) & ", "
End If

If IsNull(Me.txtHrs) Then
strSQL = strSQL & "null, "
Else
strSQL = strSQL & Trim(Me.txtHrs) & ", "
End If

If IsNull(Me.txtComments) Then
strSQL = strSQL & "null, "
Else
strSQL = strSQL & Trim(Me.txtComments) & ", "
End If

strSQL = strSQL & "'" & Now() & "', "
strSQL = strSQL & "'" & Trim(Me.txtLogon) & "' "

'Before Insert
MsgBox (strSQL)

DoCmd.RunSQL strSQL

'After Insert

Me.Refresh

Exit_AddTimesheet:
Exit Sub

Err_AddTimesheet:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_AddTimesheet

End Sub

View 5 Replies View Related

HELP!! How Do I Get Rid Of Parameter Value?

Oct 29, 2004

Hello,

I do not know what I did but now when I open my database it asks me over and over again to "enter parameter value" and it won't let me open the database like normal. Please help!

Katie

View 3 Replies View Related

Find

Aug 10, 2006

Is there any way I can do a search that lets me put in a section of a part number and the part number be found? I only see how I can find the number if I put in the entire number.

Thanks

View 4 Replies View Related

Find Less The Following.

Apr 25, 2006

I think this is fairly simple, but being as I haven't ever done it! I want to do a search to find all records less those called "Default". As I say I just cant think how to do it. Any help appreciated. Thanks

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved