Enter A Parmeter Value Intermittent

Aug 19, 2005

Hi all,

I have a problem in a database I'm designing at the moment. Basically I have a form (frmMain) which is filtered (from another form). I can then go through the filtered records no problem. I made a query, and also a report based on this query. The query has all fields from the main table (same as frmMain), and I want to base the query on a field on the filtered form (fldJobRef). Now, sometimes this works fine, othertimes I get the box saying "enter a parmeter value" for Forms!frmMAIN!fldJobRef. The form frmMain is open at this time, and I can see plainly and clearly on this form a fldJobRef ! If I go into design view in the query and "build" the criteria again, it works for a short while, can anyone offer any suggestion?

Thanks

[UPDATE]
I found that if I simply open the main form without any filter at all, then the query works fine.

View Replies

Intermittent Database Access

Dec 27, 2006

I have a website that runs on a host out in the real world. I need to do some work on it in a test environment. I started IIS on XP pro and created a website under the default wwwroot. The site runs and connects to a MS Access database and will show a list of records pulled from the database, but only once. Refreshes fail with an error: Provider (0x80004005) Unspecified error.

If I wait a few minutes I can access the database again. I can not find the problem. Please help.

View 5 Replies View Related

Intermittent Problems With Record Locking

May 2, 2007

hi,
I've got a database that is split -front/back on a server. It is used by roughly 5 people. Usually one or two people use it at one time, with one of the users who leaves the application open at all times. Sometimes when the users are working in the screen, which would be in the subform, an error like "record is locked" pops up and they cannot enter any data. This happens on a date field where I have put some code to auto fill the date if the previous record has today's date in it. It doesn't seem like it should be locking on that. Should it? This is what I have in the code:
Code:Option Compare DatabasePublic DateValue As DatePublic DatePresent As BooleanPrivate Sub DateLog_AfterUpdate() 'fill the date with previous entry - if it has been entered in same session DateValue = Me.DateLog.Value DatePresent = True End SubPrivate Sub DateLog_GotFocus() If (DatePresent) Then Me.DateLog.Value = DateValue End IfEnd SubPrivate Sub Form_Load()Me.RequeryDatePresent = FalseEnd Sub

View 2 Replies View Related

Intermittent Form Link Criteria Fault

Dec 1, 2006

:mad: and tearing out my hair with this one...
Someone out there please help:

I have a form that should open, linking to the date on another form (that is changeable using a Calendar Control), and display records for that date.

My underlying data is available for a variety of dates but some of the dates (and therefore the records) will not appear when this form opens.

They will all show if the form is opened without the filter. Or they will show in a report.
So I know that the coding is correct.
This intermittent-type thing is really bugging me.

Have even tried re-typing some of the dates in the table in case the format has somhow got changed.

Nothing is working.

View 14 Replies View Related

Intermittent Generic Error Messages Causing A Major Inconvenience

May 26, 2006

Hi,

I am absolutely puzzeled with a problem we are having with an Ms Access 2000 application, which is the front end to a SQL Server database. We have a database which was working fine for over 6 months. And now all of sudden users are intermittently getting the error messages:

"Error Executing this command"
AND
"You cancelled the previous operation."

I removed the error handling code from the application to get more detailed error messages and we got the following error message:

The expression On Click you entered as the event property setting produced the following error: .

The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].

There may have been an error evaluating the function, event, or macro.

This is only intermittent and when they close the database and open it again it works fine for a little while and then the error occurs again. As you can imagine this is a major inconvenience for users.

I have searched the web and forums and there just seems to be 101 reasons why this could happen. Nothing has changed on our system which might cause this occur so I don't know why this is happening.

Could anybody provide any ideas on how I might go about trouble shooting it. We are thinking of opening a support call with Microsoft but the error messages are so generic that I'm not sure what help they could be.

Any help / ideas or suggestions would be greatly appreciated.

Many Thanks

View 4 Replies View Related

Where Do I Enter A Query?

Aug 11, 2005

I want to be able to simply type out my query. It's faster for me than using the GUI.

Where in Access can I just enter a statement?

View 1 Replies View Related

Enter Parameters

May 3, 2006

Hi,
I have a Data Access Page which is generated on behalf of a query.
Query uses one parameter field ,so when is started it promts with the form named Enter Parameters in which I have to input parameter value.
So before the DAP is opened, first is displayed parameter form.
I would like to change dimensions of that form(height, width) but I dont know how.
I already tryied by opening DAP in design view & then in microsoft script editor but i couldn't find anything about this pop-up parameter form.
Any suggestions are wellcome:rolleyes:

View 1 Replies View Related

Cannot Enter Data

Sep 3, 2007

I have built a database which has been running OK for 3 or 4 years. Something happened the other day (error - rebuild d/base) and now there are certain fields that I cannot enter any data into. Others are fine and I can see what is already there.
Any suggestions very welcome.

View 2 Replies View Related

Enter Parameter Value

Jun 8, 2005

I have a form and it is related with a query and by clicking ok I got the required results in Access 97. But now I have converted to Access 2002 and whenever i enter values in the form and click ok I get a Dialog Box "Enter Dialog Box". I read MKB article but it did not help me at all. Please help me out I am not getting any idea at all to solve this problem?

View 6 Replies View Related

Enter Parameter Value

Jun 1, 2007

I have searched other threads and cannot find one that helps solve my problem. So, I hope someone can help.

I have a query which runs ok until it is filtered. I have tried using criteria to filter the info I need but this returns an 'Enter Parameter Value' message. Running the query without using criteria works okay but using a filter in the report itself returns a 'Data Mismatch' message.

The report filters fine on fields until it gets to one that has been changed from text to number. It also includes an Nz formula. The formula in the is field is: CLng(Nz([order_no],0)). Other fields related to this also appear to be affected.

I need the CLng formula as the field is needed to calculate other fields using a zero instead of a null which would otherwise cause an error. I was given the formula on this forum yesterday, (thanks Bob Larson and AlanJ10), which was great in solving the other issue but is this is what is affecting filtering, (ie. a confusion between text and number?!?!) I have also tried converting the result of the calculation I want to filter back into text using CStr but this does not make any difference.

I have checked the field names and also renamed fields that were 'Expr' (as in default names for calculated fields), and cannot see any problems.

Thanks

View 5 Replies View Related

Enter Parameter Value (need Help)

Sep 29, 2007

I have a query and one of the fields/headings i have it create is a "cost" total where it does a dlookup from a defaults table.

I then have a "listprice" which is antoher field in the querry of which the data table sits.

I want to take the [listprice] and minus the [cost] without re-creating the dlookup function...

I need this to help with an APR calulction using the RATE function which if i have it do all the dlookups it says I have exceeded the limitiation and will be trumcated. So if i use the name [cost] it works but i have to hit enter because it says "Enter Parameter Value".

Any ideas how to get around this?

Thank you.

View 1 Replies View Related

Enter Parameter Value

Jan 26, 2008

I have the following query that gives me this halt. If I enter without responding to it it opens in Datasheet view as intended. It wants me to enter Query2.EmpID. This is my SQL statement.

SELECT qryPolicyByDriverName.CWSPolicy, qryPolicyByDriverName.EmpID, qryPolicyByDriverName.DriverName
FROM tblTrainingPoliciesNotCoveredDrivers INNER JOIN qryPolicyByDriverName ON tblTrainingPoliciesNotCoveredDrivers.CWSPolicy = qryPolicyByDriverName.CWSPolicy;

I don't know why this is happening. Thanks for looking at my problem.

View 2 Replies View Related

Usage Of Enter Key

May 26, 2005

I have a continuous form with an unbound text box (for search critera) and a command button to kick off the search, which simply applies a filter.

When a user enters text in the unbound text box and hits "Enter", I want the search to be kicked off (instead of having to tab over or mouse over to click the "Search" command button. This is the default functionality of an HTML <form>, so users kind of expect it. But I'm having trouble implementing it in MsAccess.

I've tried using the KeyDown property of the unbound textbox, but no luck, since the KeyDown method occurs before the data in the box is saved. I'm guessing this is related to detecting what key has been pressed but my issue seems to be the order of events occurring on the form.

Any suggestions? This *must* be common situation, but I've found no related topics in searching the forum.

View 3 Replies View Related

Enter Parameter Value

Jul 9, 2005

ok im am not sure if this is in the right place but it seems to be a form problem.
i have a form that has a textbox(text1) which is used to enter a supplier name, the user then presses enter and another form opens up with all the supplier details.ok.
the code i have to do this is on the afterupdate of text1 which is unbound is
DoCmd.openform"SupplierDetails",,,"[Supplier Name]=" & Supplier name
when i use this code and the enter key is pressed an `Enter Parameter Value` dialog box appears with the supplier name under the blue title bar.if i then enter the supplier name again it opens the second form and displays all the details i want.
If i use the code
DoCmd.openform"SupplierDetails",,,"[Supplier Name]"= me.Supplier_name
it opens up the second form without the dialog box but it doesnt display any details.
is ther any way to adjust the first code so the dialog box isnt displayed and just goes straight to the second form and displaying the details.
i have gone through as many posts as i can but cant seem to find a fix.

any help would be appriciated thanks

View 14 Replies View Related

Tab, Enter In Textboxes

Feb 2, 2006

Hello all,

Thanks to all the folks that have helped with my posts in the past.
I have 2 questions.
I have a form with textboxes.

When I tab from one textbox to the other, the tab goes to one of the buttons on the page. How do I tab from one textbox to another.

Also, I have a textbox for memo. I would like to press enter and go to the next line in that textbox.

Thank you very much.

View 6 Replies View Related

How To Enter More Than 255 Charaters

Jun 14, 2006

I created a form to let user enter project summary. However, the maximum charaters is 255. What can I do to allow more charaters be entered in the form? I already set up "can grow" as yes.

Thank you.

View 2 Replies View Related

Onkeypress? Enter?

Oct 20, 2004

I have a text box next to a button that takes the value in the text box and performs a search with it. I'd like for the search to be performed when the user hits Enter after entering the value in the text box (when the focus is still on the text box). I assumed that i'd need to use the onkeypress event to run the search function performed by the button, but i'm not sure how to do this. help anyone?

thanks,
Jason

View 2 Replies View Related

'Enter Key Disable????

Mar 9, 2005

I have one form where I want the 'Enter key to be disabled. What is the best way to disable the 'Enter key for this one form without disable'n it for the entire database?

View 1 Replies View Related

Using The {enter} Key To Run Code

Jul 8, 2005

after entering data into a text box I need to run some code (i.e. sql update the table) by just pressing the {enter} key, what code is required? how do I go about doing it ?
any info would be appreciated.

thanks
jabez

View 3 Replies View Related

Enter In Form...

Mar 31, 2006

Here's an awkward problem that i'm experiencing...I've created a form and everytime i hit the Enter key, any data that i've inputted disappears . I've noticed on the bottom right corner where it displays form view when i hit enter it say's calculating...and then poof , data gone...i've created a test record, #3738...Any help will be greatly apprecitated...i've attached form for a better understanding...

View 3 Replies View Related

Help To Enter Value Based On Day Of Week

Jun 2, 2005

I have table that is used to collect roster information the date field is formatted dddd/dd/mm/yyyy a second field requires the end user to insert W to designate the entry as a weekend date. The end user's often forget to insert the W (not functional) I need a way to code the field to look @ date field and update itself with a W if [DateField] is a weekend date.

A query calculates the roster hours and * the hours field by 1.5 if the W is true. The query works fine, I just want to automate the "W"

Weekday Fn perhaps? Help anybody???

View 2 Replies View Related

You Do Not Have Permission To Enter This Database

Oct 5, 2005

Hello,
I get the above message when I try to open a database created by someone that no longer works here. I tried to create a new version of the workgroup information file and assume the permissions of the administrator, but I still cannot access the database. Any leads?

Thanks

View 5 Replies View Related

Is It Possible To Enter The Contents Of The Parameter Value Box?

Jul 13, 2007

Does anyone know if it's possible to edit the contents of the "Enter Parameter Value" Box...for starters, I'd like to delete the phrase "Please Enter Parameter Value" as it means nothing to most users of Access; also, I'd like to format the text that I've entered in the query itself, i.e. make it bold, increase the size of it.

Incidentally, I did go down the route of linking my query to a form but this caused problems as I want more that one user to be able to view their particular parameter value at the same time.

Many thanks

View 13 Replies View Related

Enter Date Automatically

Oct 23, 2007

Can anyone tell me if the following is possible in a table or do I need to use a form.

I have a check box in a table that when I check it I want it to automatically enter the current date. I also don't want to change the dates that have already been entered manually and that date should only display the date on which the check box was checked. :confused:

It is a database that hold the details of IT equipment and when it is disposed.

I think I may have to use a form but I would like someone to confirm this if it is possible to do in the table could someone also help me implement it.

Thanks in advance

View 4 Replies View Related

Let The User Enter The Field They Wish To See

Aug 18, 2005

Hi all

Can a SQL query be written so that when the user runs the query, a prompt asks the user to enter the field they wish to see?

i.e. a query is written to return certain predefined fields, plus a field that is not defined. When the query runs an error comes up to enter the field it should search for.

It would be handy for the start of each month, when a new field (month's data) is required. It will avoid updating the query each month.

Thanks in advance!!

Lucas

View 1 Replies View Related

Can't Enter Info Into Query

Nov 12, 2006

For some reason the query I built will not let me enter any info into it. Is this a relationship problem or because I am using the querie in a form that has subforms, (I can enter new info into the subforms.) or because I wrote code to just print the report to the current record? Or something else????

Thanks!
Julie

View 7 Replies View Related