I have numerous reports based on queries with a criteria date select string. So when I Preview the report I first get asked "Enter start date:" etc.
In all reports I have entered a text label with date control source stating "=[Enter start date:]" to have the start date parameter value printed on the report. All straight forward up to now. Anyone have an idea why with some other reports when I enter the exact same code the report preview text label renders "#name?". I don't get it?? So I thought maybe I should change it to something completely different. "Start book date". I changed it for both query and report label and still get "#name?".
Completely clueless and I have rechecked them all. The labels are all consistent with the criteria string in the query.
I am trying to set up a query by paramater to then base a report on.
For example, I would like to input a location name to get a query to only display the records for the specifiied location and the accompanying data for use in the report.
How do I do this?
I have tried using the [Enter .......] type command but I either get zero or I get the full list, which is no use.
I'm not sure if this is a syntax problem or not, but:
I am trying to design a parameter query using a form for entery. The trick is that I am trying to use a wildcard in order to select the data for one of two job sets.
My job number format looks like this: 06-07-123 or 07-01-006 I can get the query to work without the wildcard by using anexact number, but I am trying to pull all the jobs that begin with "06" or "07" (but not in the same query).
In my query, I direct the query to get the records based on the data from this field: Forms!frmDRSNoInput!txtDRS1.value
I have tried using the wildcard as follows: Like "[Forms]![frmDRSNOInupt]![txtDRS1].[Value]*"
Additionally, I experimented with different possibilities, but as you can see, I wound up here.
Hello, is there any way I can have my single-parameter query bring up a lookup list of options from a table field rather than relying on the user to correctly type in the criteria? Then when this query runs I will know the user is picking one of the correct options from the lookup list.
I am really close to finishing up my report. But, as I had discussed in an earlier posting, I keep coming up with an error "#name?". I believe I am getting the error because I have reached some kind of maximum amount of fields aloud for a report. Does anyone know how many fields can be added to a single report?
I am going along, copying one field to the next, with a minor change to each new field, and then all of a sudden I start getting the error message.
So I have a report that opens via Parameter. The SQL behind the query that runs the report is (I took out alot of lines that aren't necessary to answer the question)
PARAMETERS [Enter Your Box Id] Short; SELECT DocumentsTable.OrganizationalID, . . . DocumentsTable.Status FROM DepartmentsTable INNER JOIN (Year1 INNER JOIN DocumentsTable ON Year1.ID = DocumentsTable.RecordDateYearID) ON DepartmentsTable.ID = DocumentsTable.DepartmentID WHERE (((DocumentsTable.Voided)<>'Y' Or (DocumentsTable.Voided) Is Null) AND ((DocumentsTable.ID)=[Enter Your Box ID]));
So if I click on the report, I get a little popup that says "Enter Your Box ID", and when I do, the report works just as expected.
However, I also want to be able to open this report via link from another report, and pass the Box ID #. I just can't get the syntax right. I would have thought it was this:
Private Sub ID_Click() DoCmd.OpenReport "Find A Box", acViewReport, , "[Enter Your Box Id]=" & Me.ID End Sub
However when that execute, I still get the pop up asking for "Enter Your Box ID"
I have an exceptions report that i would like the user viewing it to write some form of justification on why the data if falling out. Is it possible to create a text box where the user could actually type text on the report before printing it?
I would like my user to be able to enter dates on a report.
I have entered unbound fields on the report; but it doesn't keep any of the information (dates) for printing or otherwise. (I don't need to save these dates since they change monthly.)
I am trying to create a form to enter data into a table that I ultimately will create a report from. I have created a blank table with the columns I need. I created an append query to add the new records and an update query and a macro to run them on click of a button. It all runs but it doesn't append anything to the table. What am I doing wrong?
I have one form which have two multiselect listboxes. They work, but every time when I choose id_organizacija from listbox popup enter parameter value comes up.
I am already tried to put id_organizacija in [ ] but that didnt solve problem.
Code: Set ctl = Me.lstEmployees For Each varItem In ctl.ItemsSelected strWhere = strWhere & ctl.ItemData(varItem) & "," Next varItem Set ctl = Me.lstOrganizacija
Need to track donations in two areas. Have one query that tracks them in location A and one that tracks them in location B. Same query, no other difference. Report made on location A is fine. Made a copy of it and based it on the 2nd query--and I get a pop-up "Enter Parameter Value" for Last Name. The Last Name field is not in the query or anywhere in the report that I can find.
I have a report and within the report I have added some text boxes with some simple logic such as sum, count, etc. These text boxes function well as long as the logic is referencing existing fields. The minute I try to have a text box reference another text box I get the "Enter Parameter Value" box pop up. I don't understand this as the text box I am referencing has a vaule based on what it is referencing.
Example: 1st text box control source =Sum([existingfield]) I get a value. 2nd text box control source =[existingfield2]/[1st text box] I get "Enter Parameter Value" of 1st text box.
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:
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.
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?
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.
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".
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.
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.
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.
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.
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?
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?
