Search results for query: *

im trying to open form passing few criterias and i can't seem to find a way to find a way to select records that are dirty. DoCmd.OpenForm "frm_purchasereqedit", , , "[StaffID] = Forms!frm_LogIn.txtStaffID And [budgetkey]=isnotnull" i've tried doing [budgetkey]="dirty" and so forth but it's...

I have a form where I need to make sure the amount does not exeed it's balance. So I have this if statement but it seems to not work properly. If Me.txtOEA > Me.txtreserve Then MsgBox "amount you wish to transfer exeeds the balance" Me.txtOEA.SetFocus Exit Sub End If txtOEA...

I have an unbound text box (format: Currency). Yet for some reason numbers are being displayed as normal number field. Can anyone tell me what's going on?

I have a pop up form where users select criterions to populate a report. User first select their name and listbox will requery based on their name. from that listbox, user can select items they like to see on their report. it seems to work fine if user only selects one line but im getting "no...

i've been trying to figure out a way to run an update query at 2am every day. is this possible? if so how? thx in advance.

im trying to populate report based on users selection of name and date range. user selects name, from date, and to date and then report populates. one problem, user must select date ranges to view the report. is there a way to set it so that if they leave "fromdate" and "toDate" blank and will...

i have few update queries that run after a cmd button is clicked. at first everything seemed fine but now.. it's taking too long to load. after the queries run, msgbox "completed" shows up. at first it was instanuous and now.. it takes about 15-20secs to pop up. is there anything i can do to...

my codings gotten little too complicated... i don't get why the first if statement is not working.. it seems like other ones are looping fine... Private Sub chkActual_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim lresponse As Integer DoCmd.RunCommand...

at first i had it set up so that when users open new request form, it automatically generates a number for them. in a long run it ended up creating too many blank forms so i have decided to assign the number after they have finished filling out the form. so i have below coding in after save...