Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.21 seconds.
Search: Posts Made By: The_Doc_Man
Forum: General Yesterday, 06:53 PM
Replies: 4
Views: 157
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 Yesterday, 06:49 PM
Replies: 3
Views: 66
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 Yesterday, 06:47 PM
Replies: 3
Views: 57
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 Yesterday, 06:44 PM
Replies: 9
Views: 169
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 Yesterday, 06:27 PM
Replies: 2
Views: 44
Posted By The_Doc_Man
Re: hello all

Glad you came by, Davebest. Welcome.
Forum: General 07-18-2019, 05:55 AM
Replies: 3
Views: 66
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: 167
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: 78
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: 169
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: 230
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: 142
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: 96
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: 139
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: 164
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: 139
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: 382
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: 98
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,172
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: 106
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: 407
Views: 22,784
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: 71
Posted By The_Doc_Man
Re: Hello

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

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

 
Forum Jump



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