Recent content by ccflyer

I think I found my problem... my users were hitting enter after each text box to go to the next. I have a calander control that was set as the next tab location (when I thought there were no more)... still a little strange, but when I changed the tab index of the calendar to a higher number...

No luck... I tried changing my code to that, but it still allows the user to scroll to a new record using the mouse wheel. -Chris

Hey Guys, I'm trying to implement the MouseWheelHook method in order to disable mouse scrolling on one of my forms, but I can't seem to get it to work. Here's the link to MouseWheelHook: http://www.lebans.com/mousewheelonoff.htm#Tips%20from%20Users%20of%20MouseWheelHook This is what I've done...

Oh, ok... I see. I fixed the usage, now it works!! Thanks! -Chris

Ok... here's what I've got so far. Right now, when this is run, I get the following error: Run-time error '2001': You cancelled the previous operation Here is my code so far: Private Sub InvoiceNumber_AfterUpdate() If DLookup("Invoice_Number", "LOE/Facility Construction - Updated"...

Hey Guys, I'm working on an invoice database and have run into a little snag due to my lack of VB knowledge. I was wondering if you guys might be able to help out. I've got a invoice entry form which has two text boxes [name] and [invoice number]. The user enters the name first, then the...

Hey thanks Keith, that was what I was looking for. -Chris

Here's how my forms look now... Here

Hey guys, I currently have an Access database designed to handle daily invoices for a company. This database has been in existence for a few years now, and I really want to revamp the look and feel of things (i.e. the forms). I was wondering if you guys would post some pics of your...

Thanks RV!!, that worked perfectly. -Chris C.

Ok, I see what you are saying now. Thanks, Chris

RV, what do the # signs do?

Hey guys, I've got a form that allows users to enter invoices into. On this form there is a field where the user enters the date of the invoice, and it is in turn stored into in a main table. This field is called [Invoice Date]. I want the current date to be automatically entered into this...

Hey neileg, That sounds like it would probably work. I know how to the two tables together, but how do you return a record only if it is present in both?

Hey Everybody, I have 2 tables, one called [Addresses] and the other called [2006_Contacts]. The table [Addresses] has a number of various fields relating to contact data of people. The [2006_Contact] table has 2 fields [Last Name] and [First Name]. I want to run a query that pulls the...