Search results

***Bump!***

I need to bump this thread again: So I thought everything was working perfectly, but now I have a random problem where I click the cmd button I use to open my Transactions form and the first time the form opens, the custom TransactionID field contians a zero. If I close the form and click to...

Wayne, Thanks for the tip! The hidden textbox worked like a charm, although it kept clearing when it was in BeforeInsert. I solved the problem by putting it in Current and checking to see if the form was opened in add mode. It's too bad I don't get to bill for each hour I spend hunting down...

I am in the process of creating a custom autonumber (I know, I know, it's not my choice. I'm just following orders). I've got it down so that the number works and increments every time someone opens a form to enter a new transaction. However, I could only get it to work if the text box is...

Thanks for the tip. I didn't realize it fired after every keystroke. I've only ever used the change event for a combo box, but it makes sense that it wouldn't be the same for a text box.

The change event is for the text box. You can change whether or not the pictures are visible from within the text box's change event. **Go with Bob's suggestions. Not only does he type faster than me, but he also knows quite a bit more! ;-)

The code would go whenever you would like the pictures to change. If you want them to change whenever the textbox is messed with, you could put it in the Change event.

I would stack them on top of each other and then write something like Select Case txtType Case Value1 Me.image1.visible = true Me.image2.visible=false Me.image3.visible=false Case Value2 Me.image1.visible = false Me.image2.visible=true Me.image3.visible=false Case Value3 Me.image1.visible =...

I've uploaded a quickly stripped down version of what I'm trying to do. So this is the form. I'd like to be able to do the following if I'm a: Managers: See and view everything in the form. All fields, populated with all data about every employee. Employees: Able to view the top half (work...

Hi, I have a form that is linked to a table and displays employee information (address, phone number, etc). It shows this information for both work and personal. I would like to set viewing privilages so that managers can view all the information for everyone, all employees can view...

RG - Thanks for the tips. I'll give that a try ajetrumpet - BusinessDays puts its result in the correct field as part of that code, so I don't think I need to assign it to anything.

Putting it in the AfterUpdate event works great. Thanks for the help! I started a thread for another validation question here that's related.

I'm back with another validation question. I've read the descriptions of when different events fire, but I'm confused as to why this one is messing up my form. I have two txtboxes: DateReceived and DateCompleted. The data may be changed at any time. If information has been...

***Nevermind. Somehow 5 posts were posted while I was typing.*** This isnt the most elegant of solutions, but I think this should work for you: If Me.notecompck = True And Me.mortcompck = True And Me.asscompck = True And Me.tpcompck = True And Me.inscompck = True Then Me.filecompck =...

RuralGuy, the control is a combo limited to the list so I figured it was ok to run the check after each change. Is this not correct? My thinking is that if a user, for example, changes the status from Open to Closed, the system would automatically fill in the closed date as the current date...

Thanks, guys. You've been very helpful. I've upped your rep points! Upon further examination, I think my loop problem is occurring because I have the form checking for consistency too many times. For example, when the user exits the DateCompleted field, it checks to make sure a DateReceived...

They are in different years, yes. I would appreciate the updated version, thanks. Also, I'm not familiar with the NZ function mentioned above. How exactly does that work and would I simply replace If(IsNull()) with NZ()?

I am using your BusinessDays function! Thank you so much for that. My boss was beside himself impressed. I just casually told him, "I know a guy." :) I hope you don't mind - all appropriate credits are given in the code. As for entering the break, I'm not sure how to do that. **Wow...

Hello, I have a form where people enter information on a new work order. Among other things, they must enter the status of the order (open, closed, dead, more info requested), the date the order was received, and the date the order was completed/dead if applicable. I'm trying to write a...

I didn't even know that was an option. It works great now! Thank you so much. As a side note, do you know if it's possible to format the combo box so that it doesn't actually have a drop down section? My thinking is that since we have hundreds of customers, I don't even want users to have...