Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 7.28 seconds.
Search: Posts Made By: RuralGuy
Forum: VB.NET 04-21-2019, 08:41 AM
Replies: 10
Views: 469
Posted By RuralGuy
Re: Multi Column Combox

Have you tried using the wizard to create the combo box?
Forum: Modules & VBA 03-26-2019, 08:18 AM
Replies: 5
[SOLVED] DateAdd()
Views: 247
Posted By RuralGuy
Re: DateAdd()

Try:
NewDate = DateAdd("yyyy", 1, Me.Expires) 'Me.Expires is the field with old date
Forum: Modules & VBA 03-26-2019, 08:15 AM
Replies: 5
[SOLVED] DateAdd()
Views: 247
Posted By RuralGuy
Re: DateAdd()

I suspect that the Me.Expires object is not a DateTime field.
Forum: Modules & VBA 01-09-2019, 08:15 AM
Replies: 12
Views: 452
Posted By RuralGuy
Re: VBA code not working as expected

Use your DLookup to populate a variable and then a MsgBox to display the results to troubleshoot your issue.
Forum: Introduce Yourself 01-07-2019, 09:01 AM
Replies: 2
Views: 191
Posted By RuralGuy
Re: Hello from New Hampshire!

Welcome to the site. Have fun.
Forum: Modules & VBA 12-03-2018, 06:16 AM
Replies: 10
Views: 241
Posted By RuralGuy
Re: Date Problem

See if this link helps: http://allenbrowne.com/ser-36.html
Forum: General 10-31-2018, 03:19 AM
Replies: 4
Views: 191
Posted By RuralGuy
Re: What is the best Event to use for....

I would use the Change event of the TabControl.
Forum: Forms 10-28-2018, 12:02 AM
Replies: 12
Views: 394
Posted By RuralGuy
Re: Filtering subform records

Not really sure. Sorry.
Forum: Introduce Yourself 10-18-2018, 03:23 AM
Replies: 2
Views: 144
Posted By RuralGuy
Re: Hello from Australia

Welcome to this Forum. Glad to have you on board.
Forum: Forms 10-15-2018, 05:58 AM
Replies: 12
Views: 394
Posted By RuralGuy
Re: Filtering subform records

How about if you modify the SubForm query and use the Forms collection so the recordset does not pull records with RER equal to Forms.YourMainForm.RERcontrol?
Forum: Forms 10-15-2018, 05:46 AM
Replies: 12
Views: 394
Posted By RuralGuy
Re: Filtering subform records

Are you using the LinkFields to filter?
Forum: Forms 10-15-2018, 05:24 AM
Replies: 12
Views: 394
Posted By RuralGuy
Re: Filtering subform records

What is the record source of the SubForm?
Forum: Forms 10-15-2018, 05:21 AM
Replies: 12
Views: 394
Posted By RuralGuy
Re: Filtering subform records

There has to be an answer but I need more coffee right now to get the brain to wake up. :D
Forum: Forms 10-15-2018, 04:46 AM
Replies: 12
Views: 394
Posted By RuralGuy
Re: Filtering subform records

Why should the current parent RER Number NOT be shown?
Forum: Queries 10-13-2018, 06:07 AM
Replies: 5
Views: 178
Posted By RuralGuy
Re: assigning an integer using Null Value

Excellent decision! Thanks for the feedback. Did you use the thread tools at the top of the thread to mark this thread as Solved?
Forum: Queries 10-13-2018, 05:50 AM
Replies: 5
Views: 178
Posted By RuralGuy
Re: assigning an integer using Null Value

To change a field in a table with a query requires either an update query or an append query. You are using a read type query (Select). Maybe if you describe what you are trying to accomplish...
Forum: Queries 10-13-2018, 05:36 AM
Replies: 5
Views: 178
Posted By RuralGuy
Re: assigning an integer using Null Value

The Nz() function does not change a field, it just changes what is returned from that field if the field is Null.
Forum: Forms 10-09-2018, 02:48 PM
Replies: 4
Views: 184
Posted By RuralGuy
Re: List Box Issues

Thanks for the update.
Forum: Forms 10-09-2018, 09:50 AM
Replies: 4
Views: 184
Posted By RuralGuy
Re: List Box Issues

Have you tried using Nz()?
Forum: Reports 10-09-2018, 09:47 AM
Replies: 2
Views: 153
Posted By RuralGuy
Re: Access Report

Have you considered using a temporary table?
Forum: Introduce Yourself 10-09-2018, 08:00 AM
Replies: 1
Hi!
Views: 123
Posted By RuralGuy
Re: Hi!

Welcome to the Forum and have fun.
Forum: General 10-07-2018, 04:59 PM
Replies: 27
Views: 1,490
Posted By RuralGuy
Re: Microsoft Windows / Office upgrade woes

Thanks once again Doc. The depth of your knowledge is astounding.
Forum: General 10-07-2018, 03:50 AM
Replies: 27
Views: 1,490
Posted By RuralGuy
Re: Microsoft Windows / Office upgrade woes

Hi Colin. I'm on most every day, just don't post that often any more. Always enjoy your stuff!
Forum: The Watercooler 10-07-2018, 03:24 AM
Replies: 30
Views: 544
Posted By RuralGuy
Re: Following Suite

What a great looking dog. Majestic almost. Thanks for the post.
Forum: General 10-07-2018, 03:19 AM
Replies: 27
Views: 1,490
Posted By RuralGuy
Re: Microsoft Windows / Office upgrade woes

I thought I recognized the dog. :D
Showing results 1 to 25 of 500

 
Forum Jump



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