Search results

Just to finish off this thread I resolved this by adding a "select for printing" Yes/No button into the detail of the subform and then used that in the query behind the report.

tblSLTrptFertApplnCharts has a single field FertApplnIndex

The error is too few parameters. INSERT INTO tblSLTrptFertApplnCharts ( FertApplnIndex ) SELECT qryUpdateFertApplns.ApplicationIndex FROM qryUpdateFertApplns WHERE (([Lookup_ProductName].[ProductName] Like "*olysulpha*")) AND ([qryUpdateFertApplns].[Variety] Like "*ham Win*")

There was nothing in the Immediate window and I couldn't understand why. Then I noticed there was a typing error in the Debug.Print command. Here is the text INSERT INTO tblSLTrptFertApplnCharts ( FertApplnIndex ) SELECT qryUpdateFertApplns.ApplicationIndex FROM qryUpdateFertApplns WHERE

How do I find Me.Filter value? Would it be in the Property sheet? If so here are a couple of examples. (([Lookup_ProductName].[ProductName] Like "*N. 34.5*")) AND ([Lookup_ApplicationTiming].[ApplicationTiming] Like "*umn seed*") ([qryUpdateFertApplns].[FieldName] Like "*unt Plea*")

Does the "receiving table" tblSLTrptFertApplnCharts have to have identical field names to the "sending query" qryUpdateFertApplns?

Using your code: Dim strSql As String strSql = "INSERT INTO tblSLTrptFertApplnCharts ( FertApplnIndex ) SELECT qryUpdateFertApplns.ApplicationIndex FROM qryUpdateFertApplns " strSql = strSql & " WHERE " & Me.Filter Debug.Print strql 'if that does not work go into immediate window and post...

Hi MajP, how would I do that please? This is my append query INSERT INTO tblSLTrptFertApplnCharts ( FertApplnIndex ) SELECT qryUpdateFertApplns.ApplicationIndex FROM qryUpdateFertApplns;

Good morning, I have a main form with a subform. The subform is a continuous form which is filtered from the main form. I then use the inbuilt Access Filters (right click in the text box) to narrow down the records shown in the subform. Once the records are filtered down I would like to copy...

On this particular form there is already data in the combobox. If all of the text is not selected and I type "br" for example then the br just gets inserted into the combobox with the existing text. If all text is selected then typing "br" triggers FAYT.

I have a continuous form with a combo box where the row source is a query. I have added the following code so that when I click in the combobox the all of the text is selected so that I can use MajP's FAYT. Private Sub cbVarietyID_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As...

Hi MB, is it possible to change how you are connecting to the office? I have recently moved my Access DB to a remote server which I now connect to via Remote Desktop and the performance is only slightly slower than when the database was in my office. The Front End and Back End are both on the...

Thank you Minty, Auto Center was set to no but deleting DoCmd.Maximize from the form open sorted it.

I will be using a smaller monitor for a while and have one large form which I need to open so that the top left of the form is in view. Currently it opens top centre. I have tried Me.Move 0, 0 and DoCmd.MoveSize 0, 0 in the form load and open but they don't make any difference. I am not using...

So I opened the folder and it was empty, then I went to a back up copy of my database opened the report and the folder stayed empty. I then opened the report in design mode and opened the unbound object and four files appeared. Closed the report and the files disappeared. So it looks like on my...

Good morning, your comment made me wonder whether I had missed something but I have just checked and that folder is empty, 0 bytes, 0 files and 0 folders.

Thank you Colin. I went to a back up version of my database and opened the word document and it also pointed to the Content.Word folder so I checked and the folder is empty.

If I double click on the object frame a word document called Document in rptSoilResultDF1 opens and I have absolutely no idea where that is saved. rptSoilResultDF1 is the name of the report. I have deleted the object frame and just wanted to make sure that the associated Word document would have...

I use this in a text box which removes blank fields. =IIf(Nz(Trim([AccountName]),"")<>"",[AccountName] & Chr(13) & Chr(10)) & IIf(Nz(Trim([Address1]),"")<>"",[Address1] & Chr(13) & Chr(10)) & IIf(Nz(Trim([Address2]),"")<>"",[Address2] & Chr(13) & Chr(10)) & IIf(Nz(Trim([City]),"")<>"",[City] &...

I have a report which has a Word document embedded as an Unbound Object Frame. I no longer need this in the report, if I delete the Unbound Object Frame from the report does it also delete the Word document? Thank you