Recent content by yammoo

i have managed to get it to work. for those that are interested in the solution is that i had to remove the .column in red portion of the code in my post above. by simply removing that my code worked like a charm. i had to make a few minor additons such as requery my combo boxes and the like...

possible event code misguiding results i think i came across a possible drawback to having my cmbClient1 box do other things such as load an existing query when the user enters into it or when the user changes the value it loads another combo box with that client's corresponding address. my...

continue working on own.... i think i shall ponder this on my own for a little while and if i come up with the solution, I will definitely let you know mr. larson. i am gonna give the problem a rest for now, however if anyone has any possible solutions, comments, or questions regarding this...

only tried one what you say makes sense, since I would only need one or the other anyways if they are one in the same. I will stick with the client number because within the query, the first name and last name fields are concatenated. I have tried working with the code I posted earlier and...

answer to question mr. larson, yes, you are right in assuming that my bound column is an id number and that my combo box has two columns attached to it. also now that i think of it, that particular combo box (cmbClient1) is bound to a query referenced in the on focus event. so my thoughts...

possible solution yes, I have one on my database, but I must warn you it is not extensive or anything of the sort. I searched extensively on the net for several days until one day it just appeared in a search without any warning. anyways, it takes your address city state and whatever and...

code request fulfilled Thanks in advance. Oh and thank you too Mr. Larson for taking the time to read my post! ok my code is Private Sub cmdOpenCorrespondingWO_Click() On Error GoTo Err_cmdOpenCorrespondingWO_Click Dim stDocName As String Dim stLinkCriteria As String stDocName =...

hello to one and all, I am trying to transfer certain information (name, address_id)from one form to another. I have linked a command button to the other form via the wizard and it worked great (option: open the form and find specific data to display). I've worked in the dlookup function to...

possible answer in another posting i don't know if you have come across the same posting within this very forum, but when i skimmed your problem and saw that you had no response, i recalled a similar posting. it was just a matter of finding it...

thanks to one and all hey y'all, it turns out i dont need that particular subreport anyways, so i used a part of that embedded subreport for my final invoice. thank you to one and all for your help. u guys are the greatest. and mr. larson was right about my subreport shifting all the other...

making page header invisible when printing perhaps selecting the properties of the page header and setting the visible property of visible to no. It seemed to work for me. if you have already tried that, then I can't think of anything else at the moment. hope this helps, yammoo

return of the shifters..... Thanks for the quick reply Rich. Yes I have tried every different alternative that I could find. I added the background image through the image frame, the ole unbound object, in the report properties. I did the zoom, clip, strech. I feel that I exhausted my search...

the shifting continues...... I was actually referring to the text fields being moved also when I add the subreport. After posting I found that when I had a subreport unto the graphic it shifts the text fields when in print preview. llkhoutx- As for the absent code, I don't really think so...

hi one and all, I have searched the forums and the internet for the past couple days and havent found anyone with this particular issue. Basically I have a need for a background image (which i have) and the text fields from a predefined query (which work fine). I would be a happy camper if...

possible solution if havent found one or upgraded since post i myself have been lookin for that particular solution. i have recently found a possible solution to doing that with access 2000. not sure if u have upgraded ur access version or found the answer ur self or no longer need it due to a...