Search results

Thanks for the reply. I will check if it saved, maybe force one on opening the optional form to test it. Can a subform be made to be visible/invisible according to the details on the on the master form? That what I am doing with the button on the master. This is because the optional form in not...

I have two forms created, a master and another which is sometimes required for additional data. They are NOT form and subform. They refer to two seperate tables. The optional form opens on a button that appears if conditions are met and when open writes the record number of the master form into...

If you don't know the exact cells how do you know which ones to transfer into the other table? Yes blanks will come across. Col headers as field names and all the data in the range you have used. Just try it, it is very easy and you will see what you have. One other 'trick' is to have the cells...

You could link the spreadsheet to your database, either the whole sheet or a named area if it is just a few cells you want. This makes a table in your db with the spreadsheet data in it. Then you can take the data from that into your other table on the click of your button pnb

Thanks, but that I understand. What I want to do is have a vanilla report and feed it all the details from VBA code. So how do I pass the results of the query to the report? Something like this? SQLQry = Select etc................ DoCmd.OpenReport "RptName", acPreview, "SQLQry" Cheers pnb

I can't get my head around this, can someone help. I have a selection of Price lists for different customers each has their version of a price list for several different products. The products don't change, just the customer and the price they get. I have created individual queries and reports...

Another good idea, thanks! Cheers pnb

Thanks I will try that, rarely use option buttons !! Cheers pnb

I have a button on a form that runs some vba code. The code run is dependant upon what the user wants to do: Method 1 Method 2 Method 3 Abort It is only valid to choose one method At the moment I use sequential message boxes for each 'Method', enabling the user to do or not each step. What I...

Solved it. Access does not like the Visula Basic window open when it does the : RunCommand acCmdSaveRecord action. Close that and it works as it should. Thanks everyone ! pnb

Yes it is updateable. Stepping to the next record and back again enables the report to print correctly. As I said in an earlier post the report is based on the on the same query as the form, but withe a filter to selectthe current record. pnb

Thanks. That brings up an error that 'Save record is not available now' :mad::mad: pnb

I have tried saving the form but it has made no difference DoCmd.Save acForm, "Form Name" ??? pnb

Thanks, but..... The form is based on a query on the table and the report is based on the same query with a filter for that record. The query should return up to date data ??? I have not had the problem before using the same methods pnb

I don't think I have ever had this before, it has me scratching my head! I have a form which enters the data for an underlying table. Each form represents a record of the table. There is a button on the form to print the current record by using a query. Simple. The problem is that the data on...

That's a nice idea ! I will try it. Thanks

Unfortunately the SS is updating whilst the Db is open. It is recording a manufacturing process !

I have a table which is is a linked area of a spreadsheet New lines are being added to this SS on an ad hoc basis. I want to use the data in these lines in my database so I have another Table to contain them, and an append query adds them, as and when. Is there a way of running a background...

The 'text' comes from an external program so I cannot change, but have changed the copy table and this has solved it ! ? Thanks

The second [Text] is the problem. It is from the destination table and as you can see in the last line, is used as the Is Null test for missing records. INSERT INTO [Copy Gas Leakage Tests] ( [Text], Result, Measure, Unit, Pressure, Unit1, [Date], [Time], [Text] ) SELECT CWHGasTests18.Text...