Results 1 to 4 of 4

Thread: Tables Question

  1. Jul 3rd, 2000, 08:31 PM #1
    kokopeli
    kokopeli is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2000
    Posts
    118
    I am making an inventory program and I am confused. I have a database named Inventory.mdb. In that DB I have a table for the opening numbers, for the deliveries, sells,close and over/short. What I am doing right now is just using the open table. The inventory is done on a daily basis and I save the values in the txtClose boxes to the open table for the next record. My problem is I want to save all the numbers for each day in the appropriate tables. Right now I am not using a data control, I am doing it in code. Can I just copy the code I have for the open, but select from a different table, or should I use a bunch of data controls? I know this is a confusing question, but that is the best I can explain it.
    Kokopeli
    VB6 SP3
    Reply With Quote Reply With Quote
  2. Jul 3rd, 2000, 09:28 PM #2
    MartinLiss
    MartinLiss is offline
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431
    You're right your question is confusing, but if you have a program that already uses code to get data from a database, then by all means do not change it to use data controls.

    One part of your question that is not clear is when you say "My problem is I want to save all the numbers for each day in the appropriate tables". Are you writing to a different table every day? In any case, please describe (examples would help) in detail what it is you are trying to do and I'm sure I or someone else can help.
    Tips, Examples & Tutorials:
    A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners


    2009 - 2016
    Reply With Quote Reply With Quote
  3. Jul 3rd, 2000, 09:52 PM #3
    kokopeli
    kokopeli is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2000
    Posts
    118

    simple version, maybe

    I have 7 columns and 11 rows. The rows are for things like open, deliveries, book on hand, actual on hand. The columns are the different products. I have a different table for each row. That is part of the question too. Should it be one table with 77 fields or 11 tables with 7 fields like I have now. Right now I am wondering how to write to all 11 tables each day. I am working on it, and have two opening now, but it looks like it is going to be a mess. I am copying the SQL statement and changing the From statement, and of course I have to change other stuff too. Is there an easier way?
    Kokopeli
    VB6 SP3
    Reply With Quote Reply With Quote
  4. Jul 4th, 2000, 01:42 PM #4
    kokopeli
    kokopeli is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2000
    Posts
    118

    One table

    I have been messing with it, now I have no idea how to specify which table is being saved. If I do this in code it looks like I need one big table. Would seven data controls be better, one for each row.
    Kokopeli
    VB6 SP3
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width