Search results

Sorry spikepl, I did not understand that. What would you suggest I put instead of the below: Dim objOutlook, objOutlookMsg, objOutlookRecip, objOutlookAttach As Object I did this trying to replicate what I found on the Microsoft Office documentation here (sample code below). ' To use this...

I simply (1) used objects instead of Outlook specific objects, and (2) replaced constants with their numerical values. '-------------------------------------------------------------------------- 'The following procedure sends the email...

Guys, I really want to thank you all! I guess it took me some time to understand what late binding was about. Because I imagined the lines of code depending on the Outlook library wouldn't work, I was quite reluctant to switch to late binding. I just adjusted my code based on pbaldy and...

Does anyone have experience with methods 1 or 3, if possible? :-0 :confused:

Thanks to both of you. @Rx: I'm not sure this is even realistic for me to go into this territory. Virtual machiens/desktops... In this case a manual copy/paste of the OLB file would be easier -- provided I have to do it on a handful of computers. @Paul: If I go for late binding, does it mean...

Dear all, :D I have been searching the web for an answer, I might have found it but I still don't get it. :banghead: I'm trying to deploy a database to several users, and I would like to make sure they all have a valid reference to the Microsoft Outlook Object Library so as to be able to send...

Thanks SpikePL, useful comment.

Thanks, it actually worked with the AfterDelete Confirm event in the end. :)

Oh no, I simply want to right click on the row and delete.

Thanks, I've tried puttin your chunk of code in the AfterDelConfirm event of the subform, ended up stucking the execution at the line Me.Requery.... I had to force stop Access with Windows Task Manager :( Sorry, wasn't sure where you were suggesting I put the code you gave :o

Thanks burrina. The module 1 code goes like (sorry it's kinda long): Public Sub tblUpdateLatestDocuments(Optional VesselID As Long, Optional DocumentID As Long) '------------------------------------ 'put a counter to time sub execution Dim t As Long t = GetTickCount...

Hello everyone :) -- I haven't been able to figure this one out myself :( -- I'm trying to execute some lines of code right after deleting a record in a subform, with a right click on the row I want to delete (the idea is that if a record is deleted the other ones should be updated by...

Sorry quys. I just solved the problem :S This: rs.AddNew .. was unnecessary. :)

Hi people :) It might be an easy one but I just wasted the past hour deciphering through my code in order to solve the run-time error '94' that I'm getting when trying to execute the following code: :banghead: Private Sub cmdUpdateDates_Click() '################################### 'This sub...

Thanks for your reply Mihail. [1] Is this really a different database relations setup than simply linking 5 times to the same tblContracts table? In other words, do you simply do this to make your database easier to understand, or is there a dramatic database structure change?:confused...

Dear all, After some more thinking, I'm wondering whether the relationships between tblTimesheetLines 8-1 tblEmployees 8-1 tblContractors 1-8 tblContracts, and tblFWO 8-1 tblContracts See relationships map.zip for a visual of this. I highlighted the two series of relationships that I think...

Thanks Sergeant! Your answer really helped me :D

Thanks Galaxiom and Lightwave for the suggestions. :) In the future, I'll try to normalize my table field names as much as possible. So that somebody that looks at it for the first time doesn't have an extra layer of complexity to deal with. Gemma-the-husky also gave me a great hint, I realize...

Thank you Galaxiom. I was actually concerned with the possibility of having redundant relationships in particular. Relationships with referential integrity can be constraining when I go further into my database development, so I thought it might be a good idea to get read of the useless...

So for a serious Access user, would it be advised to turn the NameAutoCorrect feature off?