Recent content by sudhirhinduja

FE BE not a feasible solution Hi, I cannot do that since its pretty much a dynamic databse in the sense that the primary key in the orders table is mm-dd-yyyy-XX where XX increments based on the next order for the day. So all have to access the orders table simultaneously and be able to email...

Hi, did you find a workaround for it? I'm facing the same problem. Please assist. Thank you so much. Suds.

How did you go about using CopyObject in the multi-user mode? I'm facing similar issues. Could you assist? Thanks, Suds.

Hey Jatfill, Could I get a sample of this database? The link does not seem to work. If you are not able to upload it my email is sudspark@gmail.com Thanks a lot, Sudhir Hinduja.

You might want to set the Limit to List property of your partID combobox to Yes. Then on Not in list event fire the new form which takes in user input from a parts form opened in add mode. I'm sorry if I misunderstood anything. But the way I see it is you have a partID combobox and you want to...

Thanks Bob, I did that as well as I changed the record source of the frmCustomers to pick up data from the query. It was picking up data from the Customer table so obviously it needed a unique customer ID. Silly me! Thanks again :) Sudhir.

Hi Bob, Here's a snapshot of the relationships. It workd fine if I enter a new customer but say if I enter the customerID again. Example 01-hindsud it shows me the contact notes but doesnt let me add any more notes compalining about the duplication of the keys. Sudhir.

Could you assist. This notes feature is working mine if I add a nerw customer.But if I try to type a previos customerID it says cannot create duplicates. Thanks, Sudhir.

Thank you Thank you, Your suggestions here worked like a charm! Suds.

Subform Try: Forms!myMainForm!MySubform.Form!myControl If that doesn't work try using the expression builder coz I faced this issue of renaming a subform and totally forgetting about its previous name. Access used to accept it most places with the new name. But that one reference got stuck...

Got it DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.CopyObject , "rptOrder" & [InputID], acReport, "rptOrder" stDocName = "rptOrder" & [InputID] DoCmd.SendObject acReport, stDocName, acFormatRTF, "sudspark@gmail.com", "", , "New JDA Order", "New JDA...

Got it DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.CopyObject , "rptOrder" & [InputID], acReport, "rptOrder" stDocName = "rptOrder" & [InputID] DoCmd.SendObject acReport, stDocName, acFormatRTF, "sudspark@gmail.com", "", , "New JDA Order", "New JDA...

Thanks Thanks MicroE, I totally used you're concept. DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.CopyObject , "rptOrder" & [InputID], acReport, "rptOrder" stDocName = "rptOrder" & [InputID] DoCmd.SendObject acReport, stDocName, acFormatRTF, "sudspark@gmail.com"...

Caption renaming Hi R. Hicks, I'm facing a similiar problem. I need to rename the caption so that each attachment gets a unique ID. Please help. Thanks,

Rename report Hi, I was wondering how did you rename the attachment. I'm stuck. Please help. Thanks,