Search results

  1. theDBguy

    Button Bugs

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

    Button Bugs

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

    download invoice documents from Amazon - possible?

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

    download invoice documents from Amazon - possible?

    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
  5. theDBguy

    A general question

    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
  6. theDBguy

    A general question

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

    Modeling Account types and number of tables needed

    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...
  8. theDBguy

    A general question

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

    A general question

    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?
  10. theDBguy

    New member

    Hi. Welcome to AWF!
  11. theDBguy

    I need the minimum value among 5 different fields in one record

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

    50/50 Chance of Working

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

    Some Idea using tables in sharepoint

    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
  14. theDBguy

    New Member

    Hi. Welcome to AWF!
  15. theDBguy

    Solved Anyone experienced this before?

    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.
  16. theDBguy

    Solved Anyone experienced this before?

    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...
  17. theDBguy

    Solved Anyone experienced this before?

    What exactly does that mean? I just tried this and although I thought I would get an error when I set the bound column to 0 but I didn't, the combo seems to work normally - displaying exactly what I selected and the textbox for the other column also displayed what it's supposed to. I can't see...
  18. theDBguy

    PDF Complete

    Just as another way of troubleshooting, could you try manually creating the pdf? So, on the affected machine, open the report in print preview. Then, click on the PDF button on the ribbon. Does it work?
  19. theDBguy

    Poor performance over WiFi

    You might be able to get away with using WiFi if the BE is SQL Server. Just a thought...
  20. theDBguy

    Continuous form with different rowsource in same combobox

    You can; but in a continuous form, it would reflect on all rows. Does it have to be a continuous form? This is not a problem in a single view form and also not a problem if the continuous form is read only. But if you want the user to see the dropdown, it gets tricky.
Back
Top Bottom