Search results

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.

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

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

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 ?

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

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

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.

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

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

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.

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

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

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

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

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

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

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

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

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.

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.