Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cneill
  • Content: Threads
  • Order by date
  1. cneill

    Combining If and Iferror and Index/Match with Hyperlink

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

    Hi, I am trying to get my head rou

    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"...
  3. cneill

    Hi, I need some help with Pre an

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

    Multiple Emails via MS Access to BCC Recipients

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

    Filtered Pop Up Forms

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

    Customize Quick Access Toolbar

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

    error 1004 when transfering Query results to Excel

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

    Hide text boxes with no value

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

    Crosstab Query

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

    Using IIF Aand Between in Querry

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

    Deleting or not deleting record

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

    code not working when Database is open

    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 =...
  13. cneill

    Report Caption

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

    Filter Form

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

    transfer query results to a current word document

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

    automation of word via Access

    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 =...
  17. cneill

    outputto error in mde

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

    Postcode validation and correction

    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]?|" _ &...
  19. cneill

    Export Access Query to Excel

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

    inporting Excel to Access

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

Part and Inventory Search

Back
Top