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

    Flipping Order of Items

    haha That's exactly it; my job is all about keeping them happy. :P Thanks again, Tom!
  2. bepaling

    Flipping Order of Items

    Hey Tom, Thanks for the quick reply; that's exactly what it was! Under the Sorting/Grouping, I didn't have the ID for the specific record selected. I selected it & it works great now... Thanks! Jason
  3. bepaling

    Flipping Order of Items

    Hey all, I have a Report based from a Form & SubForm. Site information is entered into the Form & Materials into the SubForm. Problem occurs on printing; the Techs spend time to group the Materials used, based on what type they were (EX. Security grouped the same, Telephone's grouped the same...
  4. bepaling

    AutoNumber Question

    Hey PHV, I checked and I did have a TextBox named Date; I've renamed it to txtDate. Then, I changed my Code to include the VBA.Date... works like a charm! Thanks PHV! Can you explain what difference it makes with "VBA.Date" as opposed to "Date?" Cheers!
  5. bepaling

    AutoNumber Question

    Hey Zameer, I used the following Code: Function CreateAutoNumber() Dim MyYear As String Dim MyNumber As Variant Dim MyAutoNumber As String MyYear = Right(Date, 2) MyNumber = Nz(DCount("[WorkDirectiveID]", "[tblWorkDirective]"), 1) + 1 MyAutoNumber = "E" & MyYear &...
  6. bepaling

    AutoNumber Question

    Awesome Zameer, thanks so much! I'll try them out & let you know. What's the difference between the DMax & the DCount?
  7. bepaling

    AutoNumber Question

    Hey Zameer, Thanks for the reply; I've checked out those FAQs prior to my first post; since your post, I've revisited them & I've checked through your site - a lot of useful information there, by the way. Here's what I've come up with so far: Private Sub Form_BeforeInsert(Cancel As Integer)...
  8. bepaling

    AutoNumber Question

    I have tblWorkDirective w/ the field WorkDirectiveID as a PK Autonumber. We (my boss & I) want to have our own autogenerating number that increases with every new record, AND has several components. We'd like it to appear as: E05-XXXX, where "E" is always that letter, "05" is the last two...
  9. bepaling

    sfrm Recall after Source tbl UpDated

    Thanks all. I realized that I was looking for the display information in the wrong spot. But, for those that are interested, I did manage to get it to ReQuery using the following Code: Forms!frmWorkDirective!sfrmMaterialsList.Requery
  10. bepaling

    sfrm Recall after Source tbl UpDated

    Hey Team, Some background: I have frmWorkDirective with sfrmMaterialsList. User inputs all information for the WorkDirective, then inputs all Materials used on MaterialList. Problem is, with new parts coming in as we expand, they aren't all in the Source Table: tblMaterials. So, I created a...

Part and Inventory Search

Back
Top