Recent content by boborsipho

NEVERMIND PPL. I've figured it out by myself. Thanks for your help anyway.

How do I check in VBA/Access (if it is possible in Access) that a update query actually updated something and then use the fact that it updated/not. I've got a log in form that checks if the username & password is valid, and then Activates the use, if found in the table, as Yes (Activates is a...

katho Spreek asseblief engels. Kan nie so goed Nederlands verstaan nie. Bob

How do I check in VBA/Access (if it is possible in Access) that a update query actually updated something and then use the fact that it updated/not. I've got a log in form that checks if the username & password is valid, and then Activates the use, if found in the table, as Yes (Activates is a...

How do I check in VBA/Access (if it is possible in Access) that a update query actually updated something and then use the fact that it updated/not. I've got a log in form that checks if the username & password is valid, and then Activates the use, if found in the table, as Yes (Activates is a...

Click the toolbox button on the standard toolbar, neillovell. The "Hammer & Wrench"-Button.

How do I select a tab in VBA? What I'm doing is that based on a combo box's value outside the tabs, a MsgBox should be displayed when I click on the tabs. Currently my MsgBox is in Private Sub TabCtl63_Change(). Should it be somewhere else? If I click on the tabs and the Combobox's value is...

I get the error, "Can't find project or library" for the following code: Me!month = Format(Now, "m") I know what it means, but how do I correct it, and what would the library be in this case? Thanks Bob

What do you think I should do in stead of Set rs = db.OpenRecordset(sql, dbOpenDynaset). What does that statement do? How do I run the Recordset/Querydef? Thanx Bob

I've been trying to get this to work for days now. My code is below. I'm not really familiar with VB. The first error was the "Too few parameters, expected 1". I changed my code a bit and now it's "Object 'Times' already exists". What am I doing wrong and how do I fix it. Is...

I tried this now, but now I have another error: Object 'Times' already exist. This is driving me nuts. Dim rs As Recordset Dim db As Database Dim qdf As QueryDef Dim temp As String temp = "Date" & mynum & "" //mynum is a parameter of the function sql = "SELECT...

Ok, I sort of understand what you mean. Here's my SQL statement: sql = "SELECT [Entertainment]![Name] & [Entertainment]![FirstName] & ' ' & [Entertainment]![Surname] AS TheName, EventCalendar.Date, EventCalendar.Time, EventCalendar.Highlighted FROM Entertainment, EventCalendar WHERE...

I've been struggling for a while now. How do I run a Select query in a module in MS Access? I tried everything: Dim sql As String Dim rs As Recordset Dim db As Database Set f = Forms!frmCalender sql = <<SQL Statement>> Set db = CurrentDb() Set rs =...

I've been struggling for a while now. How do I run a Select query in a module in MS Access? I tried everything: Dim sql As String Dim rs As Recordset Dim db As Database Set f = Forms!frmCalender sql = <<SQL Statement>> Set db = CurrentDb() Set rs =...