Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 2.03 seconds.
Search: Posts Made By: The_Doc_Man
Forum: Tables Today, 12:40 PM
Replies: 11
Views: 121
Posted By The_Doc_Man
Re: Using access to store chemistry experiment results

ScubaAinz,

The way we usually would do this is to have a table of experiments. Each experiment has an ID number. (Could be Autonumber.) You would have the date, the start time, and any other...
Forum: Introduce Yourself Today, 12:27 PM
Replies: 6
Views: 60
Posted By The_Doc_Man
Re: New Here

Hello, Joey. I have no personal experience in Qatar but many years ago a company where I worked had guys doing some computer work in Qatar. Are they still strict about people having hard liquor in...
Forum: General Yesterday, 11:24 AM
Replies: 7
Views: 118
Posted By The_Doc_Man
Re: Open Forms in Datasheet View (All Records)

Billy, my correct answer to #5's question is "No, you shouldn't create a query or a form. You should create whatever works correctly for you." But I gave you the easiest answer so you could get...
Forum: General Yesterday, 11:14 AM
Replies: 12
Views: 141
Posted By The_Doc_Man
Re: PO generator

You commented that you were working on a "mission statement" for the DB in question. This is THE crucial time in your DB. You will not find another part so important until you reach final testing. ...
Forum: General Yesterday, 11:01 AM
Replies: 7
Views: 118
Posted By The_Doc_Man
Re: Open Forms in Datasheet View (All Records)

The issue of opening in datasheet view is possible. Are you looking at opening a query in datasheet view?

https://docs.microsoft.com/en-us/office/vba/api/access.docmd.openquery

This would do...
Forum: General Yesterday, 10:52 AM
Replies: 5
Views: 362
Posted By The_Doc_Man
Re: Access 2019

I know you have it fixed so this is merely an after-the-fact comment. Your fix points to the possibility of having had a small amount of object corruption in the older version. The "Import to a new...
Forum: Introduce Yourself Yesterday, 10:45 AM
Replies: 4
Views: 89
Posted By The_Doc_Man
Re: Hello to all!!!!

Hello, The Joeness, glad you chose to step in.
Forum: Modules & VBA 07-14-2019, 09:35 PM
Replies: 32
Views: 1,132
Posted By The_Doc_Man
Re: Get value of Link Master Field

No. The second form will be "FormName (2)" and the third one will be "FormName (3)" based on the way Access handles multiple instantiation conflicts.
Forum: Modules & VBA 07-14-2019, 09:31 PM
Replies: 4
Views: 94
Posted By The_Doc_Man
Re: Access Front End Auto Updating.

This implies some issues in either the mapping itself (perhaps via a drive letter conflict) or the security (permissions) associated with that mapping.

However, I'm a bit confused. If you could...
Forum: Politics & Current Events 07-14-2019, 07:51 AM
Replies: 394
Views: 22,599
Posted By The_Doc_Man
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Found this as a response to the question about whether scientists will yield to political pressures. Colin, the problem about bringing in "irrelevant political viewpoints" is that if political...
Forum: Introduce Yourself 07-14-2019, 05:30 AM
Replies: 3
Views: 68
Posted By The_Doc_Man
Re: Hello

Thank you for noticing, and welcome.
Forum: Queries 07-13-2019, 06:22 PM
Replies: 10
Views: 141
Posted By The_Doc_Man
Re: Odd and Differing Behaviour in Query on SQL data stores

I looked this up because I wasn't familiar with SQL server internals. But it appears that date/time variables are numeric for SQL server similar to (if not identical to) Access internal date...
Forum: General 07-13-2019, 02:07 PM
Replies: 7
Views: 136
Posted By The_Doc_Man
Re: have a list of numbers in access and I want to show them in a special way

First, how are those numbers stored? Because a LONG integer can only store 9 full digits. So there is something you aren't telling us about the numbers. Now if you had a newer version of Access,...
Forum: Introduce Yourself 07-13-2019, 01:56 PM
Replies: 4
Views: 91
Posted By The_Doc_Man
Re: hello

Another new face is always welcome.
Forum: General 07-13-2019, 07:45 AM
Replies: 3
Views: 161
Posted By The_Doc_Man
Re: Suggestions Before Splitting

Billy, here is the problem. If you are planning to distribute files on a network, this presumes that you are sending them to another computer. If you give a person the file to put on their computer...
Forum: Tables 07-13-2019, 07:26 AM
Replies: 8
Views: 168
Posted By The_Doc_Man
Re: Forcing A Field's Data Type To Be Currency In Dollars ($) Instead Of Regional Set

Adding to this discussion on the narrow subject of "Rounding" ... using a DOUBLE for all currency gives you approximately 15 reliable decimal digits and a chance of a 16th digit. Since we are...
Forum: Theory and practice of database design 07-13-2019, 06:57 AM
Replies: 20
Views: 528
Posted By The_Doc_Man
Re: building a database from scratch

Wrong forum for this discussion, but as storms go, Barry is so ill-formed that he won't be able to reach a massively destructive status. Isolated heavy rain, spot flooding, but nothing major. As of...
Forum: Introduce Yourself 07-13-2019, 06:52 AM
Replies: 4
Views: 78
Posted By The_Doc_Man
Re: Hello!

Welcome, j99k, and glad to have you aboard.
Forum: Modules & VBA 07-12-2019, 07:24 PM
Replies: 13
Views: 345
Posted By The_Doc_Man
Re: Can it be done??

I am adding a second note because there are products that purport to do what you describe - but they have a poor track record. If you look a PeopleSoft databases, for example, they claim that they...
Forum: Modules & VBA 07-12-2019, 07:16 PM
Replies: 13
Views: 345
Posted By The_Doc_Man
Re: Can it be done??

You are essentially trying to build a "faceless" database and there is a serious flaw in the entire concept. A database that has no inherent structure will have no inherent data coherence. You will...
Forum: Theory and practice of database design 07-12-2019, 06:53 PM
Replies: 20
Views: 528
Posted By The_Doc_Man
Re: building a database from scratch

Adrianscotter, you are describing something called "The Peter Principle" which is found in private industry but is MOST commonly found in government: "A person will rise to his own level of...
Forum: Introduce Yourself 07-12-2019, 06:42 PM
Replies: 4
Views: 79
Posted By The_Doc_Man
Re: New to the Form

Good to meet you, Kevin. Welcome aboard.
Forum: Introduce Yourself 07-12-2019, 06:42 PM
Replies: 3
Views: 70
Posted By The_Doc_Man
Re: Jallo

Hi, Jall, and welcome.
Forum: Introduce Yourself 07-12-2019, 06:41 PM
Replies: 3
Views: 69
Posted By The_Doc_Man
Re: New to the forum - eager to learn

Glad you came in to join. Welcome.
Forum: General 07-11-2019, 07:34 PM
Replies: 29
Views: 385
Posted By The_Doc_Man
Re: Volume tracker in access

AbhishekA, you must understand that with every business there are differences from every other business even in the same general field of commerce in the same city. Each boss is different, each...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 06:27 PM.


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 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World