Search results

Have you tried putting a breakpoint in your code and stepping through it to see what the problem is?

Although, if it is just mispelled, wouldn't it be better to allow the user to edit the name? If you've assigned the value to records, it might not let you delete it without first removing that value from the records, anyway!

The case is most likely that you are using joins on fields that are null. If you are using a join, make sure the data on both tables is present, or use an outer join.

=Now() will just give you the date with time, you'll have the same problem. I agree with Rich, there is little to no point in putting today's date in each day.

Since you are importing a CSV file, you can open it in Excel first and use the CLEAN function, which will remove all non-printable codes. FYI, Trim will only remove leading and trailing spaces.

I think the problem is that you are using ".value", which will refer to the comitted value of the control. Since this is beforeupdate, you are not getting the compare you want. Try this: 'assign vars values anticipatedCompletionDate = txtAnticipatedCompletionDate...

There is no reason to set it to .1 - you can set it to 0.

Most likely - you can try two things: If you want the field to be a date, change the destination field's data type to date. If you want the field to remain text, use the cstr (convert string) function to convert the date to text before you append. In the append query, you can use...

Are you sure that in all cases the source field's type matches the destination field's type? Setting them ALL to text is not necessary (for example, you probably want to keep your date fields set as dates). It is only necessary that both the source and destination match. If that still doesn't...

I'm not sure the code the wizard uses, but I like to use code like this: me.recordsetclone.findfirst "[CustomerID] = " & me.cboSearchCustomer me.recordset.bookmark = me.recordsetcone.bookmark Just make sure that the combo box is bound to Customer ID.

Right.... I guess I'm picturing a combo box that has: Hartman, Ace Hartman, Bob Hartman, Stan And no matter which the user selects, the form displays Ace. This would be because Access is using the last name to search, not the CustomerID. The CustomerID will always be unique, the name won't...

Use the On Current event of your form. Do something as follows: Select Case me.cboComboBox Case = "Cars" me.tbTabControl = 1 Case = "Trucks" me.tbTabControl = 2 etc...

It is searching based on last name. Change it to search for the customer ID.

Also, have you tried compacting and repairing? Sometimes doing this will allow you delete the bad records, without having to export to Excel and re-import.

Your source table has fields of a different type than your destination table. For 36 of the records, it couldn't convert the source field's data into the destination field's data type. For instance, you are trying to trying to append a letter into a number field...

I've already shown you how to fix this. Since these fields are undbound, you must manually set them according to your data.

I'm sorry, but I am not going to build your database for you. Take a shot at it. Post with specific questions.

Here you go.

Do While not rs.EOF operation 1 operation 2 rs.movenext Loop

Trying using the IsDate function. Iif(IsDate([DateField]), cDate([DateField]), Null)