Search results

This one has been a real head-scratcher for me. I keep getting and error message saying "Object required". I have been over and over this a hundred times but can't see the error. Any help would be appreciated. Private Sub btnEMailTechnician_Click() On Error GoTo...

Welcome to AWF! Wayne

Welcome to AWF. (From a fellow Canuck!) Wayne

Welcome to AWF. Hope you find what you're looking for here. Wayne

Colin, You're right. That works for all the words in that string. Wayne

Here's the simple code I use for proper case: [CODE]Private Sub ClientCityName_AfterUpdate() On Error GoTo Err_ClientCityName_AfterUpdate 'To change the City Name to Proper Case If Me.NewRecord Then Me.ClientCityName = StrConv(Me.ClientCityName, vbProperCase) End If...

I see you have both an alpha and a numeric component to your part number. Considering ONLY the numeric portion of it, is it possible that there could be duplicate numbers? (for example: SM-000125 and DC-000125) Wayne

Welcome to AWF. Hope you find the help you're looking for. Also Wayne

How do you get this to work if the records you want to display in the HTML table in the body of the email are coming from a different table or sub form? I've been playing with it for a couple of days now, but can't seem to get it to work. Any advice would be appreciated. Wayne

You say you have your DateTime field set to a default value of Now() - correct? But that is only for initial data entry. You also said that this is a combined field of Date and time. Then possibly this code might not work. What type of field is it? Is it a Date field, or a general text field? Wayne

I'm glad it meets your needs. As for .FindFirst, it will loop through the records and simply find the first record that matches the criteria (in this case - today's date). In my code, I wanted it to open at the first record with today's date as the Service Date, and if there were no records with...

I have found (after trying a few other possibilities) that Uncle Gizmo is right - it is best to use the same form for both editing existing and adding new records. I have custom navigation and search buttons along the bottom of the forms to navigate and find existing records, and separate...

Hello Albert. Welcome to the forum.

Welcome to the forum. Wayne

Hi Mark, I was just trying to be able to access the BE tables from either my laptop at the cottage, or the computers at home, that's all. It wasn't for multiple users, just an easy way to access my db from anywhere. My original thought was to put the BE on my OneDrive, and installing...

My father was an RCAF officer, and like the RAF, their motto is Per Ardua ad Astra, Latin for "Through adversity to the stars" . That's why I asked. Thanks for the tip. I will check it out. Wayne

Hey Lightwave. Just looking at your user title. Are you former RAF? Wayne

Thanks CJ. I just moved everything back to the hard drive, and all is well in the universe again. Wayne

Didn't your Mama tell you to play nice with the kid next door?

Thanks guys for the input. I was hoping for a cheap, and easy solution, but it doesn't seem possible. I did try the BE on my OneDrive, however, the database becomes read-only very quickly. I'm not sure I want to migrate to SQL or Azure yet. Anyway, I appreciate your thoughts on the matter. Wayne