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 Rhinorhino 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: *

  • Users: kdoran
  • Content: Threads
  • Order by date
  1. kdoran

    excel cell to subject line in email

    I need to have a cell populate the subject line in an email. Here is what i am currently using to email the spreadsheet via button. ------------------------- Private Sub CommandButton2_Click() ActiveWorkbook.SendMail Recipients:="name@company.com" 'each individual file should be save to a...
  2. kdoran

    trouble deleting all entries in tables

    I have a database and want to be able to delete all the entries in the tables with no prompt. table1 table2 table3 tried various ways with no luck. What has worked was this DoCmd.DeleteObject acTable, "table1" but this deletes the actual table and I do not want to do that, just the data in...
  3. kdoran

    query to total for the month

    Ok I have been running a query off the date (for weekly, monthly, yearly checks) for an entry to find out if techs are doing there calibration checks for a certain area. What I am finding is that if you calibrate a piece of equipment twice in one month it shows up twice and causes the total to...
  4. kdoran

    Query ran from date entry in table

    I am trying to run a query that would use a date in a simple table that has 12 entries, the date for the first of each month. I want to use that date say 03/01/06 from the table and run a guery to find the entries in another table that have dates in that month. I get how to use between...
  5. kdoran

    pull date from list of dates

    Is it possible to pull a specific date range from a table of dates to see if there was an entry made weekly. tblFieldTag FieldTagID WeeklyCheck (yes/no) MonthlyCheck (yes/no) tblFieldNotes FieldNotesID (autonumber) FieldTagID (This is a required field) FieldNotesDate FieldNotesText for...
  6. kdoran

    query report off specific time frame

    I am trying to make a report that will query for specific times of the year what has been done and what has not been done. It would key off the checklist and and type of check. tblFieldTag FieldTagID WeeklyCheck (yes/no) MonthlyCheck (yes/no) YearlyChekck (yes/no) ValveChecklist (yes/no)...
  7. kdoran

    Query by date

    I have been looking and unable to find out how to run a query that will look at a date field and find dates within a set number of days for example last 30 days or last 365 days from today etc... I am looking to run a report that will generate this and only get the entries from the last (fill in...
  8. kdoran

    Printing to wrong printer

    I am using Access 2002 and have a form with a button that is linked to a query which prints a report. The default printer set to the one in the office and you can see it in the pull down menu, but when you press print it prints to a totally different printer. This problem has just popped up...
  9. kdoran

    Add text if True

    I am trying to add text to a report if a check box is checked. I have three check boxes FailOpen FailClose FailLastState If one of these three are checked I want to add text that says the same to a report so if FailOpen is checked it will say Fail Open. Thanks in advance, Kelly
  10. kdoran

    Update query trouble selecting both

    I have two check boxes on the same table and I want to run an update query that will look for both checks per line and then remove them. If they are both not present either one will stay checked. Any ideas? Thanks, Kelly
  11. kdoran

    Trouble adding to new line

    I have a couple of tables tblFieldTag FieldTagID Input Span Out Description ProblemLoop (Yes/No) SelectDeselect (Yes/No) tblFieldNotes FieldNotesID (autonumber) FieldTagID (This is a required field) FieldNotesDate FieldNotesText On a form when it is opened it runs a subform (form26)...
  12. kdoran

    Trouble with autopopulate code

    I have a couple of tables tblFieldTag FieldTagID Input Span Out Description ProblemLoop (Yes/No) SelectDeselect (Yes/No) tblFieldNotes FieldNotesID (autonumber) FieldTagID (This is a required field) FieldNotesDate FieldNotesText On a form when it is opened it runs a subform (form26)...
  13. kdoran

    Autopopulate to new line in table

    I have a couple of tables tblFieldTag FieldTagId Input Span Out Description ProblemLoop (Yes/No) SelectDeselect (Yes/No) tblFieldTagNotes FieldTagNotesID (number) FieldTagID FieldNotesDate FieldNotesText On a form I have a subform that runs a query of ProblemLoops and displays the FieldTagID...
  14. kdoran

    Report most recent entry to report per Line

    Hi, I have a couple of tables tblFieldTag FieldTagId Input Span Out Description ProblemLoop (Yes/No) tblFieldTagNotes FieldTagNotesID (number) FieldTagID FieldNotesDate FieldNotesText What I am trying to do is have a report that will pull the ProblemLoops up with the info from tblFieldTag...
  15. kdoran

    Null error with append query

    I am trying to append query from one db to another one (tried a linked table or directly to it). The table is exactly the same. When I run it I get an error message. Here is error message I get. Cant append all the reocrd in the append query. Db set 0 fields to Null due to a type conversion...
  16. kdoran

    Update or append to another database

    I am trying to use a query to update or append (no luck with either) from one table to a table in another database. I have a form for data entry which puts info in a few tables when equipment in the field is worked on. On another form I have a text box where you type in the date which will run...
  17. kdoran

    Add new information to existing table

    I am using access 2000. I have a table - tblFieldTag FieldTagID - primary key Manufacturer ModelNumber I am trying to add and or update this table with a new table given to me by another person. I want it to overwrite any manufacturer or model number currently in tblFieldTag. If the Field...
  18. kdoran

    Need help Learning VBA

    I have been using access 2000 for a short period now. I am asking for help in pointing me in the right direction to learning VBA on the web or other. Your responses are greatly appreciated. Thanks in advance, Kelly
  19. kdoran

    Compact backend on closing

    Is it possible to compact the backend db with the tools menu ‘compact on close’? Do I need to set this on the backend db or on the Front-end mde or both? Also is it possible to have the backend db compact on close something like every 10 or 15 times was opened? It may be a silly idea but the...
  20. kdoran

    Search field for specific Character

    I am trying to search a field with a query and want the criteria to find a single character and I am not sure how to find a character that may not always be in the same spot. Example Looking for V FIV-18001 TV-18050 I am using this query for a report. Any ideas, Kelly

Part and Inventory Search

Back
Top