Search results for query: *

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

Is there an easy way I can count the number of subreports with data in them so I can number my sub reports? For example report Looks like this. HEader. 1. Subreport Header data data data 2. Subreport Header data data data 3. Subreport Header data data data If sub 2 has no data...

This has been covered in other threads but I am unable to fix my problem. I have an unbound main report with several sub reports. I am trying to ensure the sub reports will print on the main report with no data in them. Looking for a consistent look on my report. I tried using iif(Nodata...

That did the trick. I had to change the Join type (still dont understand the different types), but I got it doing what I wanted. Thanks again. Eric

I managed to get the code working with help from the northwinds DB and a post on another board. When I embed a jpeg (my jpegs are all 6k max)the db starts getting very large very fast. The files get embeded as Microsoft Photo Editer 3.0 photo. If i put them in as bmp (50 k files size) the db...

Howdy, I have a bound OLE object on a form that holds a jpeg. I am able to inset a file into this form using the inset object menu browse ect. I would like to add a cmd button that opens the file dialog and allows me to choose the file I want and inserts that file into the ole object. I have...