Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.63 seconds.
Search: Posts Made By: The_Doc_Man
Forum: General Yesterday, 05:55 AM
Replies: 2
Views: 48
Posted By The_Doc_Man
Re: 'invalid argument' Error, when preforming a search (ctrl+f) in a form

Are we talking about using CTRL/C to copy the desired value, CTRL/F to open the form search option, and CTRL/V to then insert the search value? You used the word "term" to describe the search value...
Forum: Modules & VBA Yesterday, 05:43 AM
Replies: 13
Views: 110
Posted By The_Doc_Man
Re: Keep Access Application Minimized

The problem is partly Windows and partly Access.

When you open an application in Windows, you open a window and attach it as the primary display/interaction area. If you minimize the window, the...
Forum: Modules & VBA Yesterday, 05:16 AM
Replies: 5
Views: 71
Posted By The_Doc_Man
Re: Serial Numbering in Access Form

You must understand that when you come here asking about what you want to do, we have all seen people who wanted to do that sort of thing before. We know (from their own descriptions and from our...
Forum: Modules & VBA 07-17-2019, 08:08 PM
Replies: 8
Views: 141
Posted By The_Doc_Man
Re: Form opens, but doesn't display correctly

Let's start with a simple test. Do you have Option Explicit declared at the top of each general and class module? If not, add it, then manually force Access to recompile your code - which it will...
Forum: Modules & VBA 07-17-2019, 07:55 PM
Replies: 13
Views: 202
Posted By The_Doc_Man
Re: Call Stack, who knew??

After doing a bit of research, I verified that you can use CTRL/L to display the call frame list on the stack. Which is no "duh" because that was mentioned in this thread. I also noted that there...
Forum: Tables 07-16-2019, 12:40 PM
Replies: 11
Views: 140
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 07-16-2019, 12:27 PM
Replies: 6
Views: 94
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 07-15-2019, 11:24 AM
Replies: 7
Views: 132
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 07-15-2019, 11:14 AM
Replies: 12
Views: 158
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 07-15-2019, 11:01 AM
Replies: 7
Views: 132
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 07-15-2019, 10:52 AM
Replies: 5
Views: 375
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 07-15-2019, 10:45 AM
Replies: 4
Views: 94
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: 33
Views: 1,169
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: 103
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: 398
Views: 22,692
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: 70
Posted By The_Doc_Man
Re: Hello

Thank you for noticing, and welcome.
Forum: Queries 07-13-2019, 06:22 PM
Replies: 10
Views: 153
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: 158
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: 95
Posted By The_Doc_Man
Re: hello

Another new face is always welcome.
Forum: General 07-13-2019, 07:45 AM
Replies: 3
Views: 168
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: 175
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: 544
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: 80
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: 355
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: 355
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...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 08:35 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 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World