Recent content by mmitchell

Has anyone dealt with an "Enhance Data Interchange" EDI X12 formated file? Specifically 850 Purchase Order and 810 Invoices. I need to import the EDI text file and parse each piece of data from each line and then process them to add transactions to my PO and Invoice system. I have no...

I thought that I could use a function that would run at each specific record insert. The code works elsewhere on a form to generate the next sequentioal number for each customer. It thought I could use the same code in the queary and that it would go out and find the last number used then...

I am trying to append records from one table to another and insert an increasing number to each record as it appends records. But it only returns the same value each time. I have the following function: Function modNextPartNumber() Dim strCustAbrev As String Dim intIncrement As Integer '...

I need a way for 2 people to connect to an Access database back end over the internet. Is there a way to "host" a file on a website of some sort and be able to "connect" to it from the Access front end? Without setting up a VPN.

I have a table of numbers by month for a given year like J F M A M etc. 2007 9 1 7 6 9 2008 1 9 3 2 5 etc. I want the average for the year. I can't figure out how to do it! Note: I can't change the way I get this data, it is in that format so That is how I have to deal with it.

Hey, I just tried dropping the table in and putting in the fileds and it seemed to do what I needed!

I have a stored procedure in QuickBooks that I run, so I can't modify it, but the data it returns resembles a crosstab and looks like this: SequenceNum VarAccntName AccountNumbr Label Amount_1 Amount_2 Amount_3 1 Metal 5000 5000 · Alloy Costs 78337.84 76377.99 54113.81 113571.11 1 Metal...

I have a crosstab query that I run on scrap reasons for specific parts. The query will return different "fields" based on what it finds for the parts I give it. My problem is that the report I made (which has all the potential fields--scrap reasons) comes up with errors about missing fields...

I have an Access 2007 .accdb split into front end and back end. I have the backed data on the server and the front end local on my PC. The server is a MS Small Business Sesrver 2003. At around 5:00pm every day I get frequent "Not Responding" from my front end, it only last a few seconds but...

Thanks for the reply, just simply need to track customers returning a steel casting, and why, then give them an RMA number and track notes about the transaction. Nothing too deep at this point. Basically used by just the QA manager.

Hello all, just woundering if anyone knows of a RMA database that is in Access so that I can customize it rather then develope it from scratch. Thanks.

Thanks, I looked at your sample and it looks great. I noticed that you seperated out the "segments" of the number, whereas my code combines them. Note sure what the best way to store the number: combined or seperated out. I would think that "crunching" it all at the time I right it to the...

Here is what I have so far that I think will work once I add it to the "add new record" button on my form: Dim strCustAbrev As String Dim intIncrement As Integer strCustAbrev = "KM" '**Need to get from form. intIncrement = Nz(DMax("Right([PatternNumber], 4)", _...

I need to create a sequential number for each customer and store them in the same table. For example: PBM0001 PKZ0001 PBM0002 PKZ0002 PKZ0003 So, the number is sequential within each customer The number has 3 parts: 1-the prefix will always be the letter "P" then, 2-the next two letters is...

I have two tables that have fields set to a text so that the ClientID is their name. When I query, my queries don't take into account the case. So "K Smith" is the same as "K SMITH" as "k sMIth" I am trying to write an unmatched query between two tables based on this ClientID but it will turn...