Search results for query: *

Hey cool PHV That is a quicker way to do it. Legend. :-) Cheers ------------------------------------- Your space here!

Awesome... Cheers dhookom Will post back if it doesn't work. Cheers :-) ------------------------------------------------------ I'm unique... just like everyone else

hey guys... cheers for that. I found insert into worked like a charm to create a temp table with filtered fields and then export that and then delete that update table from original db. I actually found the answer after many hours of constant trial and error whilst trying to get syntax...

Hey... I'm using the db with asp code saying if table.field = yes then display or filter returned content. say for a search field... If I leave them as -1 and 0 would the asp code still pick up those differenes?

Hi... I have filtered some data copied from another table in a DB to a new table in the same DB and then exported this temp table to a new .mdb file. When I open the new DB the yes/no data has changed format to -1/0. So far I have used DoCmd.TransferDatabase to export but how do I export it...

Hi... I have very limited VB knowledge just to state. I'm trying to export data from a table (entered via a form) to a new db with only some of the fields. In the form I have a button that is to run the event. I managed to copy the DB with DoCmd.TransferDatabase but have no idea how to code...

Hey ssatech... Running the query and exporting it is exactly what I want to do I have no idea how to do it. I thought I might have been onto something but with my limited knowledge I can't say that I was... Any help would be appreciated. Cheers :-)

A little digging again and I found this... Dim SQL_Text as String SQL_Text = "Select Name, Surname from dancers" Docmd.RunSQL (SQL_Text, false) I haven't had a chance to run this yet but I will later on. Is this what you were meaning and then do the DoCmd.TransferDatabase function? If not I...

Hey sorry for the confusion. How would I run the query. I don't usually code in VB so I don't really have much of an idea. Cheers

Hey ssatech That doesn't work. It says Jet DB engine could not find object dancers... I have a form called "Dancers" which updates data in a table "dancers". I want to copy most of the data from the table "dancers" for a simple db related webpage but excluding those addresses etc. (This is to...

Ok slowly learning here. So far I have this code with an empty db in that folder. But how do I make it specific for a query rather than just a table as a whole? DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\db\test.mdb", acTable, "dancers", "dancers", False Cheers

Hi... I have a simple database with name, surname and address details etc, however I want to be able to hit a button from a form to export it to a new mdb file with only basic things from the table, say just names and not the addresses. I understand that I could create a query to select only...

How can I go about that? I haven't used SQL much before and I'm new to ASP. Cheers

I can't write it in access as I have to enter names cos varText are from Request.Form text inputs. If I search with only one name and like function it works fine... but I need it to check both not just one.

Hey Jim. Cause I have heaps of if's... cause it is about a 20 variable search. The start of the SQL code goes like this. strSQL = "SELECT Surname, Name, Image_Thumb, ID, Online FROM dancers WHERE dancers.Online=Yes " So hence if text is entered into text box from a form named "Text" (This...

Hi... I have a small problem and I know it will be simple as anything. I have a text box and if something is entered it ammends the SQL query with the code below. The thing is I want it to search dancers.Name as well as dancers.Surname with the same string of text from the text box. (This is...

Hey Sheco thats awesome! Thanks for that. Even if I say 0 months it still makes it more accurate (the last one). Thanks for all the help guys. __________________________________ Two blondes walk into a building... You think one of them would have seen it!

Hey Sheco... Just add to this I'm new at most of this! :-P I understand datediff but how does dateadd fit into the calc/sql query? I haven't written any code as such but it will be roughly like this. Dim varagemin = Request.Form("agemin") Dim varagemax = Request.Form("agemax") Dim date1 =...

Tarwn... How would you go about that? You mean like top range = date() - maxage low range = date() - minage select.... where "search age input" between top and low Is this roughly what you mean? Pseudo code obviously.

Hey. Sheco I can see where you're going with that. I was however going to use this variation of code. if request("agemin") <> "" then strSQL = strSQL & " and age between " & request("agemin") & " and " & request("agemax") & " end if I needed an age calc also but is it still better you reakon...