Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.56 seconds.
Search: Posts Made By: RuralGuy
Forum: Modules & VBA Yesterday, 08:29 AM
Replies: 6
Views: 121
Posted By RuralGuy
Re: Rogue Column in a csv file

Dave, do you get the same results if you import to Excel? Just curious.
Forum: Queries 01-19-2018, 01:03 PM
Replies: 4
Views: 90
Posted By RuralGuy
Re: Of Nulls and Dates

Have you tried the Query Builder? It's pretty smart.
Forum: Code Repository 01-15-2018, 02:27 PM
Replies: 2
Views: 238
Posted By RuralGuy
Forum: General 01-15-2018, 02:24 PM
Replies: 3
Views: 223
Posted By RuralGuy
Re: Access/Office 2016 upgrade left corner window icon gone

I don't have ac2016 but it looks like the Quick Access Toolbar. Try playing with it. You used to be able to change it some.
Forum: Modules & VBA 01-11-2018, 07:15 AM
Replies: 8
Views: 242
Posted By RuralGuy
Forum: Modules & VBA 01-11-2018, 06:56 AM
Replies: 8
Views: 242
Posted By RuralGuy
Re: Condition formatting expression when a shopnumber appears with an specific remark

Rather that look in another table, why not include the "stock" value in this query and simply not display that field on your form. You could then use the field in the conditional format statement...
Forum: Modules & VBA 01-11-2018, 06:32 AM
Replies: 8
Views: 242
Posted By RuralGuy
Re: Condition formatting expression when a shopnumber appears with an specific remark

You want to conditionally color a field if another field in a different table has the word "stock" in it? Sounds confusing to me.
Forum: Modules & VBA 01-10-2018, 07:52 AM
Replies: 8
Views: 242
Posted By RuralGuy
Forum: Forms 12-19-2017, 08:45 AM
Replies: 9
Views: 291
Posted By RuralGuy
Re: Protect Data in a Combo Box

Use the BeforeUpdate event to qualify the changes.
Forum: Tables 12-09-2017, 05:23 AM
Replies: 5
Views: 318
Posted By RuralGuy
Re: Need help creating a validation rule.

FYI, the SetFocus is not necessary as Cancel = True will do this for you.
Forum: Tables 12-08-2017, 03:02 PM
Replies: 5
Views: 318
Posted By RuralGuy
Re: Need help creating a validation rule.

Use the BeforeUpdate event to enforce your validation. Cancel = True will hold the focus in the current control.
Forum: Introduce Yourself 11-30-2017, 10:57 AM
Replies: 1
Views: 141
Posted By RuralGuy
Re: From HandicappedPets.com

Welcome to AWF and enjoy.
Forum: Forms 11-20-2017, 09:08 AM
Replies: 35
Views: 549
Posted By RuralGuy
Re: Delete Files Based On a Text Field

Here's a link with code tag examples: https://access-programmers.co.uk/forums/showthread.php?t=240420
Forum: Forms 11-20-2017, 08:58 AM
Replies: 35
Views: 549
Posted By RuralGuy
Re: Delete Files Based On a Text Field

Highlight your code and then press the "#" sign in the tool bar.
Forum: Forms 11-20-2017, 06:58 AM
Replies: 35
Views: 549
Posted By RuralGuy
Re: Delete Files Based On a Text Field

Thanks for the update. :)
Forum: Forms 11-20-2017, 06:56 AM
Replies: 35
Views: 549
Posted By RuralGuy
Forum: Forms 11-20-2017, 06:55 AM
Replies: 35
Views: 549
Posted By RuralGuy
Re: Delete Files Based On a Text Field

So adding the code tags allowed the trailing ""?
"\"
Forum: Forms 11-20-2017, 06:50 AM
Replies: 35
Views: 549
Posted By RuralGuy
Re: Delete Files Based On a Text Field

Wow. It even stripped it out of that post.
Forum: Forms 11-20-2017, 06:49 AM
Replies: 35
Views: 549
Posted By RuralGuy
Re: Delete Files Based On a Text Field

The site will not let me post that trailing "".
???? I reported it to the Mods.
Forum: Forms 11-20-2017, 06:42 AM
Replies: 35
Views: 549
Posted By RuralGuy
Re: Delete Files Based On a Text Field

Follow Ridders directions. Hi Colin!
Forum: Forms 11-20-2017, 06:41 AM
Replies: 35
Views: 549
Posted By RuralGuy
Re: Delete Files Based On a Text Field

I ttried editing my post right away and it would not stick. change this line:
MyVar = "C:\Folder1\Folder2" & CustomerID
...to...
MyVar = "C:\Folder1\Folder2" & CustomerID
Forum: Forms 11-20-2017, 05:50 AM
Replies: 35
Views: 549
Posted By RuralGuy
Re: Delete Files Based On a Text Field

Try something like:

Dim YourStringVar As String

YourStringVar = C:\Folder1\Folder2" & CustomerID

If Dir( YourStringVar ) <> "" Then Kill YourStringVar

Warning: Untested
Forum: Forms 11-16-2017, 08:54 AM
Replies: 8
Views: 212
Posted By RuralGuy
Re: Dropdown Box DLookup Error

It should be under "Thread Tools" at the top of the thread. I believe it is only available to the OP of the thread and the Mods of course.
Forum: Forms 11-15-2017, 10:25 AM
Replies: 8
Views: 212
Posted By RuralGuy
Re: Dropdown Box DLookup Error

Did you want to mark this thread as Solved?
Forum: Forms 11-15-2017, 05:24 AM
Replies: 8
Views: 212
Posted By RuralGuy
Re: Dropdown Box DLookup Error

This probably runs pretty slow with all of those Domain functions. If the RowSource of the ComboBox is "tblDropROI" there is a much faster way to get the values. If "OrgID" is a number then your code...
Showing results 1 to 25 of 500

 
Forum Jump



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


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World