Any ideas why combo boxes that all have their "auto expand" option set to YES are not auto expanding as I type-in text? They were working last week and I have no idea why they're not working now. Strangely, if I type in any of the entries present in the combobox list (text such as "St. Louis City") exactly as it appears in the combobox list, and then press enter, I get an error message telling me the value is invalid. Then, if I use the drop-down list to find and select "St. Louis City", it allows me to enter this value.
I'm working on a sub-form set to continuous and would like to amend a memo filed so that it autoexpands when entered. Have tried amending the height of the field through the on enter an on exit functions but this alters the size of the form.
I have a bound combo box that has a query as a row source, The query has 3 fields called from tblMasterItems, The ItemID , ItemDesc and ItemSupplier(related to the PK of tblSupplier).
Column Count = 3 Column Width = 0";1";0"
If I do not put a criteria under ItemSupplier, the combo box behaves just fine. The problem happens when I set the criteria under ItemSupplier, the criteria being the supplier ID, the combo box no longer expands and searches as you type, but the items in the combo box have been filtered and are there.
Summary:
When the row source qry ItemSupplier Field does not have a criteria, cbo works just fine. When the row source qry ItemSupplier has a criteria, cbo no longer expands and searches as you type, but has the filtered data showing if you hit the expand button (that arrow pointing down in the cbo)
Auto complete was working with a combo box. After adding much functionality to a database I find that auto complete does not work on any combobox in any form. So I create a blank database and a simple test shows that auto complete works. When a form from the faulty database is imported in the test database, auto complete stops working on the test form. Even if the imported faulty form is removed, auto complete still does not work.
I tried creating a new database and importing the faulty form after removing all controls and events from the form except for the combo box. Auto complete still stops working. Not only on the imported form but also on the existing form which works prior to the import.
I checked auto expand and it is 'Yes' in all conditions.
What ever is causing the problem on the faulty form seems to cause some property of the database to change.
Is there some database option or property setting that controls auto complete?
Is is possible that importing a form will cause a database property to change?
HI i never needed help this much. i worked on an access application for 1/2 year. Everything went fine. But now we wanted to start working with it, some older acces versions are acting weird.
I have a form that contains a subform datasheet, and the datasheet has a datasheetsubform aswell.
This works fine in 2003. De datasheet is displayed, and when you click on the plus, the other datasheet opens in the maindatasheet.
But in 2000, you dont see the plusjes. It is a major issue that i fix that! can some help me to solve this?
I want to make a table (1 row, 3 columns) on Form like we create the table in Microsoft Word. When I type the data in the first row more than one line. The other rows will then automatically expand. All the data will be saved in the same table.
I try to combine 3 textboxs but do not know how to solve the problem.
I have a main form which is linked through a [PackageID] field to a subform. i wast to use the same form for both shipments in and out. the subform has a list of serial numbers add for each [package id].
On the main form i have addresses ect and then a combo box onthe [PackageID] field which brings up all the serial numbers that came in, in that package.
This is perfect for sending a large container back out unopened, however there are times when the database will need to 'pick and choose' serial no.s from several packages. To do this i made the [SerialNo] field on the subform a combo box - looking up all the serial no.s in stock - however when a serial no is selected it doesn't update the other 15 fields in the subform.
Any sugestions? Got a feeling thats its quite an easy thing to do but its beaten me!
I have a main form with two combo boxes on which are linked if you select from the first cbo it filter the second. I also have subform that has a combo box on which is filtered by the second cbo on the main form. All works lovely when adding a new record BUT when I move to another record the cbo entries in the subform are not there, there are saving to the table are all the other data is showing just not the combo box entries - to get round this I have to reselect from the second cbo click into the subform and refresh and then they appear but this isn't how it's meant to work and I'd have to do this on every record but it then resets the previous one
On my main screen I have a button that I press and it pulls up a pop up box...in the box you type in one item and hit ok then the query goes and gets the results.
My quesion: how do it make it so when I click the button the pop up box has lets say four areas where I can enter different items and then it goes and gets all four...or three or whatever I need ?
Hi I have a report with a column of data. It contains a variable amount of data according to the demand of the user (criteria entered in a parameter query). The problem I have is that the data is short string of 3 letters but there are generaly lots of entries so the report runs over several pages. I would like to be able to creat columns side by side. A bit like with the "Can grow" option" but that a new column appears...
I have a report that needs to show about 20 different fields from 24 records. I have it set up in landscape view, with one record per line (running horizontally). It allows me to show about 15 of the fields, spanning two pages (wide). I don't know how to add a third page to show the remaining fields.There are no Groupings.
Also, is there a way to "wrap" text in the column header?
I have document management system for 2 projects in one db. I have a login form where user has to select the project id thru a combobox. And I have all the queries based on this combobox to display results in form or report. But after login and selecting the project, login form closes and main form opens to display data pertaining to that project. But it does not work, the moment we click close to open main form again query method apears displaying the same string :[Forms]![frmLogon]![Project]. This happens for all forms, reports. I cant't figure this out. Can somebody please help me?
I have 2 combo boxes, one Categories and Products. However I have follows a tutorial and when I select the Categories, the products do not show even though the tutorial says it does. I have attached a copy of the DB.
Is there a code for event procedure OnEnter() that allows me to expand my list box so that i can see a list that's larger than the size of it. I was hoping to multiple select from the list and do it at a glance because my list is very long.
the login is working perfectly, once It logs in there is a button to expand all that is based in JS. I can't seem to work out how to get it to click the button to expand the whole menu, latest code is below:
Code:
Option Explicit Function Checkpage() Dim IE As Object Dim lform As Object Dim Document As Object Dim item As Object
I have a chart I am trying to create that pulls data from a table. It pulls from a list of about 7 items. The issue I have is when I do this it is showing the ID numbers in the legend and not the actual names>
Have a generic dashboard report with multiple charts in it. One in particular is a bar chart, but depending on what the dashboard is produced for, the bar chart may have too many bars in it to make it legible. Therefore I'd like to conditionally determine the number of bars (basically the number of records in the query) and then make the chart go from one page and continue onto another.
I have combo boxes populated with all values in a particular field, then shunt the form onto that record (standard combo box for selecting records from a list in other words).
Problem is, these boxes seem to stop working if I leave the form for another and then return to it.
Here's the code Access puts behind:
----------- Set SerialRS = Me.Recordset.Clone SerialRS.FindFirst "[Serial Number] = '" & Me![Combo60] & "'" If Not SerialRS.EOF Then Me.Bookmark = SerialRS.Bookmark -----------
The form may be opened and closed via other processes (although never unloaded), but when I come back to it these combo boxes always stop working! Why?
I recently created a database to be used to store incoming invoices. We have 4 suppliers which supply the same material and wanted each supplier to have its own database.
I began by making a database which included all the key tables, forms, queries and functions I would need to then save 4 copies, one for each supplier. This just meant I would not have to repeat the process for each individual supplier.
The problem is all my data is external and upon importing it into the database it has made the search function (combo box) not return results.
I believe this is because: 1) The form was created before the records existed 2) The records were imported from an external source and not created using the form.
However, the way I have designed the form is so I can see all relevant information linked with a specific invoice. This aids in gathering information quickly about an invoice but also so I can input credit note and invoice query information linked to a specific invoice on the same page.
Is there anyway to remedy this?
Or use a similar search function that returns records in my form "Main View"
The last thing I want to do is have to create the form again, although I don't think this will work either as reason 2) states.
New to access...just build a form, in which there are combo boxes....cascading of boxes was done.
Now the problem is I want afterupdate function to get activated when user changes the value of one combo....for which I have created a code in code builder... see the code... I think I am making a mistake in writing the code to requery...
I have a cascading combo box working fabulously in a form. However when I embed that form into another form, the cascading combo boxes quit working. After doing some searching around on the web I think my issue is either in the query that the dependent combo box references and/or in the "after update event procedure" but I just can't seem to figure out the exact changes to make to my database. Details:
Tables with data for combo boxes:LOOKUP TABLE - Veg Species - Species Type, LOOKUP TABLE - Veg Species - Species Name. Related together based on common field: SpeciesType
[code]...
When the form with the combo boxes is embedded as above, I can select the species type from the dropdown but when I try to select the species common name value I am asked to
"enter parameter value - Forms!SUBFORM2a - Enter Specific Veg Info!cmbSpecies_Type".
i have a form with two cascading combo's that work when the form is opened as a single form however when i place the form on Page 3 of a TabCtl it fails to cascade the correct values.
frmSiteDetails > TabCtl33 > Page3 > frm ConditionDetails subform with Combo's 1 & 2 Combo 1 = [ElementGroupName] SELECT ElementGroupID, ElementGroupName FROM tblElementGroup; has Column Count of 2 and Bound Column 2 Combo 2 = [Element] qrySubElements has SQL:
I accidentally posted this in "general"...so I am posting it here under "forms", since it is "form" related. My intention was not to double-post...sorry. Summerwind had posted an example to auto populate a combo box. The code below follows his example, but is not working for me:
The fields I have on my form are:
cboCompany cboLocation
cboCompany is based on tblCompany( with fields CompanyName, Location)
When I update the cboCompany field, I want the cboLocation combo box to populate with all locations for the company that was entered into the cboCompany combo box on the form. E.g. The company "Visions" may be exist in the tblCompany with 3 different locations: Visions (Las Vegas), Visions (Ohio), Visions(California). When I pick the company "Visions" from the cboCompany combo box, I want the cboLocation combobox to be populated with "Las Vegas", "Ohio", and "California".
The code is as follows but returns empty records in cboLocation:
Code: Dim StrSource As String
StrSource = "SELECT Location FROM tblCompany WHERE tblCompany.CompanyName Like " & Me.cboCompany.Column(1) With Me.cboLocation .RowSource = StrSource .SetFocus .Dropdown End With
When a Combo Box is first opened, the vertical slider doesn't quite sync up with the contents. The slider will move up and down, but the contents of the combo box won't automatically slide up and down with that slider until the slider has first gone to the bottom of the list.
I've sat here for 10 minutes and waited -- no difference. Unless I physically slide the slider all the way to the bottom of the list, the contents of the combo box will not slide with that slider.
How can I make the contents sync up with the slider right away so that I can more easily find things 1/3 of the way down without sliding the bar all the way to the bottom to sync it up then back up to slowly slide the slider until I see it?