Search results

succeeded >32682 highest (rows for my accdb error, only 3038): edited >glad i fixed it >i used the codes posted at Mendip Data Systems

succeeded >32682 highest (rows for my accdb error, 3038) : edited >glad i fixed it

wow >i use 2016 version >thanks, i'll see the content

thanks >the old version is fine >i already see the new link >i needed that error list

Accdb has prompt error message when something has missed >using list of access error: error number and error description would help access user identify every error and probably find best solution posted on internet

i also use error list >could determined error# codes

great >i used part of it now >make codes selection for every command

>this was great, i been able now to move my Main Form any place on desktop, no more Accdb_Window background, can control it already >thanks again AWF

On accdb open the window always show at the back of first Form opened as background >i keep searching how to hide or minimized >finally found: isladogs has posted something in the year 2017 >but was qouted from Dev Ashish >'Usage Examples 'Maximize window: '...

yes sir >i try to post that one, just this day >3 votes with my cast

Increase Accdb file size capacity

nice sir, copy

where to start and how to do it orderly?

hello everyone >my question is? do we have the authority to ask and suggest to "microsoft"/"access" for the satisfaction of access users needs?

macro is nice to use >but you could convert that macro command to codes >just try the codes below DoCmd.OpenForm "your_form_name_here", acNormal, "", "[ID]=" & [ID], acEdit, acNormal >i always use these onclick to ID number as hyperlink

>use this sample codes for hide command DoCmd.ShowToolbar "Ribbon", acToolbarNo 'Yes or 'No MsgBox "Ribbon, acToolbarNo; NavigationPane OpenNo" CommandBarControl.Visible = False DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide >no need to restart this time auto...

>when you need to open you ribbon and navigation pane >try the codes below DoCmd.SelectObject acTable, , True If Not (objPane Is Nothing) Then objPane.IsCollapsed = False End If DoCmd.ShowToolbar "Ribbon", acToolbarYes 'Yes or 'No MsgBox "Ribbon, acToolbarYes; NavigationPane OpenYes"...

>for XMenus whereas: command=XMenus; you cannot edit your form using right click, unless you have click button for Form designView [Command Prompt] = "restrt" On Error Resume Next CurrentDb.Properties("AllowFullMenus").Value = False If Err.Number = 3270 Then Set prpNew =...

>try this codes sometimes ...you can simplfy it, if you apply this codes, you need to restart your open database, so you have to add codes for db auto restart "[Command Prompt] = "restrt" need codes to insert for shutdown and start again, or restart codes, or manual close then open again...

well if that would be, so let it be >i guess yes "recordsets are too small"