Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Qwert0000

    Keeping column sizes when updating data from Access

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

    Loop help

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

    Loop help

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

    Visible

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

    Visible

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

    Visible

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

    Common Dialog control.

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

    Common Dialog control.

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

    Add an input mask for varying credit card formats (MC/V/AMEX)

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

    help with multiple select list box

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

    help with multiple select list box

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

    Sub Report with No Data

    Cool! One star on the way.
  13. Qwert0000

    Sub Report with No Data

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

    Sub Report with No Data

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

    Sub Report with No Data

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

    Sub Report with No Data

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

    Sub Report with 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...
  18. Qwert0000

    TxtBox Control Source not In form Record Source

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

    OLE Question

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

    OLE Question

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

Part and Inventory Search

Back
Top