Search results

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

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

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

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?

i am trying to import a txt file into access. normally i don't have a problem with importing. but this file is strange. there are 2 or 3 or 4 rows for each record. basically each record starts with the same digit - no other row begins with that digit, but depending on how many and which...

i have a datasheet. when the user double clicks [member number] field, a new form opens so that user can enter details. after the user enters details, the [details date] field in the datasheet is updated and the background color of some fields in the datasheet is changed. to show these changes...

i have a datasheet. when the user doubleclicks on the member number, another form opens where the user can enter details about the member. when the user goes to the next member number on the datasheet, the detail form closes. when she double clicks the member number, it opens with the second...

i have a datasheet and a separate form. basically, the datasheet is a list of members. when i double-click one particular member, a form opens where i can select a membership status from a combobox. after the combobox is filled, the datasheet is requeried to reflect the status change. this...

i keep a table of the last time certain queries are run. the table consists of 20 fields. each field is the name of a particualr query. Each field has only one record - the date of the last time it was run. i want to get the date for a particular field (query). there really isn't a criteria. i...

i have a form where i enter today's date for those who are entitled to commision checks. after i enter the date for all those, i click on a button to open a report. however, the report is missing 1 person's commision - always the last entry. i imagine it is something simple. what am i doing...

how do i put the query results in the message of the email (not as an attachment)? would it be different if it was a report, and not a query? the query has only 2 fields and probably up to records. thanks

i have a form with member information and a subform for the notes. when the user opens the form, it will have the member info and the notes. i want those notes to be sorted by date descending. i know i can do that by basing the subform on a query. the problem is: i want the user to be able...

i want to have abutton that users click and then browse for file i found this Attachment: filefinder.zip, which is basically this: Dim OFN As OPENFILENAME On Error GoTo Err_BtnLocateImport_Click ' Set options for dialog box. With OFN .lpstrTitle = "Locate Import File" If Not...

this is probably simple, but ... i can do this in crystal reports, however, it does not seem to work in access: if {tbl_transactions.tnyint_transaction_status} in [8,4,10,15,20,25,30,35] then ..... meaning if status is one of those numbers, then ... how do i do that in access? is...

when a user clicks the close button from the main form, i want to save the time and do a few other things. where do i put the code for that? or is it better to disable that button and force users to use a button that i create (that will have the coding i need behind it)?

i want to import a .dbf file. i am able to do it from file>get external data>import. and it imports nicely however, when i try to write code for it with transfertext, i get an error message "Cannot update. Database or object is read-only." the file is not a read only and i can import it the...

i have to export a few files a day. i would like to name them filename_date_1 filename_date_2 filename_date_3 ... i want to check if the file name exists and if it does then change the number.