Search results

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.

that is how i would do it. but i get the data that way.

i have to figure out payroll. employees are supposed to work a certain amount of hours on a given day. Mon 9-5, Tues 10-1, etc. if they worked more or less, i have to adjust the pay. i have a table of the hours they are supposed to work each day the table looks like this: employee Mon-in...

thanks!

i have received a file that has one field per record. i have to split it into two. i know how to use instr, mid, etc. but this is more complex because the character position of the break is different for each field. the only common thing between all of them is that the first field should only...

i have to find how many members are in each date range. meaning how many members have been active for 0-3 months, 4-8 months, 9-15 months, 16 - 24 months, 24+ months. can i do this with a query. i don't want a lot of iif statements. any suggestions?