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 use the following method: 1.) Create your button on the form 2.) In the OnClick event of the button put the following code: me.portionval.visible = True Calculate Add the following procedure in the form Private Sub Calculate() Me![portionval] = Nz(Me![mainarea], 0) *...

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

Just a quick post to say thanks to Cajun~! I have been looking for this solution forever. VERY easy to implement. A star and many more for ya!

I have a very similar situation, where I need to look up users that have a "position" = "Dealer". I tried the following with no luck? = Nz(DLookup("fullname", "tbluser", " POSITION='Dealer'"), "N/A") Thanks as always for you help!

In this case it is a literal. Thanks PHV

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.

Howdy Tom: Thanks for the response. Placing the code in the control souce caused the same result. Cheers,

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

This is a classic example of looking at the data too long, and assuming the error is within Access. It took someone on the outside looking in to point out the same thing. The clients hand written report showed 1.51 and the error was there, not in the calculation. You the man Duane

Any hope for this problem?

I am hoping someone can help me figure this 1 issue out. The response RAC2 works great except for the following: Int(Sum([20ENTERED]*20/500)) AS 20count, Int(Sum([20ENTERED]*20/500))*500 AS 20value, Int(Sum([20entered]))-[20value]/20 AS 20Lcount, Int(Sum([20ENTERED]*20))-[20value] AS...

Howdy Dhookom, Yes these controls are all in the details section of my report. Like all begining..... (and I say this lightly) "programmers" I had a lot to learn, (and still do) when I created this report some time ago. The report is based on a query: SELECT [TABLES Query].SORT, [TABLES...

Ok just a little modification. The Array you prvided includes "6" & "7" which I do not have a TABLENUM for. So for whatever reason "8" & "9" (label191 & label192) do not change colors, but all the rest work fine. Anything we can de here?

AMAZING!!!! Where do I send the check? As always PHV many thanks, it's people like you that help us guys out here floundering around make things work. Hats off, and a star!

Expected List seperator, I tried a few closing paren's but no luck. Sorry for dragging this out.

heres what I have: Private Sub Form_Current() t = Array("1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "P1", "P2", "P3", "P4", "P5") For i = 0 To 16 If DLookup("TABLENUM", "SOFTCOUNT", "TABLENUM='" & t(i) & "' AND Int(INSERTDATE)=#" & DATE & "#") = t(i) Then Me("Label" & (i...

Entered 2 records with no results (they stayed red). I also verified the spelling of the table name and column names in my DB. SOFTCOUNT.TABLENUM SOFTCOUNT.INSERTDATE 2 9/2005 9:05:19 AM 3 9/2005 9:05:21 AM t = Array("1", "2", "3"...