Recent content by Ranman256

we have 2019 & 365. the update fixed all of them.

Microsoft did an update that caused ours to never quit too. Run the latest update from them, it now corrects it.

you can use a tv as a monitor, plus the Smart Tv's (usu all of them are smart now) will have apps to stream various services: netflix, prime, etc. stream from devices smart tv's now at walmart in 98" size

The relationship has nothing to do with the combo box. is the combo box used to Load the record? or are you just puting data in a field? normally set the combo box to a query from 1 TABLE, that has 2 fields: ID, fieldForUserToSee set the column count = 2 set the column widths to like: 0.5;1...

add both versions and your app will work for everyone ,64 or 32 #If Win64 Then 'Public Declare PtrSafe Function Private Declare PtrSafe Function GetSystemMenu Lib "user32" (ByVal hWnd As Long, ByVal bRevert As Long) As LongPtr #Else Private Declare Function GetSystemMenu Lib...

we have some of these, only certain users have permission to the folder (those needed) the BE is 'hidden' the BE can only be opened by certain admins. the FE & BE have no shiftkey bypass. so it's pretty safe from internal users.

paste the code into the form module area put a button on the form to run: Pick1File to pick the text file you want to load. it will then parse the file to fill in the boxes. rename the form box names to YOUR CONTROL NAMES Option Compare Database Option Explicit Public Sub Pick1File() Dim...

this will collect a values into a list. You decide where to put it. 'return a list all field results Public Function getListOfVals() Dim rst Dim vWord, vList const dbOpenSnapshot = 4 Set rst = CurrentDb.OpenRecordset("select * from qsMyQuery", dbOpenSnapshot) With rst While Not .EOF...

if you cannot access the server file, then add record locally, then export to excel to be added later: 'see if you can connect if Dir("\\server\folder\myDb.accdb") = "" then 'export the record to a folder to be added later when you have connection vFile =...

int the subform properties set LINK MASTER FIELD and LINK CHILD FIELD to that field.

on that pc, it might be a protection issue.... set enable all macros: set Trust center settings: access menu: File, options, trust center, (left pane) trust center settings btn, (right pane) Macro Settings,(left pane) Enable all macros

why convert? I still use old .mdb because they still work.

not the close, but you can CANCEL the close with the Form_Unload event. or do stuff before the close.

I have never needed any report event except ON PRINT. this worked for everything.

FILTER spelled wrong. but you dont need to set filter = "" if you are gonna turn it off. So no need for it.