Search results

I use the naming conventions on combo boxes, list boxes and command buttons. I guess it's just a matter of naming them properly.

Just wanted to let everyone know I found what caused the issue with the Error code 438. Found that for some reason I changed the 'Name' of the control to 'Title.' Still don't know why I would do that. Changed the Name to DvdMovieTitle and it works fine now.

The problem with that is this is a split form. Without the SetFocus I'm forced to click in the first field even though it is the first control in the Tab Order. After clicking the 'New' button, the focus goes to the datasheet even though I set it to Read Only.

I'll import into a new database. I really didn't think of trying that. I do compact and repair frequently, especially if I'm making changes to all my forms. Oh, well. Thanks for the insights. James

Now I get 'Method or Data member not found. I have this cvode on another form and it works fine: DoCmd.GoToRecord , , acNewRec Me!Listing.SetFocus I believe it was a corrupted form. (Which seems to be a recurring theme with me.) I found a backup with the form from 4 months ago and the thing...

I've been using this code for years to add a record. Although it's been a while since I used it on this particular table and form. The form is a split form. Code: DoCmd.GoToRecord , , acNewRec Me!DvdMovieTitle.SetFocus When I remark out the SetFocus line no error. This same code, except for the...

Ok. I'll do that. What else is odd that when I show the QAT below the Ribbon it's fine. Thanks, James

Odd. I have 4 items in the Quick Access Toolbar. When I do not have a form in design view all 4 are visible. The moment I put a form in design view the Toolbar only show the firs 2 item. Isn't this sort of defeating the purpose of the Quick Access Toolbar? Not in Design View: In...

When I initially placed the 3 command buttons on the form I used the ribbon-Design-Command button and simply placed it on the form. I then copied the button to the clipboard and pasted twice to create the other 2 buttons. Using this procedure seemed to be the cause of the spacing commands to be...

I created a new form and placed 3 command buttons on it. When I select all 3 to space them all spacing commands, horizontal and vertical are disabled.

I don't seem to have the update yet. I'll keep looking for it. James

https://support.microsoft.com/en-us/office/access-crashes-when-opening-zoom-box-with-shift-f2-853718bd-a341-468c-924e-af0b57d3fa0d#:~:text=If%20you%20try%20to%20open%20the%20Zoom%20box,available%20in%20Current%20Channel%20and%20Current%20Channel%20%28Preview%29.

Yes I have. I binged the issue and this seems to be a issue they are ware of. According to the article ther is supposed to be a fix in the next update on the 8th (today).

When I try to zoom in the Record Source in the Property Sheet Access closes. No error, nothing. This happens in all forms and all databases I have tried and happens when I press Shift-F2 or right click and select 'Zoom.' Any ideas? James

Actually I wasn't setting the focus to a button. I created a unbound text box called txtDummy and set the height and width to 0.003. In the on close of the editing form: Forms!frmMySplitForm!txtDummy.SetFocus

I have a split form with record id as the first column. The id field 'Display as Hyperlink' set to screen only so when I click on it and editing form opens on that recotd. On the OnClose of the editing form I requery the underlying form so the records are refreshed. Problem is, and this is...

I couldn't find it in the Object Browser and thought I was simply missing something. I'll just do it manually. Thanks, James

I'm using the following to set certain properties on a SplitForm datasheet: Public Function DataSheetProperties(frm As Form) frm.DatasheetFontName = "Ebrima" frm.DatasheetFontHeight = 10 frm.DatasheetFontWeight = 700 frm.DataSheetRowHeight = ???? End Function I'm getting...

That seems to work only sporadically or not at all. I can use the link's instructions if and when I get bored of the current datasheet font..

Gasman's link is fine but I will need to do this with every one of my splits. I found that I need to force a save after changing the font in the Function. If I change the font, open the form and press ctl-s, close the form a reopen it the datasheet honors the new font. I was considering using...