Go Back   Access World Forums > Search Forums

 
Showing results 1 to 20 of 20
Search took 0.01 seconds.
Search: Posts Made By: Endojoe
Forum: Forms 09-28-2011, 01:21 PM
Replies: 5
Views: 1,114
Posted By Endojoe
Re: Combo Box with occasionally empty columns

Well, putting a default value in the column for NULL would end up putting bogus information on my form as far as I can tell, unless I'm missing something. Here's some more information. This is a...
Forum: Forms 09-28-2011, 07:54 AM
Replies: 5
Views: 1,114
Posted By Endojoe
Re: Combo Box with occasionally empty columns

Jdraw, thank you for your response. I think I follow you, but the problem with that solution is that it eliminates records I need from the query. In the Query, I put 'Is Not Null' in the criteria...
Forum: Forms 09-28-2011, 07:12 AM
Replies: 5
Views: 1,114
Posted By Endojoe
Question Combo Box with occasionally empty columns

Good Day All,

I have a table sourced Combo Box on a Form and it populates several Text Boxes and Option Groups using the following code:


Private Sub cbo_CUSTOMER_NAME_AfterUpdate()
...
Forum: Forms 05-12-2010, 01:20 PM
Replies: 3
Views: 1,252
Posted By Endojoe
Re: Selecting Options in Option Groups With Command Button

Bob thanks a million!! I can't believe I couldn't figure that out in my research leading up to my post....but for some reason I just couldn't seem to find a clear explanation of how to achieve such a...
Forum: Forms 05-12-2010, 09:38 AM
Replies: 3
Views: 1,252
Posted By Endojoe
Selecting Options in Option Groups With Command Button

I have 5 option groups, several of them populate text box controls with standard verbiage in my form using the After Update event. There are a couple circumstances I want to create Command Buttons...
Forum: Forms 08-18-2009, 08:06 AM
Replies: 3
Views: 1,667
Posted By Endojoe
Re: Change RecordSource with Option Group

Well....that was simple enough. :cool: Thanks a ton missinglinq!!! :D I have no idea why I couldn't find something so clear and concise on my own. :o Thanks a bunch again. :) Worked like a...
Forum: Forms 08-18-2009, 06:24 AM
Replies: 3
Views: 1,667
Posted By Endojoe
Question Change RecordSource with Option Group

I have two tables, 'table1' has around 4500 records but is no longer being added to because I have created 'table2' to take it's place due to the fact that I couldn't set a couple fields in 'table1'...
Forum: Forms 06-03-2009, 07:03 AM
Replies: 7
Views: 985
Posted By Endojoe
Re: Command Button using If/Then

That looks like it will make for much cleaner code! And after some research on it, it would appear to be a very powerful tool for many other things too, thank you for the suggestion!
Forum: Forms 06-02-2009, 12:35 PM
Replies: 7
Views: 985
Posted By Endojoe
Wink Re: Command Button using If/Then

:D From your lips to gods ears...I wish I was the boss. I'm just trying to make my data entry job easier...and I'm lucky I have been given the OK to do even that much :-) Things are done the way...
Forum: Forms 06-02-2009, 11:27 AM
Replies: 7
Views: 985
Posted By Endojoe
Thumbs up Re: Command Button using If/Then

Mr. B thanks a million!! Put me on the right track. I took my Dim declarations out of the ElseIf and moved them all up to before I even began the If/Then statement and everything worked as I had...
Forum: Forms 06-02-2009, 08:13 AM
Replies: 7
Views: 985
Posted By Endojoe
Unhappy Command Button using If/Then

I'm trying to use an If/Then statement to get a command button to create a new record with certain information carried over from an existing record, but just exactly what information is carried over...
Forum: Forms 05-20-2009, 01:09 PM
Replies: 4
Views: 648
Posted By Endojoe
Thumbs up Re: Guiding User Selection of Option Groups

Ok, so the default value on the option group I want the user to select from initially is actually set to 0 (so that I can use that value to trigger a reminder box to pop up if no selection is made on...
Forum: Forms 05-20-2009, 11:41 AM
Replies: 4
Views: 648
Posted By Endojoe
Re: Guiding User Selection of Option Groups

Missinglinq that nailed it! Thank you so much...I'm pretty new to VB stuff, so sometimes I forget that 0 is really Null (and nothing can = Null :D) It's amazing to me that that oversight on my part...
Forum: Forms 05-20-2009, 06:49 AM
Replies: 4
Views: 648
Posted By Endojoe
Guiding User Selection of Option Groups

I have a form with 4 Option Groups, and I need to guide the user through the selection process in a step by step manner. I have tried using some VB code to set the Option Groups to invisible, then...
Forum: Forms 04-14-2009, 01:26 PM
Replies: 17
Views: 5,116
Posted By Endojoe
Re: Display Date as mm/dd/yy

Well...In Access 2007 anyways, I went into Table Design, selected Date/Time as Field type, then manually keyed in mmm/dd/yyyy for the field format, and did the same in the control on the form I...
Forum: Forms 04-14-2009, 09:53 AM
Replies: 17
Views: 5,116
Posted By Endojoe
Re: Display Date as mm/dd/yy

WIS, That actually worked wonderfully for me in the situation I'm trying to resolve. However....I'm using a somewhat odd date format, mmm/dd/yyyy, and for consistency's sake, I'm trying to get the...
Forum: Forms 04-09-2009, 11:32 AM
Replies: 3
Views: 588
Posted By Endojoe
Re: Removing Text From Control

Much thanks once again for setting me on the right track. It worked beautifully! I ended up using the 'on change' to trigger the auto-populate and have been experimenting with different triggers to...
Forum: Forms 04-09-2009, 07:59 AM
Replies: 3
Views: 588
Posted By Endojoe
Removing Text From Control

I have a form in which I need to auto-populate a couple of controls when data entry begins in certain controls. I have achieved this using the following:

Private Sub PART1_Dirty(Cancel As...
Forum: Modules & VBA 04-07-2009, 11:36 AM
Replies: 3
Views: 601
Posted By Endojoe
Re: Error Handling

Paul, thank you so much for setting me on the right path!! Worked like a charm. :D Like your title too... ;) Great Book.

For anyone who may find this helpful later...here's the code that...
Forum: Modules & VBA 04-07-2009, 07:34 AM
Replies: 3
Views: 601
Posted By Endojoe
Red face Error Handling

I have 3 reports I want to print from a single command button. I have achieved this using the following:

Private Sub All_Reports_Button_Click()
On Error GoTo Err_All_Reports_Button_Click

...
Showing results 1 to 20 of 20

 
Forum Jump



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