Search results

i have encountered a situation i don't understand. i have a subform that runs some VBA on the on open event. (code takes 2 dates from textbox on form, runs report, e-mails to user.) when i open the subform independently, everything works fine, but when the main form opens, the code doesn't...

situation: form displays a value, derived from the control source (a table). this is a value which can be changed by the presence of one or more associated records in a different table. problem: the different table in question has 0 att'd records. now, it's easy enough to create a query to...

Private Sub Form_Open(Cancel As Integer) Dim sUser As String Set sUser = GetWinUserName If sUser <> "[user1]" Or "[user2]" Or "[user3]" Then Cancel = True End If End Sub "getwinusername" is a separate module. OK, so why won't this code run? i've been beating my head against this...

OK, i think i'm missing something incredibly simple here. i have a form that opens when a command button is pressed. i want for it not to open when [criteria] is met (based upon winusername). i can get the winusername w/out any trouble, but i don't understand how to tell access to use that...

version: access 2000. OK, i have what may be a fantastically stupid question. i did a search on this and didn't find anything that seemd to address it. my issue: autonumber field, sole primary key. i am adapting a legacy (non-access) db into access. it was originally an autonumber field but...