Search:

Perhaps others have had this missing type happen to them ... and solved it. Right now, I have no idea of why, or under what circumstances this missing type gets substituted ... I do know that some...

Yee Haw ... I'm Back. 5+ long years since working with VC++ ... Now for the headache :D ...

I keep getting this damned compile error on __missing_type__ ... This object is a placeholder for the...

Obviously you have a type mismatch trying to compare a date type using a string comparison operator ... A solution would be to have a "match" column that formats your date as a string for this...

MyCombobox.RowSourceType=Table/Query
MyCombobox.RowSource=SQLCode

#1 : Where is the ClientID? In which table?

#2 : Not really. I wouldn't advise it ... What I would do is populate the Account...

WAY too late now ... You won't be learning VB with only 2 hours before the interview ...

If you think about this: "The funny part is that if I remove the parantheses (like sp_StoredProc2 'N'), then the second Query works fine!" the answer should be apparent - Do you have any kind of...

Mike,

Replace works fine for me also ... Yaeh, the backslash was a bad idea ...

Cathy: Try recompiling your app and look to see if there are any invaid or missing references ...

Hmmm ...

Dim TmpString As String

TmpString="ABCD*EFGH*JIKLM*NOPQR*STUV*WXYZ*"

TmpString=Replace(TmpString,"/*","")

Should work ... I think it may have to do with VB treating the "*" as...

At which time it's not worth my time to do so unless forced to ... Right now they're happy to have it vertical ...

Thanks again Luth.

Luth,

AWESOME!!!! That get's me half way there ... Now all I gotta do is have it print vertical from right to left (bottom to top) ... :D

This is somewhat of a VBA question .... Anyone know of a way to get a label to print/display "sideways" (vertically)? I know of no fonts available ... Thanks!

I believe that's called replication and reconciliation ...

What do you mean by comments?

Yes.

"UPDATE MyTable SET MyYesNoField=False;"

Yes ... For the most part we're talking common sense here ... The interesting part is when you start getting into relating disparate data together ... Then the data design comes in handy. HOW TO...

Talk about open ended ... Think about what kind of data you want to capture/track/hold/make/etc ... Then break it down into related bits of info. Create table structure from that. Normalize. Build...

# signs ... Date literals need to be surrounded by # signs ...

Numerous ... Depends on the database in question ...

Check your record locking ... Is it table level? Page level? Row level? Ideally you should be using row level ... Also you should have error trapping such that you can go into a "holding pattern"...

Try: (D_f_a_orl & '' = '')

Too true Ahmed. You have sinned to the other side tho ... A way to handle both issues at the same time is:

If rs.Fields("withdrawnprize").value & "" <> "" Then
...

Remember IsNull will fail on...

I agree ... And further, this kinda project is VERY involved ... Something that most programmers/developers would not part with for nothing (or attempt to write for nothing for that matter either)...

You have to have the proper MDAC installed ...

SELECT * FROM MyTable WHERE IsNull(MyField);

That depends on your purpose ... What normal form are you looking to get to? Oh, what database is this to be in?