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!

  • Congratulations Chriss Miller 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 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...
  2. 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...
  3. 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...
  4. 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...
  5. dwarvenmilitia

    Age Calculation

    Hi... I have a table with DOB and I need to calculate and age so i can search for a age range. I know how to search once I have an age but not to sure how to calc age from retrieved table values. I've read people use vba but I have no knowledge of this. This is being down in ASP too. Any...
  6. dwarvenmilitia

    Convert tables to CSS Div/Span

    Hi... I know this will be a simple problem cause I don't know much css. I have a web page with main data but for aesthetics I want 2 bars up and down either side of the main page. In tables I would do it like this: <table> <tr> <td height="100%"> imageleft.jpg </td> <td> main page...
  7. dwarvenmilitia

    If Check box select (multi variable search)

    Hey everyone... I am trying to create a multi checkbox (yes/no) search function but when the page runs with a checkbox selected, my sql query (as far as I can tell) won't be ammened to my main sql string. Multi checkboxes as in varA, varB, varC Basic idea is: varA = Request.Form("Checkbox")...
  8. dwarvenmilitia

    ASP search form for DB content

    Hey I know this may sound really bad but I have all my db setup and pulling images off and displaying in web fine. I can create a search bar for text (one variable). BUT Say I have like 6 catagories ie field names in the db and they are checkboxes (yes/no). How do I go about variables between...

Part and Inventory Search

Back
Top