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

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

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 = '" &...

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

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

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

Hello I am not sure If I can explain this toowell, but here we go. I have a table with components in and renew years this has a relationship with a schedule of rates (SOR) table. I have created a crosstab query which shows the component name as row, and renew year as column heading. The...

Hello. I have a crosstab query which produces figures depending on the table. However some of the cells in the columns are blank when zero. Is there a way to show the zeros? However I know I can use Nz([field],0) to get the zeros. But this then will not let me make the fields Currency which is...

Hello. is there a way to calculate columns together in a crosstab query. The picture attached will help explain. I need to add the firt five columns to the sums already in the 6th column for example. As this is set for a report and currently I am doing the calculations in the report which is...

Hello. I seem to be having an issue with my reports. When I open them sometimes the data will load straight away and other times it takes 10-30 seconds and other times it wont load at all until I start clicking where data should be. The template loads i.e. labels etc. but no text boes which...

Hello. I want to scale my report when I open it from a command button as a pop up screen. Can I set my pop up screen size but scale the report to fit inside? Thanks

Hello. I have a report which shows a 30 year forecast budget. It is based on showing the first 5 years indivual then in 5 year increments. These figure are based on life cycles of component. I.e. 20years for a kitchen. Therefore if a kitchen cost is in year 2015 it also needs to be in year...

Hello I have a macro which runs about 8 queries. But when I run the macro messages appear regaring what the query is about to do etc and requires a repsonse. Can I remove these so the macro just runs and then states finished? Any help much appreciated. Thanks

Hello I am having trouble opening a report from a command within a subform. I have a main form with a control source in which a navigation panel no the main form dictates what opens in the control source i.e. subforms. This all works great but one action I require is within this control source...

Hello I am having trouble with an embedded chart within a subform. I have a main form with a control source in which a navigation panel on the main form dictates what opens in the control source i.e. subforms. However I have a form with an embedded chart which opens in the control source but...

Hello. I was wondering if the following was possible. I have 10000+ records with a unique 'propref' number in the database. I also have tens of thousands of photographs on a network drive all with the propref encorporated into the title. is there a way to get some sort of link so that...

Hello. I am having trouble exporting single records from a form to pdf. I have the following code so far. but it gives: Run time error 3464 Data type mismatch in criteria expression. Debug highlights: Me.RecordSource = "Select * From Propertyextract Where [propref] = " & _...

Hello. I have the following code which I use one my forms to search and bring up a record. It works great. However it requires the user to know the actually unique property reference number to search. Private Sub cmdSearchPropref_Click() Dim Rs As DAO.Recordset If Not...