I am trying to display some dat afrom my tables in a query, but am not getting what I am after.
You will see that in:
tproductionFigures
I have 4 entries these represent the figures I need to display, as this shows that the machine was actually in production on the days shown.
In tDowntime
You will see that I only have Downtime for 2 of the 3 shifts that actually produced.
This is a possibility in real terms as sometimes the shift will have no downtime.
If I try to run a query I only get data for the days where there are Data for all 3 shifts. In both tProductionFigures and tDowntime
What I want in my Query is:
The Production Figures every Daycode and Shifts and the appropriate Downtime accounted for each.
If there is a record in the tProductionfigures that is not in the tDowntime Table then I need the Databas eto assume and Display Zero Downtime for the day/Shift etc..
You will see in my query:
TestBaseData
That only 2 of the four records are displayed, there should be a record for each record in the tProductinFigures table.
I have a problem with my database I have a combo box that will search for my record. Actually its working I input the specific number it goes to the specific record. But I want, if there no existing record in my database it will display a Messagebox that "No record Found" I try to put a code in a macro builder in a after update property field but nothing happened.
Expression code that it will display the msgbox if there's no record found.
the given code from macro builder is attached. I try to have an if else statement but I dont know how to not equal that giver conditional expression.
I'm trying to make a form that shows what the last record was next to the empty space where you enter a new record.
This is so the user knows that what they are entering is roughly in line with what has come before.
So for example if I was recording temperature every May, I would like a form that has a field called temperature and next to that field I would like to see last year's temperature.
The fields we want to focus on is "AccNo" and "TestCode"
Now i want to filter based on this condition:
If "AccNo" AND "TestCode" BOTH have duplicate data in a record. Show that record only once. Remember. . . "AccNo and TestCode, both these fields have to have duplicate data in a record.
Example: MethodCode..... AccNo .....PatientName.....MR..... TestCode ..... etc, etc CAPT.....M566679.....John Blue.....123456.....CBCA CAPT.....M566679.....John Blue.....123456.....CBCA the example above should only display once because of the repeated AccNo and TestCode
Example: MethodCode..... AccNo .....PatientName.....MR..... TestCode ..... etc, etc CAPT.....M566679.....John Blue.....123456..... CBCA CAPT.....M566679.....John Blue.....123456..... LIPID the example above is just fine because the TestCode is not matching
How do i create a query to accomplish this? someone please help, i've had troube with this for the passed couple weeks . .. .
Hi, hope you can help me with a small problem. I have a subform (datasheet format) which shows payment and fee records with a current balance displayed for each record. I'd like to only display the balance on the final record, but can't work it out.
Can anyone help by pointing me in the right direction, please?
Thanks very much for all your help, it has been invaluable.
I have two unbound fields on a form that I would like to display the result in the following way, similar to the record navigation at the bottom of a form.
I have created a combo box that simulates browsing, but limits it to a single filepath. I would like to store this file path along with the filename into my database in a field. There are two ways of doing this that I have found work, but i need a less cluttered way. 1) My rowsource string is created byrowString = rowString & filePath & fileName &";"fileName = dirthat's in a loop that reads all the files in the directory.... the problem with setting this rowsource to my combobox is that its very long and cluttered looking combo boxMy secont way is: rowString = rowString & fileName &";"fileName = dirThen i make a hidden text box whose value is filePath + Me!cboBox where the cboBox has the string value of the file (Sample1.jpg) In this instance i make the text box the control source instead of the combo box... but I'm pretty sure that's a bad way of doing what I want to doboth of these ways seem ... redundant, so i was wondering if there is a way to do this otherwise ?
I have a subform that displays three records for a single day in datasheet view. I want to display the most recent 2 days' records (six total). Re-sizing is not working. I'm guessing there's a simple solution, and I've searched for a post dealing with this but no luck. How can I do this? Thanking you in advance.
My form has a button that opens a report. This report is based on a query that sets the report to display ONLY information related to the person in the current query record.
How can I get the report/query to display ONLY the last (most recent) record in the query?
I have a table with only ten records, this will not change. I would like to create tabs like and index showing one record per tab. Is there an easy way of doing this
I don't know if this is the right place to post this but here goes. How do you display an icon or image in a field in a subform in Access2003? I tried inserting an image into a field with its data type set to OLE Object. This doesn't work. I insert a bitmap or icon file (*.ico) into the table. When I open up the subform the field displays the word "Package" for Bitmap image". Any help would be greatly appreciated Thank you :D
First let me say, I've search this forum for as long as tolerable looking for a simular problem as mine and could not find one. I am sure this isn't the first time this question has been asked.
I have taken a few Access courses at a local college for my own personal use and have discovered that the courses albeit expensive, just covered what appears to be mere basics.
At this time, I do not understand SQL or VBA. Nonetheless, I have created a database to organize my four bookcase library.
The library consists of books & mags, records(33's, 45's and 78's), DVD's, VHS & Digital tapes, CD's(Music and software).
I have created tables for Books/Mags, Video and Music. All of which pulls required data from a list in other tables such as mediatype (Book, DVD, Record etc..), location(C1S2R which has a description field as Case 1 Second Shelf Right side area) and Genre(Country Music, Video Sci-Fi, Fiction Reading etc...).
When I query on a field such as Title, it brings back the desired results. However, when I query on a field where the data was import from another table such as Genre, the result is an empty table and yet the record truly exsist.
For instance this is the criteria I used Like ["Genre"] & "*" When prompted I typed V and expect at least one record that had Video Sci-FI listed. The result came back blank. When I just hit OK then the whole table would display and sure enough the Video Sci-Fi record would be there as well.
This is true of all the fields/data that has been pulled into the table from another table. I have tried many combinations of the criteria command to no avail.
If I can get this part to work I can quit biting my nails (or should I say nubs)
I've searched for this but can't find how to do it, When I open this form I want it to display the last record in its control source, This is probably a simple one but I just can't seem to make it happen...
I have a form with a sub form that opens based on a record search for a patient, whose details are displayed at the top in the main form. The sub form displays visit information for that patient (there can be multiple visits).
On opening the sub form is filtered and only shows one record at a time. I would like it to open and show all existing visit records for the patient and be ready to enter a new visit!
Im sure this must be easy to do (but cant do it myself...)- how do I set a continuous form subform to display the last record when a new main form record is opened? Whatever I do, the continuous subform displays the first record and I have to scroll down to get to a new record, which is getting tedious.
I am trying to display the records (counts) on my Invoice form.
I tried to put one text box and typed as follows:
=Count-[n]
This kind of text box we normaly use to count records on Reports and it counts well. But this did not support me on form.
I need, it should display records from 1,2,3 and so on upto the last record entered for that invoice.. Each new invoice should start from 1 to the last record number.
What I am trying to do is have a form on an event display a set of records and pictures that are attributed to that record. A nice generic example of this is I have a query run to find all employees with the last name "smith". I want the form to display all the employee records with the last name smith and look up the picture file and assign it to an image box on the form. I have tried many different variations of code and queries and have not been able to get it to work. Can anyone suggest a more direct path than the hit or miss that I have been using? Really it seems to be multiple records that are the problem. I have many pictures coming up on the form based on a single response query.
here is a good example of changing a picture file on the fly in a form.
Public proff Public filestring As String Public picname As String Public proffpic As String Public fullfilename As String Public colore
Using Access 2000, I have an BeforeInsert event to set a value in a field by referencing the form/subform/fieldname. When the user enters a new record simpy by arrowing down the subform, this value IS entered but NOT displayed until the record is saved.
How do I get the programmatically stored value to display on the proper field box WHILE the user is entering the other fields?
I assume the NEW record is a buffer (not in the database yet), so perhaps I need to reference the new record buffer so it displays on screen. How do I reference that?
Hello once again, I am wondering how I can display information on a form that is not of the same record source without using a subform.
Right now, I have a form setup with qryAll as the record source which provides the information to a listbox i have setup on the form. When I select something in this list box, I want to display information related to it from a table based on a CenterID. Is this possible to do? I won't need to edit the values, I just need to display them into a textbox or something. Jared
I have a database that keeps tracks of the orders that clients make and when I do a search from my search form, if the client is in the database but haven't made any orders. A solid blank screen opens up. Is there a way to stop this to show a message box if there are not orders?
What I am trying to do is have the user click a button to open a report based on the current specification they are updating. Now for each specification there are multiple revisions so i added a 'revision history' table. When the user prints the specification, I only want the latest revision number, date, and rev descr to show. I tried using the following:
Private Sub Report_Load() Dim db As Database Dim Rev As Recordset Set db = CurrentDb() Set Rev = db.OpenRecordset("SELECT tblRevisionHistory.revnum, tblRevisionHistory.revdate, tblRevisionHistory.revision FROM tblRevisionHistory;") Rev.MoveLast Me.Text23 = Rev.Fields("revnum") Me.Text26 = Rev.Fields("revdate") Me.Text28 = Rev.Fields("revision") End Sub
The above only showed me the last record in the table regardless of the specification number filter.
i have a form based on a table.The key column of the table is a combo box in the form , if i select a particular value in the combo box then i have to diaplay the all the fields in the record on the form automatically based on that particular value.
Ofcourse it is a simple task, but today only i am trying my hand in VB for the first time in my life.... so i find it difficult to find the answer.......
I'm this is a simple issue. I have a combo box which can have the following status's: Not Started, In Progress, Complete. Depending on the value of the combo box i want a different image to show. So if not started is selected i want the user to see a red box. If Complete is chosen, a green box will show. i can do this easily enough but my problem comes in when i go to the next record. The boxes just stay visible regardless of what option is displayed. What event is triggered when you go to the next form?? Form Open / Load doesnt seem to work. :mad: :confused: