Search results

Hi Bryan, Try to do a Debug.Print destPath, so you can see what folder path you're trying to create. If it's a full path, I am not sure MKDIR can do that, but I could be wrong though. Cheers! PS. I just did a quick test. MKDIR cannot make a subfolder if the parent folder does not exist. You'll...

Can you post your query's SQL statement? Thanks.

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

What is the data type of the field?

Hi. Welcome to AWF!

Tally tables have a lot of use in a database, so you will hear it mentioned a lot. Good luck with your project.

I would use a Tally table that contains sequential numbers and then use a cartesian join query to produce the number of labels/records you need. For example: SELECT ClientName, Address FROM TableName, TallyTable WHERE TallyTable.Seq <= 5 https://thedbguy.blogspot.com/2016/02/cartesian-query.html

That probably means there is a space before the single digit numbers. If so, try it this way. Trim(Mid([FieldName],InStr([FieldName], ". " + 2)))

Yes, I would use a combination of both. For example: Trim(Mid([FieldName],InStr([FieldName], " ")))

I just have to ask, why are you using an unbound form to view records?

Just thinking out loud but couldn't you use a flow to read the text file directly into the sql server? Why do you need a list in between?

Try it like I said, add a new combobox to your form using the wizard and select the third option. Then, look at the code it creates and apply it to your situation. That's exactly the technique used by the combobox wizard.

Yes, Access 2016 can be either 32- or 64-bit. Since you got a new computer, Access may have been installed as 64-bit by default. If so, you should be able to reinstall it and specifically choose 32-bit this time.

Hi Frank. You can simply reinstall Access as 32-bit.

Yes, it should. As you said, that's not advisable, so they would be limiting themselves if they use that approach You can see this problem come up when people use a non-unique bound column where they wonder why the value goes back to the first item when they were clearly selecting the second...

Hi. I think it's possible for both scenarios, but they would require different approaches. For example, if the listbox is not a multi-select listbox, you could simply assign the new record to the bound value of the listbox. And for continuous forms, you will have to "navigate" the form to the...

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

Hi. Welcome to AWF!

I think maybe your problem is not with Access but with GMail. If it was just Outlook, you can use CDO as a replacement.

You could try: WHERE (Fieldname Like '*' & searchbox '*' And Fieldname Is Not Null) Or searchbox Is Null