Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.20 seconds.
Search: Posts Made By: The_Doc_Man
Forum: General Yesterday, 06:50 PM
Replies: 9
Views: 141
Posted By The_Doc_Man
Re: 'invalid argument' Error, when preforming a search (ctrl+f) in a form

If the CompactAndRepairFile isn't trying to C&R itself, this should be OK. However, I am a known cautious person about some things. Therefore, I would make an extra copy of the file before actually...
Forum: Tables Yesterday, 06:39 PM
Replies: 15
Views: 179
Posted By The_Doc_Man
Re: Preset values in a field

You have a ready-made relationship. Your table tblCerts is a child; your table tblInfo is a parent. There is another way of saying this: tblCerts DEPENDS ON tblInfo because if you don't have a...
Forum: Tables Yesterday, 09:24 AM
Replies: 15
Views: 179
Posted By The_Doc_Man
Re: Preset values in a field

I'm going to step in with supplemental information because everyone is telling you what to do but their "why" is a bit thin. (Not wrong, just doesn't explain in detail.)

You had a design for...
Forum: General Yesterday, 09:03 AM
Replies: 9
Views: 141
Posted By The_Doc_Man
Re: 'invalid argument' Error, when preforming a search (ctrl+f) in a form

If restarting the computer makes a temporary difference, it MIGHT be a type of corruption for which it is POSSIBLE that a manually initiated Compact & Repair might be constructive. As a precaution,...
Forum: Introduce Yourself 07-20-2019, 02:16 PM
Replies: 4
Views: 91
Posted By The_Doc_Man
Re: Hello All from WA

Glad you could join us, Rick. I once visited Washington state many years ago with my parents. We came in through Oregon, drove around to as far inland as Yakima, then drove to Seattle through the...
Forum: Introduce Yourself 07-20-2019, 05:18 AM
Replies: 4
Views: 59
Posted By The_Doc_Man
Re: G'day!

Glad you chose to take your bush walk though our territory, Renee. Welcome.
Forum: General 07-19-2019, 06:53 PM
Replies: 7
Views: 192
Posted By The_Doc_Man
Re: Accidental them changed

I usually took the approach of creating a "template form" that was the prototype for all the other forms I was going to build. Then when I need a new form with the same look and feel as the rest of...
Forum: General 07-19-2019, 06:49 PM
Replies: 9
Views: 141
Posted By The_Doc_Man
Re: 'invalid argument' Error, when preforming a search (ctrl+f) in a form

Are you saying that when the error occurs, it restarts the computer? Or is it that the user gets so frustrated that THEY restart the computer as a separate action?
Forum: Modules & VBA 07-19-2019, 06:47 PM
Replies: 3
Views: 67
Posted By The_Doc_Man
Re: Hide Admin Button

To help you find some articles on this subject, try doing an in-forum search using "user role" as a search target. The SEARCH option is in the thin menu bar/ribbon near the top of each page, just...
Forum: Modules & VBA 07-19-2019, 06:44 PM
Replies: 9
Views: 183
Posted By The_Doc_Man
Re: Form opens, but doesn't display correctly

For what it is worth, the results of the test I asked were inconclusive.

Just to be pedantic about it, there is technically no difference between these two statements:


IF X = TRUE THEN
...
Forum: Introduce Yourself 07-19-2019, 06:27 PM
Replies: 2
Views: 53
Posted By The_Doc_Man
Re: hello all

Glad you came by, Davebest. Welcome.
Forum: General 07-18-2019, 05:55 AM
Replies: 9
Views: 141
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 07-18-2019, 05:43 AM
Replies: 15
Views: 213
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 07-18-2019, 05:16 AM
Replies: 5
Views: 89
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: 9
Views: 183
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: 234
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: 152
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: 99
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: 144
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: 13
Views: 176
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: 144
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: 387
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: 104
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,181
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: 112
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...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 12:33 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