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: *

  1. renigar

    Having trouble with Excel Lookup

    My blindness finally cleared. My mistake was trying to get the max day date by looking at the monthly data columns instead of the from the daily grand total column. Stuff like that makes you feel kind of stupid. Oh well. renigar
  2. renigar

    Having trouble with Excel Lookup

    I appreciate the comments. I'm stuck here or maybe slightly blind. I figured xlookup was the way to go but, I'm getting the #VALUE! error and can't see what's messing me up. You don't need to solve it but, I could use a helpful suggestion. Thanks
  3. renigar

    Having trouble with Excel Lookup

    Combo, In my mind, which is often times foggy, the formula has to check through 11 columns and 5000+ rows that will grow every month. It seemed like an array to me. I also thought that since I already got the Max Day value in Column R and the date I need is on the same row as that value, there...
  4. renigar

    Having trouble with Excel Lookup

    Hello Everyone, The attached Workbook has 15 years of freshwater flow data. There are three sheets. The two main sheets are SupplySummary and FlowData. On SupplySummary, column R is Max Day (MGD) for the year and column S is Max Day (Date). The day in that particular year that had the highest...
  5. renigar

    Access VBA Syntax Error

    Thanks jedraw, That did the trick. I don't think I would have got that on my own.
  6. renigar

    Access VBA Syntax Error

    I'm sure this is easy but I've been staring at it for to long. I get the following error message in this line of code. DoCmd.OpenReport "Evaluation Due Dates R", acViewNormal, , "Division = " & rs.Fields("Division"), acHidden Can somebody open my eyes. Thanks
  7. renigar

    Access 365: Search LastName in one table to put EmployeeID in another

    Thanks again dhookom, I rearranged things a bit an ended up making the box for the EmployeeID use the =[cboEmpID].Column(x) tip you showed me. This works fine for a visual reference to the number.
  8. renigar

    Access 365: Search LastName in one table to put EmployeeID in another

    Thank you. I overlooked setting the ID column to 0. So the search now works but I would still like the ID to appear in the box once the selection is made. Is that possible?
  9. renigar

    Access 365: Search LastName in one table to put EmployeeID in another

    dhookom, Thanks for your help. I had the combo box row source almost like you suggested. I added the Division column. I didn't have the brackets around the field names, and it worked as far as showing the information. When I put the brackets on the field names it didn't work at all. I used your...
  10. renigar

    Access 365: Search LastName in one table to put EmployeeID in another

    ...Private Sub UniOutFindBtn_Click() Dim strLN As String Dim EmpID As Long strLN = InputBox("Please Enter Last Name" & vbNewLine & "To Search For", "Last Name Search") If strLN = "" Then Exit Sub [EmployeeInfoT].Filter = "LastName Like ""*" & strLN & "*""" [EmployeeInfoT].FilterOn = True...
  11. renigar

    Excel Power Query refresh error

    Thanks SoftwareRT, this info helped but hasn't solved my problem yet. I I got into the Power Pivot connection properties for Excel Group Billing Raw and found on the Used in tab (includes Billing Days) has the message "Some properties cannot be changed because this connection was modified using...
  12. renigar

    Excel Power Query refresh error

    I am trying to fix an Excel file that uses Power Query to import data from another Excel file into Power Pivot. This file was created by a former employee and I am not up on these features of Excel. This file was working fine until this week when it started generating a refresh error. The...
  13. renigar

    Code to write file path to field always writes to 1st record

    dhookom, your suggestion works great. Thank you very much. Andrzejek, your suggestion sort of works. When I execute it I get a dialog box that says, Error: Invalid Operation. Before I can click the OK button it drops the data in the field. Thank you for your suggestion.
  14. renigar

    Code to write file path to field always writes to 1st record

    Thanks for the reply dhookom, The primary key is the ID, set to autonumber. I'm not back to work until Tuesday. I'll look into your tips then and let you know. Thanks again, renigar
  15. renigar

    Code to write file path to field always writes to 1st record

    ...' Set the title and filter dlg.Title = "Select a file from DigCardsImages Directory" dlg.Filters.Clear dlg.Filters.Add "pdf Files", "*.pdf" ' Show the dialog and capture the selected file If dlg.Show = -1 Then selectedFile = dlg.SelectedItems(1) ' Write...
  16. renigar

    Trying to add hyperlinks to pdfs through form entry

    Regarding thread 702-1753559 hyperlink/browse for file, Link The link above is exactly what I am trying to do. I know a bit about Excel VBA but very little about Access (365) VBA. I'm a little confused on how to link the code to the text box where the hyperlink would be entered. I assumed that...
  17. renigar

    Access 365 Report use nickname if exist instead of 1st name

    After a little more research and some YouTube videos I have figured it out. Thanks for the initial push. renigar
  18. renigar

    Access 365 Report use nickname if exist instead of 1st name

    Thanks dhookom, I've been googling the function and the pages tell you the syntax but don't tell you where you use it. In a query, in the report? Could you please provide a little detail or direction.
  19. renigar

    Access 365 Report use nickname if exist instead of 1st name

    We have a simple employee database, 1 table, names, addresses. work cell phone number, etc. A new cell phone list is distributed whenever there is a change. Some employees are widely known by a nickname which we have a field for. When printing the report I would like to replace the first name...
  20. renigar

    Fishing for Ideas on sorting sheets in workbook

    Thanks Skip, My data layout was great for what it was being used for until I wanted to make it more flexible. Thanks for the tip. Renigar

Part and Inventory Search

Back
Top