When I add a new field to a query contained in a combo box, my entire
application crashes (auto creates a backup.)

Has anyone had this problem?

It's a simple query with only one table (no joins.) There are 15 fields in
the combo box. Is there a limit to the number of fields you can add to a
combo?

Please help...

Access 2003 SP3

Thx.

If you have not done so yet, apply this hotfix from Microsoft:
http://support.microsoft.com/kb/945674

What you describe is one of the bugs in A2003 SP3:
http://allenbrowne.com/bug-Access2003SP3.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JK" <jasonk at necoffeeco dot com> wrote in message
news72F9E18-76A9-404D-9780-(E-Mail Removed)...
> When I add a new field to a query contained in a combo box, my entire
> application crashes (auto creates a backup.)
>
> Has anyone had this problem?
>
> It's a simple query with only one table (no joins.) There are 15 fields in
> the combo box. Is there a limit to the number of fields you can add to a
> combo?
>
> Please help...
>
> Access 2003 SP3
>
> Thx.

Does this need to be installed on every computer that will use the .mde file
or just the developers PC?

Thx so much!

Jason

"Allen Browne" wrote:

> If you have not done so yet, apply this hotfix from Microsoft:
> http://support.microsoft.com/kb/945674
>
> What you describe is one of the bugs in A2003 SP3:
> http://allenbrowne.com/bug-Access2003SP3.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "JK" <jasonk at necoffeeco dot com> wrote in message
> news72F9E18-76A9-404D-9780-(E-Mail Removed)...
> > When I add a new field to a query contained in a combo box, my entire
> > application crashes (auto creates a backup.)
> >
> > Has anyone had this problem?
> >
> > It's a simple query with only one table (no joins.) There are 15 fields in
> > the combo box. Is there a limit to the number of fields you can add to a
> > combo?
> >
> > Please help...
> >
> > Access 2003 SP3
> >
> > Thx.
>
>

That didn't solve the problem. The app. still crashed as soon as I add the
one additional field to my combo box. Very strange.

I downloaded the hotfix, and ran it. I was asked for a location to save the
files and I put them in the Microsoft Office folder in Program Files. The
website did not specify a specific location. Maybe I put them in the wrong
location?

I also didn't restart my computer - the website says you don't have to - but
I'll try that too.

Jason

"Allen Browne" wrote:

> If you have not done so yet, apply this hotfix from Microsoft:
> http://support.microsoft.com/kb/945674
>
> What you describe is one of the bugs in A2003 SP3:
> http://allenbrowne.com/bug-Access2003SP3.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "JK" <jasonk at necoffeeco dot com> wrote in message
> news72F9E18-76A9-404D-9780-(E-Mail Removed)...
> > When I add a new field to a query contained in a combo box, my entire
> > application crashes (auto creates a backup.)
> >
> > Has anyone had this problem?
> >
> > It's a simple query with only one table (no joins.) There are 15 fields in
> > the combo box. Is there a limit to the number of fields you can add to a
> > combo?
> >
> > Please help...
> >
> > Access 2003 SP3
> >
> > Thx.
>
>

It would need to be on each workstation.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"JK" <jasonk at necoffeeco dot com> wrote in message
news:E80DC2F8-DAD5-4F86-BEA8-(E-Mail Removed)...
> Does this need to be installed on every computer that will use the .mde
> file
> or just the developers PC?
>
> Thx so much!
>
> Jason
>
> "Allen Browne" wrote:
>
>> If you have not done so yet, apply this hotfix from Microsoft:
>> http://support.microsoft.com/kb/945674
>>
>> What you describe is one of the bugs in A2003 SP3:
>> http://allenbrowne.com/bug-Access2003SP3.html
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>> "JK" <jasonk at necoffeeco dot com> wrote in message
>> news72F9E18-76A9-404D-9780-(E-Mail Removed)...
>> > When I add a new field to a query contained in a combo box, my entire
>> > application crashes (auto creates a backup.)
>> >
>> > Has anyone had this problem?
>> >
>> > It's a simple query with only one table (no joins.) There are 15 fields
>> > in
>> > the combo box. Is there a limit to the number of fields you can add to
>> > a
>> > combo?
>> >
>> > Please help...
>> >
>> > Access 2003 SP3
>> >
>> > Thx.
>>
>>

If memory serves, you extract the files to a location, and then you have to
run the executable that's extracted.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"JK" <jasonk at necoffeeco dot com> wrote in message
news:9B3E0E29-0ABA-4D06-B0AA-(E-Mail Removed)...
> That didn't solve the problem. The app. still crashed as soon as I add the
> one additional field to my combo box. Very strange.
>
> I downloaded the hotfix, and ran it. I was asked for a location to save
> the
> files and I put them in the Microsoft Office folder in Program Files. The
> website did not specify a specific location. Maybe I put them in the wrong
> location?
>
> I also didn't restart my computer - the website says you don't have to -
> but
> I'll try that too.
>
> Jason
>
> "Allen Browne" wrote:
>
>> If you have not done so yet, apply this hotfix from Microsoft:
>> http://support.microsoft.com/kb/945674
>>
>> What you describe is one of the bugs in A2003 SP3:
>> http://allenbrowne.com/bug-Access2003SP3.html
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>> "JK" <jasonk at necoffeeco dot com> wrote in message
>> news72F9E18-76A9-404D-9780-(E-Mail Removed)...
>> > When I add a new field to a query contained in a combo box, my entire
>> > application crashes (auto creates a backup.)
>> >
>> > Has anyone had this problem?
>> >
>> > It's a simple query with only one table (no joins.) There are 15 fields
>> > in
>> > the combo box. Is there a limit to the number of fields you can add to
>> > a
>> > combo?
>> >
>> > Please help...
>> >
>> > Access 2003 SP3
>> >
>> > Thx.
>>
>>

After ensuring the hotfix has been applied as Doug suggests, if it still
crashes you need to walk through each of the steps here:
http://allenbrowne.com/recover.html

If you are still stuck after that, post the SQL statement that fails (i.e.
with the extra field in it), along with these properties of the combo:
- Column Count
- Column Widths
- Bound Column
- Control Source
- Name

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
news:(E-Mail Removed)...
> If memory serves, you extract the files to a location, and then you have
> to run the executable that's extracted.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "JK" <jasonk at necoffeeco dot com> wrote in message
> news:9B3E0E29-0ABA-4D06-B0AA-(E-Mail Removed)...
>> That didn't solve the problem. The app. still crashed as soon as I add
>> the
>> one additional field to my combo box. Very strange.
>>
>> I downloaded the hotfix, and ran it. I was asked for a location to save
>> the
>> files and I put them in the Microsoft Office folder in Program Files. The
>> website did not specify a specific location. Maybe I put them in the
>> wrong
>> location?
>>
>> I also didn't restart my computer - the website says you don't have to -
>> but
>> I'll try that too.
>>
>> Jason
>>
>> "Allen Browne" wrote:
>>
>>> If you have not done so yet, apply this hotfix from Microsoft:
>>> http://support.microsoft.com/kb/945674
>>>
>>> What you describe is one of the bugs in A2003 SP3:
>>> http://allenbrowne.com/bug-Access2003SP3.html
>>>
>>> --
>>> Allen Browne - Microsoft MVP. Perth, Western Australia
>>> Tips for Access users - http://allenbrowne.com/tips.html
>>> Reply to group, rather than allenbrowne at mvps dot org.
>>>
>>> "JK" <jasonk at necoffeeco dot com> wrote in message
>>> news72F9E18-76A9-404D-9780-(E-Mail Removed)...
>>> > When I add a new field to a query contained in a combo box, my entire
>>> > application crashes (auto creates a backup.)
>>> >
>>> > Has anyone had this problem?
>>> >
>>> > It's a simple query with only one table (no joins.) There are 15
>>> > fields in
>>> > the combo box. Is there a limit to the number of fields you can add to
>>> > a
>>> > combo?
>>> >
>>> > Please help...
>>> >
>>> > Access 2003 SP3

Wow. I don't know what I would do without you guys. I manually ran the .msp
file and that fixed the problem.

I should have known better regarding the hot fix installation.

Much appreciated!


"Allen Browne" wrote:

> After ensuring the hotfix has been applied as Doug suggests, if it still
> crashes you need to walk through each of the steps here:
> http://allenbrowne.com/recover.html
>
> If you are still stuck after that, post the SQL statement that fails (i.e.
> with the extra field in it), along with these properties of the combo:
> - Column Count
> - Column Widths
> - Bound Column
> - Control Source
> - Name
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
> news:(E-Mail Removed)...
> > If memory serves, you extract the files to a location, and then you have
> > to run the executable that's extracted.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no e-mails, please!)
> >
> >
> > "JK" <jasonk at necoffeeco dot com> wrote in message
> > news:9B3E0E29-0ABA-4D06-B0AA-(E-Mail Removed)...
> >> That didn't solve the problem. The app. still crashed as soon as I add
> >> the
> >> one additional field to my combo box. Very strange.
> >>
> >> I downloaded the hotfix, and ran it. I was asked for a location to save
> >> the
> >> files and I put them in the Microsoft Office folder in Program Files. The
> >> website did not specify a specific location. Maybe I put them in the
> >> wrong
> >> location?
> >>
> >> I also didn't restart my computer - the website says you don't have to -
> >> but
> >> I'll try that too.
> >>
> >> Jason
> >>
> >> "Allen Browne" wrote:
> >>
> >>> If you have not done so yet, apply this hotfix from Microsoft:
> >>> http://support.microsoft.com/kb/945674
> >>>
> >>> What you describe is one of the bugs in A2003 SP3:
> >>> http://allenbrowne.com/bug-Access2003SP3.html
> >>>
> >>> --
> >>> Allen Browne - Microsoft MVP. Perth, Western Australia
> >>> Tips for Access users - http://allenbrowne.com/tips.html
> >>> Reply to group, rather than allenbrowne at mvps dot org.
> >>>
> >>> "JK" <jasonk at necoffeeco dot com> wrote in message
> >>> news72F9E18-76A9-404D-9780-(E-Mail Removed)...
> >>> > When I add a new field to a query contained in a combo box, my entire
> >>> > application crashes (auto creates a backup.)
> >>> >
> >>> > Has anyone had this problem?
> >>> >
> >>> > It's a simple query with only one table (no joins.) There are 15
> >>> > fields in
> >>> > the combo box. Is there a limit to the number of fields you can add to
> >>> > a
> >>> > combo?
> >>> >
> >>> > Please help...
> >>> >
> >>> > Access 2003 SP3
>
>