Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.50 seconds.
Search: Posts Made By: Mile-O
Forum: Queries 02-26-2016, 08:10 AM
Replies: 2
Views: 873
Posted By Mile-O
Re: Showing all records in a Crosstab query - even null values

Sam Summers; that's a username blast from the past...

One quick solution would be to, in the query design view, right click on whatever your field is your crosstab's column heading and enter the...
Forum: Modules & VBA 02-25-2016, 01:46 AM
Replies: 8
Views: 702
Posted By Mile-O
Re: Chunks of 20 products from a list of 180 - best approach?

Another useful thing to note is the Static keyword.

So, rather than Dim, you can use Static, and the variable value will be retained.

Static myCounter As Long
Forum: Modules & VBA 02-24-2016, 01:12 AM
Replies: 4
Views: 2,053
Posted By Mile-O
Re: Dcount With Multiple Criteria

I would have thought IsNull(DateReceived) would be better written as DateReceived Is Null in this context.

Anyway,

CountMsg = DCount("*", "[F_Tbl_Msg]", "([ToUserID]= """ &...
Forum: The Watercooler 02-22-2016, 01:21 AM
Replies: 2
Views: 611
Posted By Mile-O
Re: Happy Birthday Mile-O

Cheers. Though these days I try not to be reminded. :p
Forum: Modules & VBA 02-19-2016, 03:56 AM
Replies: 18
Views: 1,076
Posted By Mile-O
Re: Complex Search Form

I added tags so that some code doesn't look like this:

Dim intExample As Integer

For intExample = 1 To 10
MsgBox "Example " & intExample
Next intExample

But instead looks like this.
Forum: Modules & VBA 02-19-2016, 03:36 AM
Replies: 18
Views: 1,076
Posted By Mile-O
Re: Complex Search Form

Apologies, I tried to add adding tags to the original post, but the code having a field called [CODE] threw it off.
Forum: General 02-18-2016, 06:33 AM
Replies: 13
Views: 694
Posted By Mile-O
Re: Is Access Capable of doing this?

A table structure, something basic like this, should do exactly what you are wanting to do without having to store calculated values in your table.


tblMaterialTypes
MaterialTypeID (Autonumber,...
Forum: General 02-18-2016, 05:17 AM
Replies: 13
Views: 694
Posted By Mile-O
Re: Is Access Capable of doing this?

You're in Access now; leave the Excel thinking at the door.

You can calculate in queries and make these queries your form's RecordSource, rather than a table. The control's ControlSource need only...
Forum: General 02-18-2016, 04:53 AM
Replies: 13
Views: 694
Posted By Mile-O
Re: Is Access Capable of doing this?

I told him as much yesterday.

http://www.access-programmers.co.uk/forums/showthread.php?t=284693
Forum: Forms 02-17-2016, 08:50 AM
Replies: 7
Views: 587
Posted By Mile-O
Re: How to make form populate table

ALARM BELL!

Do not do this. If you are calculating it at run-time, you always calculate it at run-time. This is part and parcel of database design in that you do not store calculated values. (See:...
Forum: Tables 02-17-2016, 06:18 AM
Replies: 8
Views: 838
Posted By Mile-O
Re: One-to-ones or one big one? And other questions

Unless you need a very specific unique code structure for your objects then the autonumber should suffice. That you are losing numbers through deletes shoudl not matter as the number is ultimately...
Forum: Tables 02-17-2016, 06:13 AM
Replies: 8
Views: 838
Posted By Mile-O
Re: One-to-ones or one big one? And other questions

Here's a quick table structure for measurements and the main objects.

tblObjects
ObjectID (Autonumber, primary key)
ObjectName (Text)
...
(stuff related to the object)

tblMeasurements...
Forum: Forms 02-17-2016, 06:00 AM
Replies: 17
Views: 973
Posted By Mile-O
Re: Is there an error in the syntax of this expression?

What happens when you take out Sum( ) and just leave 140*15*1200? It seems redundant there and may be causing an issue.

IIf(IsNumeric([WEIGHT CALC]), 140*150*1200, 0)

If you change the...
Forum: Forms 02-17-2016, 04:02 AM
Replies: 17
Views: 973
Posted By Mile-O
Re: Is there an error in the syntax of this expression?

Something to note: you are comparing apples with oranges.

Weight Calc is a value of 2200. "Select Material" is a text string. Or in other words, number = text is not a valid comparison.
Forum: Forms 02-16-2016, 01:13 AM
Replies: 4
Views: 674
Posted By Mile-O
Re: Error in coding for login form

He means this:
TempPass = DLookup("StaffPassword", "Staff_chelsea", "StaffId = " & Me.txtloginid.Value)


Also, it would be best to use a Nz() on that DLookup, to catch any occasion where you...
Forum: Forms 02-15-2016, 01:33 AM
Replies: 3
Views: 886
Posted By Mile-O
Re: Docmd. run action queries?

Save the user the hassle of asking for passwords by just giving them a UserLevel and referring to it when you want to check something. Have a look at my ThisUser class here:...
Forum: Reports 02-11-2016, 06:14 AM
Replies: 2
Views: 414
Posted By Mile-O
Re: Too Few Paramater Expecetd 1

Are you using VBA in your report to build this SQL? Say, using the QueryDefs object and/or a Recordset object?
Forum: Theory and practice of database design 02-10-2016, 03:25 AM
Replies: 5
Views: 2,777
Posted By Mile-O
Re: Database for Employee Training

Were I looking to do this, I think I would want to break things down and probably add a few more items. By a few more items I'm thinking of things like Vendor (who is providing the training), it's...
Forum: Access World News 11-11-2015, 03:23 AM
Replies: 32
Views: 15,307
Posted By Mile-O
Re: EU Cookie Privacy Laws - popups coming

On a Wordpress based site I maintain, I implemented a Cookie notice via a plugin. This one pops up on the site, and then vanishes after about 5 seconds. Less intrusive.
Forum: Tables 08-14-2015, 07:48 AM
Replies: 6
Views: 771
Posted By Mile-O
Re: Excel cell selector

I don't see it working. With Excel you are effectively creating a Range object by selecting/dragging. In Access, the Range object doesn't exist.
Forum: Tables 08-13-2015, 07:56 AM
Replies: 6
Views: 771
Posted By Mile-O
Re: Excel cell selector

You mean like this? Move the cursor over the edge of a cell until you get th white cross cursor, then drag along. Not that it does much.
Forum: Forms 03-31-2015, 03:52 AM
Replies: 5
Views: 801
Posted By Mile-O
Re: Creating a lookup

No need for a DLookup.

Put the contact number in the query of your main contact combo. Set the column count to include this, and then hide the column with the contact number.

In your textbox,...
Forum: Politics & Current Events 03-31-2015, 03:15 AM
Replies: 72
Views: 8,107
Posted By Mile-O
Re: Freedom - ?

No, but if they are punished with a fine then the business may suffer, especially if it's a substantial amount and they can't afford it. Negative coverage may also affect sales. But that's how the...
Forum: Politics & Current Events 03-31-2015, 01:09 AM
Replies: 72
Views: 8,107
Posted By Mile-O
Re: Freedom - ?

Who is the I when it comes to selling goods? Is it a person who works within a business enforcing their own beliefs or is it, under laws of corporate personhood, the business itself with its terms...
Forum: General 03-27-2015, 08:42 AM
Replies: 6
Views: 1,134
Posted By Mile-O
Re: List box row source queries

It would be. But when you obfuscate your problem behind unhelpful object names, it's hard to grasp a) what you're doing overall; and b) if the reason you have to do it is down to a fundamental design...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 10:23 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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World