Recent content by siena

Hi onpnt, Your test code worked fine but the big question, though is why do I keep getting this type mismatch error on this line? Salary = rs("sal")

No, I put it right after function HighLight() If it should be an include file, will be included the same way as: <!-- #include file =" what should it be called?" -->

Ok, why am I getting type mismatch here: Salary = rs("sal") or like: Salary = int(rs("sal")) or like: salary = CInt(rs("sal") or salary = CLng(rs("sal")

The field type is currency (access database). The funny thing is I am even getting type mismatch in when I dim the variable: Whether I dimmed like this: Salary = rs("sal") or like: Salary = int(rs("sal"))

Hello everyone, I am trying to search our directory by, among other things, date and salary. I have one column for date and one column for salary. So far, I keep getting type mismath error on both salary and date. Everything else seems to work. Here is my code: dateCheck =...

'After clicking the submit button, my message said records successfully inserted ' I use asp to submit records to our access database. When a user opens up a form inputs data and clicks the submit button, a message I created would say: "Record submitted successfully to our database" If you...

I hope this is the appropriate forum for this post. I linked an access database with a dbf file so I can print a report of both tables joined. However, since linking the 2 together, I have not been able to insert records into the tables. After clicking the submit button, my message said records...

It worked!!!!!!!!!! Thank you and 2 stars for you and your persistence. You saved me and I thank you very, very much!!! I also want to thank everyone who contributed their time and feedback.

well, when I say "the code stopped working", I mean that when I use " select fctrafic.sitecode, filename from table1, table2 where table1.sitecode = table2.sitecode, it runs good but when I add additional fields, it displays a cartesian product. Isn't this weird?

Let me just give you guys a visual stimulation of what I have been trying to do. I have done this several times with this approach. The only difference between what I am doing now and what I have done before is that this is the first time I am using multiple tables. In the past, it has always...

thanks for the post but Cassidy has helped me resolve this. Thanks,

Actually, what is working is when advance search is off. When advance search is off, it is like: select * from table. if advanced search is on, it is like select * from table where filename like.... or sitecode like .... I don't think it will hurt anything whether Filename <> 'z'" applies to...

Correction! I mis-interpreted my own code. If advanced search option is "ON" then a user searches with a filter. In other words, a user searches by sitecode or filename. If advanced search option is "OFF", the user performs a wildcard (%) search. I think I need to rest my brain for the rest of...

thank you, that's what I ended up doing. I had to do extensive internet search to find an answer. Thank you!

hi again, when I do advanced search, it works beautifully but when I turn off the advanced search to perform a basic search, it gives the following error: Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression 'FileName <> 'z' and (...