Recent content by Qwert0000

Check in the "data range properties" on the external data toolbar. Uncheck adjust column width.

Thx for the pointer on the Dim Statements The recodset I am tring to use is not part of the current form I am using. I have 3 tables I am dealing with. Table 1 [Personnel] is the record source for the current form . Also has the information I am using to select records in my where...

I have a table where I have the "where" clause of my sql statement stored as one of the fields. I can append to a table via a form when running my sql clause based on the current record. I would like to run this code as a loop on a on dirty trigger on a seperate form. Im not realy sure how to...

Conditional Formation did the trick. Had to rethink what I was tring to accomplish. Thanks for the pointers.

Thanks Tried searching but wasnt having any luck. Looking in the right place now.

I have a continous form that I would like to be able to toggle the visible property on some text boxes of certain records depending on the value of a check box. I can get this to work on a reg form, but can't seem to figure out how to handle this a continous form. Any suggestions? Thank you Eric

Thank you so much. I had to change the strTemp = Right(strPath, (Len(strPath) - Len(CurrentProject.Path & strSubDir) - 1)) to a - 0 as the first letter of my file name was getting cut off for some reason. I guess my original description wasn't clear because although I said I was using the...

Hi, I finally got the common dialog control to work using the code at, http://www.mvps.org/access/api/api0001.htm I just need a little help setting the flags and checking the directory that is returned. I am using this to set a bound text box to a file name for linking a picture within my...

My Discover starts with a 6 and is a 4-4-4-4 format.

Right after I posted I reliazed I made a mistake and grabbed the wrong piece of code. My coding isnt pretty but it seems to work. My CboSelectIndividualReport is actually a multiselect extended list box that originally started out as a combo box, never renamed it is all. Hope this helps Eric...

I use this code to do what your trying to do. It prints reports only on selected values. If CboSelectIndividualReport.ListCount = 0 Then MsgBox "Please Select Member(s)", vbOKOnly, "Try Again" Exit Sub End If For SelectCount = 0 To CboSelectIndividualReport.ListCount -...

Cool! One star on the way.

Thanks again. This site has been an invaluable learning tool for me. I'd toss you a star but I'm not sure how. Eric.

one more quick question. I had to remane my subs I had the names starting with numbers and that seemed to give me problems so i changed the names. My subs have been hidden as i can edit them through the main report. How can I unhide the subs so I can delete the old ones. Ive done it before...

That did the trick. Threw a couple of invisible text boxes on the main to do the counts and referenced the text boxes in the subs. Thank you so much. Eric