Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.12 seconds.
Search: Posts Made By: Mark_
Forum: Politics & Current Events Yesterday, 02:25 PM
Replies: 404
Views: 22,748
Posted By Mark_
Re: Antarctic sea ice is now DECLINING dramatically

I had been thinking about how much ice should be down there and how long it would take to get a good baseline. That's when I was reminded of the Nilometer (https://en.wikipedia.org/wiki/Nilometer)...
Forum: General Yesterday, 01:59 PM
Replies: 8
Views: 109
Posted By Mark_
Re: Creating an Amortisation Schedule in Access

Just to make sure, you are using simple interest, not compound?

Are you also trying to create a schedule of payments due so that you know when the next payment will be and for how much?
Forum: Forms Yesterday, 10:33 AM
Replies: 3
Views: 63
Posted By Mark_
Re: Yes/No field

I have also seen this done with a button where the caption of the button is set based on value in a Yes/No.

If Me.YesNoField = True
Me.Button.Caption = "√"
Me.Button.Caption = ""...
Forum: Modules & VBA 07-17-2019, 03:40 PM
Replies: 13
Views: 201
Posted By Mark_
Re: Summing date ranges

One thing to be very careful about; Periods that start BEFORE or end AFTER your date range.

John work from July 21st to September 7th. How do you want to reflect his time if your asking for only...
Forum: Queries 07-16-2019, 08:51 AM
Replies: 6
Views: 114
Posted By Mark_
Re: Date\Time to hourly slots

I have had to do this in the past. How many records are you looking at? Will job type also need to be included? What are the rules for "Hour" as you show "Before 9am"?
Forum: General 07-15-2019, 01:17 PM
Replies: 12
Views: 161
Posted By Mark_
Re: PO generator

To add to Doc's post, can you walk us through how you envision someone using the system? Start with the person taking an order. What do they need to know? What do they record?

Remember that as...
Forum: Politics & Current Events 07-14-2019, 01:12 PM
Replies: 404
Views: 22,748
Posted By Mark_
Re: Antarctic sea ice is now DECLINING dramatically

Issue that few want to talk about though is that the way ice thickness is measured has changed since reading started. They have gotten better and better at getting a good read, but they are still...
Forum: Politics & Current Events 07-13-2019, 08:35 PM
Replies: 404
Views: 22,748
Posted By Mark_
Re: Antarctic sea ice is now DECLINING dramatically

Interesting read. I'm really wishing we had a much better grasp of how much ice is "Normal", something that will take a fairly long time to determine. It does beg the question how much ice is...
Forum: Theory and practice of database design 07-11-2019, 03:36 PM
Replies: 20
Views: 546
Posted By Mark_
Re: building a database from scratch

Oddly, this is one piece I often don't do. Rather, I prefer sitting with a few employees to see HOW they fill out the form (order for fields) rather than see what manager expect them to use. It has...
Forum: Queries 07-11-2019, 08:13 AM
Replies: 4
Views: 114
Posted By Mark_
Re: Query not working when one field is not filled

You do not provide the "False" value when you use IIF (https://support.office.com/en-us/article/iif-function-32436ecf-c629-48a3-9900-647539c764e3). You are giving a condition and a "TRUE" value.
Forum: Tables 07-10-2019, 07:26 AM
Replies: 4
Views: 72
Posted By Mark_
Re: Autonumber question

One warning about "2019-###", what happens in 2021 when you have 2174 records for the year? Is this a possibility?
Forum: Forms 07-10-2019, 07:22 AM
Replies: 23
Views: 369
Posted By Mark_
Forum: General 07-09-2019, 03:52 PM
Replies: 3
Views: 126
Posted By Mark_
Re: Grouped query and sort numbers

jessy. Welcome to awf!

From what you have posted, you should have the following tables/records

In tblStations, you should have the following records;
Station 1
Station 2
Station 3
Station 4
Forum: Forms 07-09-2019, 02:42 PM
Replies: 23
Views: 369
Posted By Mark_
Re: When Filtering Form and no results are returned. Handle the search box gracefully

Please remember, what is intuitive to one person is not intuitive to another.

For myself, I would have used a subform that gets filtered from the parent. If the filter returns no values you could...
Forum: Tables 07-09-2019, 12:50 PM
Replies: 5
Views: 147
Posted By Mark_
Re: Anything wrong with my table relationship design?

One thing you may want to consider; Any chance a customer will have more than one email or phone number?

I'd add a "tblCustContact" that has
ContactID - AutoNumber
CustomerID - Foreign Key to...
Forum: Forms 07-09-2019, 11:14 AM
Replies: 23
Views: 369
Posted By Mark_
Re: When Filtering Form and no results are returned. Handle the search box gracefully

You can always use DCount() to validate that your filter WILL return results before changing your filter. This will avoid issues with no results returned.

When you have no results, what do you...
Forum: Queries 07-08-2019, 03:38 PM
Replies: 9
Views: 188
Posted By Mark_
Re: Multiple Appends


One thing to think about if you are doing timekeeping, how do you want to handle holidays /weekends?
Forum: Reports 07-04-2019, 05:15 AM
Replies: 24
Views: 340
Posted By Mark_
Re: Restricted Employee Access to Reports

Two questions;
1) Can you have a separate front end for "Clients" instead of employees? If yes, this generally means you can use network security to help keep people out of areas they should not be...
Forum: The Watercooler 07-02-2019, 10:11 AM
Replies: 2,970
Views: 578,310
Posted By Mark_
Re: What's your best/worst joke?

Doc, what a horrible thing to say! Walking down the highway... I never!

They'd be bused down the highway. Walking would be dangerous!
Forum: Modules & VBA 07-01-2019, 10:40 AM
Replies: 6
Views: 150
Posted By Mark_

Please post the command line copy that works so we can make sure you are using the proper syntax.
Forum: General 07-01-2019, 08:49 AM
Replies: 13
Views: 243
Posted By Mark_
Re: Splitting Linked DBs

Hi ErinL,

One other question that may be relevant; are all computers connected to your network physically or are some wireless?
Forum: The Watercooler 07-01-2019, 06:05 AM
Replies: 4
Views: 114
Posted By Mark_
Re: Boston vs Yankees in UK?


Try playing it with an M-79. Hole in one every time, but the grounds crew will hate you.
Forum: Forms 07-01-2019, 06:00 AM
Replies: 19
Views: 426
Posted By Mark_
Re: Sequential Number in Access form(invoice box)

Business questions;

1) Are you required to account for each invoice number, even if it is not used?
2) What happens if you start a transaction but it is not finished?
3) What happens if...
Forum: General 06-27-2019, 01:45 PM
Replies: 14
Views: 312
Posted By Mark_
Re: Loosing Data from tables

Would have to see your code in the form(s) that do this. It could be that you are accidentally saving a blank record then NOT saving the update.
Forum: Forms 06-27-2019, 01:31 PM
Replies: 15
Views: 516
Posted By Mark_
Re: Autogenerate incremented number based on number of records and add a prefix

OK, I think I see what is causing you such an issues.

Me.txtDetailLineNumber.DefaultValue = rst!OrderNumber & "-" &resultcustomProjNr
In your child record you are saving the OrderNumber, ad...
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 07:04 PM.

Microsoft Access Help
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