Search results for query: *

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

Thank you vongrunt and I am sorry that I had to leave. I got very frustrated and had to leave. To answer you question about what I want to get when the advanced option is turned off, the advanced option is like using a wildcard search. Once it is on, all records are listed. When it is turne...

Well, I am surprised by what I found. If I do a response.write on the first one (the one that works), I get this: SELECT * FROM trafficCountsFiles ORDER BY siteCode ASC; If I do same response.write on the one that doesn't work, I get this SELECT * From fctrafic,trafficCountsFiles ORDER BY...

putor = 0 strSQL = "SELECT * FROM trafficCountsFiles " If advanceSearch = "ON" Then strSQL = strSQL & " where FileName <> 'z' " If selSiteCode <> "" or selKeyword <> "" Then strSQL = strSQL & " and ( " If selSiteCode <> "" Then strSQL = strSQL & " siteCode LIKE '%" & selSiteCode &...

I am almost 100% certain that this is not possible but no better place to verify that than on this forum. We some files on sql server database and some additional (more gis-related records) in a dbf file. There is a common key between the sql server database and dbf file and that is called...

vongrunt, Bless your smart heart. You are absolutely right. Strange again because we have some with 11 characters but it works and I thank you a lot.