Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.13 seconds.
Search: Posts Made By: theDBguy
Forum: Queries Yesterday, 08:06 PM
Replies: 5
Views: 86
Posted By theDBguy
Re: Like R

Hi Nicole. Glad to hear you got it to work. Good luck with your project.
Forum: Queries Yesterday, 05:56 PM
Replies: 5
Views: 86
Posted By theDBguy
Re: Like R

Hi Nicole. Can't download your file at the moment but maybe try something like:

Like "R[0-9]*"

Sent from phone...
Forum: Modules & VBA Yesterday, 04:24 PM
Replies: 2
Views: 71
Posted By theDBguy
Re: Two dimensional SQL table lookup

Hi Max. I agree with Galaxiom about your table structure, but you should also be able to use DLookup() to get your value. For example,

MyValue=DLookup(t,"TableName","Hpa=" & p)
Forum: Introduce Yourself 12-14-2019, 07:09 AM
Replies: 3
Views: 68
Posted By theDBguy
Re: Hello

Hi. Welcome to AWF!
Forum: Forms 12-13-2019, 07:13 PM
Replies: 6
Views: 92
Posted By theDBguy
Re: RecordSouce changes without instruction to

Okay. Thanks for checking and letting us know. Cheers!
Forum: Forms 12-13-2019, 06:53 PM
Replies: 6
Views: 92
Posted By theDBguy
Re: RecordSouce changes without instruction to

Hi. Just curious, what happens if you tried to use the Open (instead of Load) event to assign the Record Source?
Forum: Reports 12-13-2019, 06:40 PM
Replies: 16
Views: 186
Posted By theDBguy
Re: Prioritizing Data in a Report

Good job and good luck with your project.
Forum: Forms 12-13-2019, 06:39 PM
Replies: 6
Views: 92
Posted By theDBguy
Re: RecordSouce changes without instruction to

Hi. In addition to what June7 said, I think using Form_frmMismatchComm before a DoCmd.OpenForm "frmMismatchComm" creates two separate instances of the same form.
Forum: General 12-13-2019, 06:36 PM
Replies: 16
Views: 237
Posted By theDBguy
Forum: Reports 12-13-2019, 02:09 PM
Replies: 18
Views: 129
Posted By theDBguy
Re: Chart Colours

Hi Colin. Thanks for the clarification. I forgot, is the new chart only available with O365 or 2019? I'm home now, and my 2016 (C2R) doesn't have it either.
Forum: Reports 12-13-2019, 10:48 AM
Replies: 18
Views: 129
Posted By theDBguy
Re: Chart Colours

Okay. Good luck!
Forum: Reports 12-13-2019, 10:29 AM
Replies: 18
Views: 129
Posted By theDBguy
Re: Chart Colours

Do you mean the last image (from MS)? If so, sorry, I guess I can't help you because I don't have that. I'll have to check what I have at home, though, tonight and let you know then. It might still...
Forum: Reports 12-13-2019, 10:17 AM
Replies: 18
Views: 129
Posted By theDBguy
Re: Chart Colours

Hi. Here's what it looks like on my 2010 version.


https://access-programmers.co.uk/forums/attachment.php?attachmentid=77920&stc=1&d=1576260959

And here's what it looks like on my 2016...
Forum: Reports 12-13-2019, 09:49 AM
Replies: 18
Views: 129
Posted By theDBguy
Re: Chart Colours

Hmm, I might have the old chart on my copy of Access 2016 (MSI). Can you post a screenshot of your Ribbon where you click to add a chart? Thanks.
Forum: Reports 12-13-2019, 09:46 AM
Replies: 18
Views: 129
Posted By theDBguy
Re: Chart Colours

I just gave it a quick try, and I was able to change the colors. Do you know how I can tell if I have the new or the old chart?
Forum: Reports 12-13-2019, 09:39 AM
Replies: 18
Views: 129
Posted By theDBguy
Re: Chart Colours

Could you maybe create a new blank db and simply add one dummy table and one report with a chart on it? Just curious...
Forum: Reports 12-13-2019, 09:31 AM
Replies: 18
Views: 129
Posted By theDBguy
Re: Chart Colours

So, are you able to post a sample/demo copy of your chart db for us to give it a try? Just wondering...
Forum: General 12-13-2019, 09:26 AM
Replies: 16
Views: 237
Posted By theDBguy
Re: Uploading Access Database to Sharepoint

Well, whatever you do, try to avoid using WiFi with Access, especially if your database is critical to your business. As Doc mentioned earlier, Access needs consistent connection with the data store,...
Forum: Reports 12-13-2019, 09:09 AM
Replies: 18
Views: 129
Posted By theDBguy
Re: Chart Colours

Hi. I haven't used the new chart feature, but I have used the old one before. If you can select chart colors before, I can't imagine you won't be able to now. They usually add feature instead of...
Forum: General 12-13-2019, 09:04 AM
Replies: 16
Views: 237
Posted By theDBguy
Re: Uploading Access Database to Sharepoint

Hi. I'm not sure if this was directed at me or to Doc. Where are the people you are trying to "share" the database located? Are they all in the same building?
Forum: Macros 12-13-2019, 09:01 AM
Replies: 9
Views: 157
Posted By theDBguy
Re: How to hyperlink to other subforms on a tab control?

Hi. Yes, this should be possible. I'll wait 'til you get a chance to post a sample db because BrowseTo requires precise syntax.
Forum: Modules & VBA 12-13-2019, 08:34 AM
Replies: 12
Views: 236
Posted By theDBguy
Re: Writing SQL to open a recordset, then it VBA gets confused...

Hi David. Glad to hear you got it sorted out. Good luck with your project.
Forum: General 12-13-2019, 08:32 AM
Replies: 16
Views: 237
Posted By theDBguy
Re: Uploading Access Database to Sharepoint

Hi. Yes, sort of. SharePoint can be the BE, but the data will be stored in Lists (not Access tables in Document Libraries). Access can connect to different data hosts like SQL Server and others, and...
Forum: Reports 12-13-2019, 08:30 AM
Replies: 16
Views: 186
Posted By theDBguy
Re: Prioritizing Data in a Report

Hi TheBigEasy. Did you follow June7's suggestion? Did it work?
Forum: Reports 12-13-2019, 08:28 AM
Replies: 9
Views: 142
Posted By theDBguy
Re: Annual Report based by month

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.
Showing results 1 to 25 of 500

 
Forum Jump



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