Search results

Good day, Recently I create a new project that has 40k row data, it has 5 network connections, using old computers, installing 2010, 2013, 2016 MS access. On those days that 5 users work together the system start to load slowly, I've tried to reset sub forms and combo and queries but then...

Thanks, for the tips, codes, ideas, it helps a lot to extend the use of MS access in the unique way as one creativeness reach the peak. Dim fd As Object Set fd = Application.FileDialog(3) With fd .Title = strWindowTitle .Filters.Clear If Forms![Form: Tab...

Good day... Could anybody share help, to give tips on editing VBA While acForms default menus is disabled.

Good Day... May this post annoying to AWF but all I need to know if this Design of acForm is accepted or not. Alternatively, maybe there is worse than this. \\: See attached acForm

Good day to everyone... I have created a form in which command could locate the db.currentname The purpose for this, is to unlocked the password of an Accdb file I found it successful during “password” delete and change, That is applicable only if I know the current “pwd” My single...

I found it interesting, a craft of Isladogs "IMAGE VIEWER" but when i use it and add to my Accdb an errror occured with this lines below, (but i'm still working to fixed the error, still hope I could do it) Dim F As /"FileDialog"/ Set F = Application.FileDialog...

Ive been using different approach for objects navigation, but this one on current is unique. I made little modification for (open/close, max/min), looks like something i missed. My idea is to count the number of tables on_click "Tables" button, as table names shown on the list, i wish to...

I love to play the Number Puzzle. This game is somewhat short term memory and past solving. It needs quick series thinking. Ive' done someways to make it possible. I only use click command through the shuffle numbers, using textbox, 1 to 16. My look out is how to make it possible using arrows...

>how to begin with this project? (find source) >locator of viewed file, other computer viewed and online https... >make a split form, upload source list >it works no much codes used

>just try make calculator on acform >excute some math operation, where answer display on table

>applying few command to achieve >for typing (start lesson) >generate also word list (might add meaning as dictionary) >CAPS/ no

MSaccess could load several forms created >sometimes we need to open it in a simple way >thus making a small form would contain of selection box for favorite acform >i just try it, for easy search

MSaccess could make movie viewer as many as you want as it can >i used this long enough in times i need to watch favorite movies >this can be done in any form we wanted to >maybe you would try sometime too

>it's been long time, i look for games like on Accdb >yes it can be >i edit some of it's mode/messages >it's a nice accdb game

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

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

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

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

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

>(access web browser won't work): edited, now it works... >but install Acrobat Reader then reactivate office/windows >works well, done >now could use both Web and Adobe