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

    Use command button to import new records

    make an import table (newdata_tbl), make an append qry from this table to your existing table. make a macro that imports the newdata.xls (transferspreadsheet), and then run query (your append query). then all you have to do is run the macro using your command button.
  2. dolfan1873

    Can you add NA to a Yes/No data type

    you could use the if/then statement to clear other boxes as you check one if you use the 3 check boxes.
  3. dolfan1873

    Can you add NA to a Yes/No data type

    you could also make 3 new fields in the db called Y N N/A and add a yes/no checkbox for each.
  4. dolfan1873

    count problem

    i tried it and i can't get it to work, it still drops one program if it has no records, i need it to appear in the results with a 0 so all 3 programs always appear in the results. maybe i didn't type something correct, i had it working but it still dropped the program. thanks
  5. dolfan1873

    count problem

    here is the SQL from a query i have, this works fine until i have no records to count in one of the programs (e2cipt or modipt or psipt), it just eliminates that program. is there a way i can keep the program and make it come in with a 0(zero). SELECT Count(Input_tbl.Program) AS CountOfProgram...
  6. dolfan1873

    count problem

    i have a query that has a program field with criteria for (3) different programs, then i count the number of entries for each of the (3) programs to determine how many items are open for each program, works great until there are no items (null values) then i get no output for whichever program...
  7. dolfan1873

    duplicates in excel or access

    i have a table with part number, sometimes the partnumbers are repeated by the engineer with a new revision, i can not just delete the duplicates, when i work in excel or access with the table as you know it only looks at the first number when you are doing a compare, is there a way to make...
  8. dolfan1873

    form open in backround hidden

    i have a system that will kick people off the database using forms, the problem is the form that is open in the backround, it works fine as long as i minimize the form, but when i have it hidden in the backround when i open the second form to set the time for the closing of the database it...
  9. dolfan1873

    kick people off database

    i got most of it, just lost it when he said to check table and see if a field is set. besides i come here for advice not to be ridiculed, if that is all you have then please don't bother to answer my post again.
  10. dolfan1873

    kick people off database

    could you please explain a little more, i am not getting it. thanks. also will this work from my pc, or does it have to be done at the server level.
  11. dolfan1873

    second autonumber field

    i have joined 2 tables that had autonumber fields and for tracking purposes i need to keep both number fields, they are not the same and i just wanted to make it update itself rather than me inputing the number. thanks
  12. dolfan1873

    second autonumber field

    i know you can't have two autonumber fields in access, but can i make a number field that will act like an autonumber, when i add new records i need this second field to go up by one number also, i tried using the max()+1 in the default value but that didn't work.
  13. dolfan1873

    Between two dates in query criteria

    set the format in the table for the date to short date this will get rid of the time, if you do not need the time
  14. dolfan1873

    Between two dates in query criteria

    Between [Type the beginning date:] And [Type the ending date:].
  15. dolfan1873

    kick people off database

    i am admin on a database that is kept on a server for our company, when the database has problems i have to call the IT people to get them to remove everyone from the database so i can fix the problem. is there a way that i can set something up in the database the will kick everyone off the...
  16. dolfan1873

    (if, like then) statement

    thank you very much, that will work
  17. dolfan1873

    (if, like then) statement

    i am trying to write an if statement that will find different occurances and return a result, if Item = like "123A*" then Cat = S end if. this works fine but to save alot of typeing or space i want to use the like for more than one instance if item = like "123A*" or "123AB*" or "123B*" then...
  18. dolfan1873

    update table with form

    i have a main form that is used for the database, on one of the check boxes i have a procedure that opens a form with some more check boxes, i made the second form off of the same table, i want the second form to update the original table, every time i try this when i try to move to another...
  19. dolfan1873

    using second form

    i did use the docmd.openform, am i supposed to adjust the same line or add and new line with another docmd.
  20. dolfan1873

    using second form

    also the form that pops up when you check this box, i have disigned it with the same query.

Part and Inventory Search

Back
Top