In theory this would work, but I'm not sure how to implement it.
I have a table with several fields (10) and I would like to create a form that would allow a user to search by entering in as much information as they know. So, they may only know a date and a location, but not anything for the other 8 fields.
Is there a simple way to do this in Access? I'm having issues when the search field is left blank in the form.
Thanks in advance!
I am having issues with assigning search criteria for the "Find Next Button". I used the wizard and it does not ask what criteria to use for Find Next. I am assuming there is a bit of VBA I need to add to the generic Find Next button. This is what comes up when I use the wizard to create the button:
Private Sub Command118_Click()
On Error GoTo Err_Command118_Click
Screen.PreviousControl.SetFocus
DoCmd.FindNext
Exit_Command118_Click:
Exit Sub
Err_Command118_Click:
MsgBox Err.Description
Resume Exit_Command118_Click
End Sub
How do I define the criteria for the next record. I want the db to move to the next record with the same [PtMRN].
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
I'm wrestling with the issues; in other threads, it became apparent that because I could not know ahead of time what I will need to know about a given entity, I will use a table to enumerate attributes that is applicable for a given entity.
However, the stumper is that what if an attribute should conform to a set list of values? Since they are dynamic, I would have problem predicting what I will need to be able to lookup, and am even don't know whether I will need a one-many lookup or many-many lookup.
I thought that generic lookup table with a table listing "classes" of lookup would allow me to have one big generic lookup table while using "classes" to act like virtual tables so I can then set the query to appropriate "class" to return just right set of values.
But as I thought about it, I ran into some issues which is pulling me toward the crazy idea that I should have freestanding tables, and use a field in tblAttribute to give me the table's name so I'd know which free-standing table it points to, and have the necessary key to lookup the values within that table.
Even though my gut instincts tell me that I shouldn't be going against the conventions of database design (who the frick goes around creating free-standing lookups?!?), I'm simply not sure how I can use a generic lookup table to hold all information.
For example, suppose I was given a list of values that has its own categories. Since the former design allows only for two level (lookup and lookupclass), where am I to insert that extra level?
Furthermore, I found myself needing a set of virtual keys to reference a certain "class" of lookups for report purposes. That means I need an extra field in my lookup table than I originally anticipates. What if I find myself needing one more field that just won't fit the generic lookup table?
So does anyone have suggestions on how we would create a placeholder for a lookup table that will be made just in time?
I have a database from sharepoint which has 250 fields based on a survey. I imported the database into Access where I made 10 queries.
I want to know is there a way to display those 10 queries in one queries or in one form.
Given that some queries has result to display and others haven't yet.
I am trying to determine the best method for linking back to a form from Queries.I have a Form that has info filled out for customer service calls that come in. Among which is a case#. From the Log of information stored from these forms queries have been made to organize the info in different ways; all of which have the case#. What I am trying to do is that in looking at a the queries I want them to be able to click on a case number and be transferred to the appropriate form. This way they can update the form as the case progresses.I am trying to improve upon what was created by another.
View 1 Replies View RelatedHi All,
I want to create a form with a Command button, when we click on the command button it needs to bring the Query from a particular mdb, the path for this mdb will vary so we should be able to provide the path info, after bringing the query it needs to be run, how do I do this by just clicking couple of Command buttons?
Thanks
I have a query that retrieves one of its criteria from a form. I have referenced correctly the value on the form from the query, and it works, but what I wanted to do is a bit more complicated: when the form is closed, I want to launch the query with a "default value". I tried to do it in 2 different ways:
a) Defining an "IIf" at the query criteria: I would need a function that checks if the form from which I retrieve the values is open.
b) Defining public variables with a default value, which would be changed from the form: I don't know where/when to initialize the value of the variable.
Query gets criteria from form when it's open. If form is closed, query uses default value.
Hi this advice was give to me however i am not sure how to develop the needed queries
"Yes, you should be able to do this in Excel. What I would do if I were doing it, is develop queries that fetch just John's data from each of the tables that contain it. Then I would export each query to the same Excel worksheet and assign a range name to each different portion of the data. This is so that I could import from Excel back to Access as easily as possible. Then send it to John via Email, or however. When it comes back, I would spend a bit of time vetting it and, if all was OK, then import each different range of cells into the appropriate table."
thanks.
bb
hi,
i have a Main form with 2 command buttons on it, cmdOld & cmdCurrent
can i assign in One Form's Record Source 2 Queries? not at the same time for sure...let me give the correct figure
i have a Main form with 2 command buttons on it, cmdOld & cmdCurrent
when i click cmdOld i will load a Form with record source qry_old,
when i click cmdCurrent i will load the same Form with record source qry_Current,
is this possible, if yes what is the coding of it please
thank you
Is there a way to add a parameter query question into a form?
So for example, I could have this in my form ::
What is your second name? [________] SEARCH
And then when someone types something in the blank space and clicks
"SEARCH", it will add it into the query's search criteria?
If you open the attached db and then run the frm 'frmEnterTimeSheets' you will be presented with a text box asking for a name. Type in Alldridge and click the add work time button. You will now be presented with a list box.
Now what I want to happen next is for the user to select one of the names and then be able to input some time against that user. However after you select the name you want to add times against, the time entry form has a clientID of 0 (there are only IDs of 4 and 8 as shown inthe list box).
I would like to see is the first and last name of the client (concatenated together).
Hey guys;
What I'm looking to do is setup up an invoicing-type system. I want to create a form wherein there will be several list/combo boxes to select various parameter (ie. product id, accessories, materials etc). As well on this form I want to put a "submit" button that will open up a report which will have the information from the various inputs(such as a breakdown of costs and such). I think I can figure the button bit on my own, but I was wondering how I would go about utilizing the boxes. I tried using a parameter-type query but this opens a dialogue box when the form is opened which I don't want. I want the selections to be stored until the submit button is pressed.
Any suggestions on how I might be able to accomplish this?
Thanks in advance
Sorry about the double thread posting, please look at the other thread with the same name.
Thanks in advance for the help
I have a form where I want the user to be able to select different options and get appropriate results according to the selectin.
Now I have already created the query I am just wondering how to I connect the Form to the query so that when the user selects what he wants to see and the query will pop up.
Or is my idea wrong on how to use form to see results from a query ?
regards
Frodo
I'm stuck trying to figure out how to update a query I have already saved. Here's my situation, I have already created a query called "REPORT_STMT_Breakout" and I want to be able to change this query based upon some date variables on a form. I'm using this query to create a pivot table. I can create the basic query, but I cannot figure out how to modify the saved query to accommodate the variables. Any help would be appreciated.
Here's the current query SQL:
SELECT PARENT, TYPE, SUM(TOTAL) AS COMBINED
FROM [
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'1. IND_Amount' as TYPE,
IND_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'2. SBG_Amount' as TYPE,
SBG_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'3. IND_Bonus_Amount' as TYPE,
IND_Bonus_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'4. SBG_Bonus_Amount' as TYPE,
SBG_Bonus_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'5. Licensing Fees' as TYPE,
Licensing_Fees AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'6. IND Misc Expenses' as TYPE,
IND_Misc_Expenses AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'7. SBG Misc Expenses' as TYPE,
SBG_Misc_Expenses AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'8. Other Receivables' as TYPE,
Other_Receivables AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
UNION
SELECT
tblStmt_Tracking.Parent_Carrier_Name AS PARENT,
'9. Unknown_Amount' as TYPE,
Unknown_Amount AS TOTAL
FROM
tblStmt_Tracking INNER JOIN tblCheck_Log ON tblStmt_Tracking.Check_Assignment_ID = tblCheck_Log.Check_Assignment_ID
]. AS BREAKOUT
GROUP BY PARENT, TYPE
ORDER BY PARENT, TYPE;
I plan on adding date variables to this query.
If its possible, can i have a querie that lets the user find a specific record, say based on flight number or flight date (for an airport) right from the switchboard?,
I can do this within the main form, but ir returns the table view of the record, which i dont want, i would like the form view of it? This possible
Thanks
Hi,
I want to have some queries run during the database is closed, like the functiona with "Repair on Close". But I don't want to use a form with a VBA code doing it. Is there any other possibility to do it? :confused:
Thanks in advance for answers.:)
This is probably more easier than my brain is allowing it to be. I have 2 queries
AccountsClosedToday_qry
SELECT UCase(Users.UserName) AS Associate, Count(Information_tbl.IsActive) AS [Closed Today]
FROM Information_tbl INNER JOIN Users ON Information_tbl.Associate = Users.UserID
GROUP BY Users.UserName, Information_tbl.ClosedDate
HAVING (((Count(Information_tbl.IsActive))=True) AND ((Information_tbl.ClosedDate)=Date()));
AccountsClosedTotal_qry
SELECT UCase(Users.UserName) AS Associate, Count(Information_tbl.ClosedDate) AS [Total Closed]
FROM Information_tbl INNER JOIN Users ON Information_tbl.Associate = Users.UserID
GROUP BY Users.UserName, Information_tbl.IsActive
HAVING (((Information_tbl.IsActive)=True))
ORDER BY Count(Information_tbl.ClosedDate) DESC;
I am wanting to get the results from 'Closed Today' and 'Total Closed' onto one form. I am thinking I may have to create a table and have this information either go through an append or an update query each time the database is loaded, I am sure there is a better way of this which is why I am posting here. Thanks.
:confused: G'day, can anyone tell me how to quickly create form based queries using the design view interface. I want my users to be able to specify the various criterias using drop down menus. :confused:
View 1 Replies View RelatedHi, I was wondering if it's possible to use one form to display the results of different queries.
I have a form to make a booking, an identical form to display booking search results and another identical form to display today's bookings.
When I update the database, I make identical changes to all 3 forms. Is there a way of displaying results in one single form?
Thanks,
Rich.
I have a report with the same subreport appearing twice. The two instances of this subreport have different queries.
For instance boys and girls information. The only difference is the queries (one would have sex=M the other sex = F)
Is there any way of doing this without copying the subreport and giving it another name (this of course would allow me to assign different queries to each subreport).
Thanks
I am driving a query through a form and everything works fine....except when the first letter of the field is the same..
So here is my criteria...Like [Forms]![frm_Delinquency By Tier]![Tier/Program] & "*"
I only want the results if the Tier/Program matches what I have selected. If I select B for example, it returns the results for B and anything else in that field that starts with B. I have a Business Tier/Program and so I get results for both B and Business.
My question is, how to set the criteria up so that I only get B when I select B and not anything that starts with that letter.
Is there anyway to enable a query that pulls up just the basic information from a table and then click on the primary key field to open up a form I have created that contains all the information in a table in a more user friendly form that I created.
The two images attached show the data sheet results of a simple query. I'd like to be able to click on the JT# for each record (i.e. 201400426838) in the data sheet (query result1.jpg) and have it automatically open the form as shown in (resulting form.jpg).
I have a form that is basically just a matrix/visual of a query. Is there a way to "toggle" between the use of queries/data?
i.e. have a drop down and select query, "SH-LS", "FPH-ENV" or "FPH-Asset" and it will show the corresponding data. The queries are all set up the same, just gathers/calculates different criteria.
Good Afternoon,
I am trying to create a form where a user will enter in a value into a text field. Afterwards, when the user clicks "Enter", a query will run and will LOOK FOR THE VALUE THAT WAS ENTERED INTO THE TEXT FIELD. i.e.
User enters their address into the field and clicks the enter button.
Afterwards, a query will run like
select * from customers where address = @address <== the value the user entered into the text field. This is where the mystery lies. How do you pass values?????
Thanks,
Nervous Jervous