Search results

Perhaps you need to join on both the name and the id instead of just the id alone. Are you getting duplicate records?

Hi. Welcome to AWF!

Try changing your button code to a simple: MsgBox Me.[NameOfIDfield] And verify that you're getting the correct values as you click on different buttons.

Try unhiding the ID textbox to see what's in it.

You can create a duplicate table structure and set a unique index on the duplicate field. Then, insert the data from the original table.

One potential approach: Change the spec to import all columns as Text into a Temp table and then use an APPEND query to convert and transfer the data into SQL Server?

Are you trying to do this in a query? Try using the IsDate() function.

Can you show us your SendObject code? Does it have a True argument at the end?

Are you able to share a sample db?

The default references should be all you need. However, SendObject will simply invoke your default mail client. So, make sure you have one.

There's no way for me to test this, but my understanding is if you left SA in, then they can reset its password. Or, if you took out that account, then they can add anyone with admin rights anyway.

I read the link and my understanding is that anyone with admin rights to the server will be able to reset the SA password on the DB instance. I could be wrong though.

Hi. Welcome to AWF!

@JIC Welcome to AWF!

What is the big blank area in the middle? Is that a listbox or a subform?

Hi. Welcome to AWF!

Is the macro called Autokeys?

If the category is Null, then it cannot be compared to anything (whether equal to or not equal to). You'll have to handle nulls in a special manner as already described earlier. I asked earlier what other categories were there. I guess you missed it. If there's only "accounts" and nothing else...

Could be with the data. You may have to post a sample db with test data to show the problem. What other categories are there?

Please ignore what I said. The others already pointed out I probably read it wrong.