Search results

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

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

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?

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

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.

I fell victim to the "copy & paste" monster. :(

Ah, sorry about that... :)

Which version of Access is on the PC that is failing? Just wondering... PS. If you use the following code, do you still get the same error? DoCmd.OutputTo acOutputReport, "rptFinishedGoods", acFormatHTML, strServerFileShareDir & "All-FG not Shipped.html", True

Can you describe the main purpose for determining the IP address? Perhaps if the goal was known, someone can offer an appropriate approach. I was thinking of maybe using an HTTP request to get this info.

To see an example of what @Pat Hartman was saying, take a look at this demo. However, this version only uses a listbox to display the file paths. I'll have to find the one that uses a table and post it later. https://www.accessmvp.com/thedbguy/demos/listfiles.php

There's really no need to import the photos into a table. Access can easily display those photos from the folder on a report. All you need in the table are the filepaths. Take a look at Similar Threads below to see previous discussions on this topic.