Go Back   Access World Forums > Search Forums

 
Showing results 1 to 19 of 19
Search took 0.02 seconds.
Search: Posts Made By: Mark_
Forum: The Watercooler 09-13-2019, 01:21 AM
Replies: 2,998
Views: 581,020
Posted By hammerite
Re: What's your best/worst joke?

Physicians were unable to reach a consensus: Should Brexit take place?

The Allergists were in favour of scratching it, but the Dermatologists advised not to make any rash moves.

The...
Forum: Politics & Current Events 08-20-2019, 03:06 AM
Replies: 615
Views: 30,608
Posted By Galaxiom
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

"A great many people think they are thinking when they are merely rearranging their prejudices."

(Often attributed to William James but the original source is not clear.)
Forum: Modules & VBA 08-10-2019, 05:32 AM
Replies: 25
Views: 455
Posted By The_Doc_Man
Re: Cannot Open anymore databases

Snowflake, if some of us go off into the weeds, it isn't with the intent to intimidate or confuse you. Please just chalk it up to people sometimes trying too hard.

The quick-and-dirty summary of...
Forum: Politics & Current Events 04-05-2019, 02:47 PM
Replies: 2,301
Views: 140,651
Posted By AccessBlaster
Re: Shootings in US schools

Have they brought cable to your corner of the world? You live in a castle right? With oil lamps.
Forum: General 02-07-2019, 10:02 AM
Replies: 9
Views: 231
Posted By Gasman
Re: DoCmd.OpenTable without column headers?

I'd leave the headers alone.
Transfer to the Excel file and then copy the saved headers that you have stored on another sheet.?

However you could use this method.?
...
Forum: Politics & Current Events 01-20-2019, 01:51 PM
Replies: 615
Views: 30,608
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

I have been following this climate change Fiasco since it started. I have no idea what's causing it, and I'm convinced that no one else does either! Both sides wheel out this person, that person,...
Forum: Modules & VBA 08-08-2018, 02:21 AM
Replies: 10
Views: 689
Posted By Cronk
Re: ERROR 3011 when exporting access qry to excel to create chart

The problem is not so much in the name of the file to which the data is being exported, but what is to be exported.


The line in yellow in #1 (bad color by the way) is missing the argument...
Forum: Queries 02-26-2018, 09:45 PM
Replies: 6
Views: 292
Posted By MarkK
Also, nothing ever equals Null--not even Null--so...

Also, nothing ever equals Null--not even Null--so this expression...
tbl_OrderDetails.VIN = Null
...will always return Null. To check if VIN is null in SQL use "Is Null" and in VBA use the...
Forum: Modules & VBA 01-27-2018, 11:25 AM
Replies: 4
Views: 401
Posted By MarkK
Another much more robust solution, in which all...

Another much more robust solution, in which all the delimiters are handled automatically is...
Private Const SQL_INSERT As String = _
"INSERT INTO student " & _
"( stdid, stdname,...
Forum: Code Repository 01-15-2018, 10:38 AM
Replies: 5
Views: 1,982
Posted By arnelgp
Generic Office document viewer

here is a sample Office Documents
Viewer. it can view (and edit), Word
documents, excel worksheet/workbook, powerpoint,
text files (untouched), and pdfs.

it uses WebBrowser control. in case...
Forum: The Watercooler 01-03-2018, 02:05 PM
Replies: 39
Views: 2,169
Posted By MarkK
I was just trying to get the code right and you...

I was just trying to get the code right and you guys see poetry! Isn't this place awesome? Something for everyone! :D
Forum: Queries 12-30-2017, 07:29 AM
Replies: 7
Views: 757
Posted By isladogs
TIP How to show rank order in a query

Its easy to create a rank order in Access reports but not so easy in queries
If you Google you will find several methods of doing so, but this is the easiest method I'm aware of

Attached is a...
Forum: Forms 12-28-2017, 03:30 PM
Replies: 20
Views: 2,314
Posted By Uncle Gizmo
Re: Generic way to refer to subform control in subform criteria

I'm not sure your code Below is correct?

[Forms]![My_Main_Form].[Form]![My_Subform].[Form]!My_Subform_Control]

The Bang Here:- ]!My_Subform_Control] donsen’t look right?

Also, I don't think...
Forum: Forms 12-12-2017, 09:09 AM
Replies: 10
Views: 571
Posted By MarkK
If I had a small set of fixed text responses that...

If I had a small set of fixed text responses that I could calculate I would not allow the user to type them in, rather, I would calculate them in advance and only allow the user to select them from a...
Forum: Tables 12-09-2017, 02:57 AM
Replies: 21
Views: 1,457
Posted By JHB
Forum: General 12-05-2017, 05:21 PM
Replies: 10
Views: 706
Posted By isladogs
Re: Filter a chart by date range

Pretty much that
Here's the main bit of the code

'set the form height greater than is needed
'changed from +2 to +10 v4503W to overcome scaling error
Me.Detail.Height =...
Forum: Debates 12-04-2017, 02:02 AM
Replies: 18
Views: 2,579
Posted By Uncle Gizmo
Re: Gay marriage in Australia: Yes or No?

I hear that Utter Access is looking for moderators.

If you cultivated a presence there, I'm sure you would get nominated as a moderator quite quickly.

Sent from my SM-G925F using Tapatalk
Forum: General 11-30-2017, 10:11 AM
Replies: 4
Views: 1,595
Posted By isladogs
Forum: General 11-02-2017, 06:36 AM
Replies: 7
Views: 22,253
Posted By isladogs
How to respond to advice given in forums

Comments made in a recent thread have prompted me to write down my own views on how best to respond to advice given

AS I hope everybody who posts here realises, none of us get paid for the time &...
Showing results 1 to 19 of 19

 
Forum Jump



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