Search results

I did exactly as you said and it worked except for one detail. The query allowed to generate a report for the facility chosen and a status of waiting on visual inspection or if you left the combobox blank it would generate a report with all facilities that had records with a status of waiting on...

My office 2013 must have taken an update or something... this used to work and now it pops up the parameter box again. Here is the query that worked last week: SELECT tbl_auditdata.AuditID, tbl_auditdata.Status, tbl_auditdata.Facility, tbl_auditdata.PONumber, tbl_auditdata.PartNumber...

I figured out why that parameter was popping up but after correcting it I broke the database somewhere and I can't get it fixed so I am starting over at the moment.

I would like to try that but I am limited in my experience and do not know how.

It pops up a parameter box for AuditID and when I x out of the parameter box it highlights this code on another form (frm_labtestinput) Private Sub Form_Current() Me.cboGoToRecord.Value = Me.AuditID.Value End Sub

So all I need is this? Case 1: Me.VisInputForm.Form.RecordSource = "qry_visinspectinputform"

Ok if I understand correctly... the keyfieldname in the query (Zqry_visinspectinputform) would be tbl_auditdata.AuditID which is the autonumber field of the table (tbl_auditdata) so I set that to 0 now in the tab control change event would I use something like this? Case 1 being the one that I...

I did like you said... I created the query called Zqry_visinspectinputform with the code you showed and I set the record source for the frm_visualinspectioninput to that query. The part I am stuck on at the moment is your WHERE clause and how to call the correct record source when the tab is...

Please? I really do not know how to accomplish this in my current query/code.

Mark_, I am trying to understand what you are saying here but I am not savy enough. I created a table called tbl_blank that has one field which is an autonumber. I do not know what to put in for the "one record" you mention. I made a copy of the query for this form...

So I finally got done with the conversion to tabbed controls... now the db takes forever to load. With navigation control I believe it defers the forms loading until the corresponding navigation tab is clicked. With the tabbed control the db loads all of the forms before it opens. Tripled the...

Thank you Minty... I was just reading something that had me on that same track but you posted it before I got it right. Thank you everyone for your input and advice.

I changed to the code you put above and as before... when just opening frm_reportcenter and choosing a facility... when I click the button it properly generates the report but when I open the frm_home (main form) and then click the tab for the report center which the frm_reportcenter is the...

Q: Is the form open at that time? A: Yes Q: are the names the same between parameter and control name? A: No Here is a screenshot of everything: The main form is called frm_home.. on that main form is the tabbed control named TabCtl87. One of the pages in the tabbed control is named...

So if I change the line of code for the command button to this: DoCmd.OpenReport "rep_waitingonvis", acViewPreview, , Me.cboFacility It pops up a parameter box displaying the choice I made in the combobox and asks for input. Say I chose "Leesport" from the combobox... I then type in Leesport in...

Yea... I don't know how to use TempVars. Is it not possible to fix the code I currently have?

Since I have been re-writing my database to use tabbed controls rather than the navigation forms I have run into several issues. One of which is running my reports from the form in my tabbed control I worked with my form (frm_reportcenter) and put an unbound combobox (cboFacility) to choose a...

Sounds like some users do not have READ and WRITE access to the folder where the back end is stored.

If any of my experiences on this matter mean anything... the folder where the back-end is stored... the users will need READ and WRITE access to that folder or they will not be able to access it from their front-end

Fine!... Let's do it your way! Just kidding... much simpler code. I was actually proud of myself for making it work even though I knew there was a simpler way. The only thing about that... there are only 2 scenarios in which I want the UserCP (page 5) to be set focused and that is if the user...