Search results

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

You are going to need the cleanup the data. To make this work as file you can import you will need to define a separator character that does not occur in the file itself. I would suggest using *. You can just use notepad to replace " 1. " with "*" and do that for the other numbers. You may able...

Your suggestions are interesting. I have tried using AutoHotKey, but I had trouble keeping focused on the web page. The IE application object might work for me. I don't see that my customers will give me the API calls.

I am taking data from Access and putting it on a website. So I need some method of turning arbitrary data into typing & clicking on a screen. I found a good website for doing the reverse, scraping information off websites and putting them into CSV's, called Data-Miner.io. However their ability...

I often need to fill out webforms when I ship customers. I create access queries which contain the information, but I still need to type (or paste) it in by hand. I would like to automate this process more. I am currently using a program called Clipboard Master which allows me to imbed tabs in...

I need to deal with this sort of problem, a lot as I often need to interact with external data sources that I can't link to directly. Here are some useful tricks which may help you. 1. Download them as CSV's (if that is an option) or open them and save them as CSV's. Then use a copy command...

Make sure to set up a 1-to-many relationship between customers and contacts. We have an ERP here that treats customers and contacts as having a many-to-many relationship, which makes it much harder to work with. Although it is possible to have the same contact at more than 1 customer, it is...

The documents aren't Access reports, they are image files. They need to be printed automatically, not by a user sitting there and selecting them manually. And how I can trust that files external to my database will be there when needed.

The attachments are image files that need to be included printed documents that are sent with shipments. It works, except for the annoyance that you need to edit attachments in the original database.

I have found that I can add attachments in the attachment field only if it is native table of the database, but I can't if it is a linked table. Is this a feature of Access or is there a way of doing it? I can always have the users work with the database containing the table, but it would be...

I have some similar problems. Access's stability in a multi-user environment has declined in recent years due to OS changes. Here are some things that have helped me. Overnight automatically copy the database to a new file and repair it. Function CompactAndCopyBack(FileName As String...