Forms :: SubForm To Display Test Results In Date Order
Oct 7, 2014
I am having an issue with the sort order on a subform.
Basically I have a main form with Client Details and a subform hich displays the associated test results for this client. Each client can have multiple test results which should be displayed in date order.
Initially the form was based on the table 'TestResults' and I set up the form with the Orderby property set to the field 'TestDate' and OrderByOnLoad set to True. This didn't work and the records were displayed in random order.
Next I tried setting up the form based on an SQL query with the field 'TestDate' sorted in Ascending order - same result. Tried this with OrderBy and OrderByOnLoad both set/unset as a pair and individually - always the same result.
How can I get the subform to display the test results in date order?
View Replies
ADVERTISEMENT
Feb 10, 2006
I have buttons that enable and disable editing/adding information on a continuous form.
When you click add the form then is set to allowadditions and shows you the * record. Is it possible to have that display at the top of the list instead of the bottom? If not, what would be the best method to move the focus to the new record when someone clicks add?
View 1 Replies
View Related
Nov 30, 2005
I have a combo box that contains the months. They appear in month order on the form but when I query, they are in alphabetical. How can I get this to be in month order on the query?
View 2 Replies
View Related
Sep 27, 2013
I have created a form and a subform from a table.
Initially I created a table with 11 rows. After completion of my project I added an extra of 480 rows to the main table. But the newly added rows are not coming in my subform.
Attached is my project.
Main : Main table (It consists of around 491 rows)
MForm : Main Form (It shows of only 11 records which I was 1st created)
How to refresh my subform inorder to display all the rows.
View 11 Replies
View Related
May 24, 2013
I have a customer table with an address Column and an Order table with a OrderDate column .
I would like to create a Query that would display the customer address and only the Last order made.
So far I was only able to display the address and and all the Order dates.
View 5 Replies
View Related
Feb 18, 2015
A form with a text box expecting a date has the validation property as, >#1/1/2010# And Is Not Null. If a date is entered older that this the error is caught however if the field is left null it is not caught as an error. I have tried several modifications of this statement with the same results.
View 3 Replies
View Related
Sep 22, 2006
Hey all,
I did a search and i found a thread that seemed like it would answer my question but for some reason the attachment isnt working. :(
Okay heres the question..
I have a form and it contains 3 fields and 3 command buttons.
When i hit the command button it uses a query to display the results.
What i want to do is instead of having the results display in a new window, i would like it to display on the same form .. maybe on the bottom of it.
Should i use a subform or listbox/combobox..
Can anyone help me figure this out?
Thanks in advance
View 2 Replies
View Related
Oct 5, 2006
If there's a post out there that addresses this, please point me in that direction as I've had no luck.
I have my queries listed in a table. On my form I have them listed in my combo box. The user selects the query they want and hits the command button "Run". I would like to show the selected query in a subform on the main form and then give the user the option of selecting another command button to export the query to Excel.
I thought it would be as simple as setting the recordsource of the subform to the query name in my combo box, but that doesn't work.
Current code to run query in separate window:
Command button "Run"
Private Sub Command9_Click()
DoCmd.OpenQuery Me.Combo2.Column(1)
Attempt at getting what I want:
Privat Sub_Command9_Click()
Forms!frmQuerySelection!sfrmQuery.Recordsource = Me.Combo2.Column(1)
or perhaps
sfrmQuery.Recordsource = Me.Combo2
Am I even close?
Thanks
View 1 Replies
View Related
Jan 28, 2005
I have created a query with parameters keyed in from unbound textboxes on a form. Does anyone know of a way to display the results (queried) in the sub-form of the same form (main) the textboxes reside? I have the query set up to create a table but when I use that table (or the query itself) in the subform I get the error message:
"The database engine could not lock table "tablename" because it is already in use by another person or process."
This seems appropriate because I am querying for results, but is there any way to get the results of a query into a form, rather than the more common pop up datasheet? I have tried several macros to open and close the tables - queries - copied tables ..re-opened forms....etc, but can't get it to work.
Thanks, for any help, I have spent some time on this one!!!
View 4 Replies
View Related
Oct 14, 2013
I have a main form which displays the results in the subform.
My requirement :
I have 1 main form and 2 subforms in that form.
I just wanted to have a get focus function on my 1st subform and needs to display the focusing result in the next 2nd subform.
In Detail :
I had a main form of search boxes Author, Published, title
If you search for 1999 in published text box then it will display all the results whose published year is 1999 along with those respective Author and Title in the 1st subform
In the result 1st subform if an ID is selected by the cursor then that entire row needs to be displayed in the next 2nd subform (As of now I wanted only 2 column details of the focussed result).
1st subform needs to display all the searched results (It was done and it works fine)
2nd subform needs to display the selected results (On Focus) of 1st subform.
How to deal with the 2nd subform linking up with the 1st subform.
Attached is the file. How to proceed further in getting done with the 2nd subform.
MForm is the main form and Main is the main table
View 7 Replies
View Related
Oct 14, 2013
I have a main form which displays the results in the subform.
My requirement :
I have 1 main form and 2 subforms in that form.
I just wanted to have a get focus function on my 1st subform and needs to display the focusing result in the next 2nd subform.
In Detail :
I had a main form of search boxes Author, Published, title
If you search for 1999 in published text box then it will display all the results whose published year is 1999 along with those respective Author and Title in the 1st subform
In the result 1st subform if an ID is selected by the cursor then that entire row needs to be displayed in the next 2nd subform (As of now I wanted only 2 column details of the focussed result).
1st subform needs to display all the searched results (It was done and it works fine)
2nd subform needs to display the selected results (On Focus) of 1st subform.
How to deal with the 2nd subform linking up with the 1st subform.
Attached is the file.
View 4 Replies
View Related
Nov 13, 2014
I have a form with a subform (FindBuffer_Form) which I built from a Query (FindBuffer_Query) within the query criteria I have the following (Like "*" & [Select the main Batch Number] & "*")in order to search a particular number.
I want to be able to run the Query from a command button on the main form and have the results appear in the subform, If I have the Source object of the subform set to Query.FindBuffer_Query I get prompted twice to answer the Criteria before the form opens, after the form opens the subform is generated as per the search criteria.
Ideally, I want the form to open with no data in the subform run the query from command button and have the result in the subform.
View 9 Replies
View Related
Jul 2, 2013
I am trying to allow a calendar to search through a text box with a large amount of data in which will have headings using the date so i wanted to use a calendar search. Hopefully this will be be like the find function in word where you type (or in this case select a date) then click search or next which will take you to that specific date.
View 14 Replies
View Related
Jul 22, 2014
I am trying to display the sum of a query into a form textbox and i am not having any luck.
Here is my code that i am currently using:
Private Sub Client_Id_AfterUpdate()
Dim db As Database
Dim rs2 As DAO.Recordset
[Code]....
View 4 Replies
View Related
Jul 25, 2014
I am trying to allow end-users to only use buttons to navigate and display records in my database (so they don't know access is in the background) I have query that runs when they press a button but after they run it there is no way to get back to the main interface screen i.e. there is not a place to put another button and close the query. I was looking into creating a form to display the query results in datasheet view but it is not appearing the way I want. I inserted a subform and the results got better but I also do not like the way it displays because the user can see the subform, simple solution to get my data to display in the form so a user can view the results similar to datasheet view?
View 3 Replies
View Related
Dec 12, 2014
In my form I have a dropdown box. There are 7 values and based on the value it will run that query in sql server. I would like to have the query open in the form instead of opening up on a different tab. Currently on the command button click there are a bunch of if statements depending on what is selected on the combo box. Each value has a query associated with it because there are 7 different sql server DB's. The code is slightly different with each query.
View 2 Replies
View Related
Sep 26, 2013
I am not sure where to start or go about creating message box that would display "No results found" if my queries return no results. My search of the forums hasn't been fruitful.
I have created one form that has a text box and a button that works as a search function to run through the tables and displays the applicable queries. Currently, if no results are returned nothing happens. Preferably I would like a message box to display stating that there were "No results found". I would assume that the code would be associated with the "Find" button. Here is the VBA code as it stands, again, I haven't even attempted to add code for a message box.
Private Sub Find_Click()
On Error GoTo Find_Click_Err
If DCount("Heading", "Service Desk Manual Query") > 0 Then
DoCmd.OpenQuery "Service Desk Manual Query", acViewNormal, acReadOnly
End If
[Code] .....
Find_Click_Exit:
Exit Sub
Find_Click_Err:
MsgBox Error$
Resume Find_Click_Exit
View 7 Replies
View Related
Jun 20, 2013
im having problems getting a subform to calculate another subform's total and display it as it keeps coming up with the #NAME?.Basically my database is like this
tblCustomer
- tblOrders
- tblItems
and this is displayed on a form. so you can flick through clients, then flick through the orders and its broken down into the items inside each order.i have seen many answers that are only about calculating something on a subform and displaying on a form but this does not work when displaying on a 'parent' subform. the form structure looks like this
frmCustomers
- sFrmCustomerItems
- sFrmCustomerOrders
i have a calculated control textbox in the footer of sFrmCustomerOrders with sums up all the prices using =sum([Price])and in my sFrmCustomerItems, i have a field called Amount (the total amount of all the items) and the Control Source formula i was using was =[Forms]![sFrmCustomerOrders]![sFrmCustomerItems]![txtTotalPrice] but i get a #NAME? error.
View 5 Replies
View Related
Oct 31, 2013
my issue is i have multilble text box in my form & based on change in one of this text box i need the code to compare between data in the form & table & returm Msg if it is not matching. attached screen FYI.
i look in the internet but i could not figuer out the VBA code since i do not know VBA. what comes to my mind to to use select case.
View 14 Replies
View Related
Apr 28, 2015
I have a subform with year and month, subform shows result of a select query.
When I open query separately it show data as required order but when i show data in subform related to this query, data show in rearrange order.
How can I set order in subform as query result.
View 3 Replies
View Related
Nov 22, 2014
I have a subform in which I display a table in Datasheet View. The problem is, I cannot figure out how to place the columns in the order (i.e. from left to right) I want.
For some reason, right-clicking on a column header in Form View and selecting Freeze Fields will shift that column to the left but I can find no consistent pattern to it and no other way of shifting a column. Reordering the columns in the table itself seems to have no effect on the order they appear on the subform and moving the controls around in the subform in Design View also seems to have no effect.
View 9 Replies
View Related
Mar 2, 2007
I am trying to create a field that will calculate a persons age at the time of a test date. I have the DOB field that gives for example :
3/10/1993
Then I have a field that turns this into the Age in Year and months
14 yrs 0 mos
I have a TEST Date field that tells me when they took the test:
10/1/2001
Now I need a field that will calculate how old they were at the time they took the test. I tried using this formula:
AgeAtTest([DOB], [TestDate])
but then in my field I am getting this : #Name?
It should calculate them to be: 6 yrs old at the time of the test. How can I make this happen?
Thanks!
View 3 Replies
View Related
Dec 17, 2013
I have a combobox (cbo_FileNames) that is unbound and gets fed on activate from a folder
Code:
Set SourceFolder = FSO.GetFolder("c:GundogManagerBackUp")
My problem is that the file names are as follows:
GundogManagerBackUp 02_12_13.xls
GundogManagerBackUp 03_12_13.xls
GundogManagerBackUp 07_08_13.xls
GundogManagerBackUp 16_11_13.xls
GundogManagerBackUp 17_12_13.xls
As you can see it consists of the name and a date of the backup. When it populates the combobox I want it to go in date order I newest to oldest. At the moment its going of the first number.
View 9 Replies
View Related
May 9, 2013
So i have a combo box that has a criteria set for the query. I have a search button that runs the query that users click.
What i need to happened is i want the results displayed in the sub form the when query is ran.
View 7 Replies
View Related
Feb 21, 2014
I have a basic DB for recording supplier records, you enter a supplier ID and it performs Dlookups to run and display query results on the same form. That part works fine.
I've added a subform and linked it to an existing query which returns the suppliers top selling lines and the query picks up the supplier from the ID field on the main form, however when I enter a new id the subform doesn't update with the results specific to that supplier.
So I think I need a way of getting the subform to re-run the query each time I update the supplier ID field, but I can't see an option for this in the subform properties.
View 2 Replies
View Related
May 30, 2013
I have these 3 combo boxes filtering results into a subform.
Code:
Private Sub Combo5_AfterUpdate()
If Len(Nz(Combo5, "")) > 0 Then
FindRFQsubform.Form.Filter = "[RFQ Title] = '" & Combo5 & "'"
FindRFQsubform.Form.FilterOn = True
[code]...
View 1 Replies
View Related