Search results

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

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

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.

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

I have a need to be able to enter "feb 06" into a text field on a form and get "Feb/2006" stored. Also if they enter just "feb" then the current year be used, so if it was 2007 then "Feb/2007" would get stored. I tried to use this code, in the fields after update, but it does not deal with the...

I need a Report that shows the Month To Date and the Year To Date per each Category at the top and along the left all of the individual people. Life Annuities Securities Group Total Agent MTD YTD MTD YTD MTD YTD MTD YTD MTD YTD Bob 25 50...

I am getting the following error: Write Conflict--This record has been changed by another user since you started editing it.... I think i know why, but I am sot sure what to do about it. I have a main form with a sub form, each is based on a stored procedure with only one table in it (not the...

I need to restore a bunch of views from an earlier date, so I went to a backup and generated a script for all the views that I need, but now when I run it in Query Anylizer I get erros about a view that is used in the view that I am trying to create, not being there. Well, it will be when I...

I have a stored procedure that normally takes 1-2 seconds to run. However, after a couple of days, it then takes 7-8 minutes to run. The tables are not being heavily modified. If I stop the SQL server and its service then start it again and run the same stored procedure, it runs again in...

What is the syntax for telling me what current record I am on in a record set using ADO? In DAO it is rst.CurrentRecord, but I can't seem to find the equivalent in ADO!! Old DAO code: 'If Me.RecordsetClone.BOF = False Then ' Me.RecordsetClone.MoveFirst ' ' For i = 1 To Me.CurrentRecord...

I am trying to do the following: 1. Loop through a table of embeded Word docs 2. Open each one 3. Save it as a file 4. Close the file 5. Loop to the next one Here is my looping and opening code that is not working. Dim rst As New ADODB.Recordset Dim strTableName As String Dim ctl As...

I have a main menu that I select things to open. Most of the things I open I open in form view but some I want to open in data sheet view. Without recoding my menu code is there a way to specify in the form to be opened that it should open in data sheet veiw? Right now I have the default view...

I converted a form and its queires from Access MDB to ADP and I can't get my form to show the footer calculations anymore. The underlying query has two fields that are sumed that I want to do a calculation on. sum(dbo.vProcMgrTotalFeetPerWOID_ByShift.TotalFeet *...

I need to select 200 random customers from my table, how can I do that? Table: tblCustomers PK: CustID