Search results for query: *

Sweet- that is exactly the bit I was missing. I will work with this tonight and see what I can accomplish. Thank you!

Hi all - how do i reference the button and form location which opens a particular form? I have a form NameDataEntry which can be opened from 3 different places on my database. Depending on where it's opened from, I want to change certain characteristics of the form, mainly it's caption and...

Duane, it works great. thanks for your help!

LOL. Me too Skip. I will give that a try, and see what happens. Thank you so much for all your suggestions though! :)

Data. I highlighted only the data, and pasted it into a new workbook.

Duane - haven't had a chance to try this yet, but it makes sense and I"ll give it a shot later tonight and let you know. Just wanted to say thanks for your response.

I have tried it both as selecting the print area in the mail merge wizard, and selecting the entire sheet in the mail merge wizard. It shows everything except the supervisor column in *both* instances. It's like that column just doesn't exist to MSWord for some reason. And it has no...

oh, and the range is A1:G19. and that is the only data in the worksheet, and the only worksheet in the workbook.

column headings: Supervisor Customer No. Customer Name Department Invoice Date Description Amount the data is contiguous. All rows have something in every column. there are no empty cells in the print area. There are no empty columns, cell A1 contains the word Supervisor above.

Hi - I am doing a mailmerge from excel to word, and when I go to insert the merge fields, it doesn't show all the columns in my worksheet. I have cleared and reset the print area, rearranged the columns, copied the data in to a NEW workbook, and even renamed the area I wanted (and it didn't...

Thanks for all your replies. I like Markus' idea, but lack the expertise in Excel to try it out right now. I'll give it a shot sometime when things are more settled here. What I ended up doing was just sorting the data by name, doing the merge, and just cutting and pasting the info for the...

Hello all - I have a query I use to populate a subform. This subform lists all charges against a client, by case. Currently, if one case has multiple charges, it lists them each individually. What I would like it to do is this - if there is only one charge on the case, list the chargetype...

ugh. so in a word, I can't do it in Word, and use my word templates, which have all of our letterhead and stuff on them, right? Because it's not a huge thing, and I won't have to do it often enough to spend hours trying to set up a memo document in Excel. thanks tho.

Hi, I have a data set with names and charges. Some names have many charges, some names have one charge. I need to send out a word document to each name listing their charges. Can anyone tell me how to do a merge and have it create one document per person, listing all of that person's charges...

:lightbulb: Ah, they were indeed formatted as text! Thanks y'all!! You saved me yet again.

Hi all - I have what should be a simple problem. I need three cells in a row to have the same reference - =BudgetStatus!G4 They were working fine until I had to go in and make changes. Now, if I go into any of them, when I exit the cell, instead of showing the value in =BudgetStatus!G4 they...

Hi lame - you're right, my example was flawed. It was a long week... It should be: So, for example, the third record created in October of 2007 will be 07100003 and the 45th record created in october of 07 will be 07100045 and then the 45th record in november of 07 would be 07110045 I...

hi all, I need to auto number the records my users enter into a form. i've created it as a text field, but can change that if I need to. I need them to follow the following format YY = last 2 digits of the current year MM = two digit month nnnn = auto numbering starting at 0001 at the...

Ooh oh, we're getting somewhere. that helped a lot. thank you!

it seems like somehow i need to capture the record ID of the highlighted/selected record on the subform datasheet, and pass that to the ChargeDetails form in the on open event?