Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 1.63 seconds.
Search: Posts Made By: Mark_
Forum: The Watercooler Yesterday, 10:21 AM
Replies: 6
Views: 89
Posted By Mark_
Re: How many genders are there?

Just to confuse things, Complete androgen insensitivity syndrome (https://en.wikipedia.org/wiki/Complete_androgen_insensitivity_syndrome) means that your can have a normal XY pair but be female in...
Forum: Forms Yesterday, 07:57 AM
Replies: 6
Views: 123
Posted By Mark_
Re: Preventing users from removing attachments from the Attachment Control in a Form

Here is code I use to find an image and fill in the path for a record:

Private Sub Btn_FindImage_Click()
Dim asFile As String
Dim afDialog As Office.FileDialog

Set afDialog =...
Forum: The Watercooler 06-17-2019, 03:55 PM
Replies: 10
Views: 226
Posted By Mark_
Re: I'm OK with this particular use of firearms!

Tera,

I will defer to the people of Venezuela when it comes to WHY the populace should be armed.
Forum: The Watercooler 06-17-2019, 02:52 PM
Replies: 2,953
Views: 576,734
Posted By Mark_
Re: What's your best/worst joke?

This one is very fun to ask people...

"If you paired a pair of pears with a pair of pants, how many pieces in your pairing?"

I've had several people give up in frustration...
Forum: Forms 06-17-2019, 12:43 PM
Replies: 5
Views: 100
Posted By Mark_
Re: Form Help Please!

Quick answer would be to open your form as a Split Form and allow the users to use the built in functions. This is a one minute change that can give you a basic idea of what is already supported by...
Forum: The Watercooler 06-17-2019, 12:40 PM
Replies: 10
Views: 226
Posted By Mark_
Re: I'm OK with this particular use of firearms!

Colin,

I believe the answers you are looking for are
a) Americans don't want to get blood all over themselves so they would prefer to shoot you over spending the time and effort stabbing you to...
Forum: Modules & VBA 06-13-2019, 01:23 PM
Replies: 10
Views: 151
Posted By Mark_
Re: Programming Logic for stopping events from occuring

Another way of doing the same would be to have EVERY call return FALSE if succeeds, and an error code if it fails. then you code look like

If RunWoStatusChanges() Then GOTO ProcFail
If...
Forum: Forms 06-13-2019, 08:00 AM
Replies: 6
Views: 123
Posted By Mark_
Re: Preventing users from removing attachments from the Attachment Control in a Form

For all approaches you would have a child record that holds the path to the attachment.

Simple approach; User copies attachment to a location then uses a file dialog to find the attachment. Pro:...
Forum: Modules & VBA 06-13-2019, 07:40 AM
Replies: 10
Views: 151
Posted By Mark_
Re: Programming Logic for stopping events from occuring

To me, it sounds as though you are putting a cart in front of random animals...

I would not be checking to see if there is an error, rather I'd simply make sure each piece had completed properly...
Forum: Reports 06-12-2019, 01:32 PM
Replies: 4
Views: 154
Posted By Mark_
Re: Graphic in Report

I've done gantt charts by simply having a label with a back ground colour on it. I'd set the width to 0, set the left based off of the start date, then change the width based on the end date. It is...
Forum: Forms 06-12-2019, 10:11 AM
Replies: 6
Views: 123
Posted By Mark_
Re: Preventing users from removing attachments from the Attachment Control in a Form

Hi Cark,

Rather than keeping the attachments in your database I strongly suggest keeping a path to them. This avoids issues with database bloat and issues with proper display/edit of attached...
Forum: Sample Databases 06-11-2019, 03:32 PM
Replies: 0
Views: 124
Posted By Mark_
Add Linking records between master files

Several times Ive seen basically the same question asked;
I have a LIST and I want to show all of it, but only make linking records to those that apply?
How I do show all records in Table A and...
Forum: Forms 06-07-2019, 10:05 AM
Replies: 8
Views: 108
Posted By Mark_
Re: DLookup question

It sounds like your data is not normalized. You may want to read up on data normalization. This type of problem will occur again in the future and may be far more difficult to work around.
Forum: Forms 06-06-2019, 09:44 AM
Replies: 5
[SOLVED] Iif and + or
Views: 78
Posted By Mark_
Re: Iif and + or

IIF( ABS(Me.Txt_1) > 5, IIF(me.txt_2 > 5000, TRUE, FALSE), FALSE)
Forum: Reports 06-06-2019, 09:26 AM
Replies: 14
Views: 135
Posted By Mark_
Re: Gerated Record Numebr

OK, just a few things to go over to help you understand what you are trying to bite off;
1) Autonumber fields do just that. They start at 1, add 1 every time a record is added, and are a number...
Forum: Reports 06-06-2019, 08:14 AM
Replies: 14
Views: 135
Posted By Mark_
Re: Gerated Record Numebr

Before you go too far in, are they expecting the number to start over at 0000 some point in the near future?
Forum: Tables 06-05-2019, 05:43 PM
Replies: 4
Views: 94
Posted By Mark_
Re: Unable to add attachments in linked table

Roger,

I'll second Micron's post. Also allows you to manipulate the attachment with the program it is intended to work with. Means you can have a word document, open it in word, and allow your end...
Forum: The Watercooler 06-05-2019, 05:41 PM
Replies: 18
Views: 341
Posted By Mark_
Re: Hazardous Living

At least your not telling her she's wrong... :D:D:D
Forum: Queries 06-04-2019, 06:22 AM
Replies: 11
Views: 148
Posted By Mark_
Re: Easier way than hundreds of fields?

I would have to say you are thinking of this like a spreadsheet.

You have a "Product".
Each "Weight" would be in a child record to the "Product". Then you total these child records to get your...
Forum: Modules & VBA 06-03-2019, 03:43 PM
Replies: 12
Views: 154
Posted By Mark_
Re: References and functions?

Gasman,

I'd personally put a comment in BEFORE you reference the object that tells you
'objClip REQUIRES MSForms Library. Check that its there before using.
Dim objClip as New DataObject
.
....
Forum: Forms 06-03-2019, 02:35 PM
Replies: 14
Views: 156
Posted By Mark_
Re: Mr & Mrs

First part is "How to relate two records". As this is for a mortgage that means you can have one OR MORE names on title/what have you, especially if dealing with business partnerships. That means you...
Forum: General 06-03-2019, 02:27 PM
Replies: 11
Views: 199
Posted By Mark_
Re: To archive, or not?

It is very difficult to say "After X records" because each back end is running on different hardware with different data structures in the DB being accessed by a highly variable number of users.
...
Forum: Queries 06-03-2019, 01:33 PM
Replies: 29
Views: 730
Posted By Mark_
Re: Sum of a field defined by query expression

Your query should look something like
SELECT [OrderID],[DetailNo], [Amount] + [Shipping] + [Tax] AS TotalAmt FROM TblOrder WHERE [OrderID] = OrderID

Then when you have the query open in design...
Forum: Queries 06-03-2019, 11:18 AM
Replies: 29
Views: 730
Posted By Mark_
Re: Sum of a field defined by query expression

In your order, I am guessing you use line items for what is being ordered. Do these line items have something that indicates they are taxable or have a shipping charge?

If yes, you can either add...
Forum: General 06-03-2019, 09:18 AM
Replies: 19
Views: 212
Posted By Mark_
Re: Group Emails using a List Box

I'd need to know how you link Emails to groups. So long as the same EMail isn't duplicated in the database you should be able to do this fairly easily. Can you post the SQL for one of your queries so...
Showing results 1 to 25 of 500

 
Forum Jump



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