Search results

  1. A

    Different Geographic Locations

    Hey thanks for the Answers, I appreciate it. Sounds hefty and impressive. The Text File and FTP was actually something I was thinking about for a solution for small business situations, as it's not really that expensive. Thanks again.
  2. A

    Different Geographic Locations

    Something that I've always wondered about are the ways to sync up locations outside of the home office. I assume in the retail industry a point of sale system is setup at each location with their own backend. At some point, (Daily, weekly, Monthly) those stores sync up with the home office...
  3. A

    Continuous Form Displays in stripes

    Thanks PBaldy, you were exactly right, alternative color was right there under the format options for the details section. Thanks a bunch.
  4. A

    Continuous Form Displays in stripes

    This is neat, I think anyway. I have a continuous form that displays the results with the background in stripes. I set the Detail section BG color to Yellow and when I display my results it alternates between yellow and white for each record. I'm using Acc 07 anyone have any clues ?
  5. A

    Beginning Design

    Thanks for your response Rabbie. I like that suggestion, with those 1 to 1's would Access be checking each specific table for a matching record when I run a query? And before I jump in and try to implement it I am curious if this would be a way of doing such: New table: TblItemType 1 Music 2...
  6. A

    Beginning Design

    I've started work on a project, it's aspiring to become a Point of Sale but for the time being I'm focused on making sure that the inventory side of it is taken care of. I think I've got this set up decently. I figured I don't see this too often but attached is a picture of the table...
  7. A

    Loop and DoEvents

    Since clearing out space and adding the DoEvents Ive seen a noticeable improvement, namely it ran all day and didn't freeze up or crash. It's actually doing what I want it to on a consistent basis.
  8. A

    Loop and DoEvents

    Greetings, I have an 07 package that I'm using to parse information, everything is uniform and comes from xml files. I've got 3 parts that I am using and looking for a little advice with the crashing I am having. The program loop is setup like such: Loop1 For ... | --Loop2 For ... |...
  9. A

    Urgent! One relationship change has made my database mess up!

    Just a quick look over, you have no records in your tables. I was hasty to tell you to make that join, I didn't review your structure to see what it was you were intending to do. I would rethink your table structure, I would link the failing or dropping ID to the student table not the other way...
  10. A

    Pls help me with this! UPDATE QUERY

    I really can't understand what you are trying to do. You're second cases true and false are identical, use the first case to do this. If IsNull(Field2) = true and isnull(field3) then case 2 else case 1 end if other than that I can't decipher you.
  11. A

    Urgent! One relationship change has made my database mess up!

    Open your blank form in design view, it says it's recordsource is query3. Open the recordsource in design view. Draw joins from your main table to those two new ones, set their join properties to All Records in the Student Table and those in the joined table that are equal (Middle radio button)...
  12. A

    SQL course on line

    I have been looking for something like this for a bit now, Thank you vm. Now then, C++ . . .
  13. A

    newbie want to get basics right

    There are many catchy ways to explain it, but I like demonstrations =). This is a small segment of information I have from a DB you might find useful in some way, it's from a retail system. TblItemMain lItemID lDepartmentID sItemShort sItemLong cItemPrice I use Hungarian notation in my...
  14. A

    Using "-" In Text Boxes for Queries

    Thx dk, yeah I figured it would take a lot of parsing and involve vb.
  15. A

    Using "-" In Text Boxes for Queries

    So when the user types in "Batman -Robin" in the text box how is that going to work?
  16. A

    Using "-" In Text Boxes for Queries

    Hello, I've scoured the forum and think I've found a way to do this but I figured I'd post first to make sure. What I've got a short form that basically provides the criteria for a query behind a report. The form allows a user to select sales records between dates from a single Vendor...
  17. A

    Converting Time from Seconds

    Thanks a bunch, I was using the Format but I had the "hh:mm:ss" wrong
  18. A

    Developing Environments

    George: They're both Core 2 Duo's for Cpu. I don't think this is an issue with INSTR() I'm getting two different sets of text when I use Document.Body.Innertext on the same website on two different machines through the same ActiveX web browser control on my form. It's replicated everytime I've...
  19. A

    Converting Time from Seconds

    I've got a time clock that stores the current time in seconds in a table. I'm having a real hard time figuring out how to convert seconds into hh:mm:ss. For Ex. "6" = 00:00:06 "67" = 00:01:07 etc Any ideas? Another thread was mentioning using int() but I don't think that's what I'm looking for.
  20. A

    Developing Environments

    I can get a look at them for you, but it will have to be either later tonight after everyone has left or early tomorrow morning.
Back
Top Bottom