Logo

Advertisement

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

www.xtremevbtalk.com

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

Advertisement

Advertisement

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

Searching Datas From Database After Selecting Value From COMBO BOX www.daniweb.com

I'm doing INVENTORY project... i'm using ACCESS databse with vb.net... i'm having purchase, sales tables... THIS IS MY PURCHASE TABLE: CodePriceCategory TypeDat SPBrnd 11222cde bgf9/10/2025356asd 12255MEN Shirt5/10/2010355Vanhesun 55322bb bb9/10/2025456asd 66422bb bb9/10/2025556fdd when i select CODE in SALES form, corresponding values have to shown in respective fields... I.e if i select 55, corresponding values have to be retrieved and showed in respective fields...

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

Security Issue In Reports Hosting. social.msdn.microsoft.com

hi friends, I am a newbie to report hosting. My requirement is pretty simple, i have five folders on the server : sales, inventory, finance, service, purchase. i have five non administrator users: sales, inventory, finance, service, purchase. when someone logs in using "sales" user credentials, i want the user to see only "sales" folder. in the security tab of the sales folder, i have given "Browser" role to "sales" user but when i login using sales, i just see a blank page with just the links to the home page and help. what else should i have for the user account for sufficing my requirement? thanks a lot, Lakshman.

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

Advertisement

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.

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?

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.

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

Autoupdating Inventory Help www.access-programmers.co.uk

hiya! Im building an inventory database for my business, I am having trouble implanting an autoupdating stock level. This is how my database looks like: I have InStock within the Table - Products I create sales orders through a form and that is recorded within a Table - inventory transactions. On this form there is a box to select the type of products and also a number box to input the number of units the customer purchases I have created an update query with the following conditions Field InStock update to -[Products]![InStock]- Forms![Sales Orders Subform]![UnitsSold] Field ProductName criteria is - Forms![Sales Orders Subform]![ProductName] so in operation, i would select product A, enter the amount, that amount will then be automatically deducted from InStock for that particular product I am stomped about what code to add to my afterupdate field... and where to add the afterupdate field. any help will be appreciated!

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:

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?

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

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.

Sending Mails From 2005? www.daniweb.com

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

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

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

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.

Sql Statement To Select Month Part Of A Date? www.daniweb.com

designing an inventory system and i want to generate crystal reports from sql queries.Actually want to generate monthly and yearly reports from the daily sales reports i have populated

Make A "sales And Inventory System" With Added Technology? www.vbforums.com

im planning to make a "sales and inventory system" with added technology like (barcode/ swipe card <-- this 2 are common) ....

Quoting Database Table's Help www.access-programmers.co.uk

Hi, I am starting to design a Quoting database and would like some advice on how to set up my tables. I would like to record all quotes received with all relating sales, purchasing and despatch/invoice details included. I am thinking of having following tables � Am I on the right track ???? Customer Table - With all details relating to customer Customer ID Name Address Phone Contact Products Table � With all details for quoted products Product ID Part Nbr Description Price UOI Quote Table � With all details Specific to Quote Quote ID Customer ID Qty Sales Price Product ID Date Received Date Required Dated Quoted Purchase Table � With all Purchase details Purchase ID Purchase Order Supplier ID Date Ordered Date Received Sales Table � With all final sales / Invoice details Sales ID Product ID Customer Purchase Order Po Date Invoice date Invoice No Total Invoice Amount Paid Date Despatch Details Payment Terms Delivery Terms Please let me know if I am on right track or any advice you could give would be appreciated. Tks

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

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

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.

Creating A Switchboard (main Menu) www.access-programmers.co.uk

I have recently created a small inventory database just for fun, but I am looking to expand my knowledge with Access since I have not dealt with it hardly at all. I would like to know how to create a regular main menu to the database that gives you options on what you want to do. I would like to be able to look up inventory by serial number, edit inventory, add inventory, and run reports from the main menu. If anyone could help, I would greatly appreciate it.

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

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

Help Creating A View social.msdn.microsoft.com

Good morning everyone, I'm new here and new to the subject I'm asking for help on. I'm used to building reports in access and having the SQL expression builder there to get counts and stuff, but I've inherited a SQL 2000 SE server and an access frontend application that I need to generate some reports with. I need to generate a report that will pull info from 4 different tables, and display the results as totals. I need to be able to have the results format into groupings by Phase as well as inventory type. So for instance I would like to have results returned for District 1 and then by Available, Sold, etc then District 2, -> Available, Sold etc. If it helps this is one view I use to show all Available lots: SELECT TOP 100 PERCENT dbo.Inventory.Lot, dbo.Inventory.BlockID, dbo.Project.ProjectName, dbo.PhaseLotReport_V.RefCodeName, dbo.PhaseLotReport_V.RefCodeTypeID, dbo.PhaseLotReport_V.LastModDate, dbo.PhaseLotReport_V.InventoryDate FROM dbo.PhaseLotReport_V INNER JOIN dbo.Inventory ON dbo.PhaseLotReport_V.InventoryID = dbo.Inventory.InventoryID CROSS JOIN dbo.Project WHERE (dbo.PhaseLotReport_V.RefCodeName = 'Available') ORDER BY dbo.Project.ProjectName Thanks for helping a complete SQL noob...

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.

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 ?

Datebase Relationships? www.access-programmers.co.uk

Im having some trouble here. This isn't my very first database but I am creating a database for a customer that does blacksmith work He wants a customers database, projects he does, inventory he has and even a timesheet all together. He wants to be able to input all his customers, then as he works on projects he wants to have the projects linked to the customer that ordered it, he wants to have a timesheet database where he can track per project as well as inventory that he uses per project So I have the databases for each, but I cant figure out how to make a relationship so when you start a project, you can pick which customer the project is for, and even pick the inventory you have that you will use for that project and have it where later you can go to each customer and see which projects that customer had and then go into inventory and see that stuff isn't there anymore because he picked it and used it for certain projects. Is there any easy way that I can do all this? I got access 2007 and lynda.com access 2003 video training that I am going through. And relationships is where I got stuck. Anyone? Thank you very much in advance! Im willing to trade services for help from someone. My portfolio : http://portfolio.337studios.com

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.

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

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

VS 2005 ArgumentOutofRangeException Error www.vbforums.com

I was using vb6 for ADODB program with MS Access as database file. It was running fine with vb6.Later I upgraded the project to VB 2005 express edition. When I try to run the project, It load listview, retrieving data from Access file (MDB). It shows the error ArgumentOutOfRangeException error.This was my vb6 sql code to LoadListView. Set objNewListItem = lvwCustomer.ListItems.Add(, , txtFirst.Text, , "Custs") PopulateListItem objNewListItem With objNewListItem [code].....

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

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

Joining Problem www.sqlteam.com

hi i have 3 table. branches,sales,purchase i have to get the sum(sales),sum(purchse) for each branch. this is my query. but i am not getting the proper result. i think its the problem with join. please help me out select bm.branch_name,sum(am.total) sales,sum(pm.total)purchase from branch bm,sales am,purchases pm where bm.branch_code=am.branch_code and bm.branch_code=pm.branch_code group by bm.branch_name thanks suji

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

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.

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?

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        

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

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!

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

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

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.

Date Functions www.sqlteam.com

i have tables customer id name address city items itemid code itname cost sales sid invno date cid amount (what are the sales done in date) purchases pid invno date cid amount (what are the purchases done in date) dsales dtsid sid code qty cost amount (detail of sales) dpurchase dtpid pid code qty cost amount (details of purchases) i want a query like customer itemname jan feb march - - - - - - - - - sai tv 1 2 0 nalini radio 0 2 1 ------------ sai krishna

Same Data, Different Criteria, One Report!? www.access-programmers.co.uk

I am trying to create a tax report for my business and am not very familiar with Access beyong making basic reports from a single table and query. Here's the problem: I want to report total costs for my unsold inventory purchased and worked on prior to 2005. From that I want to be able to subtract the total costs of sold inventory purchased and worked on prior to 2005. Yes, all in one report. Is this even possible? My report contains these columns from a single table- inventory #, purchase date, cost, sold or unsold (yes or no check box), 3 columns of additional costs and 3 columns of cost dates. Also a couple other confusing columns of costs that were split between myself and co-purchasers. These include a column of negative costs, the date paid, the balance paid to the co-purchaser, and the date of the balance paid. I have been sorting by purchase date prior to 2005 and unsold. The problem is I have no idea how to include the values of the sold inventory in with this report of all the unsold inventory costs without creating a massive report with all my inventory from which I can not sum the columns properly. The other problem is that when I sort by purchase date I get cost dates from after 2005. I can limit the criteria for one of the date columns, but not all. My questions are: How do I included both sold and unsold inventory information in a report and sort by inventory # without simply listing all the information together in one column by inventory #? Can I do the calcualtions I want to do in one report? How can I limit all of the date columns to show only before 2005? If I make each of the date columns with criteria AND >#12/31/2004#, they limit down to only a few records because many of the date fields in my database are empty. If I use the OR criteria it doesn't work. I actually have many other questions but I suppose those are the biggest ones. I know that this is a very specific topic, so if anyone has suggestions as to great resources for Access help (ie. books, tutorials, etc.) particularly with creating tax or inventory reports from a single table, that would be extremely helpful. Anything would be extremely helpful!! I'm sunk.

How To Display A Table For IEnumerable Property On A Microsoft Report stackoverflow.com

I've got a class with the following properties which I'd like to display on a Microsoft Report:[code]My objective is to create a report showing each transaction (Sales) that was made within a particular time span [say, within one week].I've so far been able to display the DateOfSale and TellerName on the report using TextBoxes.I'd like to display the Purchase for each sale as a Table and that is where I'm stumped.Does anyone know how I can display the Purchase property as a table on the report and sum the TotalCost of all the purchases made in a given Sales at the bottom of the table?

Data Modeling bytes.com

The following is a technical report on a data modeling project that was recently assigned to me by my professor. I post it so that anyone else who is studying databases and data modeling can have an example to go by with their study of databases. I was assinged to come up with a data model, but I choose the Autoparts sales and inventory management schema. It you would like the SQL code to generate the schema or if you would like the ERWin diagram of this model just email or reply to the post. I can post the SQL code by will have to email the ERWin file. I also have a SQL file to populate the schema with test data. I left out the Business rules for now. Any comments or question let me know. This model was targeted for Oracle 9i but with ERWin can generate schema for SQL server or any database. -- javatek?@usa.com remove the ? to reply. Final Technical Report ITEC 2160 Database Processing April 2004 AUTOPARTS SALES & INVENTORY MANAGEMENT SYSTEM Abstract / Introduction: The selling of automotive aftermarket replacement parts is both a retail enterprise selling to consumers and a wholesale operation selling parts to repair shops and other resellers. In consideration of the diverse customer base, this data model will be developed so that sales of auto parts either retail or wholesale can be recorded and tracked electronically. In addition, stock inventory levels will be monitored electronically with this model and an automated stock replenishment mechanism implemented. Due to time constraints this model will be a stripped down version only pertaining to the sales and inventory functions. The current design does allow for further development and the addition of other components. Since the heart of an auto parts store is in its inventory of parts we will begin with an explanation of how the inventory is managed. By the use of the MinQuantity field in the Inventory table the system will be able to indicate a low stock level once the quantity in stock is equal to or less than the minimum quantity specified by the MinQuantity attribute. At this point a View for Inventory can be generated to display inventory items whose quantity levels are below their specified minimum. This Reorder_View can be used by the system to generate purchase orders to vendors whose contact data and address are stored in the table named 'Vendor'. Just as the Inventory table contains all the attributes for any given part the Vendor tabled does the same for all vendors. To complete the description of the model that will be created we will now discuss the sales tracking process. Once a sale is made, a record of that sale is recorded in the Daily_Sales table. A transaction number to be associated with this sale will be generated then used as part of the identifier for this sale. The store number and part number are also part of this unique identifier. From this record a sales invoice/receipt can be created and printed. But for all purposes this process of generated a sales record then generating a receipt will appear to be simultaneous. At the end of each day the contents of the Daily_Sales table will be appended to the Sales_History table and Daily_Sales will be truncated. In support of the sales tracking and invoice generating process five other entities must be created, they are; 'Customer', 'Employee','Store', 'Pricing', and 'Transaction.' The Customer table will record the customer data, Employee contains store employee data, the store number and address attributes are recorded in Store , Pricing contains information on how to price retail and wholesale sales, and Transaction is used to record the Transaction number. There are two sequences created to provide for surrogate keys, they are: Trans and PO_Number. Trans is the sequence that is implemented to created the Transaction number for the Transaction entity and sequence PO_Number was created to provide a unique identifier for purchase orders. In Part 3 of this assignment we continue to refine the Data Model and confirm that referential integrity actions work as defined. As of this point the model has been implemented into Oracle 9i and data entered into tables. The functionality of triggers, views and other components are being tested. Entities/Description Inventory: Contains information on all items to be sold. Customer: Customer information both retail and wholesale buyers. Vendor: Suppliers of items in Inventory. Employee: Contains store employee information. Store: Store location and description. Invoice: Receipt given to customer for items purchased. Invoice_Line_Item: Individual items purchased per invoice. Reorder_View: A view of Inventory for rows where Quantity <= MinQuantity Purchase Order: Orders placed to vendor to replenish stock created from reorder records. PO_Line_Item: Individual items purchased per Purchase Order Pricing: Contains information for customer pricing and discount. Daily_Sales: Records information on daily sales transactions, truncated nightly. Sales_History: Maintains historic data on sales transactions to be appended nightly with Daily Sales activity. Transaction: Transaction number generated by a sequence to provide unique identifier for a Sale. Surrogate Keys: SEQUENCE Trans This sequence was created to provide for a unique identifier for the Transaction entity, which is then inserted into Daily_Sales as a Foreign Key, part of the composite unique identifier for Daily_Sales. SEQUENCE PO_Number This sequence is needed to provide for a unique identifier for the Purchase_Order entity. Constraints: 1) Customer Entity identifier is Cust_ID. 2) Customer Price Type can not be Null, exists in Pricing. 3) Daily_Sales Entity identifier is a composite of three identifiers, Transaction_No, Store_ID and Part_No. 4) Daily_Sales Customer ID entity can not be Null, exists in Customer 5) Employee Entity identifier is EmployeeID. 6) Inventory Entity identifier is Part_No. 7) Inventory VendorID entity can not be Null, exists in Vendor 8) Invoice Entity identifier is a composite of Store_No and Transaction_No. 9) Invoice_Line_Item Entity identifier is Item_No. 10) Invoice_Line_Item, Store Number and Transaction Number can not be Null. 11) Pricing Entity identifier is Price_Type. 12) Purchase_Order Entity identifier is PO_Number. 13) PO_Line_Item Entity identifier is Part_No. 14) PO_Line_Item PO_Number can not be Null. 15) Store Entity identifier is Store_ID. 16) Transaction Entity identifier is Transaction_No. 17) Vendor Entity identifier is VendorID. Check Constraints: Daily_Sales.IT CHAR(1) DEFAULT 'F' NOT NULL CHECK (IT IN ('T', 'F')) The Insert or update must be either 'T' or 'F' representing a logical True or False. Inventoy.OnOrder CHAR(1) DEFAULT 'F' NOT NULL CHECK (OnOrder IN ('T', 'F')) The Insert or update must be either 'T' or 'F' representing a logical True or False. Domains: Simple Domains: FirstName - Varchar, Average Width = 20, Not Null LastName -- Varchar, Average Width = 20, Not Null Street -- Varchar, Average Width = 20, Not Null City -- Varchar, Average Width = 20, Not Null State -- Varchar, Average Width = 2, Not Null Zip -- Varchar, Average Width = 9, Not Null UPDATE: On update to Vendor cascade to Inventory. On update to Pricing cascade to customer INSERTION: When inserting into Daily_Sales Tax cannot be Null. Cannot insert into Inventory if Vendor_ID does not exists in Vendor. DELETION: If delete to Invoice cascade to Invoice_Line_Items If delete to Purchase_Order cascade to PO_Line_Items. Retrieval And Reports: The following SQL statement will provide a list of customers by zip code to provide for a targeted mailing. Select FirstName,LastName,Address,City,State,Zip From Customer Order by Zip Desc; Another SQL statement to retrieve customer data for a targeted mailing for a specific postal code. Select FirstName,LastName,Address,City,State,Zip From Customer where Zip = 38119 Order by LastName; The following SQL statement will produce a vendor list with the specific items in inventory that the vendor supplies. Select A.Vendor_Name, A.VendorID,B.Part_No,B.Description, B.Quantity From Vendor A, Inventory B Where A.VendorID = B.VendorID; Another retrieval statement to provide a list of Inventory Items provided for a specific vendor. Select A.Vendor_Name, A.VendorID,B.Part_No,B.Description, B.Quantity From Vendor A, Inventory B Where A.VendorID = B.VendorID AND A.VendorID = 59120; Views: SQL code to create the view Reorder_View. It is by this view that allows for the creating of purchase orders by what ever application code that is created to process the rows of Reorder_View. This view only displays those rows in Inventory whose minimum quantity have fallen below the reorder threshold. CREATE OR REPLACE VIEW Reorder_View AS SELECT I.Part_No, I.Description, I.Quantity, I.MinQuantity, I.ReorderQuantity,I.Cost, I.VendorID, I.OnOrder FROM Inventory I WHERE MinQuantity >= Quantity and OnOrder = 'F'; Triggers: The following trigger code is an Insert trigger that fires before insert into Daily_Sales. Its function is to retrieve the next value from the Trans sequence and insert that value into the Transaction entity. This newly generated number is then used for the Transaction number for the row to be inserted into Daily_Sales. This trigger generates the new number if the new value for the field IT is 'T'. The 'T' indicating that this insert is a new transaction. If the new value for the IT filed is 'F', indicating that the new insert is not a new transaction, then the current value for the sequence is inserted for Transaction_No into Daily_Sales. create or replace trigger TI_DailycheckTrans BEFORE INSERT on Daily_Sales REFERENCING OLD AS old NEW AS new for each row begin If :new.IT = 'T' THEN insert into Transaction (Transaction_No) values (Trans.NextVal); SELECT TRANS.CURRVAL INTO :new.Transaction_no from Dual; else SELECT TRANS.CURRVAL INTO :new.Transaction_no from Dual; END IF; END; / -- javatek?@usa.com remove the ? to reply.

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

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

Publication (inventory Project) www.eggheadcafe.com

publication (inventory project) ...?

ActionScript 3.0 :: Get To Pictures Loaded Into The .swf? www.actionscript.org

This the the project in a nutshell. The website has inventory that has three pictures for each piece of inventory that's paths are stored in a SQL database. Now when a piece of inventory is clicked it goes to the page that the slideshow will be located. Here is where the 3 pictures will be playing in a loop. The problem is I don't know how I'm going to get to pictures loaded into the .swf. XML is out of the question because I have 143,000 pieces of inventory and I don't want to have that many XML files. Is there a way I can access the database directly and pull the paths from there?

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

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

One Form Field Serve Two Jobs? www.access-programmers.co.uk

Hello all, I have an Access database for a project I'm currently working on. It's a simple stock control system which records sales and the level of stock. How can I set up a form that when you click a button, two queries are run? I want to add a record to the 'Sales' table but also modify the 'Stock' table to edit the 'Current Stock' field. Any ideas? Thanks

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! � � �

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

I Just Dont Have A Clue Of How To Do It www.access-programmers.co.uk

Im trying to make a simple database in access , so far all is going well but im stuck with the inventory. I have "products" table with Id [autonum],name[text],price[money], provider[number], stock[number] Providers table with Id[autonum] ,name [Text],tel[number], Employes table with Id[autonum], name[text],tel [number] and i have Sales table with Id[autonum],date[date],employer[number],product[number],quantity[number],total price[money] I have relationships between table.provider and provider.name then sales.employer with employer.name and sales.product witht products.name. Now what i want to do is that every time that i make a sale it modify my stock number on the products table. I think the proper way is just to calculate stock every time i need it but i dont know how to do that either :D Ill upload my db but i have to tell you that is in spanish so if you haveany question im here to answer.Thanks a lot to all

Qimported A Database From Access In To Multipul Text Boxes? www.vbforums.com

I have imported a database from Access in to multipul text boxes in Visual Basic 2008. The information is on CD sales and the fields include ID,Tune name, Artist Name, Sales Quantity, and Year issued.i want to Query the database for 1) the tune with the greatest number of sales from a particular year. (year selected from a list box) 2) total sales in a particular year. (year selected form a list box) 3) display all tunes by a particular artist. (typed into a textbox)

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

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

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

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.

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

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

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?

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

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

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.

Monthly Report forums.aspfree.com

I am trying to create an inventory which list sales by month. I have created a crosstab query from the detail history table which works fine except I would like a record for each month whether there was sales or not. So on the report I would have all 12 months for each item with the months with no sales displaying zero. Any suggestions? Valerie

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.

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

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

Make Account Statment Report? www.daniweb.com

I m tryng to make report but its not working.i explain u to description of my project i have 5 tables in form Payment,Receivable,Expense,Sale,Purchase and now i want to make debit credit form and its work that when i give a party name the report show me its statment if the party is vendor show purchse from him and payment paid to him and if he is buyer so show him payment received and sale to him

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

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:

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.