Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 1.08 seconds.
Search: Posts Made By: RuralGuy
Forum: Reports 05-18-2018, 07:22 AM
Replies: 7
Views: 191
Posted By RuralGuy
Re: Group by non-standard expression.

I'm not really sure but I would try 1-3 rather than 1 to 3. You could also create a Public function in a Standard module that uses the Select Case structure if you wanted.
Forum: Reports 05-18-2018, 06:32 AM
Replies: 7
Views: 191
Posted By RuralGuy
Re: Group by non-standard expression.

How about adding a calculated field to the query that uses something like Switch() to group the records for you to group on?
Forum: Forms 04-16-2018, 11:42 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

You probably already know Justin that computers are pretty dumb. They only know what you tell them. Mike has a pretty good idea on how you could tell the computer what surveys go with what protocols.
Forum: Forms 04-14-2018, 07:20 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

I'm probably just stupid here Justin but how do you know what "survey types" are available for each "specific pest"?
Forum: Forms 04-13-2018, 09:46 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

Thanks Justin. That will help a lot!!
Forum: Forms 04-13-2018, 09:34 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

My 2002 system FE/BE has the relationship the same in both FE and BE and I'm certain I only defined those relationships in the BE. At least I'm pretty sure. :eek:
Forum: Forms 04-13-2018, 09:31 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

If a Compact and Repair and zipping do not decrease the size enough, it should be possible to create a BackEnd with no data, just the structures. Import just some of the relevant records and then C&R...
Forum: Forms 04-13-2018, 09:27 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

It should work just fine. I just wanted to see if there was anything unusual in your environment.
Forum: Forms 04-13-2018, 09:15 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

Justin, what version of Access are you using and 32/64 bit?
Forum: Forms 04-13-2018, 08:58 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

I might also suggest that 1:1 relationships are not very common. They usually indicate (though not always) fields that should be in the same table.
Forum: Forms 04-13-2018, 08:57 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

In looking at your relationship picture, it appears as though you have not defined a relationship for the Protocols table yet.
Forum: Forms 04-13-2018, 08:45 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

While I'm giving this some thought I thought I'd point out that it is never a good idea to use a *reserved* word for the name of any object you have defined. In this case you have used NUMBER as the...
Forum: Forms 04-13-2018, 07:33 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

Hmm...I'm starting to understand your db a bit better. What is the RowSource of the "Select Type" combo box? BTW, I like the looks of your form.
Forum: Forms 04-13-2018, 07:12 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

Is there a field in the RecordSource of the mainForm that also appears in the RecordSource of the SubForm that would limit the SubForm to the records you want?
Forum: Forms 04-13-2018, 06:49 AM
Replies: 24
Views: 377
Posted By RuralGuy
Re: Subform ComboBox

I'm going to assume you are using the LinkMaster/ChildFields properties of the SubFormControl to do your filtering. Are you aware that you can have more than one field listed for each property...
Forum: Forms 04-13-2018, 06:44 AM
Replies: 6
Views: 222
Posted By RuralGuy
Re: Subform control

What have you tried so far? What code do you have in the Large Close Button on the Main Form?
Forum: Modules & VBA 04-09-2018, 03:02 AM
Replies: 14
Views: 2,428
Posted By RuralGuy
Re: Changing DSN linked tables to DSNLESS tables

You're most welcome and a *BIG* tip of the hat to Doug Steele.
Forum: Forms 04-03-2018, 11:22 AM
Replies: 1
Views: 110
Posted By RuralGuy
Re: Subforms not linking properly

You may need to post your zipped up db for anyone to supply a decent answer.
Forum: Forms 03-24-2018, 07:36 AM
Replies: 2
Views: 169
Posted By RuralGuy
Re: Open a form to a specific record from a subform

Perhaps this is what you are looking for: http://www.baldyweb.com/wherecondition.htm
Forum: General 03-17-2018, 07:09 AM
Replies: 4
Views: 349
Posted By RuralGuy
Re: Removing Access 2000-2003 Users/Permissions

Thanks for that document Pat.
Forum: Forms 03-15-2018, 09:29 AM
Replies: 3
Views: 166
Posted By RuralGuy
Re: Listbox columnheads different color

I don't think so unless Stephen Lebans has something: http://www.lebans.com/List_Combo.htm
Forum: General 03-15-2018, 09:19 AM
Replies: 19
Views: 452
Posted By RuralGuy
Re: Data Validation at Form Level Please

Where do you want the calculations to go?
Forum: General 03-15-2018, 09:07 AM
Replies: 19
Views: 452
Posted By RuralGuy
Re: Data Validation at Form Level Please

Are you familiar with VBA? Have you looked at the DateAdd() function?
Forum: General 03-15-2018, 09:01 AM
Replies: 19
Views: 452
Posted By RuralGuy
Re: Data Validation at Form Level Please

I'm not sure where you are having an issue but the code would go in the AfterUpdate event of the control where you are entering a date.
Forum: Forms 03-04-2018, 07:38 AM
Replies: 8
Views: 219
Posted By RuralGuy
Re: cbo AFTER UPDATE EVENT NOT WORKING EVERYTIME

I'm going to start by suggesting your use this link to review your code and the use of reserved words: http://www.allenbrowne.com/AppIssueBadWord.html#F
Showing results 1 to 25 of 500

 
Forum Jump



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