Search results

Can you post a screenshot of your version info?

Which version are you on (what channel)? Was there an update installed in the last week or so?

The way I handle this situation is to rename the FE to accdr, and I don't run into this problem too often.

Sorry, just woke up. I think the Tempvars("varnane") is a VBA syntax, while the Tempvars!varnane is a query (expression service) syntax.

I believe it's Office. https://www.devhut.net/no-labels-rendering-displaying-on-microsoft-access-command-buttons/

Yes, there's a bug in the latest updates and the only solution for now is to roll them back.

I would appreciate it if you could let us know what happens, so I can update the article. Cheers!

It's been a while but I thought I tested this function with PDFs and it worked. https://thedbguy.blogspot.com/2021/03/download-file-from-internet.html?m=1

Here's another possible option. I didn't check the pricing on this one either. https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/install-set-quickbooks-enterprise-odbc-driver/L1Am8lpxa_US_en_US

I think this is possible by using third-party ODBC drivers like this one. https://www.cdata.com/drivers/quickbooks/odbc/

Good question. I am not very familiar with the differences in attributes between the two accounts; but if they have any common traits, I might suggest storing those in one table and just split the rest in separate tables. Unless, if the number of different attributes is not a lot, you might also...

Maybe you could start out by looking at templates. Hopefully, there's something close to what you want, and you can just tweak it.

Hi. I moved your thread out of the Introduction Forum. But to answer your question, I don't see why not. Why do you ask? What are you using now?

Hi. Welcome to AWF!

You'll need a custom function for that, but it might be easier to handle if you have a normalized table structure.

You could also add a check for ControlType in your code.

Maybe look into using Power Flow or take a look at this article. https://thedbguy.blogspot.com/2021/03/download-file-from-internet.html?m=1

Hi. Welcome to AWF!

The original file I downloaded earlier didn't appear to have unique values. This becomes more apparent by adding an ORDER BY clause in the Row Source of the combo.

Hi @Gasman Is the problem happening all the time or only on certain zip codes? The first thing I noticed on the original db file was that there are 1447 records in tbl_Zip and there are 1465 records in tbl_ZpCityState, which means there are 16 duplicate zip code values in the combobox. Since...