Search results

  1. M

    Running Queries in other Databases

    Hi everyone, I have a form and want one of the combo box's to run a VBA code that does the following: Opens up 2 databases and appends an excel file to each and then runs a query that is in each of those databases. E.G. On click: Dim appAccess As New Access.Application Dim FilePath As String...
  2. M

    Using DLOOKUP in VBA Code

    Hi guys. I have the following code and want to add a DLOOKUP, I'll try elaborating as I go. I know it will look like a lot but my only trouble is understanding how to use DAO recordsets in DLOOKUPS. It's simple when you understand it (to code), but I've tried many variations and can't grasp it...
  3. M

    How to do DLOOKUP in Field

    I have two tables. The main table is named "Master Table" and the table I want to pull information from is called "RefData". I want to read the field [Master Table].[Company ID] if it isn't blank and populate the field [Master Table].[Company] by reading from my RefData table. My RefData table...
  4. M

    Scan for close matches within Table

    I'm looking to create a vba code that would search and find close matches within a table. Sample Data is attached!!! I would like to find a potential match based on all of these criteria but in opposite directions (aka a buy and a sell). If it's not there, I created a code to find it in...
  5. M

    Using DateDiff in Sub

    I have a module that has the following IF statement that isn't working: If DateDiff("d", Now(), rs("Date")) = 1 Then ... End If I'm trying to use this code to do the following: If the difference in DAYS between rs("Date") and now is exactly 1 day (not counting for hours/minutes/seconds)...
  6. M

    VBA Code for DLOOKUP

    I'm looking to create a Sub in VBA that uses the logic: If DLOOKUP() does NOT return a value, then do X Y and Z. What would be the best way to do this? I'm also trying to do the following: If a record is a match to another record in a linked recordset/table, then do A B and C. How would the...
  7. M

    VBA code to do VLOOKUPS/Rough Matching

    I have used VBA quite a lot before for Microsoft Excel, but only once before (terribly) for Access. Please bare with me as I try to explain what I intend to do with this code!! I'm looking to have the code run and do the following: 1) Run my Update and Append Queries 2) Start running the...
  8. M

    Deleting Duplicates Question

    Hey everyone, I have a file that will be searching for new data from a daily file and appending it to a master. If I use an Unmatching Query or delete duplicates, will it pull in the most recent record or the old record? I ask this because my OLD record will have comments added to it but I...
  9. M

    Adding Calculated Fields to New Table Query

    Hey everyone, I am in the midst of a process and ran into a bit of a wall, I was hoping somebody here would be able to help me out. My process: Import new daily file, add calculated and some blank/text fields to it, append it to the Master. My master file has 5 fields more than the file I'm...
  10. M

    Query Based on Passing Criteria

    Hey everyone, I'm attempting to make a table based on a weird criteria, was hoping I can explain it well here and someone can help me. I get a weekly table of products that come into a warehouse. Each product has a unique ID and this table also contains the company it comes from (lets say...
  11. M

    Pulling Values from Form ComboBox

    Hi everyone, So I have a form that has three combo boxes, namely "cboLOB" "cboDescription" and "cboStatus". The form's name is "Form", if that's of importance here. The three combo boxes are in descending order and based on the value from one, the appropriate range of values appear in the next...
  12. M

    Counting Unique IDs per Date

    Hi everyone, I have a set of data in Access that looks similar to the Excel file I've attached. I am hoping someone can help me use an Access Query (or maybe VBA is the way to go?) I need to create a count of the following: 1) # of Primary Keys per Company 2) # of Unique Packages per Company 3)...
  13. M

    Dynamic Unmatching and Append Query VBA

    Hi everyone, First time poster, I've heard lots of great things! here's the problem I'm currently having, hopefully someone can provide assistance! I have a folder containing MASTER databases for each month/year(MASTER0816, MASTER0916, etc) linked to one central Access database where I will be...
Back
Top Bottom