Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 28
Search took 0.02 seconds.
Search: Posts Made By: MajP
Forum: Modules & VBA 09-13-2019, 05:14 PM
Replies: 10
Views: 908
Posted By Pat Hartman
Re: Can't move subform to next record

This whole thread mystifies me. Forms are the way humans interact with data. Code should be using action queries or recordsets rather than automating forms.
Forum: Modules & VBA 08-08-2019, 06:45 AM
Replies: 25
Views: 444
Posted By The_Doc_Man
Re: Cannot Open anymore databases

What the static-variable DB pointer accomplishes, when compared to repeatedly just invoking CurrentDB directly in code, relates to the fact that CurrentDB consumes memory, almost certainly on the...
Forum: Modules & VBA 07-12-2019, 05:41 AM
Replies: 13
Views: 377
Posted By plog
Re: Can it be done??

Even though you are determined to do this the wrong way, I'll try and explain myself better and then leave this thread (no promises on the many other threads you will be opening to maintain and get...
Forum: Queries 04-25-2019, 12:58 PM
Replies: 84
Views: 1,199
Posted By Gasman
Re: How it Work function Rnd()?

Well it works for my UK settings.

However if I change to estonian settings, it does not obey the format?

? "#" & Format(thedate, "mm/dd/yyyy") & "#"
Forum: Theory and practice of database design 04-24-2019, 04:57 PM
Replies: 10
Views: 414
Posted By theDBguy
Re: Front End Deployment of Split Database in a small enviornment

Hi. I agree, this would be a very bad idea. Shared front ends are prone to corruption. Also, depending on your database functionalities, if you're using any temporary objects like tables or have some...
Forum: Politics & Current Events 03-27-2019, 06:12 PM
Replies: 11
Views: 487
Posted By Mark_
Re: Alexandria Ocasio-Cortez's "Green New Deal"

And here may be the true reason it did not pass...
Forum: Forms 02-07-2019, 02:55 AM
Replies: 15
Views: 244
Posted By Gasman
Re: Delete Command Button Event

You don't learn do you.:banghead:

On numerous occasions, by numerous people you have been advised to put the sql string into a variable and Debug.Print that variable.

That will almost always...
Forum: Modules & VBA 01-26-2019, 02:51 PM
Replies: 12
Views: 121
Posted By sonic8
Re: Font Dialog (64 Bit compatible) or Get List of Fonts


I can confirm that the above code for the Choose-Font-Dialog actually can be converted to run successfully on 64-bit. - If you want to try it again as an exercise, pay particular attention to...
Forum: Modules & VBA 01-09-2019, 10:01 AM
Replies: 26
Views: 761
Posted By pbaldy
Re: Variables instead of controls?

I don't follow it religiously either. I'd say my rule of thumb is to use a variable if I'm going to need the value more than once, use the control directly if just once.
Forum: Forms 01-07-2019, 02:04 PM
Replies: 27
Views: 799
Posted By June7
Re: Calculation Not Working

Maybe you mean:

=Sum([TransactionPrice]*[TransactionQuantity])/Sum([TransactionQuantity]) = 18.99


=Sum([TransactionPrice]*Abs([TransactionQuantity]))/Sum(Abs([TransactionQuantity])) =...
Forum: General 01-07-2019, 11:31 AM
Replies: 22
Views: 768
Posted By Micron
Re: Forms/controls Example

I agree with Me.myControl name. While it was stated that an incorrect reference wouldn't be debugged, I prefer the term "when compiled". Try misnaming a control in code when you use !. Click to...
Forum: Forms 01-03-2019, 06:34 AM
Replies: 3
Views: 194
Posted By isladogs
Re: RGB and HEX Color Codes Chart

Have a look at my colour converter app at http://www.mendipdatasystems.co.uk/colour-converter/4594450413
This converts between HEX, RGB & OLE colours
Forum: General 12-28-2018, 10:26 AM
Replies: 28
Views: 682
Posted By Pat Hartman
Re: Problem coding forms to feed tables

Access is a RAD (Rapid Application Development) tool. Although you can use it to create your own unbound forms, why??? What do you think is better about writing and testing all your...
Forum: Queries 12-13-2018, 05:36 AM
Replies: 2
Views: 212
Posted By Minty
Re: Please help!

Have a long read of this

No access database is ever fully 100 % secure.
Forum: General 12-09-2018, 07:17 PM
Replies: 7
Views: 879
Posted By The_Doc_Man
Re: Formatting access cells for inputing data in hh:mm format

MajP - you see that format in navigation a lot. When I worked with the oil industry and they did underwater seismic imaging near certain Pacific islands, we would see longitudes between 160 and 180...
Forum: General 12-09-2018, 02:51 PM
Replies: 7
Views: 879
Posted By June7
Re: Formatting access cells for inputing data in hh:mm format

hours:minutes:seconds (elapsed quantity, not clock time) or degrees:minutes:seconds, the calculations to convert to/from decimal hours or decimal degrees are the same. Exclude seconds if that...
Forum: General 12-09-2018, 11:27 AM
Replies: 6
Views: 662
Posted By June7
Re: Feeding Ms Access Form by Outlook (Contact's Photo)

@MajP, it seems links posted in CODE tags are not clickable unless you use HTML tags. If you want to emphasize them then maybe just 'white space' them - add carriage returns.
Forum: Tables 12-07-2018, 04:59 AM
Replies: 17
Views: 1,528
Posted By CJ_London
Re: Does calculated fields cause database going slow?

Nope - you can't index calculated fields

with regards your example calculation, unlike Majp, I would store the calculation elements in a table, then just join to the table. Perhaps something like...
Forum: Queries 12-05-2018, 01:25 PM
Replies: 14
Views: 477
Posted By pbaldy
Re: Save query count to variable

Wouldn't it need to be:

select Count(*) as TotalCount from yourQuery
Forum: Queries 11-19-2018, 10:17 AM
Replies: 4
Views: 608
Posted By pbaldy
Re: consolidating data with empty fields

Maybe I'm just hungry, but wouldn't a totals query grouping on run and sample and using Max on the other fields return the desired result?
Forum: General 11-01-2018, 04:21 AM
Replies: 19
Question ActiveX Controls
Views: 637
Posted By isladogs
Re: ActiveX Controls

Just wondering whether you noticed my reply to you in post #6
Forum: Forms 09-12-2018, 06:16 AM
Replies: 20
Views: 4,555
Posted By moke123
Forum: Queries 08-31-2018, 12:38 PM
Replies: 20
Views: 378
Posted By isladogs
Re: Crosstab query sorting problem

Ah yes - didn't notice that! How about this instead?


NOTE: I altered the date format to...
Forum: Modules & VBA 08-25-2018, 06:11 PM
Replies: 41
Views: 1,487
Posted By The_Doc_Man
Re: dbEngine(0)(0) vs Currentdb

I will step in for one related but slightly tangential comment.

The difference between DbEngine.Idle dbRefreshCache and DoEvents is that the former is a DBEngine-only event, whereas DoEvents...
Forum: General 07-17-2018, 02:22 PM
Replies: 23
Views: 2,411
Posted By Mark_
Re: Multi-tier application

The most secure, lease overhead, and most portable for clients would be separate back ends.

Which would be easier for you to add, procedure level security to ensure only the correct datasets are...
Showing results 1 to 25 of 28

Forum Jump

All times are GMT -8. The time now is 02:25 AM.

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