Recent content by MatthewH

Yes I'm 100% sure I won't need it. Once it's appended to the linked table I use the linked table for everything. That should be a very simple task for me to do (this entire thread), I'll come back here in about an hour or two if I run into any problems haha. Thank you all for everything!!

Hey everyone thanks for your responses and attempts. I think I'm over-complicating this and I want to be sure I am before I go about this other method. I want to import an excel sheet into a table and append it to a linked database. Very simple. I have the path of the excel file and the path...

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

Thank you so much for that link it definitely helped a lot with the Domain function! What I have so far is: VarX = DLookup("Desk","RiskBookDesk", "Criteria=rs1("Agent'") It's obviously messing up at the rs1 part but I don't understand how to get it to fit what I want. I just want it...

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

I don't think that's what I'm going for, I'll try to elaborate. I have my master table which has a bunch of information about our sales. It's got a full list of client IDs, prices, quantities, salesperson's name, date, etc. It has one field though that's COMPANY ID (who we sold to). I want to...

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

Well the problem I'm particularly having is creating a recordset that skips the current record when looking for matches but searches the rest of the database. The idea I came up with so far that seemed to work was to set a BucketCount and assign each field a value. So if it matches on Price it...

Hope somebody is able to help soon... Any tips/help is appreciated! :)

Any help is truly appreciated I'm stuck :/

Well CLOSE would be that the TradeID matches up perfectly but there's just one error in the other fields. The error can be a big error but as long as the other fields all line up we can identify where that error is. So if Price Quantity Time Trade ID and Direction are all exact matches but the...

Okay so we sell paper on a large scale. Every paper trade has a Trade ID. This Trade ID comes up twice, one when we sell the paper (listed in our DB as a SELL) and another comes from the other company as a BUY order (listed in our DB as a BUY). We link these two up to ensure that we didn't put...

Ok I'm going to give my best explanation attempt. Our system checks each trade against one another for our product to try finding a match. A buy must be matched to a sell and if they match on all of the criteria (price, time, quantity, etc), our system automatically links them up and stores...

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

I actually used those just as quick references for what the text would be but it actually uses the comment "Happened on ___" and ___ is a CDate function referencing the date. SO I completely agree with you that happened today/yesterday isn't a good method and I have amended it to include the...