Search results

That's unfortunate. But to determine the actual cause of the problem, the first part of my question was to verify if SSMA works with regular (not converted) ACCDB files first. Otherwise, I don't think we can be certain if the problem is your MDB file or your install of SSMA. Luckily, even if you...

Just a guess but does the wizard work with ACCDBs? If so, maybe try converting the MDB to ACCDB first.

Welcome back!

Hi. Welcome to AWF!

Please let us know how it goes. Good luck!

No, I meant one of the four (4) queries you said you would have to constantly update if the ID didn't start with 1.

If you don't mind, can you show us the SQL statement for one of those queries that has the ID field value that needs to stay at 1? Thanks!

Depending on what you're actually doing, I think the main idea is: if the C&R doesn't require you to reestablish table relationships, then wouldn't it be a simpler approach than the reset query? In other words, compare the following two approaches: Reset Query Steps Delete Table Relationship...

Hi. Did you try the last file I posted? If so, you'll see I didn't use that code. And as I also said in my last post, I don't think that code approach may not always work in some cases. For example, I deleted some records, and the code didn't work as expected anymore.

As @MajP was trying to say, the Autonumber field should restart at 1 if you empty the table and do a C&R before appending the new records.

This seems to break it. :( I deleted a few records, and the dropdown went crazy... (showing totally unexpected AIN values)

I just gave it a try, and it always gives me the record with AIN one more than the selected one. For example, if I select AIN=1367, the dropdown shows 1368. I was also going to check what happens if the AINs weren't sequential.

Thanks for checking. Does that version of the code still work if after you get to a different record by selecting either the buttons on the left or an item from the dropdown, you would then hit the Next button at the top (a few times)?

Okay, thanks. I see it now. The only thing I could come up with is that control is probably corrupted. As a quick test, I added my own dropdown in red, right next to it, and the new dropdown seems to work fine (I think). Could you please verify? Thanks!

Okay, as @Gasman said, I removed the Load event, but I still don't see the problem in my attached updated file.

I'm on my phone right now, but I didn't know I had to comment out a code to reproduce the problem. Which code was that and why comment it out if leaving it in doesn't cause any problems? I'll check it again when I get back in front of a computer.

I was finally able to download your file to take a look. Unfortunately, I may have misunderstood the problem as I don't seem to experience what you were saying about "rounding" and mismatches in the combobox. I did, however, add a single line of code for something else. Would you please take a...

For starters, your function is not returning any value nor is it modifying the argument referenced by the calling procedure. Furthermore, I think you meant to construct Strings in your function since you're building a SQL statement.

I think it's more like "drawing."

Just curious, would it be possible as the C&R is happening, another user might attempt to open their own copy of the first accde? If so, what happens with them?