Recent content by benzan

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

nvm. solved it using expression builder

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?

im not sure what i have is correct... c: path = %PATH%;<c>:\windows\command;<\\pac0031>:\<\\pac0031\public\shk>;<c>:\<C:\Program Files\Microsoft Office\OFFICE11> start /wait msaccess.exe "<\\pac0031>:\<\\pac0031\public\shk>\<Budget Monitor v.I>" /x "<autoRunQuery>" it seems like it's...

first of all, im not sure about the drive name and path.. so i moved it to my desktop to test out the batch file. it seems like it's doing something but I don't see how this method runs the updqte query. doest this thing only output data to a text file?

Im trying the method that's explained in the post you have requested but im quite confused. im trying to follow this method. Step 1. Create a macro that will run your report using the actions "OutputTo" and "Quit". When you select the OutputTo action format, file-and-path, and encoding...

nm found a good example from nw database.

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.

oops. typo. i wanna make the date range *optional*

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

by compacting do you mean like archiving?

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

perfect. thx remou.