Recent content by michaeljohannes

Solved the problem. I needed to add: cancel = true below Me.WarrantAmount.SetFocus thanks, M

I tried this (warrantyAmount is my control name) in my On Exit event for WarrantyAmount. But the problem still persists. I seem to recall that subforms have different syntax like: Me!JobsTableSubform.Form.WarrantyAmount.SetFocus but that didn't work either. Private Sub...

Cheers, George. Thanks for the help. The On Exit event works, but it still 'tabs' to the next field. Is there a way I can force the user to stay where they are?

Hello Access Programmers, I have a new field I've recently added to a subform that I want to be required before tabbing to the next available field. How can I control the user's action to disallow 'tabbing' over this required field? (ie, if they try, they get an err message pop up saying...

Hey Pbaldy. I thought of that and purposely disabled the wireless adapter. The only possible network connectivity option is through the LAN connection. Any other ideas? M

Thanks for your reply, Malcy. I had a look and the folder that houses the database IS shared. It's strange because all the other XP computers don't have any issues with it at all. It's very odd. If you come up with any other ideas, I'm all ears. Thanks, M

Hello, I am having a heck of a time getting a Dell laptop with a WIRED connection to connect to an Access 2007 database. After foolishly connecting to this database wirelessly, I took the wise advice of members here to never connect an Access database using a wireless connection due to Access'...

Hello Access Architects! I am in the process of creating a small-scale database (suitable in Access) that tracks my client's music collection. This is not a CD collection but rather a sheet music collection for a community choir with 20 - 25 singers. To make things really simple, I will have a...

Cheers, RG! I appreciate your help!

Hi Mark, Thanks for the speedy reply. Yes it is bound to a table.... And I do realize it's redundant data (and it bugs me so!!) But it's what my boss wants... I get the idea that if data<>null, then the same information is available to me (as a sort of developer or DBA). But to the average...

Hello, Can anyone suggest a possible solution for the following problem? I have a simple popup form that has a checklist of events the my company wants to keep track of. Basically, I have 5 check boxes. Next to each of these check boxes I have a date column. ie checkbox1 represents (Did client...

Thank you for your responses. I think I will use a wired connection instead of wireless. I appreciate the very quick responses! M

Hi Bob, Thanks for your advice. I'm starting to think that it's a terrible idea to have this connection via a wireless connection. Is there anything I can do to make it work (wirelessly)? Otherwise I will simply have to "plug in" when accessing the DB. Cheers, Mike

Hello, I found a somewhat related thread but thought I would post a new one just in case my problem happens to others who were 'forced' to "upgrade" to Windows Vista Home Basic when buying a new machine.... Okay, no more complaining, here's the issue: I have a small (8 MB) Access 2007...

Thanks, Bob :)