Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 371
Search took 0.08 seconds.
Search: Posts Made By: Mark_
Forum: General 10-02-2019, 07:35 AM
Replies: 12
Views: 275
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: Forms 10-01-2019, 08:35 PM
Replies: 8
Views: 8,600
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: General 09-30-2019, 09:06 AM
Replies: 9
Views: 223
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-19-2019, 02:13 PM
Replies: 25
Views: 633
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
Forum: General 09-12-2019, 09:05 AM
Replies: 13
Views: 248
Posted By Mark_
Re: Checkbox to activate Combo box to then populate textbox - Possible at all? Pls He

From a design standpoint, I'll admit I'd do this a little differently.

I'd have your combo for exchange rates. I'd have the default for it be "", and "" would be an option. Then if you DON'T have...
Forum: General 09-12-2019, 08:57 AM
Replies: 9
Views: 179
Posted By Mark_
Re: User Interface Form - Report

To add to what the others have posted, since you will be running a report on this, I'd suggest two additional tables that you will want;

TblAudit-This contains information relevant to a given...
Forum: Tables 09-11-2019, 12:43 PM
Replies: 17
Views: 341
Posted By Mark_
Re: Identify and rename MS Access latest table - SQL

This may sound like an odd question, but why do you need to rename a table? From the format, it looks like you are saving data as part of a table name.
Forum: Forms 09-11-2019, 07:49 AM
Replies: 23
Views: 325
Posted By Mark_
Re: Attachment field and sending email by access

Your very welcome. Took me a couple days to fix that when I was trying to find out why my "Email group" procedure wasn't working. Really annoying issue...
Forum: Forms 09-04-2019, 07:52 AM
Replies: 20
Views: 280
Posted By Mark_
Re: Single Field Form - Best Practice

Having run into it lately, if you DO go with image files your best if they are in .PNG format. I've had issues with non-PNG images not appearing on reports, even if they do show on an image control...
Forum: The Watercooler 08-30-2019, 07:45 PM
Replies: 5
[SOLVED] "Zed's dead.....
Views: 157
Posted By Mark_
Re: "Zed's dead.....

Forum: Modules & VBA 08-27-2019, 07:01 PM
Replies: 6
Views: 146
Posted By Mark_
Re: Check box issue

Just to make sure, there is nothing in your table that shows 'Product shipped'.

An easy approach is to record the date the product was shipped. Then you can quickly filter out those records to...
Forum: General 08-22-2019, 01:04 PM
Replies: 25
Views: 443
Posted By Mark_
Re: Access Training Database

I put that in as bold and red to make sure were very clear;

Employee takes "Widget Waxing" V1.
When "Widget Waxing" V2 comes out, they need to take the course all over again.

This means that...
Forum: General 08-22-2019, 10:54 AM
Replies: 25
Views: 443
Posted By Mark_
Re: Access Training Database

To help clarify, Does the training fall into one of the following?

1) A given course is only good for a set duration (normally 1 year or 2 years) and needs to be redone afterward?
2) A given...
Forum: General 08-16-2019, 09:47 AM
Replies: 14
Views: 274
Posted By Mark_
Re: Struggling with an Inventory Tacking DB

Three steps back.

You need a product table that is looked up (not directly related to) INVENTORY, BATCH and PO LINE ITEM
You need an INVENTORY. This has
Product – What is made
Quantity –...
Forum: The Watercooler 08-13-2019, 07:30 AM
Replies: 19
Views: 414
Posted By Mark_
Re: Me as a developer and how my apps are used.

Almost as annoying as finishing up the change request, rolling out a new function that is on their "Must have" list, and going back 6 months later to see they never use it.

Really hated seeing a...
Forum: General 08-12-2019, 09:06 AM
Replies: 10
Views: 156
Posted By Mark_
Re: Degrees and employees

A unique index on Employee and date would prevent you from having two degrees issued the same date.

If you use a list of degrees, you can Join it to your table of degrees and exclude all where...
Forum: General 08-12-2019, 08:15 AM
Replies: 10
Views: 156
Posted By Mark_
Re: Degrees and employees

Do you have a list of "Degrees" that you can choose from? if so, I'd have a drop down on it. If not, you should be able to check the DegDate and make sure they don't add two degrees for the same date.
Forum: General 08-12-2019, 08:06 AM
Replies: 10
Views: 156
Posted By Mark_
Re: Degrees and employees

Please post what you already have and how you determine "existing degree"?
Forum: Queries 08-12-2019, 06:31 AM
Replies: 22
[SOLVED] Error on IIF
Views: 225
Posted By Mark_
Re: Error on IIF

@ OP,

So you can better understand what CJ_London was posting about,
ANY time you pass a value inside quotes or any time you tell something to be returned in quotes, ACCESS treats it as a text...
Forum: General 08-09-2019, 11:16 PM
Replies: 6
Views: 143
Posted By Mark_
Re: Huge decimal places when subtracting two numbers

In addition to what the others have said, if your first value shows as 76.07 but was calculated as 76.06999999999999, then you are getting the right answer. This means we would need to know where...
Forum: Modules & VBA 08-05-2019, 09:21 AM
Replies: 8
Views: 246
Posted By Mark_
Re: Make controls visible/invisible in combo box using VBA

To add to Pat's good advice, I would normally add one SUB that sets all of the controls .Visible = False. I would call this FIRST, then only make visible what you need.

I'd also have them all...
Forum: General 08-05-2019, 09:01 AM
Replies: 20
Views: 393
Posted By Mark_
Re: Pencil and paper

I wonder what happens when he realizes he has to SHARPEN a pencil or it stops working? Will he get rid of it because its broken?
Forum: Modules & VBA 08-02-2019, 03:50 PM
Replies: 67
Views: 662
Posted By Mark_
Re: Code for Business Hours -Help Please


Since the start/end times are variable for your employees, you may find it most useful for a given extract to have one (or more) "processing" records. Each would have start date/time and...
Forum: Forms 07-18-2019, 10:33 AM
Replies: 3
Views: 104
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: 16
Views: 338
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...
Showing results 1 to 25 of 371

Forum Jump

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