Search results

Hi, check this sample code: Option Explicit Public Sub ProcessFile() Dim strFileName As String Dim strFilePath As String Dim oDoc As Document ' Set Directory for file strFilePath = "C:\Test\" ' Get Name of .doc File from Directory strFileName = Dir$(strFilePath &...

Hi, check this discussion: isLocked and check: orders sample db quote: There are also several useful functions located in the UtilityFunctions module, such as the IsLocked function which determines whether the current record is locked. end quote! HTH Good luck

Hi, have you checked all your references (vba editor--tools--references)? Are any marked missing? Did you check the DAO object library and the word object library? HTH Good luck

Hi, you could create another macro which calls your macro and then call that macro with the windows scheduler or you can call your original macro directly with the windows scheduler: http://support.microsoft.com/?kbid=230575 This way you can basically automate the whole process without needing...

Hi, sorry for the late response. Have been quite busy latly :) Anyway, glad you got it sorted out. Good luck on future projects!

Hi, you didn't establish a link between main form and subform! Open the subforms property window and check in the data tab. You will find child and master link! You have to establish both. Since bus_Id is your id field which both contain that's your child and master link. I created it for you...

Hi, you would just need to parse the arguments given from the listbox to the open event of the form. Depending on what your values are chose on from below: If Number: DoCmd.OpenForm "YourForm", , ,"[YourID] = " & Me.YourListbox If the ID is Text: DoCmd.OpenForm "YourForm", , ,"[YourID]...

Hi, I looked at your db. I don't really know if that is your actual db or not, but your table structure is not correct. Your data is normalized. But then again you have hardly any structure or data, so I just fixed it so it works on the form, but you might want to read up on normalization if...

Hi, your attachment comes up blank. There is nothing in the zip file...at least not for me? Maybe you need to rezip and repost and make sure the file contains data. Thanks!

Hi, so you mean the ones which do NOT have a value in the date field? Use Is Null in the criteria of the query date field! HTH Good luck

You're welcome :)

Hi, check this thread HTH Good luck

You're welcome. Glad I could assist. Good luck on future projects!

You're welcome. Glad I could assist. Good luck on future projects!

Yes it might be! I would recommend using a specified method to send e-mails through Notes as Sendobject didn't even support earlier notes versions. Check this: http://www.granite.ab.ca/access/email/lotusnotes.htm and these limitations of sendobject...

You're welcome. Glad I could assist. Good luck on future projects!

Hi, the sample just shows to you how to create a simple HTML e-mail so that you can format it or do whatever you want to which other methods (e.g. SendObject) don't, as they only allow plain text. So you will have to use the code in the sample and your scenario to populate the body and the...

Hi, maybe you can clarify a little more! Why do you want to do this? Do you want to do certain maintainance things at that time and keep users out? Maybe you can explain what it is you are trying to achieve. HTH Good luck

Hi, you should actually NOT store these pictures in your db. It causes bloatation and should be avoided. Store the path of where the pics are stored instead and then use these on runtime to display your images. Check this for more: http://www.databasedev.co.uk/bound_image_report.html HTH Good luck

Hi, what method are you using to send the e-mail? Maybe you can post some code sample! If SendObject then pay attention to the end boolean syntax (false, true). The default is True, which launches the application. A False setting inhibits the client. HTH Good luck