Search results

Hello, getting a run time error 13. Thank you

Hello. I have given a look at Bob Larsen's thread and found it very useful. Before I finally decide to abandon my idea I would like to share what I have come up with and know if its something still possible to do or if I am completely going in the wrong direction. I apologize for my confusion on...

Thanks you both. I will give a look and take your advises.

Hello. I have a database that I periodically requires some updates to either a form, a query, etc. The db is used in different offices and to avoid other users to open the program in design view and cause problems, I was thinking of using the transfer object method. For this reason I have...

Hello. I am planning to design a form that can be used to set appointments for the customers listed in my db. Data related to customers is stored in tblCustomers and appointments time/date is stored in another table, named AppTime. Appointments should be available from 09:00 to 05:00 with slots...

Hello friends, I am back for some other help. I have some vba which exports data to Word via bookmarks: <Dim objWord As Object Set objWord = CreateObject("Word.Application") objWord.Visible = False objWord.Documents.Add ("C:\MyDocs\MyTemplate.dot")...

Thank you for your great help.

Will try. Thank you

Thank you. But honestly I have never heard about it.

Hello friends, back for some other useful help. On a form I have placed a button to go to a new records: DoCmd.GoToRecord , , acNewRec. It cold happen that users don't want to save this entry or accidentally erroneously clicked on the New Records Button. Is there a way, you can recommend me to...

Thank you

Hello friends. I would appreciate any help with this small problem. I have designed a form with a records source to table "tblCustomers". This table has fields like, ID, LName, FName, DOB, etc. When I open the form, it automatically goes to a new record: DoCmd.OpenForm "frmCustomers"...

Thank you. That works fine.

Hello friends, I have an unbound text box on a form named Age with the following code in the control source box: =DateDiff("yyyy",[DOB],Date()) & "." & Int(Format(Date(),"mm")-Format([DOB],"mm")) Unless I type a DOB in the appropriate DOB Text box, the Age text box shows the following error...

Fantastic Arnel. Great job as always. Thank you

Thank you Arnel. I have made the change to the cbo row source as recommended (C:\Folder) but getting an error message: The expression After Update you entered as the event property setting produced the following error: Variable not defined. Thank you

Hello friends, Searching around, I have found a great code to create a form that displays folders and files directly from MS Access. I know is simply replicating file explorer, but I would like to customize this code and having problems. On the form I have a cbo and two list boxes. The combo...

Hello, I have been exporting date from a form to MS Word with no problem, using bookmarks in the word file and appropriate VBA: On Error Resume Next Dim objWord As Object Dim strPath As String strPath = DLookup("[TemplateLocation]", "TablePath", "[TemplateID]='" & Me.[TXTPATH] & "'") Set...

Hello, can you please help me with the following code I have places in a unbound txtbox: =DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd")) I have a date of birth control. After I type the DOB, I would like to unbound text box to show the age format as years and month...

Great. Thank you