Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.47 seconds.
Search: Posts Made By: Mark_
Forum: Politics & Current Events 10-14-2019, 07:01 PM
Replies: 525
Views: 27,234
Posted By Mark_
Forum: Politics & Current Events 10-14-2019, 03:56 PM
Replies: 525
Views: 27,234
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: 311
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: 103
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: 207
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: 689
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: 689
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: 205
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: 272
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,516
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,516
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: 200
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: 170
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: 98
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: 194
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: 160
Posted By Mark_
Re: Correct formatting of main & subreports Access 2007

Can you post a sample DB with the report/subreport?
Forum: Tables 09-23-2019, 08:56 AM
Replies: 12
Views: 231
Posted By Mark_
Re: Modeling Many-to-Many-to-Many relationship?

AZ_CC,

Can one funding source go to more than one expenditure?
Forum: Tables 09-19-2019, 02:13 PM
Replies: 8
Views: 207
Posted By Mark_
Re: Why does autonumber started at 2 with 1 around the middle and 4 in the last?

To add to the others, when you delete records, new records are written over their position. Autonumber also does NOT change your numbers when you delete a record, so you can start with

1 Apple
2...
Forum: Forms 09-18-2019, 08:13 AM
Replies: 10
Views: 145
Posted By Mark_
Re: Email Form As Shown (Not in Tabular Format)

First question is how are you trying to send the Email?

For myself, I normally use Outlook. Doing this I have to work out what the body of the Email will look like and code it so I can send...
Showing results 1 to 25 of 500

 
Forum Jump



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