Search results

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.

This is great, it's definitely steered me in the proper direction. Here is what I've got it down to. I opened my accdb on my normal machine and on one of the XP machines that it isn't working on. I tossed in the MsgBox InStr(string, "delimiter") On the working box it give me 3447, so bingo...

You're right and should have included this but I overlooked it. Through my testing I have set it to If Instr(string, "delimiter") > 0 Then But I haven't had different results. Any message boxing, I tried that as well. Right before the parse I msgbox myself the string, "Gigantuam text box"...

Has anyone noticed any problems building there access packages in Vista and then deploying them on Windows XP? For the last 3 months I haven't had any problems until recently. I've tracked the issue down to a parsing issue. I have a bit of code that parses data it's set up akin to: If...

Thanks Adam, that's great. So if I wanted to make a search engine for my database and I wanted to be able to include the ability to use "-" as if it were NOT, I would basically have to parse the text box control accordingly and then build a sql statement off of the parsed line. Something like...

no, that's definitely not it. That would work as I originally said it does, with just "1" or "2" in my criteria. Not when it's "1 Or 2". My question deals specifically with the logic operators in the query criteria. And if I precede and end my criteria with "*" a problem arises when I enter "1"...

I was playing around today and found something that is odd to me. If I set my query criteria to "Like [Forms]![FrmName]![Text0]" it will work as long as it is simple. For example, I'm running the query against a table and my criteria is for the TableID column (1, 2, 3, etc). As long as I use...

PDAs, Blackberry's and all these other fancy shmancy devices are so popular now I'm thinking it's useful to get a bit intimate with what is needed to program for them. I've got a copy of Visual Studio 2008, and I'm somewhat fluent with VB. My beginning questions are: 1.) Where can I find a...

After installing a program update I was called back to the user's desk approximately 15 minutes later. They were complaining that the screen had just gone blank and the latest update must have broken it. I moved the mouse, screen saver turned off and the user was wowed with my amazing trouble...