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...

...SQLINSERT = "INSERT INTO [TrainingReqs] ( RecSchoolID, SSN, SchoolRecNumber, TargetDate ) " & _ "SELECT (([Personnel].RecNumber*1000) + [RequiredSchoolList].SchoolID), [Personnel}.SSN, " & School & ", (DateAdd(""d"", " & Target & ", Date$()))" & _ "FROM...

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...

...to set a bound text box to a file name for linking a picture within my form. I have my filter set as (ahtAddFilterItem(strFilter, "Pictures (*.BMP)", "*.BMP") and have the inital directory set (CurrentProject.path & "\pics"). I am uncertaine about what flags...

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

...As Integer With Application.FileDialog(msoFileDialogFilePicker) .Title = "Select Employee Picture" .Filters.Add "JPEGs", "*.jpg" .Filters.Add "Bitmaps", "*.bmp" .AllowMultiSelect = False .InitialFileName = CurrentProject.path &...

....Title = "Select Employee Picture" .Filters.Add "All Files", "*.*" .Filters.Add "JPEGs", "*.jpg" .FilterIndex = 2 .AllowMultiSelect = False .InitialFileName = CurrentProject.path & "/Pics" my...