Search results

Hi. Welcome to AWF!

Have you checked out the Name As statement? https://learn.microsoft.com/en-us/office/vba/Language/Reference/user-interface-help/name-statement

Check your records to make sure they don't contain any illegal characters for filenames.

Hi. Welcome to AWF!

Take a look here. http://allenbrowne.com/ser-57.html

Hi. Welcome to AWF!

So, are you trying to add a single or multiple new records in one go? If only one record, then you don't need a loop (Do While).

What is the value in Me.cboInvReversal? When you filter the records, how many records do you end up having? If more than one, are you saying to want to create that many records?

To add a record, you would use .AddNew instead of .Edit

Hi. Welcome to AWF!

Hi. Glad to hear you got it sorted out. Good luck with your project.

Hi. Welcome to AWF! Instead of hiding the form, maybe you could try resizing it to a very small size that's it's nearly invisible. Check out the MoveSize method.

Hi. Welcome to AWF!

Glad to hear you got it sorted out. Good luck with your project.

Have you tried using the Format property? Just a thought...

That tells me that maybe you're not looking at a folder. So, if the new code I provided returns that, then perhaps changing your code should make it work now? If Dir(detPath, 16) = "" Then

Hi Bryan. Did you see my last post? Just curious...

Okay, it's starting to get interesting. Could you try the following now? Thanks. MsgBox Dir(destPath) After that, try it this way. MsgBox Dir(destPath, 16)

If that folder exists, then that's a good question. Can you change the debug.print to the following and post a screenshot of the result, please? Thanks. MsgBox "[" & destPath & "]"

Again, did you do a debug.print to verify what the computer was seeing versus what your eyes are seeing? Just curious...