Hello All,
I've bee trying out access 2007 and have a weird issue and would like
to see if I'm issing something really basic.
I have a form based on a query, I create a combo to look for records
on my form based on Org_ID. Wgen I create all is fine - I type e,
combo goes to e and starts filtering etc just like normal......I save
the form, close the database and when I re-open the combo doesn't
respond to any input - I can select a record and the form finds the
record, but if I try to type in the combo nothing happens.
I have the db in a trusted folder, I have reverted to letting access
create the combo with embedded macro (just trying to see if it's a
code issue) - SP1 is installed....macros are allowed...
Totally frustrated and would appreciate any guidance if anyone has
resolved the same issue.
Thanks
John
3  1797 
On Wed, 5 Mar 2008 04:26:08 -0800 (PST), flymo <fl****@hotmail.com>
wrote:
Can you reproduce this with the dropdown in the Northwind login form?
Is AutoExpand set to True?
-Tom.
>Hello All,
I've bee trying out access 2007 and have a weird issue and would like
to see if I'm issing something really basic.
I have a form based on a query, I create a combo to look for records
on my form based on Org_ID. Wgen I create all is fine - I type e,
combo goes to e and starts filtering etc just like normal......I save
the form, close the database and when I re-open the combo doesn't
respond to any input - I can select a record and the form finds the
record, but if I try to type in the combo nothing happens.
I have the db in a trusted folder, I have reverted to letting access
create the combo with embedded macro (just trying to see if it's a
code issue) - SP1 is installed....macros are allowed...
Totally frustrated and would appreciate any guidance if anyone has
resolved the same issue.
Thanks
John
Hi Tom,
Yes I get the same problem with the northwind and autoexpand is set to
true.
Thanks
John
On Mar 5, 9:03*am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Wed, 5 Mar 2008 04:26:08 -0800 (PST), flymo <fly...@hotmail.com>
wrote:
Can you reproduce this with the dropdown in the Northwind login form?
Is AutoExpand set to True?
-Tom.
Hello All,
I've bee trying out access 2007 and have a weird issue and would like
to see if I'm issing something really basic.
I have a form based on a query, I create a combo to look for records
on my form based on Org_ID. Wgen I create all is fine *- I type e,
combo goes to e and starts filtering etc just like normal......I save
the form, close the database and when I re-open the combo doesn't
respond to any input - I can select a record and the form finds the
record, but if I try to type in the combo nothing happens.
I have the db in a trusted folder, I have reverted to letting access
create the combo with embedded macro (just trying to see if it's a
code issue) - SP1 is installed....macros are allowed...
Totally frustrated and would appreciate any guidance if anyone has
resolved the same issue.
Thanks
John
Hi Folks,
I've created a dozen combos by wizard with this problem and it works
ok.......but does not once the form is closed & reopened. THere is no
other code or macro running...Really, really stumped and looking for
suggestions.
Thanks
John
On Mar 5, 10:13*am, flymo <fly...@hotmail.comwrote:
Hi Tom,
Yes I get the same problem with the northwind and autoexpand is set to
true.
Thanks
John
On Mar 5, 9:03*am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Wed, 5 Mar 2008 04:26:08 -0800 (PST), flymo <fly...@hotmail.com>
wrote:
Can you reproduce this with the dropdown in the Northwind login form?
Is AutoExpand set to True?
-Tom.
>Hello All,
>I've bee trying out access 2007 and have a weird issue and would like
>to see if I'm issing something really basic.
>I have a form based on a query, I create a combo to look for records
>on my form based on Org_ID. Wgen I create all is fine *- I type e,
>combo goes to e and starts filtering etc just like normal......I save
>the form, close the database and when I re-open the combo doesn't
>respond to any input - I can select a record and the form finds the
>record, but if I try to type in the combo nothing happens.
>I have the db in a trusted folder, I have reverted to letting access
>create the combo with embedded macro (just trying to see if it's a
>code issue) - SP1 is installed....macros are allowed...
>Totally frustrated and would appreciate any guidance if anyone has
>resolved the same issue.
>Thanks
>John
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Sean |
last post by:
Greetings all,
I am attempting to make a form that will filter through several tables
that
(I believe) have refretial integrity. I am pulling data from several
tables into the form and i would...
|
by: Scott Loupin |
last post by:
I've got two databases with similar data in them (WestSide and EastSide).
I've set up two identical reports that is filtered by date and the client
name. I'm using one form to do the filtering.
...
|
by: MLH |
last post by:
I have a form (xxxxxxxxxxxxxx) with a combo-box control
(yyyyyyyyyyyyyy). The rowsource property for that combo box is as
follows:
SELECT DISTINCTROW .,
. FROM ;
The SQL for qryVehicleList...
|
by: Mike Jakes |
last post by:
I hope that someone can offer a little advice on this one - I've
searched the group but can't find an answer. I think that I'm doing
something really stupid or missing something trivial, but see...
|
by: hackerslacker |
last post by:
I have an ordering form that use two combo boxes to filter down the
records of a Products table. This worked fine with the after_Update of
the first filtering the records and creating the...
|
by: John |
last post by:
AC2007
I changed my combo's row source and then the autocomplete stopped
working. The combo is two columns, bound to the first.
First column is primary key (ID). Second column is a...
|
by: John Kreps |
last post by:
I've tried to get combo boxes to work with Access 2007 for days now
without success. What I can't get to work is the autocomplete. I've
got three simple tables and one form with two controls....
|
by: kaib |
last post by:
i've got 2 tables tblCompany and tblHrtasks and on the form:
when i choose the company name, the subform gives the details of employee attached to that company; but there is a combo box in the...
|
by: Dev1 |
last post by:
All-
I'm new to this forum and i've been working with acces for about 2 days now. I have a form in which I have two combo boxes and depending on what is selected on the first dropdown the second...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
