Search results for query: *

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

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

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

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!

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

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

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

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

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

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