Recent content by GraemeG

Hi, I have 10 tables all with the same amount of records (will eventually be 12000+) based on a KeyReference but with different fieldsets. I need to be able to set a filter, using the KeyRefernce, on all the tables at once to show the one particular record in each of the tables and then...

hi thanks for all the replys. Trevor G - I am filling in so many blanks as the data capturing device is a form which only have to answer certain questions, therefore leaving the other fields blank. However I now need to create a query which uses caluclations and it will not show records and...

Hello, I have a query update which is trying to replace blanks within my table. However I can do this for one field. But when I try and use the same query update for multiple fields it won't update. I take this to be because it will only update if all the particulars are blank for the one...

hi, I have an append query which I am trying to append to multiple tables at once is this possible. I have the following sql which isnt working at the minute. INSERT INTO [MOT:Bathroom] ( propref ) INSERT INTO [MOT:Bedroom1] ( propref ) INSERT INTO [MOT:Bedroom2] ( propref ) SELECT...

Got it - me.refresh on enter!

No not everything is bound. I have the first combobox (cboFloorCode) unbound source Table:Field Second combobox is bound to a control source in a table but the rowsource is from a different table. This second combo is cascaded from the first combo selection. I then have two other listboxes both...

I have solved this by doing a query then using the control source to view the query. However how can I get the calculation to refresh live on update. i.e. it updates once the form is closed and reopened. Thanks

Hi, I have a form with the following: Combobox One - cboFloorCode (cascades to another combo) Private Sub cboFloorCode_AfterUpdate() Dim strSource As String strSource = "SELECT SORdescription " & _ "FROM SORV4_BR_FLOOR " & _ "WHERE SORshortdesc = '" &...

Amazing! Fantastic! Thanks :)

Hi, from what you are asking I think the setfocus after update would suffice. I.e Private Sub "name of current txt/combo box"_AfterUpdate() Me."name of txt/combo box to move to after answered".SetFocus End Sub

Hi Thanks I havent used the DCount before how cant it be incoprated into what I have or do I have to re-write something else?

Hi, I have a basic (pre record selector) form with one text box to enter a primary key to then open the main form to the specific record. using [Private Sub CmdSearch_Click() DoCmd.OpenForm "Internal Survey Form", , , "Propref = '" & Me.txtPropref & "'" End Sub It still opens to a blank form...

Hi, thanks. Sorry yes I understand the concpet and what they are. but what I have (posted just above your 1st repsonse) does not seem to be working. Thanks

Hi I have not got it set up like this and would take an age to split all my tables up. I have this but the second combo box is always blank no matter what I select from the first box. First Combo SELECT [SORV4_BR_DPC].[SOR shortdesc] FROM SORV4_BR_DPC GROUP BY [SORV4_BR_DPC].[SOR shortdesc]...

Hi, I have attached the table below from which I require assistance on combo boxes. The first combo box on the form selects the SOR shortdesc - I then want the second combo box only to show the SOR descriptions which relate to the SOR shortdesc selected in the first combo box. Is this...