Search results

Still in the current record. I've never had to the past, or maybe I just didn't notice it..... I will give that a try, I'm sure that it will work. Thanks! :)

DLookup is used to look up data in a table or query. DLookup(Data,Name of table,criteria) Look in the help file for more detailed information. Here is an example: UserName = DLookup("[UserName]", "tblClasses", "[ClassID] = " & txtClassID.Value & " And [UserName] = """ & txtUser.Value &...

Use DLookup to see if a record already exists.

You could create a sub for each group that sets the visibility. Public Sub Location_Hide Me.txtBuilding.Visible = False Me.txtRoom.Visible = False End Sub Public Sub Location_Show Me.txtBuilding.Visible = True Me.txtRoom.Visible = True End Sub

I have a form which has a table as it's Record Source. The problem lies when a bound combobox or bound textbox is changed, the change is noted on the form but when I reference the value of the object it comes back as null. So I look in the table and the field has not changed. But if I requery...

Bingo! You were right. The module was crashing when it was being compiled. The difference being was the one group was referencing the Outlook 11 Library and the others were using Outllok 2000, so it was an easy fix. Thanks!

Why not check to make sure that the listbox's value <> "" before you run the code? If lbxRegion.Value <> "" then 'Place your code here Else strMesg = "Please select a region and try again" & Chr(13) & "Click 'OK' to contine" strTitle = "Please Select a Region"...

Hello, I am having a problem with a database I created. It is running great for one group but another group is having issues. It is a split Access 2000 db, I have created a batch file so that the front end will be copied from the network to their PCs and then it will launch the db. The...