Recent content by deekras

thanks for your reply. so i put in the whole SQL of the query into the OpenRecordset- (see below) and i still get the error message 3061. Too few parameters. Expected 1. Set rs = CurrentDb.OpenRecordset("SELECT tblOrders.DirectorName, tblOrders.OrderNo, tblOrders.Email...

Set rs = CurrentDb.OpenRecordset("select * from qrySendPasswords", dbOpenDynaset) i have tried that. I get the same error. that query has a field whose criteria is that it is a certain field from the particular form. WHERE ((tblOrders.OrderNo)=[Forms]![frmdates]![OrderNo]) do i have to put...

I'm still stumped about how to write the loops. I want something like this: Dear DirectorName: Below are the passwords of your teachers: TeacherName1 password: 123 TeacherName2 password: 124 Please retain for your records..... i guess there are 2 loops one from director to the next director...

I have a table with director names and the teachers who work for them and passwords for each teacher - one record per teacher. so that if a director has 4 teachers, there are 4 records. i would like to send an email to the directors to tell them their teachers' passwords. i imagine that i have...

i tried. i changed the doc name. i reviewed all the parameters. i get an error. "object doesn't support this property or method".

i would like to run through my database and merge in a word 2007 document (several page .docx) save that word document as pdf (do that for several word documents) zip all pdfs email i have the code for the loop and the merge and email. works well. I am stuck on the save as pdf and zip all...

here are samples of two of the files that i have to import into a table 'tblNew' (from there i append it to tblArchive. TITLE1 TITLE2 REPORT WEIGHT SHAPE/CUT COLOR CLARITY COMMENTS: DESCRIPTION: DATE PICTURE USA THE ID CARD™ US 33316501D 0.74 ct. twt PRINCESS G-H SI2-I1 DIAMOND STUD...

importing different .txt into one table every morning i have to import a .txt file into a specific table. the problem is the table can have a different number of fields or the fields can be in a different order. this complicates the import specification. i am looking for a simpler solution.

I have a table that has data about different advertising campaigns. each record has a start and end date; each campaign has a different code. i have a separate table that has responses - people that called in because of campaign. this table includes call date, the campaign code and other info...

thanks for the quick response. i tried that, but i can't get it to work properly. i have a datasheet of names. when a user calls someone, she double clicks on the ID field and a popup form opens where the user enters the results of the call. date and user name are filled in automatically. i...

i have a list from which i want the telemarketers to make calls. i have about 6 callers at any given time. how do i make sure that if one caller is calling a specific person on the list, no one else has access to that name? or at the very least the other callers see that another caller is...

I am trying to do the same thing - but i run into a problem. my macro in excel is called "PERSONAL.XLS!m" i get an error message 'PERSONAL.XLS' could not be found. Check the spelling ..." what am i doing wrong. secondly, can i run an excel macro on a .txt file or do i have to change it to a...

what formulas would i use?

how? i get the data that way from excel. how do i say? if this column has "tues in" then move to column10 sometimes "tues in" is in column 5 sometimes column 7.

not really. i want to compare the time that the employee shuold have been at work to the time he actually was. on mon, he shuold have been 9 hours, but was only 8 hours, etc. on tues, he should have been 8 hours, was 10 hours.