Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 164
Search took 0.07 seconds.
Search: Posts Made By: RogerCooper
Forum: Access Web 11-08-2019, 09:20 AM
Replies: 3
Views: 1,045
Posted By RogerCooper
Re: Trouble Using Selenium from Access

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
Forum: Queries 11-01-2019, 11:39 AM
Replies: 7
Views: 274
Posted By RogerCooper
Re: Query - Running slow - Advice needed

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...
Forum: Access Web 10-31-2019, 11:19 AM
Replies: 3
Views: 1,045
Posted By RogerCooper
Trouble Using Selenium from Access

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...
Forum: Macros 10-18-2019, 11:09 AM
Replies: 2
Views: 204
Posted By RogerCooper
Re: [Macro]How to print the query name in a Macro into a table

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.
Forum: General 10-17-2019, 08:14 AM
Replies: 11
Views: 660
Posted By RogerCooper
Re: Inexplicable Slowness in Executing Queries

I don't recall exactly which program was causing problems, but the issue was at the server level.
Forum: Tables 09-26-2019, 11:50 AM
Replies: 3
Views: 176
Posted By RogerCooper
Automatically Connecting to SQL Database Tables

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.
...
Forum: Forms 08-09-2019, 06:39 AM
Replies: 28
Views: 340
Posted By RogerCooper
Re: Datasheet Form with Many Fields

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...
Forum: Forms 08-09-2019, 05:40 AM
Replies: 28
Views: 340
Posted By RogerCooper
Re: Datasheet Form with Many Fields

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.
Forum: Forms 08-09-2019, 05:38 AM
Replies: 28
Views: 340
Posted By RogerCooper
Re: Datasheet Form with Many Fields

Continuous forms have a width limit.
Forum: Forms 08-09-2019, 05:35 AM
Replies: 28
Views: 340
Posted By RogerCooper
Re: Datasheet Form with Many Fields

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...
Forum: Forms 08-08-2019, 11:48 AM
Replies: 28
Views: 340
Posted By RogerCooper
Re: Datasheet Form with Many Fields

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...
Forum: Forms 08-08-2019, 11:01 AM
Replies: 28
Views: 340
Posted By RogerCooper
Re: Datasheet Form with Many Fields

Disabling control resulting in it being skipped when navigating the sheet but does not gray it out. Skipping the field helps.
Forum: Forms 08-08-2019, 09:15 AM
Replies: 28
Views: 340
Posted By RogerCooper
Re: Datasheet Form with Many Fields

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...
Forum: Forms 08-07-2019, 08:34 AM
Replies: 28
Views: 340
Posted By RogerCooper
Re: Datasheet Form with Many Fields

It won't let me display the form as a datasheet.
Forum: Forms 08-07-2019, 07:22 AM
Replies: 28
Views: 340
Posted By RogerCooper
Re: Datasheet Form with Many Fields

It does matter, as each records needs to be on a single row, so users can use arrow keys to easily navigate.
Forum: Forms 08-07-2019, 06:31 AM
Replies: 28
Views: 340
Posted By RogerCooper
Re: Datasheet Form with Many Fields

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.
Forum: Forms 08-07-2019, 06:18 AM
Replies: 28
Views: 340
Posted By RogerCooper
Datasheet Form with Many Fields

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...
Forum: General 08-06-2019, 11:43 AM
Replies: 6
Views: 138
Posted By RogerCooper
Re: Importing Old DB into New

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...
Forum: General 08-01-2019, 11:15 AM
Replies: 5
Views: 179
Posted By RogerCooper
Re: Filling Out Webforms

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...
Forum: General 07-31-2019, 11:44 AM
Replies: 5
Views: 179
Posted By RogerCooper
Re: Filling Out Webforms

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,...
Forum: General 07-31-2019, 07:23 AM
Replies: 5
Views: 179
Posted By RogerCooper
Filling Out Webforms

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...
Forum: Theory and practice of database design 07-29-2019, 03:42 AM
Replies: 8
Views: 439
Posted By RogerCooper
Re: Check to ensure all imports done

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...
Forum: Theory and practice of database design 07-01-2019, 08:53 AM
Replies: 8
Views: 1,397
Posted By RogerCooper
Re: Design method

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...
Forum: Tables 06-24-2019, 03:36 AM
Replies: 9
Views: 449
Posted By RogerCooper
Re: Unable to add attachments in linked table

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...
Forum: Tables 06-21-2019, 11:51 AM
Replies: 9
Views: 449
Posted By RogerCooper
Re: Unable to add attachments in linked table

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.
Showing results 1 to 25 of 164

 
Forum Jump



All times are GMT -8. The time now is 06:09 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World