Search results

I have also faced problems with the contents of query string disappearing from a stored query when run. All I could to do was to store the SQL from each query and fix it when is disappeared.

The improvement may have been caused by moving to the latest version of Visual. We were on Access 2013 before. The tip here is that upgrading to the latest version can improve performance.

I recently upgraded from stand-alone Access to Microsoft OfficeProPlus. This resulted in huge improvement in stability, especially in multiple-user situations.

I was able to resolve this. The driver needed to be in c:\Users\<User Name>\AppData\Local\SeleniumBasic. There is a clear explanation on udemy.com

Union Select Queries are always slow, significantly slower than running the 2 queries separately. Could you have a single delivery schedule table, and then update the table when the delivery is received?

I am trying to use Selenium to interact with websites. However, whenever I try to run I receive errors, with a different error for each browser. Is there something else I need to download? My code Function AutomationTest() Dim bot As New WebDriver bot.Start "firefox", "http://google.com" End...

Check out the sourcebook from FMS, https://www.fmsinc.com/MicrosoftAccess/modules/index.asp. It has code to list all objects in the file and lots of other goodies.

I don't recall exactly which program was causing problems, but the issue was at the server level.

We recently converted our ERP from Oracle to SQL Server. While Oracle automatically saved the password, SQL Server demands the password be typed in, creating a problem for activities run overnight. What is the best way to connect to SQL Server automatically?

There is no limit if you are in the Datasheet view. A continuous form looks like a datasheet, but Access treats it differently. That is what confused me, a datasheet view is not the same as a datasheet form.

I was able to gray out uneditable data, by right-clicking the column and choosing conditional formatting. Then I just set a condition met by all cells.

Continuous forms have a width limit.

I need to support redundant fields in the ERP. You might think that the carton determines dimensions but some items don't have a carton. And I need to distinguish between missing carton information and no carton.

Products can have many characteristics which need to be recorded. A majority of the fields come from our ERP (and there are more fields which I don't use in my query). When you are manufacturer, you need to keep track of a lot of things. For example, we need to track the dimensions of the...

Disabling control resulting in it being skipped when navigating the sheet but does not gray it out. Skipping the field helps.

I created a datasheet form from scratch, using the creating forms wizards. It shows all the fields. Thanks for the assistance. I still have one issue. In a datasheet form is there a way of graying out uneditable data? I can change the background (and other formatting info) in the underlying...

It won't let me display the form as a datasheet.

It does matter, as each records needs to be on a single row, so users can use arrow keys to easily navigate.

I will try that out. It will be a busy form, but as long as users can navigate with arrow keys, it should be easy to use.

I need to allow users to see a datasheet format an editable query with nearly 100 fields (it describes every possible piece of information about the products we sell). I need for the users to be able to edit some fields, while locking other fields. The users need to be able to see more than 1...