Search results

I think the best suggestion is to buy a book about Access/VBA and work your way through it. And of course there are many good sources on the Internet. If you want help here you have to ask specific questions.

Ferguson may be a good manager but as a person he has shown a lack of class on different occasions. But then again, football is not known for its classy people. Moyes will be a good replacement.

You could use something like this. Dim Msg As String, BoxResponse As String Dim Title As String, Style As Integer Msg = "Are you sure you want to delete this Record?" Style = vbYesNo + vbExclamation BoxResponse = MsgBox(Msg, Style, Title) If BoxResponse = vbYes Then...

May be this helps. http://support.microsoft.com/kb/185384 Catalina

Thank you Galaxiom. I thought I had seen it recently but I couldn't find it. It works like a charm, you made my day! Catalina

I have a string (for a password) that contains 8 - 12 characters. There has to be at least one digit in it (0-9). So I have to test it in the Before Update Event of the field. Any idea how I can accomplish this? Even better would be if it could test for an uppercase as well. All suggestions...

Go to the Form Properties, on the Format Tab set Auto Center to Yes. Catalina

Try the DatePart Function. For example: DatePart ('yyyy', #15/10/1998#) would return 1998 DatePart ('m', #15/10/2003#) would return 10 DatePart ('d', #15/10/2003#) would return 15 Catalina

Do you get an error number? May something like this will work: On Error GoTo ErrorHandler code here ExitHandler: Exit Sub ErrorHandler: Select Case Err Case 2102 MsgBox "Network Connection Failed! ", vbExclamation, "" Resume ExitHandler Case Else...

It may work alright now but with a flawed table design you will run into trouble sooner or later. May be you can use an Update Query for what you want to do. Catalina

There are 5 instances of 5 different things so I had to break them all out into seperate tables. That really sounds like a table design problem, like lagbolt already indicated. May be you can tell a little more about what you need and why and someone will help you setup the correct design...

You want to see all records and be able to add a new one, is that correct? Catalina

How about a simple DCount in the On Current Event of the form. If the result is 0 you can make the subform invisible with: me.mysubform.visible=false (substitute mysubform with the actual name) Catalina

Double post.

You're welcome, I'm glad you got it done. Catalina

How about rs.Edit instead of rs.AddNew Catalina

You should be able do this with a Make Table Query and combine the two using the common A field as a relation into a new table. Check this out: http://office.microsoft.com/en-us/access-help/create-a-make-table-query-HA010108505.aspx#BM1 Catalina

The form came from another application, I only changed it where required. I just made a new one, copied all elements from to old form to the new one and then copied all the underlying code. Now the font problem is gone. There must have been a bug somewhere. Catalina

Using Access 2010/Windows 7. On my edit form I use Tahoma Normal for the field labels, the label background is transparent. I can move to another record without a problem but when I want to add a new record with DoCmd.GoToRecord , , acNewRec the label font gets bolder. There are no...

Thanks Beetle, I would like to have a go at it, so please post it if you can. It is very much appreciated. Catalina