Search results

Thanks for the quick reply and it worked!! I greatly appreciate your help!!

Hi everyone, I have a program that I have created in Access 2007 that stores all of our drawing numbers with a letter following the number to cover the revision level. For the longest time I've been wanting to add an auto number button on the form so that I don't have to find the last record...

Hi everyone! I've created a form that populates data from my main table. I am trying to create an AutoNumber button that basically finds the last record in my table and then starts a new record following that number. The problem is that the main index column that I am trying to search is not...

Thank you, that works great!!

Hi, I am using the the following code to get the windows user name: Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String ' Returns the network login name Dim lngLen As...

Thanks pbaldy, I installed the update and all my problems have been resolved! Wow what a bug!!!:)

I installed the SP1 update and all my problems were fixed!!!! It must have been a bug. Thanks for all your help!!!

I am refering to the textbox name not control source. I renamed some of them to differ from the control source name and also just changed the code to this orientation so that there wouldn't be any conflicts: Forms![Form]![Notes].Enabled = True Still nothing at all happens. I don't understand.

:confused:It seems that no matter what code (expression) I apply, my form doesn't change. Is there some kind of link or key command I need to specify or set to execute these commands I am typing in the visual basics editor. I used the form wizard to create a form that populates combo list...

Yes, all the fields still stay enabled and nothing seems to happen no matter what code I put in. I'm thinking it has something to do with me pulling the information from tables and the code doesn't see those values or something. How do I get the table information to become part of the form so...

:confused: Hi, I've used Visual Basics in the past and havn't had to many problems, but I am using Acess 2007 and am bit new to it and I just can't get this darn thing to work. Can someone please help me? Here's the problem: I have a form with a combo box and many text fields on it. There...