Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.06 seconds.
Search: Posts Made By: Mark_
Forum: The Watercooler Yesterday, 07:31 AM
Replies: 9
Views: 220
Posted By Mark_
Re: What would this TURF war look like?

So you don't think someone who's already into weight lifting (or sprinting, or other sports) could also feel they are trapped in the wrong body? Hmm. Odd, I would never believe one would innately...
Forum: The Watercooler 10-17-2019, 09:47 PM
Replies: 9
Views: 220
Posted By Mark_
Re: What would this TURF war look like?

The women who seem least accepting of a trans-woman tend to be involved in athletic competitions. Their argument, backed by biology, is that a body that has grown to maturity as a male will have many...
Forum: Modules & VBA 10-17-2019, 09:38 PM
Replies: 3
Views: 84
Posted By Mark_
Re: Insert contents of HTML file into Outlook body

How are you sending the Email now? What's the code?

If it is something that support HTML, you can loop through your record source to create the body as Micron has indicated. If it doesn't, you...
Forum: Politics & Current Events 10-14-2019, 07:01 PM
Replies: 531
Views: 27,427
Posted By Mark_
Forum: Politics & Current Events 10-14-2019, 03:56 PM
Replies: 531
Views: 27,427
Posted By Mark_
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Something relevant to the original article that started this thread, the way the study was done has been brought in to question;
...
Forum: Theory and practice of database design 10-14-2019, 10:25 AM
Replies: 14
Views: 340
Posted By Mark_
Re: The pitfalls of VBA proficiency

John,

My first question is always "Will this be what I need or will I have to prepare for expansion later?" If it is something I KNOW I will need to expand upon, I plan how that will work first....
Forum: Access Web 10-14-2019, 08:37 AM
Replies: 5
Views: 112
Posted By Mark_
Re: Looking for advice on migrating to Cloud

Something to remember about "Cloud" storage; your data still resides on a server (or servers), but they are often no longer under your direct control. This may require a rework of your local network...
Forum: Modules & VBA 10-13-2019, 03:06 PM
Replies: 10
Views: 216
Posted By Mark_
Re: Problem with Looping

theDBGuy implicitly answered WHY June7 suggests not doing this the way you are doing it. From a users standpoint, having multiple "Reminders" pop up that are not relevant to what I'd doing at the...
Forum: Queries 10-06-2019, 01:40 PM
Replies: 31
Views: 698
Posted By Mark_
Re: Appending Table with a Picture

theDBGuy,

Didn't know that. Had run into an issue with it a while ago and had kinda sworn them off...
Forum: Queries 10-06-2019, 12:27 PM
Replies: 31
Views: 698
Posted By Mark_
Re: Appending Table with a Picture

NancyR,

One of the other reasons most of us recommend keeping attachments as a path to the file is because of how difficult it is to update/keep the current attachment straight when you try to...
Forum: General 10-02-2019, 07:35 AM
Replies: 12
Views: 218
Posted By Mark_
Re: 2 x Auto-Incrementing Fields

As others have posted, your real autonumber should be used within your database, not be a "For display" value.

Your format, 19IT”000. looks to be the last to digits of the current year, a two...
Forum: Queries 10-01-2019, 08:44 PM
Replies: 16
Views: 273
Posted By Mark_
Re: Speeding up a LEFT JOIN query

If BrojacNap is a number, you'd normally be looking for 0, not Is Null. Have you tried that instead?
Forum: Forms 10-01-2019, 08:35 PM
Replies: 8
Views: 8,518
Posted By Mark_
Re: printing subforms

I'd create a report to do what you need as they are actually for printing, but if that isn't an option, check out THIS THREAD (https://access-programmers.co.uk/forums/showthread.php?t=288084) and see...
Forum: Forms 10-01-2019, 03:45 PM
Replies: 8
Views: 8,518
Posted By Mark_
Re: printing subforms

Open the report in design view.
Click on the "Page Setup"
In "Page Layout" select "Landscape"
Forum: Modules & VBA 10-01-2019, 07:23 AM
Replies: 15
Views: 220
Posted By Mark_
Re: Recordset Operation

Taking a couple steps back, how are you getting duplicate data into your system? Would it work better to notify the user they are entering a duplicate record PRIOR to entry?
Forum: Modules & VBA 09-30-2019, 01:28 PM
Replies: 15
Views: 220
Posted By Mark_
Re: Recordset Operation

Have you tried using the built in "Find Duplicate" wizard?
Do you need something more than what that does?
Forum: General 09-30-2019, 09:06 AM
Replies: 9
Views: 201
Posted By Mark_
Re: In over my head.

One note regarding concurrent users; while you may have 40 odd users who CAN access the system, odds are you won't have them all using it at once.

This does bring up a different issue you may...
Forum: Tables 09-27-2019, 09:05 AM
Replies: 6
Views: 176
Posted By Mark_
Re: conditional autonumber?

ReginaF,

A suggestion, use an actual autonumber in your table AND have your custom number for display. You would use the real autonumber (never seen by users) to link together child records and...
Forum: Forms 09-27-2019, 09:01 AM
Replies: 2
Views: 100
Posted By Mark_
Re: displaying images in a subform

Please also make sure all of your images are in .png format. Access won't always display right if they are in other formats.

As a GIANT pain, some times a .jpg will show on a form but not report...
Forum: General 09-27-2019, 08:59 AM
Replies: 13
Views: 213
Posted By Mark_
Re: Width, Height, Top, Left Properties keep jumping around / won't accept value

If I remember correctly, this is also impacted by the resolution your monitor is set to. I remember having this issue when two different computers (older with lower res monitor) wouldn't let the same...
Forum: Tables 09-26-2019, 08:04 PM
Replies: 9
Views: 199
Posted By Mark_
Re: Alternative approach to multivalue field

Dunebuggy,
any other information you need to record by country? i.e. number of participants, date (or date range), coordinator, ect?
Forum: Modules & VBA 09-24-2019, 02:07 PM
Replies: 12
Views: 187
Posted By Mark_
Re: Loop through a table to find value and us in SQL query

To help us aid you better, is your intent to import the excel sheets into temporary tables then move them to a normalized set of tables? If yes, is this a one time import or will you need to do it...
Forum: Modules & VBA 09-23-2019, 02:24 PM
Replies: 12
Views: 187
Posted By Mark_
Re: Loop through a table to find value and us in SQL query

As important, what is the advantage to you of having duplicate data? Is the 2nd table not one that can be related to the original?
Forum: Modules & VBA 09-23-2019, 10:49 AM
Replies: 4
Views: 82
Posted By Mark_
Re: Macro to empty tables

Is this for testing or is this intended for use in an production environment?
Forum: Reports 09-23-2019, 10:47 AM
Replies: 5
Views: 164
Posted By Mark_
Re: Correct formatting of main & subreports Access 2007

Can you post a sample DB with the report/subreport?
Showing results 1 to 25 of 500

 
Forum Jump



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