Search results

The code here worked fine. No more error. Thanks to all for the help, James

I don't get the error when I insert a 'On Error Resume Next' before '.RowSource = .RowSource' But then I'm not sure if that's a good idea?

Yes: Me.Bookmark = .Bookmark

I have a single record form that I placed a List Box on. The form and the List Box are based on the same table. I'm synching selected value in the list box to sync with the form's date using the following code in the After Update of the List Box: Private Sub lstListing_AfterUpdate() Dim rs...

The thing is Access has always honored the value I put in 'Default database folder. This is for everything I do. Whether it be saving as accde, open database, or backup a databse.

I do need do browse to the folder again.

Yes, I know I need to browse to the folder. That's my point. It wasn't like this before.

Windows 11 Access 2019 MSO (Version 2409 Build 16.0.18025.20160) 64-bit.) I don't see any recent updates for Access. I usually just open my database(s) from the Access home screen.

For some reason now, when I backup or create an .mde, Access is not using Default database folder that I have set in Access Options. It's using the users Desktop folder instead. Any Ideas? James

Microsoft® Access® 2019 MSO (Version 2407 Build 16.0.17830.20056) 64-bit

This was working fine before. I set the default database folder for a long time now. Even when I click Browse next to the default database folder it opens to "usernane" \desktop.

So, this is occurring because of a change ms has done?

Huh?

For some reason now, when I backup or create an .mde, Access is not using Default database folder, and I must browse to the folder. The in Access options the folder is correct in the Default database folder but when I click Browse it it brinks up <username>Desktop. Any ideas, James

So, should I change all effected text box fonts to Calibri Detail?

Version 2309 on Windows 11

This is odd. My continuous form text box font name to Calibri. Bit, after opening the form in form view the font gets changed to MS San Sarif 11 point. When I change the font to any other font it's ok. Only when I set it to Calibri does the font revert back to MS San Sarif. If I set the font to...

Actually I changes the prefix to 'opt' because I'm using 'frm' for my forms name prefix.

I found it. In the Select Case I needed to put the Option Group name. Seems ok now.

I'm using the following code: Private Sub frmReminderFilter_Click() Dim strFilter As String Select Case Filter Case 1 'All records strFilter = "SELECT * FROM tblReminders ORDER BY ReminderDate, ReminderTypeID, ReminderTime, Reminder;" Case 2...