Search results

Hi guys, I have an issue I'm struggling with. I have a main report that is made up of subreports. I print / export this main report to a printer or PDF. All works well. Each subreport if effectively one page of the printed main report. On occasions there is one subreport I want to hide based...

Worked like a charm - thanks again!

Ohhh....nice idea! I will try that

Hi Guys, I have a report that contains a report header, page header, details, and page footer sections. The page headers and footers are fixed at the top and bottom of the page, which is A4. The details section contains a basic subreport that populates when the main report is opened. My issue...

Thanks very much for your help - in the end both of your suggestions worked - the code you supplied, and also simply skipping the error (On Error Resume Next).

Thanks for the advice, but I'm afraid I have no idea how to do either of those things. How can i work that into the function?

Using Nz(.OpenRecordset()(4)) does not work. The error is triggered on: fnGetV1SN = .OpenRecordset()(4) The issue seems to be when the Query runs and there is no results to show, because there is not yet a previous matching record to get data from. But the code expects there to be, and it...

Hi folks, I have an button function: Private Sub Command266_Click() Me.V1_SN = fnGetV1SN() Which when clicked, triggers this code: Public Function fnGetV1SN() With CurrentDb.QueryDefs("Qry_AutoPop") .Parameters(0) = Me![Bath SN] fnGetV1SN = .OpenRecordset()(4) End With End Function...

John's solution worked perfectly. Thanks very much.

Well, technically, the values permissible for this particular field are between 0 and 1 or the words "N/A" and "FAIL". I can set that up in the validation property easily enough, but if its relevant to this, that's what it is.

Thanks guys, Could anyone point me in the right direction to some form of working example of this...I've taken a look around but I can't figure out how to use this function to get what I want.

I have simple piece of text formatting that adds a degrees symbol to any value entered into a text field in a form (also the table). @° This works fine - you type 0.3 and it becomes 0.3° What I would like to do is have the ability to automatically add the degrees symbol to numbers only, and...

That worked perfectly, thanks very much!

Hi Guys, I have a little issue with some VBA code in a sub report. The following code works in the sub report when opened directly: Private Sub Report_Load() If IsNull(cmb1.Value) Then Me.img1.Visible = False Else Me.img1.Visible = True End If End Sub It displays or hides an image...

That worked perfectly - thanks very much!:)

Yes it is a parameter value. You enter the value manually when you run the query directly. I want the form button to run it and enter the parameter value based on the Bath SN field that been filled in already on the form, then copy the S1 SN field result.

Apologies, yes, Bath SN is a text field, and so is S1_SN. The WHERE clause is used when running the query directly, you enter the value for Bath SN and it displays the corresponding records that match that value. It works perfectly.

Qry_AutoPop searches all previous records using The "Bath_SN" as the search criteria. It then displays the corresponding results, which includes the field "S1_SN". I have the query set to display the latest/newest record, and only that record, based on the date field sorted in ascending order...

Hi there, I have a form that has a textbox called "S1_SN" and I have a query called Qry_AutoPop that works and generates the required information. One of the fields in the query is also called "S1_SN". The query is initiated based on the "Bath_SN" value. The form also has this field. Both form...

isladogs, I had already started thinking the very same, and placed a hidden textbox in the subform, and also changed the form source in your module from: Screen.ActiveForm.Controls to: Form_MYSUBFORMNAME.Form.Controls And my after update code on the subform is: If Me.[No: Stations] = "6"...