Search results

I am trying to print out a mail merge, basically 4 pages to a printer which can handle staping. The problem is the printer sees the file as one large document, it does not recognize that every 4 pages is a new document that needs to be printed seperately. I checked the printer settings and...

Hi all, Is there any function similar to CurrentUser() in Crystal that would automatically print either the Windows username, or machine name automatically onto a report? Thanks!

Hi all, One of the buttons on a form I have runs an append query which appends a specific client record to a new table, dbo_Tbl_ParticipantData. I would like the OnClick event to trigger a lookup into this new table to see if the record already exists based on SSN. What is the best way to do...

My office recently got digital recorders that allow us to record meetings and then save the recording to .wav files on the PC. I created a database with a field that contains a link to the file. If I link a word or excel document, the word/excel application opens with the appropriate file. The...

Hi all, I'm in a bit of a bind trying to figure out how to accomplish this query, any help would be appreciated. I have a table called ApprovedCertification. This table contains the following fields: PK, ParticipantPK, CertificationDate, CertificationType I want to be able to compare the...

I have a form, called main form, which has on subform on it. The subform is in continious form view. Basically it tracks an Out Date and an In Date. I want to make text box visible/not visible based on whether there is a value in the In date field, in the last record in the recordset. I can get...

I have a question on preventing users from adding a new record to a continous subform if a certain condition on the current record they are working on is not met. Let me explain… I created a database (with the tons of insight from these forums)for tracking incoming phone calls to my department...

Hopefully someone can help me out. At my office we send out people to do inspections on a regular basis. An inspector will visit around 20 locations a day. I want to be able to take a list of address' and parse them out into seperate fields. For example: 10 Main Street 24-32 5th Avenue 534...

I have a table as follows Othersource____PAsource____Wagesource 5_____________8__________0 8_____________0__________2 5_____________5__________9 I am trying to do 2 things, first get the maximum value for the 3 sources, which I have been able to do using a zmax() function posted on another...