Tables :: Grabbing Parts Of A TXT File To Add To A Table

Dec 5, 2013

I have a report that is generated daily that is a TXT file that is also the has the same file name each morning. One section out of this file is needed in a database that compiles and sends out reports to our customers. This section of the TXT file is variable in length, but is always preceded and ends with a specific text string that I can search for. It is also formatted in columns that are always the same width.

I currently have to hand enter this section into the database every morning. Not the easiest of tasks... I would like to get this automated.

View Replies


ADVERTISEMENT

Tables :: Copy Parts Of One Table To Another On Form Load

Dec 13, 2013

Access 2013. I have a table that I would like to contain columns from other tables when the form containing the table is loaded.

Example:

I open a form to input information into the table 'Equipment Input', but I want Equipment Input to be partially loaded with columns from another table 'Equipment and Rates.'

View 7 Replies View Related

Grabbing Oracle Login From A Linked Table

Apr 20, 2006

Not sure if this is possible but I have in my db a linked ODBC connection to a table. I use a Oracle 8 login to access the linked table. My question is can I capture the user login in ID somewhere in my table to show who is logged in? Thanks...

View 2 Replies View Related

Grabbing Values From A Table Based On Form Entry

Jan 5, 2006

In my database I have 4 tables for a small painting and decorating business.

These are:
tblCustomers, tblOrders, tblStock, tblPayments.

I have a form based on tblOrders to add new orders when they come in from customers.

In this form there are 3 important fields: "CustomerID" (Lookup to tblCustomers), "StockID" (Lookup to tblStock) and Quantity (Entered by user).

However, I want a calculated field that will be worked out automatically when the user is entering these details. The calculated field should go to tblStock and grab the "Cost" field.

However the main problem is specifying what price it will grab from the table. I want it to get the "Cost" where "StockID" = (the stock ID selected in the lookup). I then want to multiply the price by the quantity which the user has entered.

The control source should be worded something like:
= ([tblStock]![Cost] where [StockID] = StockID)*Quantity

but that isn't valid.

Could anyone point me to a piece of VBA or some way to get around my problem?
Many thanks for any help,
Stephen

View 2 Replies View Related

Grabbing Time Values From Table In Visual Basic And Performing Calculations With Them

Nov 8, 2004

Hi,

My boss wants me to program in visual basic, instead of using queries, a calculation between times, which values are gotten from a table. How do I perform a calculation between two fields from a table in code and what functions are there to calculate the amount of difference in minutes between times in visual basic? THANK YOU SO MUCH IN ADVANCE!

G

View 3 Replies View Related

Quick Q About Product Tables (parts)

Jun 30, 2006

OK, here's my delima (my head is spinning)

I have a standard Product table:

tblProducts
ProductID (PK)
ProductName
VendorName
Description
UnitPrice
InStock

Every Product has many Parts, but one Part may go to many Products

I will build this table:

tblProductParts
PartID (PK)
PartName
VendorName
Description
UnitPrice
InStock

How would I relate them together? I figure I need to use a Many to Many, with this table inbetween:

tblProductPartsList
ProductPartsListID (PK)
ProductID (FK to tblProducts)
PartID (FK to tblProductParts)

I feel like I'm missing something, can you let me know what you think???
THANKS!!!

View 5 Replies View Related

Alternate And Related Parts From 1 Table

Aug 2, 2012

I have a table with an ID and PartNumber field.

Parts tbl
PartNumID PK(Auto)

PartNumber

Heres some example data:
1 M24308/2-2F
2 M24308/4-2F
3 ORD9F0000
4 ORD9M0000
5 D90000VLO
6 D90000JOO

How would I design the table to allow me to define alternatepart numbers and also related parts? For example:

Record 1 is the primary part and record 3 is the alternatepart.
Record 2 is the primary part and record 4 is the alternatepart.
Records 5 and 6 are related parts to records 1, 2, 3 and 4.

I have a form that allows the user to select a part and displaythe part data. But I also want the alternate parts and related parts displayedon the form, maybe in a subform with tabs. I havent gotten there yet because Icant determine the table design.

View 3 Replies View Related

Create A Form For Adding New Parts To The Table?

Dec 7, 2011

We use a lot of different pipes for our work for different projects, I have inputed some basic data into a table called item description, this conotains the pipe detail (diameter/type) supplier and length its supplied in.

What I want to do is create a form which we can populate with all the defferent types of pipe in one of our jobs. I want to create a form for adding new parts to the table so its more user friendly to other users as opposed to using the table itself.Also when we are listing down the different pipes and fitting within one of our jobs there may be a few duplicated for example there may be 3 90deg bends.

Can I create a report once the form has been populated with all the different items which groups the duplicates together and totals them up? Ideally the final report will list each different part, and the quantity/length required.

View 1 Replies View Related

Split Table In 4 Equivalent Parts By 3 Criteria?

Dec 19, 2014

I have a table with the folowing structure:

ID(integer)
Value1(Double)
Value2(Double)

I need to split this table in 4 equals parts:

- count of id must be equal or close to equal(ex: 467 split in 3 x 117 and 116) for each part

- the cumulated Value1 and Value2 must be equal or close to equal for each part

View 3 Replies View Related

Queries :: Split Table In 4 Equivalent Parts By 3 Criteria

Dec 19, 2014

I have a table with the folowing structure:

ID(integer)Value1(Double)Value2(Double)

I need to split this table in 4 equals parts:
- count of id must be equal or close to equal(ex: 467 split in 3 x 117 and 116) for each part
- the cumulated Value1 and Value2 must be equal or close to equal for each part

View 11 Replies View Related

Tables :: Import Excel File To Table?

Oct 22, 2014

How do you import an excel to table..appended?? Using code. I am new to access. I have code to export and open an query into a excel file.

View 5 Replies View Related

Tables :: Possible To Update A Table In Split File?

Nov 21, 2013

I have an Access 2007 file that is 'split' so the tables are centrally stored on the server.

How do I update one the linked tables stored in the back-end file with a table from another Access file?

If I import the 'new' table it is not 'linked' - it is embedded with the Access file I am working on.

What is the correct way of doing this without corrupting the data?

View 3 Replies View Related

Tables :: Locate DSN File For Linked Table

Feb 18, 2014

I have a table that was linked from a SQL Server with a file DSN. It was linked years ago so now I want to locate that specific DSN file for that specific table if possible.

View 3 Replies View Related

Tables :: Read A File And Import Its Data Into A Table?

Oct 17, 2014

Was wondering how i can import data from a file to a table in different fields. The data inside the file is described with the number of characters and space's between. The attached file has the data.

For example in the file attached, the first four characters represent a data like 'ticket number' and maybe the third line 6 to 10 charcaters represent 'name of a passenger'.

Now how do i import these data to a table into respective fields in a table.

View 14 Replies View Related

Tables :: Export Table To TXT File Without Hyphens And Pipes?

Feb 23, 2013

I need to export a table to .txt.

I need to have the field names as well as the records.

Some records are part numbers with a leading zero like 043095.

Some records are part numbers with dashes and alpha's like 123456E-789.

I don't think I can use .csv because some records have a part number description uses comma's like "some text, more text, even more text".

I don't need all the hyphens and pipes for the grid work.

The problems I have so far are:Exporting to .txt without formatting doesn't bring over the field names (I know they made it this way) Is there a work around other than exporting the data and then adding all the field names in with a macro in Excel? I can do it but, what a pain.

I see dropping of leading zeros = 43095 in .txt and .xlsx

Exporting to Excel sometimes scrambles the part numbers and they come out like this 5.91E-09 when it should be 123456E-789 (so I'm losing data).

Exporting to Excel also puts qoutes in the description field like "A very large part" (extra clean up necessary).

easiest way to get rid of the hyphens and pipes and leave it in .txt form?

View 3 Replies View Related

Grabbing Max Or Min Values

Feb 10, 2005

Hopefully this is an easy one. I've got a table with (for example) a list of books sold (field 1) and the price they each sold for (field 2). There are duplicates in both field 1 and field 2. I'd like to create a new table that has each book's name exactly once, and the maximum value it sold for. How can I do that?

Thanks!

Ivan

View 2 Replies View Related

Tables :: Survey File - Concatenate 2-3 Field Values In Table

Sep 6, 2014

I have a project that in Access. I'll be handling a survey file that will maintain answers per customer. The visit to customer is done monthly in a year, which means that a customer can have 12 visits in a year. My problem is that if I will maintain this project for the next five years or more, I have to maintain another field in my table that will block the duplicate entries.

View 5 Replies View Related

Tables :: Browse For Excel File To Import Into Access Table

Jan 15, 2015

I want a user to click a button, have the file open dialog open, they select a spreadsheet, and then it imports into a table. The problem is the filename can be different every time. The table name will remain constant.

Here is the OnClick:

Code:
Private Sub Command8_Click()
On Error GoTo Err_ImportSpreadsheet_Click
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel2Xml, "Table1", "T_Staff.xls", "Yes"

Exit_ImportSpreadsheet_Click:
Exit Sub

Err_ImportSpreadsheet_Click:

Resume Exit_ImportSpreadsheet_Click
End Sub

View 1 Replies View Related

General :: Grabbing Web Information Into Database?

May 17, 2015

I have two third-party library programs that allow you to type in an ISBN and the software searches, say Amazon, and grabs particular missing data: author, cover jpg and summary etc, and imports the info to the program. I'd like to replicate this process with Access. If I can type in an author, title or ISBN to Access, I'd like it to search Amazon to gather and input the missing data to my assigned fields. Is this possible? Or am I stuck to typing in the information separately.

View 10 Replies View Related

Tables :: Command Button On Form To Run Text File Import Into Table Wizard?

Aug 28, 2014

Is it possible to have a command button on a form to run the Text File Import Into a Table Wizard?

View 13 Replies View Related

Grabbing Last Six Digits Of Social Security Number

Aug 9, 2005

hello,

simple problem. how would i grab just the last six digits of a social security number?
example: 123-45-6789 to 456789

I'm guessing that I should use the Format function, but I'm not quite sure how to write it. Thanks!

G

View 1 Replies View Related

Modules & VBA :: Grabbing Values From Search List Box

Jun 30, 2014

I was able to create a very user-friendly pop-up search form : {URL] .....

I would like to take it a step further... Now, I would like to grab the selected record ID from within one of the list box columns and use it in my SQL statement (to copy the record into a new one). Is there any way to reference a highlighted record value within a list box recordset directly and/or any workarounds?

I know one would be to grab the ID and insert it into the text box, just don't know what the coding references would be for this.

View 4 Replies View Related

General :: Forms And Queries In One ACCDB File - Path Setting To Linked Table File

Oct 5, 2014

I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.

One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.

Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?

View 4 Replies View Related

Parts Database Qty In - Qty Out

Nov 8, 2006

Hello!
Simple one for most, but I have having problems with a Database I am setting up
The database controls stock movement (i.e. inwards stock and outwards stock)

I have set up a Parts Inwards table with the following fields:
Part Number (linked)
Qty In
Stock Location

And I have set up a Parts Out bound with the following fields:
Part Number (linked)
Qty Out
Stock Location

Now for the problem, when I run a query to tell me how many parts I have left in the stock room i.e. Qty In - Qty Out, it duplicates the data in the Qty In.
I assume its got something to do with the fact that I have multiple Qty out’s for a single Qty In entry…hope this make sense?

Can someone help?

View 4 Replies View Related

Creation Of Two Fields From Parts Of Another

Jul 5, 2006

In a field “NAME” I have “Adam Smith”.
From this field I want in a QBE window (not in VB) to make two new fields “FIRST NAME” “Adam” and “LAST NAME” “Smith”.
In Excel there are the functions FIND and SEARCH with which I take the number of the gap “ ” (5) between Adam and Smith and with the functions LEN, RIGHTS and LEFTS I have a result.
What could I do in Access 2003?

View 3 Replies View Related

Delete Parts Of A String

Apr 28, 2008

Hi,

I am trying to delete a part of a string but not all of it.

For example; American Express Inc. I would like to delete only the "Inc.", but leave "American Express".

How is this done?

Many Thanks,

Tim

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved