Search results

I have a function that helps check for duplicate records. It seems to work with American Settings but does not work with UK settings. Is there a difference in double quotes or something. Here is the function: CheckNullString (Incoming as Variant) As String If IsNull(Incoming) = True Then...

Its the Dlookup I am having a problem with. I am getting strSomeField ="" if there are no entries. And I cant seem to find a code that will remove the "invalid use of null" warning. Sorry, still learning.

I have a command button in which I am trying to locate a duplicate entry. Here is the coding for it: Dim s As String Dim strField As String If IsNull(Me![cmboBuyerID]) = True Then MsgBox ("You need a buyer") Exit Sub End If If IsNull(Me![cmboSellerID]) = True Then MsgBox ("You...

I have a text box that uses a Dlookup function, I need to be able to have the option of manually entering something in this box as well. But of course, I get the control can not be edited error. I tried to put the function as a default value, but got nothing. It must be something simple I am...

I have a text box that uses a Dlookup function, I need to be able to have the option of manually entering something in this box as well. But of course, I get the control can not be edited error. I tried to put the function as a default value, but got nothing. It must be something simple I am...

I have two seperate databases. I want to append the data from one table into a similiar table in the other database. I wanted to do it with the TransferDatabase macro. Problem is everytime I try to append the data, Access creates a new table in the destination table instead of appending to the...

This is probably going to sound like a stupid question, but is there anyway to assign a value to checked box instead of -1.

Is there a way to have a text box with the current time in it, but it can be manually changed by a user if necessary. I'm using the function Time() amd it wont let me edit anything. Thanks in advance.

Thanks Simon..works perfectly.

I have a table with two fields, Company ID and Contact. In some cases there can be up to 8 or 9 contacts with the same company ID. On a seperate form, I would like to be able to have a combo box that shows all that certain companies contacts when another field is updated showing the ID number...