Recent content by dolfan1873

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