Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dwarvenmilitia

    Exporting a table/query from a form button

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

    Exporting maintaining data format yes/no

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

    Running a Query and Exporting

    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...
  4. dwarvenmilitia

    Exporting maintaining data format yes/no

    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?
  5. dwarvenmilitia

    Exporting maintaining data format yes/no

    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...
  6. dwarvenmilitia

    Running a Query and Exporting

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

    Exporting a table/query from a form button

    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 :-)
  8. dwarvenmilitia

    Exporting a table/query from a form button

    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...
  9. dwarvenmilitia

    Exporting a table/query from a form button

    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
  10. dwarvenmilitia

    Exporting a table/query from a form button

    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...
  11. dwarvenmilitia

    Exporting a table/query from a form button

    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
  12. dwarvenmilitia

    Exporting a table/query from a form button

    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...
  13. dwarvenmilitia

    Simple Search Query

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

    Simple Search Query

    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.
  15. dwarvenmilitia

    Simple Search Query

    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...
  16. dwarvenmilitia

    Simple Search Query

    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...
  17. dwarvenmilitia

    Age Calculation

    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!
  18. dwarvenmilitia

    Age Calculation

    ...pushing it but I don't think it necessary for now, just the months are needed. Would it go along the lines adding underneath date1 Dim date3= DateDiff("m", -varagemin, Now) - (date1*12) Dim date4= DateDiff("m", -varagemax, Now) - (date2*12) SQL = SELECT...... WHERE DOB BETWEEN date3 AND date4
  19. dwarvenmilitia

    Age Calculation

    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.
  20. dwarvenmilitia

    Age Calculation

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

Part and Inventory Search

Back
Top