Search results for query: *

Some help would be greatly appreciated I am struggling to find a way to combine these two functions The aim if to returns one of the following three results The selected "Master ID" is in Cell $E$2 The Function is in Cell F2 1.) The "Master ID" that is selected from cell $E$2 finds a matching...

Hi, I am trying to get my head round INDEX MATCH for the first time but am not doing very well Could someone help me with this please I tried to use =INDEX('Master List'!E5:E5:E5020,MATCH(E5,IF('Master List'!AQ5:AQ5020=C3, 'Artwork and Sculpture'!C3:C150),0)) But the result is just "value"...

Hi, I need some help with Pre and post year 1900 dates in Excel The Date field is formatted to dd/mm/yyyy For <1900 dates I found this if Statement =IF(RIGHT(P16,4)>1900,RIGHT(P16,4),CONCATENATE(YEAR(P16))) It returns the correct yyyy result in cells Q from the date in Column P Strangely the...

Hi I have been using this codes for some time to send to Recipients using the query The list of emails getting added to the "TO" list Some of the people in the list have said they now do not want other people to see their email, how can I modify this code so that the list created gets added to...

Hi, The main form FrmAmendHouseDetails contains a Tab control, there are 4 tabs, each Tab contains has subfrm in datasheet view, the fields are locked to the user. I have created a Pop up form to enable the user view all the information (easily) held in the filtered record, which can then be...

I want to add a button to the Quick Access Toolbar to enable me to call a function when I am in report design view The function is a Stephen Lebans function for rotating labels His instructions are for an earlier version of access, I can not find a button to add to the toolbar which I can then...

Hi I am getting error 1004 application-defined or object-defined error I am getting the error at the following point in the code ActiveSheet.PageSetup.PrintArea = Range("A1", "P30") Any thought on how to correct this? DoCmd.SetWarnings False DoCmd.OpenQuery "QryAttendeeSheet", acViewNormal...

Hi can anyone help? I have an unbound form with 25 Text Boxes, 25 Labels and 25 Text boxes in the form footer on a Pop up form. The query QryVenueAttendees1 is a crosstab query, the code will dynamically populate all the unbound controls. 25 is the maximum number that I need. I am trying to...

Hi Everyone, I have added a number of text boxes to a form (more than I will ever need) and am using the following code to populate them, because the number of field will vary each time the Crosstab query runs. Public Sub Form_Load() Set rst = Me.Form.RecordsetClone For i = 0 To...

Hi Everyone, I know I am missing something with this, so could do with a pointer Field in Query within the query there is another field that filter the Tax Year Selected on FrmMain I then just need to check that the date entered on the Form is between the start and the end dates for that Tax...

Hi Everyone, I am trying to do the following but can't seam to get it right, part of it works but not all, any guidance would be greatly received. On the Subform which is in Datasheet view in the OnDelete event, I have the following code Private Sub Form_Delete(Cancel As Integer) If...

Hi Everyone, I have a strange one for you. When I use the shift key to get into the database design, if I then open the form and press the reports button on the form the following code works fine Dim RDate As String Dim House As String Dim strFile As String Dim strFile1 As String RDate =...

Hi, I have the following code in the onopen event Me.TaxReports.Caption = "Summary Tax Report By House for Tax Year - " & "" & [Forms]![FrmSchemes]![TaxYear] The TaxYear is a combo box, which is run from a query (QryTaxYears), the Bound Column is 1 (which is not visible on the form) Column 2...

Hi, I am trying to filter a Pop up remainder form and just can't seams to show the right records that I want it to display. I have tried lots of permutations so any help would be greatly received. The criteria in the query returns all the records Between Date() And [RentPeriodTo] I also have a...

please help, I am trying to transfer the query result to the bookmarks in a word document I have already created it stops at Set rst = db.OpenRecordset("QryHousingBenefit") telling me there is two few parameters.expected 1 I have checked the query and it is producing the right results does...

Can anyone help me change the coding to allow me to either use a dlook up or collect the Address information from a form Dim WordObj As Word.Application Dim WordDoc As Word.Document Dim WordRange As Word.Range Set WordObj = CreateObject("Word.Application") Set WordDoc =...

I have the following code for a comand button, works find when Database is in MDB format but get an error when in MDE format, I am using Access 2002 'Export File Code Dim strPathFile As String, strFile As String, strPath As String Dim strRpt As String, strBrowseMsg As String, strQuery As String...

Hi, I use the following Private Sub PostCode_BeforeUpdate(Cancel As Integer) If Not rgxValidate(Forms.FrmAddNewAccount.PostCode, "(?:(?:A[BL]|B[ABDHLNRST]?|" _ & "C[ABFHMORTVW]|D[ADEGHLNTY]|E[CHNX]?|F[KY]|G[LUY]?|" _ &...

Hi How do I use the DoCmd.TransferSpreadsheet acExport Query then open the save as box to specify where to save the file. I have found the code to open the Save as box, but I don't know how to connect the export to the save as box? can anyone help please

Hi I want to inport an excel spreadsheet into access I can use this code, but the file path to the spreadsheet is not always the same, so I would like to open the windows dialoge box to select the file to inport DoCmd.TransferSpreadsheet transfertype:=acImport,tablename:="Hours Worked"...