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

    Time format

    Ok here is my problem. I export a table from an Access database into an Excel spreadsheet then in to another Access database. I know it sounds stupid but I can't just link the two Access databases or make any changes to the orginal Access table exporting from. On export, the time is in 24hr...
  2. pavewayammo

    Excel - Time import

    Ok here is my problem. I export a table from an Access database into an Excel spreadsheet then in to another Access database. I know it sounds stupid but I can't just link the two Access databases or make any changes to the orginal Access table exporting from. On export, the time is in 24hr...
  3. pavewayammo

    Summing on Crosstab

    Ok here is my problem. I have a table with personnel status. The status field can be either blank or have an l,t or o in it. I figured out how to get the totals for each but my problem is when no one has one of them. For example if at least 1 person has blank and l and o but none for t. I get an...
  4. pavewayammo

    Auto update with date

    Ok I have looked through all the FAQ's and searched the forum for this but just can't find the help I need. Here is what I am trying to do. I have 3 fields (DateSubmitted, LeaveStr and LeaveEnd). I need the DateSubmitted to be updated with the current date when either of the other two fields...
  5. pavewayammo

    Import ?

    I have an import question. I have been looking for a way to do this for a couple months now. I have serveral .html files that I would like to import. Now the catch is there is 4 tables in it and other text. When I go to file>Get External Data>Import.. it only imports the tables. I would like to...
  6. pavewayammo

    Look up question

    Ok I have look through the FAQ's and searched the Forums for this answer. These are the fields I need for the drop down list. SCL Text 20mm Number Chaff Number Flare Number 9's Number 120's Number Now in a differant table I will have the same fields. I would like to be able to select the...
  7. pavewayammo

    Form opens slow

    Can someone shoot me a few ideas on how I can speed the opening of a from that has 69 fields that come from one table with two subforms? Right now the form uses a control tab to keep like items together but since I added 40 more fields the the original 29 it opens so slow. Some users think...
  8. pavewayammo

    Noob question on adding record

    Ok I want to have a new record added everytime the database is opened to a table with computername, username and date. I understand how to get the comptername, and username but not sure how to have it added to a record.[flush] Thanks, paveway [spineyes]

Part and Inventory Search

Back
Top