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

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.

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

im having hard time putting in my own values. since MyDbs = CurrentDb() doens't that mean i can just leave it that? and what do i put in openrecordset? tablename? Set basedata = mydbs.openrecrdset("basic Data")

so.. copy & paste and change names? and call the function like Function NewQI_Num() ?

i can't understand half of those codings >_<

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