Search results

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"

thanks for the recognition >good luck with your project

good luck with you project >thanks for the like reaction

several ways to do it >try this way >use query to sql SELECT [PhysicalTherapy].groupyear, First([PhysicalTherapy].sessiondate) AS FirstOfdate, Last([PhysicalTherapy].sessiondate) AS LastOfdate, [LastOfdate]-[FirstOfdate] AS diffdays FROM PhysicalTherapy GROUP BY [PhysicalTherapy].groupyear; >but...

quite hard >address, city, state, and ZIP code. >using "BeforeUpdate" could be possible, where there is 1 field that received your old "address, city, state, and ZIP code" as field1 >could be the other field received your new "address, city, state, and ZIP code "AfterUpdate" as field2 >in a...

>sample codes, very useful Dim strWhere As String Dim lngLen As Long If Not IsNull(Me.SelectPropertyName) Then strWhere = strWhere & "[PROPERTY TYPE] like ""*" & Me!SelectPropertyName & "*"" AND " End If lngLen = Len(strWhere) - 5 If lngLen <= 0 Then...

wow very prompt >add this to my filter mode Dim strWhere As String Dim lngLen As Long Me.Filter = strWhere Me.FilterOn = True

welcome tammy >express out your vision for sure you shall meet the best result with your own way >thanks for the like response

very important data banking >if for this year you can make SplitTable for that as your server for 2020 attendance >well for 2021 separate SplitTable set on your link table manager, i used this method cause i also have data banking over 10k >on the run your 2020 SplitTable for 2021 is unlinked...

hi nice query run >try the sql of query below SELECT Table1.PartNumber, Sum(Table1.SumOforderedqty) AS SumOfSumOforderedqty, First(Table1.orderdate) AS FirstOforderdate, Table1.PartNumber, Last(Table1.orderdate) AS LastOforderdate, First(Table1.SumOforderedqty) AS FirstOfSumOforderedqty...

quite tough >your field [Line Status] should have a partner fieldname ="CountRecieved" then if [Line Status] = "Received" then [CountRecieved] =1 >with that dataflow [Text35] = Sum([CountRecived]) >try that simple way, i used it with my complex Forms