Search results

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...

I'm using the following to set the font name for split form my datasheets: Public Function DataSheetProperties(frm As Form) On Error GoTo DataSheetProperties_Error: frm.DatasheetFontName = "Calibri" frm.DatasheetFontHeight = 11 frm.DatasheetFontWeight = 400 On Error GoTo 0...

Ah, I see. It's working out fine.

I haven't found one, yet. I'm not looking for a date picker. Just a Month view calendar to reference on my main form.

I changed it and saved it 10 times. Actually it only reverted to the other font when I selected 'Calibri' 12 point. When I choose any other font size it's fine. Anyway, I imported the database into a new one and the problem seems to have cleared up.