Search results for query: *

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.

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

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

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

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

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

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

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

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.

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.

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

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.

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

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

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

thank you very much, that will work

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

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

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

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