Search results

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...

This now hides both scrolls bars alltogther

Access 2007. Both pop up and maximise on load. These selections have to be made in order for my reports to load properly. I have code which hides all access features so it looks like my programme is stand alone and if these options are not both selected the reports hide behind the main window...

Hello. I have Reports which are pop up and are maximised on load. This is what I require. However when this happens, sometimes the reports open and fill the screen which is what I want. However the windows taskbar at the bottom hides the horizontal scroll bar. Also it only shows the windows...

Thanks. I have actually resolved this using an IF and then the Calculation.

Hello. I have a report based on a query with caluclations etc to create a 30yr forecast. There are fields which are required for the calculations but not to be seen on the report. Ok this is ok upto here, however one of the fields means another field has more than one of the same. i.e...