Dbar10
Last Activity: Jan 30 '09, 02:40 PM
Joined: Nov 2 '08
Location: Blue Springs, MO
-
Thank you vrey much. this worked -
thank you, that did it.Leave a comment:
-
Sifting out 2 indentifying numbers in a report detail for labels to a sum
I have a tricky problem. I have a report that contains information about amounts paid for service and they have a RANumber that on each line with the amount. Then in the invoice header I am showing a text box with the total values for each of two RANumbers. I am getting the Sum of each of the two RANumbers just fine with:
RA1Sum :=Sum(IIf([NPI]<>1780694984, 0,[TotalPaid]))
RA2Sum:=Sum(IIf ([NPI]<>1649307471, 0,[TotalPaid]))... -
rpcilli,
I amworking in an Access mdb. I can't find what you are talking about. Can you help me?Leave a comment:
-
New Record command Trouble
In my main form I have a [LastName] field that I can scroll with my mouse to advance to any name. I have put code in this field so that On Lost Focus the cursor moves to a new record in subform [UnitsWorkedQuer y subform]. My problem is I can't click back on the LastName field and scroll because the scroll function is remaining in the subform. I didn't realize that when scrolling with the moouse it loses focus so the cursor remains in the subform.... -
Thank you ChipR This will work for what I need.Leave a comment:
-
Nico, I am still having trouble. I applied your solution last night but I had it operating on the LostFocus command. I found that the cursor stuck in the new record of subform. I moved the code to the AfterUpdate action and the cursor does not go to the new record in the subform. It goes to the first record in the datasheet instead. I don't understand why it worked on lostfocus and not afterupdate. Can you help me?Leave a comment:
-
Capital Letters in a field
In Access, there used to be a way to Set the first letter in a field to automatically UpperCase in a form or table to override a lowercase entry. Does anyone know what that is? Thanks -
Have lost control-Please help
In my main form I have a [LastName] field that I can scroll with my mouse to advance to any name. I have put code in this field so that On Lost Focus the cursor moves to a new record in subform [UnitsWorkedQuer y subform]. My problem is I can't click back on the LastName field and scroll because the scroll function is remaining in the subform. How can I regain control? Thanks
Part 2: I tried moving the above command to AfterUpdate... -
Nico, Thank you very much. It looks like I misunderstood. Your solution worked great, I really appreciate it.
Dbar10Leave a comment:
-
Nico, I think you missunderstood me? I don't want to duplicate a record. When the cursor lands in the subform, it lands on the first existing record in my datasheet view. I don't want the user to have to hit the new record command to get to a new record. I want the cursor to land on a new record after it rusn the requery. Can you help me? ThanksLeave a comment:
-
That works except
Thank you! Except the cursor lands in the first record of the subform. Can I get it to land on a new record? ThanksLeave a comment:
-
Need cursor to go to next field after requery
I have a form with several subforms. In the main form I need to run a requery for several subforms to update info. But when I requery the cursor goes back to the top of the form. I need the cursor to end up in the next field after the field that contained the requery command. I have done this before but I can't remember the code. Can anyone refresh my memory? Thanks
Assitional Info:
Main Form = Billing Work Form
... -
Awesome
What was I thinking? Thank you. That worked great.Leave a comment:
-
Need help with Search Engine for my form
I am working on a form in my application for a Worker Profile evrything is working fine except the Search Box. I have to be able to search on two criteria. One is the WorkStatus i.e. Active, Inactive,etc. and 1 of three other choices. First Name, Last Name or SSN. I have pIaced 4 unbound text boxes on my form tied to the select query that pulls all the records called Work Add/Edit Query. I can run with the status and it works fine but how do I include... -
Thank you. I only have this in a query in Access. I don't know where to put this code. Is it in each of the unbound boxes? Sorry, I am not well versed in VB. I can do simple things, but can this be done in a select query?Leave a comment:
-
Form Search Engine - Please help
I am working on a form in my application for a Worker Profile evrything is working fine except the Search Box. I have to be able to search on two criteria. One is the WorkStatus i.e. Active, Inactive,etc. and 1 of three other choices. First Name, Last Name or SSN. I have pIaced 4 unbound text boxes on my form tied to the select query that pulls all the records called Work Add/Edit Query. I can run with the status and it works fine but how do...
No activity results to display
Leave a comment: