Search results for query: *

Thanks so much it works great.you were correct about all comments. as i said, newbie learning to code and very much appreciate your assistance. [noevil] "Unless you try to do something beyond what you have already mastered, you will never grow." Ralph Waldo Emerson

I am not that good using code to make things work and i just can't figure this out. I need to create a message alert based on two fields. If the fields (GuestFirstName and GuestLastName) equal a specific value (i.e. John Smith), then a message needs to show up that reads "Offering Full Credit...

I have an hp 3600 color laserjet printer that states in can produce full bleed documents (prints all the way to the edges)... i can't figure out how to make it do that - does anyone have any ideas of codes or such for a word document to make this printer print full bleed. thanks. [noevil]...

I am so sorry for the confusion - KISS is my middle name at work i'm not sure how this got so confusing: 1. user a has 100 photos (photo_100.jpg through photo_200.jpg) in directory b and a 100 page report completed in work. they need to add 1 photo per page to each page in the document form...

Pretty much, if there are 40 photos in the directory, all 40 will be inserted somewhere in the document. each project will have a varying number of photos, but, whichever number are in the directory will be the number ending up in the word document. Thanks again for your help... it is very...

Marcus4, you are correct in assuming what i was trying to accomplish. We have photos for each project - they would correspond with text in the main document and need to be placed where they are referenced. I was tyring to find an easier way for the person preparing the document to place the...

Fumei this is something i am going to replicate over and over with many different photos. I am not using a template. They are going to be all different photos (in the same directory)... basically the structure is this: directory: P2596\photos file names: anywhwere from P2596_1.jpg through...

I'm sorry about the not providing enough information. I have about 150 photos (all jpg files) they are all stored in the same directory and are all sized the same. this is something that will occur over and over again in different directories with different documents - i just need to get one...

I have a problem and I'm hoping someone can help. I need to create a report with a large number of photos (2 or 3 to a page, varies). I would like to be able to "merge" the photos into the report without having to go through the insert picture dialog system... is there a simpler way of creating...

thank you for the response. I believe I have worked my way around it by creating a table with the first query which requires the SELECT DISTINCT Query where all fields from two queries are combined from two separate (related) tables - All employee information is related by Emp_No in my DB...

I have a query where i'm concatenating several fields into one and then combining them with another query for the end result... Every thing works fine except when I place the DISTINCT in the SELECT Statement, I get however many times the second query records (i.e., qry1 has 1 concatenated...

Thanks for your support - you were correct that there was another function utilizing the concatenate name and i was able to easily change it which corrected the issue. again, many thanks. [noevil] "Unless you try to do something beyond what you have already mastered, you will never grow."...

I get that Concatenate is the ambiguous name? I ran the compiler and no errors show on the module - I'm not quite sure what is happening. [noevil] "One of the secrets of life is to make stepping stones out of stumbling blocks." Jack Penn

Well, I've been able to concatenate the fields of my one query into one field but still can not bring the result into one field. I need major help. Here is what i have. my original query was to concatenate all fields from one employees record into one field. I finally got that to work and...

that works - it then asks for the employee number in a parameter box. I'm going to start from square one this morning with copying over your block of code, compile, debug and re-write the select query to see if i can figure it out - i've been over it so many times, it just doesn't make sense...

nope, still getting the ambiguous name error....i'm about lost for the day....i'm starting to see dots all over the place from staring at this the entire day. I'm beginning to wonder if there is something wrong with the module i copied from the FAQ. I ran the debug and it was fine but it just...

Sorry, here it is... SELECT tblEngCertID.CertIDNo, tblEngCertID.CertificationTitle, tblEngCertID.Prim_Id, tblEngRegist.REGPID, tblEngRegist.Emp_No, tblEngRegist.REGID, tblEngRegist.FirstIssued, tblEngRegist.StateIssued, tblEngRegist.RegExpires, tblEngRegist.RegNumber, tblEngRegist.DateModified...

Here it is: SELECT qryEngRegistrationsWTitle.Emp_No, Concatenate("SELECT CertificationTitle & Chr(58) & Space(2) & StateIssued & Space(1) & Chr(40) & Chr(35) & RegNumber & Chr(44) & Space(1) & 'expires' & Space(1) & RegExpires & Chr(41) & Space(2) & FirstIssued FROM qryEngRegistrationsWTitle...

Ok, so i've tested the SQL and it works fine as PHV suggested. It gives me each record joined into it's own field. What I need to do now, is get each of those joined into a field so I end up with one field with all of the information in it. I tried adding the tblCertsID.[Emp_No]) line and i...

Wow, thanks for the replys. Sorry it took so long to get back to the question, i got stuck in a meeting. Ok, there are two tables in the query and only one Emp_No field in each table....it is the primaryID for both tables... What I'm trying to accomplish is to have the records in...