VB6 And Access Database ... Inventory/Sales/Purchase Project


I am a VB newbie. Have just started a Project - similar to an Inventory - to recorditems I buy and sell on Ebay and, eventually, to track my Ebay transactions.I have got the Access database set up (with relationships),and I've used the VB Wizard to create some forms.I need to combine these Forms, and others, into a working systemeg: If ADDing an Item, it needs to have come from somewhere - Purchase Order and Seller records. If DELETEing, then Sales Invoice and Customer records will be needed.This project is intended exclusively for my own use.At the moment it's all done on Ebay and email records.Hope you can understand thisI could email the database and VB project to anyone who thinks they can helpI've been told that it's easier to do with msAccess Forms, but I've only ever used msAccess to create tables. Also hope someone can give me pointers or an example to work from.Best regards

View Answers
Very similar questions


Inventory And Sales Transaction Table Design Question - Version: 2003 (11.0) www.utteraccess.com

Im putting together a database that tracks sales and inventory and several other things. Now i will have a transaction table that records all movement of money in and out, through sales, expenses, purchase of inventory etc. Now what i need to know is if it is possible for a transaction table to have relationship with approximately 5 other tables, like one for expenses, inventory aquisition, sales etc. Thanks in Advance Corey

Cumulative Totals visualbasic.ittoolbox.com

I am using Vb6 as front end and Ms Access as backend.In an inventory program I want to take out cumulativetotals of Closing Stock. At the moment I am achievingmy task by making a temporary table which calculatesthe cumulative ClosingBalances. Then from thistemporary I am generating various reports. Is theirany way, where, I need not make this temporary table,and, through SQL query generate a resultant recordsetas explained below.In my Access table I have following fields :OpeningBalancePurchaseSalesClosingBalanceFields Purchase and Sales are filled inprogramitically. How to write a query which willcalculate the ClosingBalance (OpeningBalance +Purchase - Sales) and fill this ClosingBalance as theOpeningBalance in the next row and so on...The resultant query (for example) should be as follows:The first row ==> 0 + 10 - 2 = 8 where 0 isOpeningBalance, 10 is Purchase, 2 is Sales and 8 isClosingBalance (Generated from query)The second row ==> 8 + 3 - 5 = 6 where 8 isOpeningBalance (Carried forward from the previousrow), 3 is Purchase, 5 is Sales and 8 isClosingBalanceand so on....Your help will be highly appreciated. Thanks in advance.

Changing Single User App To Multiuser www.vbcity.com

Hello everyone,I have an app that I need to convert to multiuser. Does anyone have any advice/warnings/general info on what to watch for, issues that may come up. The application is using an Access database (Jet) and ADO.The application is an inventory control system, purchasing and sales. Multiple users will be doing the same functions at once (ie. trying to edit the same inventory item at once)Thanks

Eliminating Sold Inventory From The Inventory List www.ozgrid.com

I am not an excel whiz, so I will need layman's terms if possible. I may have found a solution to my problem under another thread, but I couldn't understand it. I have only briefly worked with macros, a very long time ago. Here goes... I have an inventory list that has not been updated for sales of the inventory, only for purchases. I have sales lists, generally by month, in separate spreadsheets. I am looking for a simple, efficient way of either eliminating or at least matching up the data in the sales list to the inventory list in order to remove sold items from inventory (on paper). I am hoping the result will be a fairly accurate inventory list, and related value, so that a physical inventory count won't be necessary at this time. Obviously I could copy all of the sales info into one spreadsheet, sort by inventory number, then manually delete all sold items from the inventory listing. I am REALLY hoping there is a better option.

Inventory Table... - Version: 2003 (11.0) www.utteraccess.com

Ok... I've been working on a project now for a couple of weeks, getting a db established for my wife's Avon business... I have tables for sales orders, purchase orders, customers, & inventory... Now, the last thing I would like to be able to do, if it's possible, is to have Access automatically increase the corresponding inventory totals when a Purchase Order is generated, and decrease the corresponding inventory when a sales order is generated... Could someone steer me in the right direction of where I could find out how to do this, or guide me on how to do this??? Let me know what information you need about my DB... Thanks...

Update Query (Access Vs. SQL Server) bytes.com

Can someome please advise what the equivalent query would be in Microsoft SQL Server ... I've tried a number of combinations with no success ... Thanks, Ralph Noble (ralph_noble@hotmail.com) ================ UPDATE INVENTORY INNER JOIN SALES ON (INVENTORY.BAR_CODE = SALES.BAR_CODE) AND (INVENTORY.PRODUCT_NBR = SALES.PRODUCT_NBR) SET INVENTORY.DATE_PURCHASED = "20050127" WHERE (((SALES.SOLD)="20050127"));

Backup And Restore www.vbcity.com

I'm programming a sales, inventory, scheduling, and rental system for my 3rd year project in VB .NET and have little background in coding in vb.I need to backup and restore my Access 2000 database and I have no Clue how to do this.If anyone can help me please, this is the only section in my system not working and the project is due in two weeks.I know I've left it late but I've given up trying to figure it out myself.Please Help me!!Thanks.Edited by - semore on 9/15/2003 7:52:21 AM

How To Delete Recordss From Database(access) www.vbforums.com

pls help.....i m doing a inventory system...using vb6, and ms access(for database)now my prb is donno how to delete certain data form database...for example..... i got these stocks ...A001A002A003A004A005if i want to delete only from A002 to A004and left A001 and A005 in databasehow m i code this ....******************************************************Private Sub cmdDel_Click()Dim DB As DatabaseDim rec As RecordsetDim replyDim f1 As StringSet DB = OpenDatabase("c:inventory systemInven.mdb")Set rec = DB.OpenRecordset("Sales")reply = MsgBox("Delete from " & cbStockCodeFrom & " until " & cbStockCodeTo & " ? ", vbYesNoCancel)If reply = vbYes Then Do If f1 = ("{Sales.StockCode} >= " & cbStockCodeFrom.Text & _ " and {Sales.StockCode} <= " & cbStockCodeTo.Text & "") Then rec.Delete rec.MoveNext If rec.EOF Then Exit SubEnd If Loop MsgBox ("Record is Deleted")End IfEnd Sub**************************************************this is wat i have done so far...i keep changing the code...until i got blur wat m i doing now...i really need some help....thankss alotttswiss

Maximum Users Logged In Sql Express social.msdn.microsoft.com

we're planning to use sql express as our database server in our office. the database will consist of accounting, purchasing, marketing, sales, inventory, production and hrd tables. 80-100 users will use the system simultaneously in adding, editing, deleting, reports. i need some advice on the following: 1. maximum users that can log on to the database simultaneously? 2.� maximum size of the database? tnx

UPDATE Query In Visual Basic Not Working? social.msdn.microsoft.com

I am trying to make a project for point of sale and i am having issues with updating inventory table. once cashier make sale items quantity should get subtracted from inventory table. i tried bellow code but it is not updating table, however in message box it does give me new quantity for that item. [Code]...

Data Aggregation From Different Workbooks www.ozgrid.com

I have a workbook which has sales data in one worksheet and inventory data in one worksheet. There around 50 workbooks I get each week one for each customer. The column headers are same for sales and inventory in all the sheets. All the 50 files are in the same folder. Is there a way to put the sales data of all customers in one worksheet and inventory in one worksheet. Currently I am doing it manually.

Copy Data From Form To Another www.access-programmers.co.uk

hi guys.... am new here and i need smal help :) i have 3 tables inventory and sales and order and i made 3 forms for each table in inventory form the user will only read the data in sales and order the user will enter and delete the data so my problem is i want to know how when the user enter the data in order form all the data will be copy in inventory table so what ever added in order table it will be copy or updated to inventory table how can i do that?? :confused:

Setting Up Tables And Relationships - Version: 2007 (12.0) www.utteraccess.com

Hey there, I am setting up tables for a lobster company, just selling 3 different sizes at of course three different prices. I'm going to have a table for restaurants, suppliers, purchases, purchase inventory, and inventory....I think. So far, these are the relationships I have set up. Restaurants(one)---->(many)Purchases(one)---->(many)Purchase Inventory(many)<----------(one)Inventory Can you set me on the right path to add Suppliers in there somewhere or just reorganize the tables. Thanks for your time. -Matt

Need To Know The Number Of Microsoft SQL Server Licenses Required forums.databasejournal.com

hi all, our company is using SQL Server 2000 Standard Edition as a backend for inventory and sales data storage. The top management of our company has decided to web enable all the data for sales and inventory so that any authorized user can have access to the data from anywhere in the world. now my question is that how many SQL Server licenses will we require if we are going to use it for the web? We currently hold 20 licenses. Thanx in advance.

New Microsoft Office Access 2007 Database social.msdn.microsoft.com

It is my first time to code vb2010 with an application of database. I am doing my inventory system project and i do not know how to start my project. Can somebody help me to find a tutorial in visual basic 2010 and New Microsoft Office Access 2007 Database? I would like to use vb2010 and New Microsoft Office Access 2007 Database... Is this possible to use for my project?

FIFO Inventory- COGS & Inventory Valuation www.excelforum.com

I had been trying really hard to get some solution on COGS valuation & inventory valuation on FIFO basis. my daily transactions are typical sales & purchases. Attached is the inventory in/out movement from Quick Books. in the column "Num" type bill is the entry from purchase bill whihc always has a reference as P/O####. This is how i will capture the landed cost against a PO., another type "Inv Adj" is inter warehouse transfer. Name is cusotmer, Inventory is my item number. in some cases it is like "2000", in some cases it is 10000:10121, and in some cases it is 10000:10200:10201 that is why they fall in different columns when i export them. What I would lilke to do: 1) Run a report by month, by customer showing cost of goods sold on FIFO basis, I can capture sales amount by running another report.

How To Add Multiple Values In One Field www.vbcity.com

my program is goingto be used to monitor the sales and inventory of a certain company. in entering the purchase of a customer, i first add all items to be purchased on a listview. then i would like to add to the database the items purchased. my problem arises when the customer purchases several items. how would i enter the products purchased into the database if there are more than 1 item purchased? I need a way to add the products purchased under one transaction.my database contains the following fields:transaction_id - primary keycustomer_idpurchase_dateproduct_idquantity_purchasedmode_of_paymenti have included a screenshot if it helps. any help would be greatly appreciated.Edited by - LiquidAngel on 8/25/2003 11:57:42 AM

Keep Each Module Separate And Call EXE's Or Should Create One Large Project? social.msdn.microsoft.com

The company I work for has a VB6 project that is using an ACCESS database.The project consists of seperate modules such as Accounts Payable, Payroll, General Ledger, and Inventory.At the current time each module is a seperate project in VB6 and the EXE files are called when needed.In total there are about 1300 forms in the project.We are moving from ACCESS to Sql Server and from VB6 to VB2008.The question that I (we) have is as follows; Should we continue to keep each module seperate and call the EXE's or should we create one large project?What are the pros and cons for each way?Is there something written that explains the advantages of either?

DB Design - Sales - Cost Of Sales - Margins - Version: 2003 (11.0) www.utteraccess.com

Hello: I'd like to understand how a Sales/Cost of Sales application would be developed. Given that: - The sales price for a product can change at any time - The cost of the product changes based on when the product is taken into inventory - Products are added to inventory multiple times - Inventory is accounted for on a first in first out basis What's the best way to account for the following: - Historical sales transaction detail can always be reproduced - At the point of sale the application knows how to price a sale and allocate the cost of sale to the transaction - The only constant is the product description prices for sales and cost are always changing Any sample db's or templates that deal with this or any links to where this subject is discussed would be greatly appreciated. I imagine this is a challenging application and I'm mostly interested from a conceptual perspective on what the best practices are for writing something like this. Thanks, Paul

Sending Mails From 2005? www.daniweb.com

I'm doing INVENTORY project... front-end : vb.net back-end : Access [code].....

Update A Table In Access? social.msdn.microsoft.com

I've created a Point of Sale program using Access and VB.net. I have an Inventory table from which items are sold. There is a quantity column and I want to be able to reduce the quantity for any item by the quantity that was sold in the point of sale front end. For example, there are 5 bracelets in inventory and 1 is sold. The quantity is typed into a textbox. The inventory quantity should now be 4 in Access. I don't know how to make this happen from the point of sale screen.

Basic Data Base Creation www.xtremevbtalk.com

I made a make shift inventory database in Microsoft Access but, instead of learning Access (because it is an insane program) I want to program a VB app to do the same sort of thing (inventory list). I'm a beginer with VB and I don't know how to store data for later use such as the MS Access saves my inventory list.How do I (Basically (BASIC)) stor data such as saved settings and inventory lists...??????Thanks for all your help in advance...?If there is already a tutorial out there that has covered this, I'm sorry for wasting space on this server!...

New To Access Multi-Table Query Problem www.access-programmers.co.uk

Hi, I new to access and I just started using it for a group project in one of my classes. We are supposed to make a database for our "business" so we decided to pick a small independent movie theater. After some trouble we finally figured out that we had to link the tables with some relation ships. Our basic tables are: "Distributors" -relationship-distribributorID-"Ticket Sales" "Employee Information" -relationship-TitleID- "Position Information" "Inventory" So I made a query that would get the revenue for each product sold in the inventory by multiplying the price and the amount sold. I was wondering if it would be possible to create a query that would total all the revenue and all the ticket sales and divide them to create a per-person spending ratio.

How To List Database Items In Combo Box? www.vbcity.com

I am working on this project that will calculate customer orders and update the inventory when the purchases are made.all my inventory and product information is stored in Microsoft Access Database. What i would like for the users to do is to list the customers orders in a list/grid by selecting each product # from a comboBox.My question is how do i put my inventory(which is held in msAccess) into the combobox so that the user can select a specific product that the customer has ordered and display each order in a list or a grid?at first i thought i might just manually enter each product in the combobox in the properties section but then i realized that if i were to edit the inventory by either deleting a certain product or adding one the list in the combo box would be inaccurate.Please help thanks

How To Retrieve Data From Three Tables Within A Database? www.xtremevbtalk.com

As I know you are all programming experts, may I expect any of you to help me out with a VB problem?I am doing a project, it is all about developing a Supermarket Transaction Control System which consists of Sales / Purchase / Inventory modules.I created the database in ACCESS with 6 tables ( ProductRecord ; SalesRecord; CustomerRecord; SupplierRecord; PurchaseRecord and UserRecord). And I use VB6.0 to develop my system.I use ADO as the data link to linkage the database. In each module, I apply a TOOLBAR (toolbar.buttoms.item(array)) to perform ADD / DELETE and SEARCH functions.Currently, my Customer Record works. It can perform add new record, delete record and search record. (It retrieves data from CustomerRecord table only). In the same way, I created Sales Record which should retrieve data from 3 different tables within the database ( SalesRecord table; ProductRecord table and CustomerRecord), however, my Sales Record can’t perform ADD function properly.The problem is:-When I add a new record with proper Sales Record ID; Product ID and Customer ID, it produce me three different records with same Sales Record ID. Let say, I have 3 customers record, 3 product records, when I add a new sales record with one of three customer and one of three products, it produces three records with different customers and different products.I think my coding part for retrieving data from different tables and write to one table. But I don’t know how to fix it. Can any of you help me?Attached is my SalesRecord coding

POS Programming In VB www.xtremevbtalk.com

I am trying to make a POS for my store. I was using Excel and VBA but it is not as reliable as I would like it to be and my employees like to unlock my sheet and enter in INventory descriptions rather then enter in the code as I like them to. I had to unlock sheets and adjust for my tax free customers and such and my employee now uses the unlock feature.I was using MYOB and then Simply Accounting but those programs are so broadbased and they really don't track well....So now I am trying to develop my own program. I now have VB6.0 and I have some books to do a quick study.Want I want to create is so simple. A form for the sale with links to an inventory database....track my inventory. Links to a customer database and if a name is not init then add one into it automatically. A way to get the totals to go to different monthly sales sheets. A print out to my STar 200 printer and email of the invoice home to me. Save the invoice in a file that is named the customer name and then all the invoices that they purchase get saved in the customers folder...... Can I link to a database so that I can add and delete inventory from a form. I read that I cannot do this to excel....is it possible to use a simple thing like notepad or does VB have a way of using it's own built in databasing utility? Which is the best way of doing a database ACcess is not my first choice. I really like Excel.I am fully capable and ready to tackle this task I just need a little guidance!!Acorn

If - Elseif www.xtremevbtalk.com

Posted - 03/12/2007 : 13:21:43 -------------------------------------------------------------------------------- Can I use one parameter in stored procedure for changing WHERE clouse...something like this ...???CREATE PROCEDURE myProc@date_from datetime,@date_to datetime,@trazilica nvarchar(30),@ReciNum integer,@ParamC integerASBEGINSET NOCOUNT ONINSERT INTO Sales ( [Description], [......SELECT arhPOSInvoiceLineitems.[Description], .....FROM arhPOSInvoiceLineitems INNER JOIN Inventory ON arhPOSInvoiceLineitems.[Item Number] = Inventory.[Item Number] And arhPOSInvoiceLineitems.[Ship Date] Between @date_from And @date_toif @ParamC = 0 then WHERE Inventory.[UPC Code] Like @trazilicaelseif @ParamC = 1 WHERE Inventory.[Item Njumber] Like @trazilicaelseif @ParamC = 1 WHERE Inventory.[Discription] Like @trazilicaGROUP BY arhPOSInvoiceLineitems.[Description], .....ENDGO

Creating A Chart. www.vbcity.com

Here is the question:3. Produce a bar chart that shows inventory costs (unit price * quantities) of each DVD in any category. For example, the user may request the horror or action category, then the bar chart should be able to display all DVDs in the category and inventory cost.I have posted an attachment of the database that i have in access.The main question here is....how do i create an excel chart using codes??Im a newbie here and am usin VB6. Please help somebody.

Transaction Table For Inventory Control www.access-programmers.co.uk

After a lot of searching, printing and highlighting I want to double check that I have the right idea. I have a simple inventory control database. From reading the forum, it seems the best approach is to drop the detail lines table of the purchase order (incoming) and the detail lines table of the sale invoices (outgoing) and make one table for all transactions. The Transactions Table would also keep records of inventory adjustments from inventory counts, etc. Each transaction would be given a type so I know in which direction the stock count moves in (adding or subtracting) when I sum the totals for each item. Otherwise, I need union queries to ensure all tables are considered in my calculations. My database is simple (thankfully). Let me know that I am on the right track I like the solution but like any new student, a little reassurance is appreciated.

Little Design Problem With My Access Db And Vb6 Application. www.vbcity.com

Hi, I have a vb6 application with an access db. In the db, the problem I have arises from two particualar tables. One table called simply holds information that holds simply id's, descriptions and costs that is imported every so often into my vb6 application from another source callled simply accounting.I have a second table called inventory (inventory ID #,simply ID #,costs and description) that holds this exact data along with other data that is input through the application but is never in the simply table. Currently when prices are changed in simply accounting, I import them in and do a join with my inventory table to get items that are either not in inventory or the prices have changed. I then either add the item in or change the price. Now here is my first problem. Sometimes in simply accounting an id number is needed that is already used, so things are changed around. When it is imported, the vb6 application has the item in twice each with a different number. Example: If I have gum in simply accounting with id 200 and it is also in inventory at 200. Gum is then changed in simply accounting to 100. My inventory after importing will have gum at 100 and gum at 200. See the problem? My second problem is I can't just dump in everything from simply because I have other things in inventory that is in there from the vb6 application that isn't or will never be in simply accounting db.My third problem is how can you make the numbers in an access db go back to 0? After constantly importing data into inventory, the numbers just get higher and higher.So in a nutshell, I need to be able to dump everything from simply accounting into inventory, but leave those things in inventory that were put in through my vb6 application alone. And of course start the numbers at zero everytime.ThanksBrad thanksleadfingerhttp://www3.nbnet.nb.ca/gspil

Table Relationships www.access-programmers.co.uk

I am trying to put together a sales/purchase/stock control/accounting program using Access. I have put together a number of tables that I feel will be required and now I'm trying to set the relationships between them. The primary end document to be printed will be a Sales Order and a Purchase Order, likely generated from the reports module, so I have a table called Purchase Order and another called Sales Orders, related to Purchase Orders will be a table called Suppliers and another called Customers will be related to Sales Orders. Another table is called products. For the Purchase Orders table, do I only add fields that are the primary key from the Suppliers table in order to list the full customer name and address stored only in Suppliers table. Would the supplier table be the parent and the Purchase Order the child ?

Correct Table Structure - Version: 2003 (11.0) www.utteraccess.com

I am creating a Sales and Purchasing database for my company, but I feel like I am leaving somehting out. My company buys and sells agricultural product. most of the time we create a Sale and them a Purchase. For example, one of our overseas customers will call and ask for 100 metrc tons of grain. We check the current market rates, ocean freight rate and anything other cost. We then give the customer a quote. They say ok and we have a sale. We then go to our suppliers in the USA and purchase the product. A Purchase is usually based on a Sale so we do not generally hold inventory, but there could be times when the market to buy is good and we purchase product with the intension of sell at a high price. A sale could also be cancelled after we have made the purchase and the product has already shipped. There could also be multiple sales on a purchase. I will need to capture any available balance for products. Below is the table structure I have so far. There are many other tables like Supplier, Customer and Traders, but for simplicity sake I will not add them. tblPurchaseOrder PurchaseId - pk PONumber OrderDate tblCommodity CommodityId - pk CommodityName CommodityPrice AvailableBalance tblTransaction TransactionId ContractNo CommodityId - fk from tblCommodity PurchaseId - fk from tblPurchaseOrder UnitPrice QntyPurchased QntySold

Converting Old Access Database In VB 6 : Is It Possible ? www.vbcity.com

Hi,I'm upgrading an old VB3 project in VB6, but i've got someproblem with the database.In the old project, the mdb version are 1.1 and we useAccess 1.10 to design the tableNow, in VB6, I want to upgrade the database in version 3.0(I think it's the higher possible version with vb6)So I use the CompactDatabase xx_1.1.mdb , xx_3.0.mdb ,,dbVersion30After, the mdb are correctly in version 3.0, but I can't open itwith Access 1.0. (it's normal)So I use Access 95 (which handle the Jet 3.0) and it told methat the database are corrupted because I use the CompactDatabaseMethod, instead of the Access Tool Convert.My problem is :1- I must convert the database with VB6 (because my customers don'town access).2- I want to use a version of Access to design the database Table,without having to 'Convert' again when I open it in Access...Is there a solution ?Thanx for your answers.Edited by - Travis on 6/27/2002 3:19:21 AM

Access 2000 Project To Visual Basic www.xtremevbtalk.com

I began a project in Access 2000 and I would now like to complete the project using Visual Basic 6. I am aware of connecting to the Access database through the (DatabaseName) property of VB6. My question is, how can I import or convert my Access 2000 forms, modules, querries etc. into the VB6 project.Thanks email

Field Show And Hide In Form: With Ref To Related Fields In Other Table www.access-programmers.co.uk

Hi all i am working on a hospital inventory system, can any one help me with my problem--ie i have made: 1. Transaction table: Fields include both sale and purchase field 2. Transaction Type: include Sale,Purchase and sale purchse return 3. table 2. is look up table in table 1 4. Is there any way in which i can display related fields in form eg if i use drop down in transaction table ie sale it will show me bill details and if i use purchsase it will hide bill details and show related fields

Question About Speed And Efficiency www.xtremevbtalk.com

Is it better for speed and efficiency to have all your tables in one Access database? Or should your put only closely related tables in the same database. For example, you are tracking what customer information along with what they purchase... Should customer tables and inventory tables reside in the same database?Thanks for any experienced insight.

Changing Data (Y1, X) Axis In A Chart At Runtime www.vbcity.com

Hello friends,I am using CR 9, VB6 and Microsoft Access database.I want to know how can I change the data (Y, X) axisin a chart at runtime by VB6 coding. for examplethe X axis shows the name of Project (PI_Name) that is a column in Project Table of my database, butI want to change it to show the project state (PI_State)that is another column in project table.Would you please help me to find a solution.Thanks,--Bita

Access Form Opened With VB www.xtremevbtalk.com

HI, Here is the situation...I created an inventory database using only ms access. I am now creating a quote tracking system that is written in VB with an access backend. My problem is that I need to open a form in my inventory access database using visual basic code. I want to have a search button in my new program that will enter values into an access form and then activate a button on the form. Is this possible??? I hope.Thanks.Brandon

Calling Another Project www.xtremevbtalk.com

Hi all,I have two projects.Inventory.vbpAsset.VbpFrom the inventory vbp, I want to call the MDIFORM of asset vbpCan u please tell me how to do that/Seelan

Connection String? www.xtremevbtalk.com

hi ,i am making a project in Vb6 and crystal report 8.5 with Access as Database.i have used this connection string to connect to Access Database from VB6. Code:Dim strPath As StringstrPath = App.PathIf Right(strPath, 1) <> "" Then strPath = strPath & "" Con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath & "TelephoneDir.mdb;" Con.Openi am facing problem in connecting crystal 8.5 to Access database.i am using crystal report control to view report.so what connection string i should write in "crystal report control" ".Connect" properties to successfully connect my Database.thanks

Get The Table Names Of An Access Database With VB6 www.xtremevbtalk.com

How to get the table names of an Access Database with VB6?Hi,I'm working on an automation project with a VB6 program and a MS Access database. The database can contain more than one table. The tables have to filled with data obtained with a VB6 program.Is there a way to get the table names of an Access Database with a VB6 application? That is, run a routine in the VB6 program which gives you the table names?It's no problem tot connect to an Access Database and to a table and to write to / read from the table, if you already know the name of that table. Code:'parts of the code:Dim MyDatabase As ADODB.ConnectionDim MyDatabaseTable As ADODB.RecordsetSet MyDatabase = New ADODB.ConnectionMyDatabase.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & "Data Source=" & MyDatabaseName$ & ";" Set ADatabaseTable = New ADODB.RecordsetADatabaseTable.fields(1) = "some text"'etcThis works fine.But when there are more tables in the database, how to get the names of the tables from within VB6? So I can choose the table from within VB6.Thanks in advance.

Sensitivity Analysis Returning A Multiple On Percentage Data www.ozgrid.com

I want to set up an automatic sensitivity analysis such as the one shown in example.doc attached, using my model that is attached (inventory model. zip). Going horizontally in the sensitivity analysis, I want to show 2H (3Q and 4Q) Sales Growth (30%, 35, 40,45,50,55,60%) and vertically I want to show 2Q Inventory Growth (50%, 55%, 60%, 65%, 70%, 75%, 80%) and I want the inside data to return sales/inventory spread ( multiple). Basically it would divide the dollar growth in sales in 2H by the dollar growth in inventory and return a multiple. Is it possible to set this up automatically using the data that I have here?

How To Summarize A Weekly And Monthly Sales Report? www.xtremevbtalk.com

help...help...help ellow to all kind-hearted vb gurus out there...could you pls give me some code snippet on how to summarize a weekly and monthly sales/inventory reports... im currently using an access database....and im not so familiar about building it on sql statements... pls reply soon... or im dead...!thanks guys....!

Read Data From MS Access Into MySQL In Real-time forums.devshed.com

I am currently working on a project that involves reading information from a inventory system into Access via ODBC and display the info on the web site using MySQL. I would like to create a live link between the MS Access(local) and MySQL (remote) whenever the inventory system is updated MySQL will be updated as well. I know that MyODBC will let me do the opposite of what I would like to accomplish by reading data in MySQL into Access. Is it possible to do the reverse way.

Date Re-Formatting www.vbcity.com

Sirs,I'm using Access2000 & VB6 in my Project.One of my Table has the following entriesTr_Date        Narration        Credit    Debit01/01/2006    To Purchase A    0    1250005/01/2006    To Purchase B    0    50006/01/2006    To Purchase C    0    2500010/01/2006    To Purchase D    0    1100002/02/2006    To Purchase E    0    50005/02/2006    To Purchase F    0    210what my Result should be is ?Tr_Date    Narration        Credit    Debit  2006Jan 01     To Purchase A    0    12500    05     To Purchase B    0    500    06    To Purchase C    0    25000    10    To Purchase D    0    11000Feb 02    To Purchase E    0    500    05    To Purchase F    0    210Is it possible in VB Coding ?Hope somebody will help to come out of this problem.regardsRajesh N        

Vb AND Acces FAQS www.eggheadcafe.com

which are the websites were we get vb6 and access database faqsand also some sites were we can write online exams for vb6 and access database for different companies

Lookup Value Based On Two Criteria www.ozgrid.com

I have two pivot tables (for sales and purchases) with three columns each, ie: company 1, company 2 and amount I need to reconcile that for the internal purchases and sales the sale value is the same as the purchase. So in first pivot table (purchases) I have one row with internal transactions where company 1 = AZS, company 2 =YDR, value 100 In second pivot table (sales) I have one row with internal transactions company 1= YDR, company 2 = AZS, value 95 I would like to develop a macro that would check automatically the combinations of companies and find out if there are differences between sales and purchase. So in the example it should show that there is 5 usd more in purchases. Hopefully normally is zero

Sony :: Post-Purchase Extended Warranty forum.notebookreview.com

Just received a Z610y as a college graduation gift, but it was not purchased with an extended warranty. I'm accident-prone, and am interested in a 3 year extended warranty with ADH. I talked to someone at Sony Style who said I could purchase the warranty up to 30 days from the date of sale. I noticed newegg.com has one for sale, but when I talked to an associate there, they said it was only for sale with the purchase of a new laptop.

Inventory www.xtremevbtalk.com

My project require me to do a inventory:Should I use simple file access or database?If database, do I have to define any fields on the database first?Or just I create the file as a database format? Another question, how can I determine the user tabbed from one txt box to another?Thanks!

Help With Some VB/Internet Issues www.vbcity.com

Hello.  I dont know if this is even possible using vb6 or if i need to merge to .net, but basically this is my question/problem.I've developed a database driven application using vb6 and microsoft access 97. When i first started coding it, it was meant to be a multiple user app, running off a small network. All meant to be an in house application. Now near completion of the project, im told that the application now has to "interact" with a website. Interact how you may ask... here's how. Imagine a database storing information for individual sales reps, all "leads" submitted by each individual sales rep, as well as leads that have been approved, declined etc. The application shows all this information to the user, who ISNT the sales rep. What i need now, is to have particular information from the database, sent to and made visible on a website. the purpose of the website is so the individual sales reps can log into the website and view all THEIR current information with us... meaning sales rep 1 can logon and view all leads he's submitted to us as well as some other choice information, and sales rep 2 can logon and see his leads submitted etc. Im aware that vb6 can connect to a website and download information such as patches and updates... but im not aware of any way a vb6 app can connect to a website and upload the information to be viewed on the web. Any help would be greatly appreciated. code snippets, links to tutorials or anything else would be very helpful. Thanks in advance.-Ryan

How To Peroform Backup An Restore Of Certain Tables From A Database www.vbcity.com

Hi All...   How can i perform the backup and restore operation on certain tables of a database with the help of VB6.0. I am using Access(Xp) and VB6. For example I have a database called Master and under this database i have tables like Employee, Sales, Purchase, Transaction, etc. Now i want to back up and restore the Transaction table from the master database. I did the back up and restore of database with the help of vbcity.com. Now i want to do it on tables. Can you help me please.......(choice of the table is based on user input)byeHanas

Publication (inventory Project) www.eggheadcafe.com

publication (inventory project) ...?

Create A Program That Asks For Input Then Uses An Else Statement To Create A Handling Fee Balance www.vbforums.com

To create a program that asks for input then uses an else statement to create a handling fee balance. Input: sales record - first name, last name, purchase amount, balance before purchase Output: report - full name, old balance, purchase amount, handling fee, new balance Definitions: handling fee is 5% of the old balance if the old balance is less than $1000.00 else it is 2% new balance = old balance + purchase + handling fee Processing: Ask for and receive sales information Calculate new balance Print output report End the program when a purchase amount of 9999.99 is entered

Best Process For Data Load social.msdn.microsoft.com

Hello I am looking for some advise. I have a process to import flat text files.��We are importing data from five vendors.�These files are seperated by vendor with each vendor having their own directory.� The general�file layouts are different for each vendor.� Each vendor may have up to five different types of files to be imported that are�their one directory (sales, inventory, transactions etc).� Sales file�for Vendor 1 is different layout �than sales file�for Vendor 2. Each vendor may have multiple instances of each type (store 1 inventory, store 2 inventory, store 1 sales, store 2 sales etc.)� There could be up to�five hundred files (of the five different types)�in a given�vendors�directory. I am using an import package.� This package has five (.dtsx files) different data flows.� Each of these data flows�has connection managers that connect �to the�specific types of files (sales, inventory, transactions etc) for that vendor.� � My current play is�to have the data flow(.dtsx file) parse the store name (from the file name) for each of the file types.� It would load/process each of the available file formats (sales, inventory, transactions etc)�for that store in that vendor folder.� We want the process to load all data files�from a given store.� It would then move on to the next available�store (same vendor).� I would like to set the process to run multithreaded so that I am loading as many of the stores for that vendor as possible (there could be over a hundred stores for each vendor) at the same time. How do I�get�each dataflow�to run multiple instances (Instance1 for vendor(x).dtsx, instance2 for vendor(x).dtsx etc)�for maximum Vendor(x) input. What is the best way/process/design to track each store name so that�each process (instance1, instance2 etc)�is loading a distinct store.�The files will be moved to a history folder as they are processed.� �Should I have a different process that�gets each store name initially�and then�saves that information to a SQL table.��The dataflow would�load the next available store name from the SQL table query and let SQL lock that store? � Any suggestions are welcome and appreciated! � � �

RESOLVED: VB Form Wizard Only Compatible With Access 97 Version? www.vbcity.com

I am trying to use the VB Form Wizard to create a form bound to an Access database named Inventory of which you may find zipped up in the General VB question area posted under the same name (NMP)...How come I can't use the Wizard? It keeps saying that my Inventory.mdb is an unrecognizable format...is it because it's Access 2002? It seems to work fine for databases I've downloaded as examples that are in Access 97. Is this the problem...or did they do something to their databases that I have not done prior to trying to bind them to a VB form in VB6?Edited by - NMP on 3/7/2004 6:57:43 PM

Unrecognized Data Format. (MS Access XP/2000) www.xtremevbtalk.com

I have developed a complete inventory application using MS Access XP Database. Everything is running well, but when I try to backup and restore my data base it show the Unrecognized Database format.Here is the backup and restore code.Private Sub backup_Click()cdi.ShowSave 'cdi is commandialogconn.CloseCompactDatabase (App.Path & "/Database/Inventory.mdb"), (cdi.FileName & ".mdb")Set conn = New ADODB.ConnectionDim AppPath As StringDim database As StringAppPath = App.PathAppPath = AppPath & "DatabaseInventory.mdb"conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & AppPathEnd Sub

Copy Range Based On Certain Conditions www.ozgrid.com

I have this macro to copy a range to another worksheet: Sub transpose_UPCID() ' Hace el copy y paste transposed en BAUCS de los numeros de UPC"s y ' las cajas ATR Dim rng1 As Range Dim rng2 As Range Set rng1 = Sheets("Sales-Inventory").Range("UPC", Range("MK_ID").End(xlDown)) Set rng2 = Sheets("Sales-Inventory").Range("Figure", Range("Figure").End(xlDown)) rng1.Copy Sheets("BAUCS").Range("C11").PasteSpecial Paste:=xlValues, _ Operation:=xlNone, SkipBlanks:=False _ , Transpose:=True rng2.Copy Sheets("BAUCS").Range("C37").PasteSpecial Paste:=xlValues, _ Operation:=xlNone, SkipBlanks:=False _ , Transpose:=True Application.CutCopyMode = True End Sub The only problem is that this code copies all the items and I need this code to look into Column A in the Sales-Inventory worksheet. There I have a data validation with a total of six options. I also have six differents worksheets where I need to copy the values based on that data validation. To give you and example, all items containing XX in column A copy to XX worksheet. Something like that.

Need Help In Creating Accounts Database For My Financial System www.xtremevbtalk.com

Hi FriendsI'm developing a Financial Accounting System in VB 6.0 using MS Access 2002 as Database. So far I have developed Purchases, Sales and Inventory modules. Now I'm working on Accounts part. Can somebody help me in designing the database for GL Accounts? I have designed a rough Database structure but since m new to Accounts so need some help from an expert. I would be glad if someone could help me RegardsZeeP.S. I m in urgent need pals ... hope to see yr reply in this regard soon

Use Access Database And Visual Studio .Net? forums.codeguru.com

i am working on a project and i want your help for something. I use access database and visual studio vb.Net. In one of my forms i want to get records in a datagridview , between two dates . For example , i have the table Sales and i want to see all my sales between the two dates. [Code]...

Need Your VB Expertise.. :) www.codeguru.com

Good day to all, i have an upcoming project.. it is a network application using VB6 and SQL server for database for 25-30 Stations(Computers).. It's my first time to develop a large client.. to be specific it is a Sales & Inventory System.. I just want your sudgestions what would be best programming structure for this project.. specially this system will run 24/7.. if you can give me some sample codes etc.. specially for the 'connections','locktype','cursorlocation','cursortype' etc.. hince it is a client server application it would be a great help for me.. thank you very much..

Help On Creating A Simple Databse www.xtremevbtalk.com

Ok,, my prof gave me a task which is very advance for me., I'm not even good at manipulating databases.,He told me to do this.,., Specs of the System:5.a.Inventoryi.Date Enteredii.Batch No.iii.Quantity (bottles)iv.Totalb.Salesi.Customer Nameii.Customer Addressiii.PO No. (not a required field)iv.Delivery Datev.Delivery No.vi.Quantity (bottles)vii.Price/bottleviii.Price/box (12 bottles/box)ix.Total Sales per Delivery No. in bottles and in box (quantity x price/bottle)x.Remarks6.Menu - Inventorya.Inventory Update (encode info on item 5.a.i to v5.a.iv) - edit, change or delete any line itemb.Inventory Report (per given period: from (mm/dd/yyyy to mm/dd/yyyy)i.Display report - all items indicated aboveii.Print report - all items indicated above7.Menu - Salesa.Sales Update (encode item 5.b.i to 5.b.ix) - edit, change or delete any item. Delivery No. should be systemgenerated. Starting from D-0001. Can enter at any Delivery No.b.Sales report (per given period: from (mm/dd/yyyy to mm/dd/yyyy)i.Display report - all items indicated aboveii.Print report - all items indicated aboveAnd sent this file to me.,., Any help.,. at section 7.b? Can anyone help me code the date range?Thanx.,.,

Inventory Tracking Application www.codeguru.com

hello.is anybody aware of any open source inventory tracking application? or any similar application for sale that comes with the source? prefferablly written in vb6. thanks

Using Multiple Filter For Pivot Table ozgrid.com

I have a huge excel file. This file contains Projects, Project Manager, departments and sales for different quarters. Each department has sales and the quarter the sale was done. Now I want to create a pivot table where I can see the sales for each quarter for each project or each project manager. Attached file may elaborate the problem. ShaA1.xlsx

How Do I Display Progress Whilst Opening A Record Set With SQL www.vbcity.com

I am using ADO to access a Pervasive Database.There are tens of thousands of records and the RSP.Open statement (see code below)takes several minutes to execute.How can I display to users that the program is executing and not hanging ?ThanksJeffCode:Dim CnP As New ADODB.ConnectionDim RSP As New ADODB.RecordsetCnP.Open "Provider=PervasiveOLEDB;Data Source=AUSDEMO"RSP.Open "Select HistoryLines.DocumentType, HistoryLines.DocumentNumber, " _    + "HistoryLines.ProductCode, HistoryLines.CustomerCode, " _    + "HistoryLines.SalesmanCode, HistoryLines.Date, " _    + "HistoryLines.Qty, HistoryLines.UnitPrice, " _    + "HistoryHeader.DeliveryAddress05 " _    + " from HistoryLines, HistoryHeader,Inventory " _    + " Where (HistoryLines.DocumentType = 3 Or HistoryLines.DocumentType = 4) " _    + " And (HistoryLines.Qty <> 0 And HistoryLines.UnitPrice <> 0 )" _    + " And (HistoryLines.DocumentNumber= HistoryHeader.DocumentNumber )" _    + " And (HistoryLines.ProductCode= Inventory.Code )" _    + " And Inventory.UserDefNum3>0" _    + " Order By HistoryLines.DocumentNumber " _      , CnP, , , adCmdText

The Top Sales Person? social.msdn.microsoft.com

I am quite newbie, really grateful for some help how to create a sql sentence in� Reporting� Services that� would� return the� best sales person from each shop.. The following returns all the sales persons from� each shop So how to select the top sales person from each shop? SELECT TOP (10) shop.name, SUM(Cd.Price) AS Sales, Personal.Name AS Salesperson FROM Purchase INNER JOIN Personal ON Purchase.Salesperson_id = Personal.Personal_id RIGHT OUTER JOIN shop ON Personal.work_id = shop.shop_id FULL OUTER JOIN Cd ON Purchase.Cd_id = Cd.Cd_id GROUP BY Shop.Name, Personal.Name ORDER BY Sales DESC Or something like this? But how in Rep.Services??? ...LEFT OUTER JOIN ( SELECT P.work_id, P.Name, SUM(C.Price) AS TotalSale FROM @Personal P INNER JOIN @Purchase B ON B.Salesperson_id = P.Personal_id INNER JOIN @Cd C ON C.Cd_id = B.Cd_id GROUP BY P.Work_id, P.Name ) D ON D.Work_id = S.Shop_id

Validating Existence In Access 2003 www.vbcity.com

This might sound kind of simple, but I'm totaly stuck.I'm using a form to modify some tables in Access 2003. it's an inventory, i want the form i use to declare what i'm selling to check for the article in the inventory table, that way i'm not selling anything that's not in my inventory. But i can't get Access to verify if such an article exists in the Inventory table. how do i do this? By any means, VB editor or Validation rules.

Calculations On A Price Range phpbuilder.com

I run an ecommerce store and I am setting up data files that store order data for my accounting program - I download and import the data (txt files) daily. I have a sales (invoices) file creation script, I have a customer file creation script - Now I want to create a purchases script. To do this I am modifying the sales script as most of the data can be the same. I am stuck however on calculating the purchase price from the sale price for insertion into the text file. Code:

Project Error! www.xtremevbtalk.com

I loaded a project to another computer so I could work on it from home. I get this message, "Can't find project or library".I have the same version of VB which is vb6 on both computers and I'm working with a non EXE. When I run the program I can log on and select stuff, but when I try to access the database I get that error message. I'm ussing an Access database. Any help much appreiciated.

Can I Incorperate My Vb Project Into Access As A Module www.vbcity.com

HelloI am working on a database in acces and i have created a project in vb6 to calculate the cost of things in my database. Ive tried creating a module in access but im not sure if it is possible to have forms as in VB. How can i use my project from access if its possible.Any help would be greatthanks

VB6/Access To VB6/MySql www.vbforums.com

Hi AllI have a VB6 Project with Microsoft Access as database. Is there a simple and easy way to modify the Project to access a MySql database? Many thanks for your help.RgdsKim

Formula In A Field www.access-programmers.co.uk

I've got a table set up with sales info and all other kinds of data. How do I get a formula to work? Here are the inputs I have: Total sales (by outside company), total purchases (from my company). I want to know what percent of their total sales are made up of the poducts they purchase from me and have that field update automatically. Its a simple formula really, I just don't know how to enter it properly. Thanks.

.net - Make Crystal Report Of Profit And Loss Statement? stackoverflow.com

i want to make crystal report of profit and loss statement i have a column of "vr_type" and there are 4 types in it "sale invoice", purchase invoice" now i want that put a 4 formula s where i select that "sum (vr_detail.debit) where vr_detail.vr_type} sale invoice it make Sum of al these types so kindly tell me what formula i should use to get the result in simply i want sum of sale,sum of purchase,sum of expense?

How To Dispose Event Handler social.msdn.microsoft.com

I have a chart Component that was rendering based on my menu selection(say Sales data, Purchase data), I have two different class to render this, In main form i have a chart control(which was referenced by my appropriate class), When I choose "sales" both sales and purchase chart rendering event handler called, how to solve this?

Connect To A Database On The Web www.vbcity.com

Hi All,I have a Sales Manager who uses this system (VB6 and Access) that I've developed (which runs on a network, Database is on a server and VB6 connects to it). This Sales Manager travels alot, he wants to be able to use this system when he is in a hotel room away from the office, we don't have vpn or anything. so what I was thinking was to have a synchronized database on the web, and on the LOGIN screen of the system it would ask if he is traveling or in office and would connect to the appropriate database. I use DAO 3.6I've tried to give the address of the database which is on the web in my connection string but that doesn't work.I would appreciate all the help.ThanxKinara

SQL Express 2005 With Advance Service License Question social.msdn.microsoft.com

Currently, i am planning to develop a small system for my client�by using SQL database. However, i am not sure is it legal to use SQL Express 2005 in this project? I mean setup the SQL Express 2005 in their server then my application will access this database. Is it legal? or Do i need to purchase any license in order�to do that? or I need to purchase a SQL Server 2005 Standard or Enterprise version?

Connecting Access 2003 With VB 6 www.vbforums.com

Hello Experts,I am currently doing a project in VB6 and Access 2003 using "Data Control". In the "connect" property of data control I don't have an option for "Access 2003". I received error messages. I tried several ways and finally I found a solution of converting Access 2003 database into Access 97/Access 2000 format. However if I run it, I am unable to retrieve the datas from my database.Can you please help me out with your ideas/solutions for this problem?Many ThanksEshu

SQL Process Design Connect To Multiple DBs? stackoverflow.com

Web server running an ASP.NET site that's connected to a sql server instance for all the web related DB needs (products, pricing, users, etc.)... The companies accounting, inventory control(FIFO, etc.) and whatnot are mainly done on another system which uses a different SQL server...much more complex, for obvious reasons. What I Need What I need is to retrieve the current quantity on hand for every product that's on the web by connecting to the internal accounting sql server, even though the website uses a different sql server for it's own requirements. The reason I can't have the information that is required to calculate the quantity on hand for every product on the web to be on the same sql server is because there are way too many tables that are needed to calculated that information...what's on purchase order, what's on sales order, and the physical inventory. What is the best way to accomplish this without altering either database?

Update Database Record www.codeguru.com

Everthing has ben settled, VB6 can interact with the inventory database by Access 97. One of the table is Employee. What code shall i write in order to perform Add, Delete, Edit, Update, or Discard? Please teach me or let me know if there is any website teaching so.

Database Relationship www.vbforums.com

Hi, I have a problem with my database relationship.. I have the item(Table/Query) and purchase(Related Table/Query) which i use in my vb project.========================================ITEMPURCHASE========================================ItemCodePurchaseNoItemClassificationItemCodeItemDescriptionItemClassificationItemDescriptionUnitPriceQuantity========================================In relationship, I check all of these 3 checkboxes..[ / ] Enforce Referential Integrity[ / ] Cascade Update Related Fields[ / ] Cascade Delete Related RecordsEverytime I delete one item, all purchase(s) related to the item also deleted. My when problem is in the update, when I edit/update the ItemCode, ItemClassification and ItemDescription, the only field change in [purchase] table is the ItemCode! All I want to happen is when edit/update ItemCode, ItemClassification and ItemDescription in the [item] table, also the ItemCode, ItemClassification and ItemDescription in [purchase] table also changed or updated..I only use MS Access as my backend database, that's why i think the problem is in the ACCESS too.. Kindly help me what's the best thing to do to solve this problem?? ''please download the project that im doing so that you will easily understand my post! thanks in advance:http://www.geocities.com/martialdc/inv.zip

Question About Pulling Price From Multiple Tables. forums.asp.net

Pricing is a little confusing at my work.  My works database from the point of sale has multiple places for price to be.  Right now the tables in question are in a SQL database.  I am trying to create a user defined function so I can get a list of prices for specific items and for the customer logged into the web page.  The tables look like this: Inventory: ItemID, ItemCompany, Description, ListPrice, PublicPrice ContractID: ContractNum, ItemID, ItemCompany, MinQty, ContractPrice Customer: CustomerNumber, CustomerDepartment, Contract1 – Contract4 ContractNum ‘99’ is a global contract to all customers.  I was able to get the price for this generic contract price, but not for contracts customer may have. Here is what I have so far (with an example item already being pulled up).  I am at a loss on how to get the customers contract price with the same function.  SELECT Inventory.ItemNumber, Inventory.Company, Inventory.Description, Contracts.Quantity AS MinContractQty, COALESCE (Contracts.ContractPrice, Inventory.WhlCatalogPrice) AS Price, Inventory.WhlCatalogPrice AS ListPrice FROM Inventory LEFT OUTER JOIN Contracts ON Inventory.ItemNumber = Contracts.ItemNumber AND Inventory.Company = Contracts.Company AND '99' = Contracts.ContractNumber WHERE (Inventory.ItemNumber = N'444') AND (Inventory.Company = N'035') 

Create A Code For 4 Items And The Print Receipt? www.dreamincode.net

Create a script that allows the use to buy 4 items and then prints out a receipt. It should check an external file that keeps track of inventory. It should update the inventory with the purchase. I know how to create a the php code for 4 items and the print receipt. But how do i check an external file that keeps track of my inventory without mysql?

Trying To Do Calculations www.codeguru.com

Hey again,I am sorry but I am still learning alot about this language (VB6) I am trying to take the amount from one text field before it's saved and add it to the amount of another text field before it's saved and place that calculation in my access database record for the second field after it's saved. What I am doing is trying to create updates to inventory onhand every time I save. I have never done any calculations. Any suggestions?ThanksKim

Add Multiple Values Selected By Date Range From Access Database? social.msdn.microsoft.com

Access database: Inventory Column 1: Pprice Column 2: Date Now what I want to do is on a button click, I want to search the database for a date range, lets say September/01/2010 thru September/30/2010. Then I want to pull all of the Pprice values and add them together to come up with an inventory parts cost for the month.

Database :: Adobe Flex With Accessing Database For Mobile Web? stackoverflow.com

Here is the issue: a client wants his entire equipment inventory accessible by persons navigating to his jquery mobile site. The inventory that exists on the desktop site was, as I understood, built with Flex. Is it possible to access this database for the jquery mobile site? I believe it is. I was then given this information from someone in the know: Database: mlxx.db.xxxxxxx.hostedresource.com login: mxxx [code]...

Help! Calculation www.vbforums.com

Scenario: Boggs Inc: wants an application that will allow the user to enter the inventory number, quantity, and price of each item in inventory. Then application should allow the user to record this information in a sequential access file. In addition, the application should allow the user to print a report showing the inventory number, quantity, and price of each inventory item as well as the Average price: Inventory# | Quantity | Item Price_____________________________________________ABC12 | 100 | 10.50XYZ35 | 50 | 15.99KLK25 | 150 | 20.00I'm having a hard time figuring out the Average......Please help I'm very new to this.........Thanx in advance

Maths Behind Sliding Scale Pricing? stackoverflow.com

I'm trying to work out a simple calculation for the following a phone model has the maximum sale price of £85.00 and this is if only 1 unit is purchased and a minimum sales price of 50.00 - this is if 150 units and over are purchased in one. How can I work out a way of the price if between 2 and 149 units are purchased?

Connecting Access With VB In A Network www.codeguru.com

Hi.. i need help....Currently, i'm working on my thesis... I'm developing Sales and Inventory System... I use MS Access and VB6.0.... the system must run in a network environment....The scenario goes like this: I have to link two computers, the first computer holds the program or system and the other one holds the database. The problem is i'm a bit confuse on, how am i going to create the connection to the database? Should i use DSN Connection? Or Winsock? ... Is there any other way?I humbly ask your advice and suggestions!!!!!!!

Move Field Value From Table To Table www.access-programmers.co.uk

Howdy all! I am new to Access (only using 2 weeks) and have never taken a class. I am trying to update a DB for my company. []=Table {}=Field What needs to be done is as follows: When a new Purchase Order form is filled out each material ordered has a {ProductNumber} and has a {price}. The {ProductNumber} is the PK in the [Inventory], while this {price} is saved in the [OrderDetails] table (in the Price field) The table called [Inventory] stores info about the products (such a manufacturer, serial number, latest price). However, as it comes time to order new materials the prices have changed. That is, when a new PO form control {Price} is filled out, [OrderDetails]{Price}records the price and product number. I need the [Inventory]{Price} to update the LATEST {ProductNumber}'s price when a new purchase order is completed. Is this difficult?

Blank Field forums.aspfree.com

I am building a query for a report - I want to concatenate several fields, but if one of them is blank I don't want it added to the concatenation. Example: LastName= Kamp FirstName= Jay SpouseFirstName = "" It is ok if the SpouseFirstName is not null Kamp, Jay & Jill This is what I get when SpouseFirstName="": Kamp, Jay & What I want to see when SpouseFirstName="": Kamp, Jay SELECT Inventory.Code, Inventory.MLS, Inventory.Pin, Inventory.LockBox, Inventory.Vacant, concatenate Code: Original - concatenate Code [LastName] & ", " & [FirstName] & " & " & [SpouseFirstName] AS Expr1, [LastName] & ",  " & [FirstName] & " & " & [SpouseFirstName] AS Expr1, Inventory.CompanyName, Inventory.Phone, Inventory.Phone2, Inventory.Cell, Inventory.OfficePhone, Inventory.Ext, Inventory.Fax, Inventory.PropertyDesc, Inventory.Address, Inventory.City, Inventory.State, Inventory.Zip, Inventory.email, Inventory.SellerAddress, Inventory.SellerCity, Inventory.SellerState, Inventory.SellerZip, Inventory.TPUser, Inventory.TPPwd, Inventory.Expire, Inventory.ListPrice, Inventory.OriginalListPrice, Inventory.SoldPrice, Inventory.CloseDate, Inventory.Offer, Inventory.LastName FROM Inventory;

Lenovo U/S Series :: Extended Battery For S415? forums.lenovo.com

I was just wondering if there is a larger battery for sale for the S415 and, if so, where I can purchase it.  

Inventory & Work Order Design Model - Version: 2002 (10.0) XP www.utteraccess.com

I have read over Allen Brown's tips on Inventory value calc. Makes sense. Setting a very basic CMMS database I have tables set up for Purchase orders, and work orders (in addition to a number of others) so as I understand Allen Brown's model, I would set up a table to capture all of the Purchase order recipts and material issued to the work orders and then calculate an on hand value from these recipts/issues. Am I on the right track here. Also what is the recommend method to receive or issue material? AKA - I have a purchase order that I place today and the materials will not arrive for a week or 2 so I have an open PO - now the materials arrive and I want to "receive" the purchase order and have this inventory available for issue to the work order. thx, DB

Database With Multiple Tables, Help Please. www.vbcity.com

Hello again,I would like to get some ideas on how to create a database with many tables. I'll try to explain with an example.Use a Inventory type example, for each item in stock you'd have a table and a form to add/edit records to the table each day or whenever. However, you'd have a couple of hundred tables in the database. The tables must also link to each other by means of Sales or incoming stock. For instance, when you make a sale, the corresponding tables must be updated accordingly, as well as when you increase your stock.I was thinking of having the list of tables show in a listview or combobox, when an item is selected, it would be activated for adding/editing records , etc.I hope to get some ideas or a different approach to this.If anyone knows of an example project or any advice it's greatly appreciated, thanx!Cheers

Importing CSV File - Overwrite Certain Records If Present - Version: 97 (8.0) www.utteraccess.com

Greetings all! I am attempting to create a database to organize my eBay sales and thought the easiest way to do so would be to use a combination of eBay's download manager and some import macros. This will reduce the number of data entry errors and should also reduce the amount of time I have to spend entering data. Basically I have eBay generate a report (in CSV format) that lists all of my transactions and any pertinant information and then use the three different import specs I've created to import the file into my database. The reason for the three import specs (one macro though) is b/c of how eBay structures sales. If a person purchases multiple items eBay combines those purchases into one Sales Record . The information would look something like this: Ebay Sale Record - 4324 eBay Sale Customer - bsmith23 eBay Sale Customer Address - 1111 Somewhere eBay Sale Customer Email - bob@somewhere.com Ebay Item - 788399430, Sale Customer - bsmith23 Ebay Item - 793039020, Sale Customer - bsmith23 Unfortunately the CSV file creates one line for the sales record and one line for each eBay item, giving me three lines total for the sale record in question. To combat this I've created three different import specs (using the TransferText command in my macro) , each pulling the appropriate information (one to pull the Customer info, one to pull the Sales Record, and one to pull the individual Item Numbers). I've also created a separate macro to pull all of my PayPal transactions into the database as well. The problem is that if I run the macro a 2nd time it simply appends the information into the existing table, potentially duplicating quite a few entries. I've created a macro that can go through and delete any duplicate entries but would like to know if there's a way to import the data and create a new record if the item doesn't exist or overwrite the existing data if it does exist (for example, I might import a record prior to receiving payment. After the customer pays for the item I would like to overwrite the old record with the new record that aknowledges the payment). Can this be done? Am I going about this all wrong? Thanks in advance!

OLE Embeded Photo Not Viewable By Remote Users - Version: 2.0 (not 2000) www.utteraccess.com

I have an ACCESS 2.0 (not 2000) database accessed by both internal and external users. In addition, there is a second database where there are inventory parts photos stored. The main database has an attached table - the inventory photos table - from the second database. In-house users open an inventory parts search form in the main database. The form has as its recordsource an SQL statement which, in effect, is a query that uses both a main database table (inventory component) and the photos table from the second database (Inventory Photos) left-joined to form a complete recordsource for the form. The photo is displayed in a control field on the form. When in-house users open a record in the search form, they can see, along with information about the part, a photo of the part. However, users connected from outside the company cannot see the photo, even though the inventory record opens just fine. Outside users connect to the company database via a VPN tunnel connection to a Windows terminal server. The in-house terminal server runs the Access database. Any ideas why the photo cannot be view by outside users? Steve

Remote Server Connection. www.xtremevbtalk.com

Hi. I have this question and I don´t know if this is the right place to post it. Here it goes:First of all I pay my bills developing vertical systems of any kind most of them in vb6 and access with CRW.If have to develope a software for the lottery market which must be online. every point on sale must be connected real time with the server where will be located the database. The point of sale sofware must check some data on the server and then sale the selected lottery number and store it on the server. The point of sale can WIN95,98,xp, etc. If the connection fail the sale can not be performed.and now the question: What are the tools and/or controls and/or commands to have an online server via INTERNET, or by phone line? I hope the question is clear.

Html - Is There A Tool That Can Scan A Roject And Build A Sitemap stackoverflow.com

I'm looking for an automated way to inventory all the links within an asp.net project that I inherited.

Displaying Unique Records www.webmasterworld.com

I've got a database table named 'sales' where each sale has these fields:

How To Make Setup For VB6 With SQL Database www.xtremevbtalk.com

Dear All,I have completed a VB6 application n its working fine with SQL database..Now i want to deploy it on the customer machine using the VB6 installation setup.How can i deploy sql database along with the VB6 installation setup.As we can do it with MS access database , deploying vb6 installation setup along with ms access 2000, how we can do it the same using VB6and SQL database.can any one guide how i can deploy my application along with sql databasebest regardsLadoo