Search results for query: *

I am trying to prevent the user from entering multiple counts for the same table (card table) on the same day. tblSoftCount InsertDate (general date) Tablenum (text) Would someone help me with a Dlookup? I want to place the lookup on the after_update event of the combobox with the...

I have a form that has a textbox containg a path. I also have an image that displays the picture referenced by the path textbox. All works well until someone deletes the image, without updating the path. This produces error "2220" "Can't open file C:\blah\blah" I would like to set the path to...

I have a form "frmSensitiveForms" that is used to track preprinted (numbered forms). I also have a subform "frmSensitiveHistory" that shows the last 15 receipt details. And this works great. I would like to click on a historical record in my subform and have the details populate the main form...

Well I thought I had the statement correct, but it only works for numbers not text? Works: = Nz(DLookup("DESCRIPTION", "TABLES", " TABLENUM='" & 1 & "'"), "N/A") Does not work: = Nz(DLookup("DESCRIPTION", "TABLES", " TABLENUM='" & P1 & "'"), "N/A") Any help would be appreciated.

Any idea how to sum this? =IIf(([wl]=0),0,IIf(([text80]=0),0,([wl]/[text80]))) Tried: =Sum(IIf(([wl]=0),0,IIf(([text80]=0),0,([wl]/[text80])))) It prompts me for "wl" value and "Text80" values? It a never ending learning curve....

I have a report based on a query that adds currency for multiple registers. The detail section is grouped by REGISTER asc. Looks similar to this (X=some value) Reg# $100 $50 $20 $10 $5 $1 __________________________________ 1 $200 $50 $120 $40 $60 $45 2 XX XX XX XX...

My users are required to enter records for 15 predefined equipment records daily. I have included 15 unbound labels with these equipment numbers on the form. As a record is entered for todays date and saved I would like the appropriate label (label186) to change from red to green. This will...

I have a report with several unbound textboxes that perform calculations. Text92 provides the correct percentage until I get to a small number (i.e 1.13%, or 0.14%). The correct value should be 1.13% and I am getting 113.05%, or value should be 0.13% and I am getting 13.33%. Im hoping that...

I have a query that works fine except the order by clause. The following order by clause I get: ORDER BY VAL([TABLES Query].TABLENUM); P5 P4 P3 P2 P1 1 2 3 4 5 6 7 8 9 10 I would like the P* values at the bottom: 1 2 3 4 5 6 7 8 9 10 P1 P2 P3 P4 P5 Is this possible? Cheers,

I have a report based on a query. This report takes the total amount of currency entered and divides into the appropriate number of straps/loose bills the user should have. The following are the currency values: Currency Value of strap $100.00 $2000 $50.00 $1000 $20.00...

Hello all, 2 questions: I have the following line in my JSP. I would like a button to populate the directoryname with "C:\DataLoad\Error <psdi:textinput label="Log Directory:" size="20" gridrow="1" gridcol="5" mbosetid="rec" mboattribute="directoryname" /> The second piece is...

I would like to display the application server in the URL on my JSP page. If the URL is: http://liadev2.light.ci.seattle.wa.us:7005/maximo/jsp/common/startcenters/startcenter.jsp I would like to display: liadev2.light.ci.seattle.wa.us On my page. As user connect to many application...

I have a small form that has two date fields and an image that acts looks like a button: txtStartDate txtEndDate Image20 The dates are used to limit the results of the report MR_CheckRegister. The following code is not working and returns all rows? CLIENTTRANS.DATEENTERED is DATE/TIME...

Access 2000 I am creating HTML help files with Robo Help. Then launching the help files in IE with the OnClick event. The following is the URL I would like to pass to IE. C:/StraightEdge/Help/Welcome.htm#Employee_Time_Off_Application.htm The first part of the URL...

I have a form that is used to set a database backup timer. Private Sub Image32_Click() On Error Resume Next Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("tblBUDirTime") If Not IsNull(Me!txtTime) Or Not Me!txtTime = ""...

I have a field PATH the stores the path to the the picture displayed. I also have a label that when clicked opens a browser dialog to select the picture, which returns the path value to the PATH field. This works fine, but causes me to go to the next record then back to my record to see the...

Access 2000 on WIn2K Have a form with two fields: Countdate = Date/time (bound textbox) defaulted to Now() Counttime = Text (Combobox with valuelist) The following code produces Runtime error 13 'Type Mismatch' after the combo (combo71) is updated? Private Sub Combo71_AfterUpdate() Dim...

After creating DB, forms, and many reports I am to the spit and polish stage. My questions: What methods have people used to ensure all text boxes, combo boxes, and other data entry fields are a consistant heigth (not length of course)throughout the many forms? What methods have been used to...

I may be going about this all wrong? Each record has a date/time stamp, this value is defaulted on the form. I have a small report search form that users enter a start date (txtStartDate) and end date (txtEndDate) with an image that has the following onclick event. Private Sub...

I have a report "rptCageinv" based on a query "qryCageInvReport", that looks at the "CAGEINVCOUNT" table. I am trying to pass the Start Date and End Date parameters to the query via a small form "CageInvReportDialog" that contains 2 unbound fields and a Cmdbutton: txtStartDate txtEndDate...