After migration to MS Access 2010 64-bit I have a problem with filtering data on tables. Ex.
1. In Access was created table "product" with field "name"
2. When I will to filter data by field "name" I don't have use any keywords as: in, like, '.'
3. I thing that problem is with reserved SQL query words
How do i restrict the user from entering anything other then the drop down list values?
thank you!
Private Sub Form_Current()
If Me!pairport Then
Me!pterminal.Enabled = True
Else
Me!pterminal.Enabled = False
End If
If Me!dairport Then
Me!dterminal.Enabled = True
Else
Me!dterminal.Enabled = False
End If
End Sub
Private Sub pairport_AfterUpdate()
If Me!pairport Then
Me!pterminal.Enabled = True
Else
Me!pterminal.Enabled = False
End If
End Sub
Private Sub dairport_AfterUpdate()
If Me!dairport Then
Me!dterminal.Enabled = True
Else
Me!dterminal.Enabled = False
End If
End Sub
ok i am trying to make this rule apply for the destination part aswell, which is dterminal and dairport
gettin this problem
runtime error 438
object doesnt support property or method
I have a combo box with a list of employees I want to restrict the user/employee to be able to only pick his name from the combo box? Is it possible?
View 11 Replies View RelatedI built a database off of the access wizard and it gives me the capability to enter date parameters before running my reports, than displaying the revised report. I.E. I am prompted to enter start and finish dates, and then after entering this info and hitting a button to preview the report, the only data displayed is that that falls into that date range.
I have created a new report that wasn't built into the wizard. This report "hits" an underlying query. I have also added a button on the switch manager to preview the report. I want a user to be able to click that preview report item on the switch manager, then be prompted to enter start and finish date information, then hit an ok button, then have the report with the relevant information displayed.
Any and all help would be greatly appreciated. Thanks.
I have a question about for combobox. I have a field from my tables that a text only then I make in the look up property field to become combobox then row "source type is a value list" then,"Allow value list edits, I make it Yes". then in the form its possible for me now to add value list in the combobox. but I want that what ever I input to become a value list, that's all they can select for the value of that field. if they can type or add not listed in the value list I input, it will not possible & there's a msgbox will appear mentioning the "the value you input is not in the list..
View 2 Replies View RelatedIs there a way to have data stored in a table and reference it in unlinked queries and tables to use for filtration?
View 10 Replies View RelatedI have designed a datasheet in a subform and it has a nested datasheet inside of it. I have it all designed and now I want to disable the user from doing anything to either, such set column widths, set colours etc. How would I do that?
View 1 Replies View RelatedThis application has worked fine in the past, but now I find it stops cold saying a particular linked table is read-only. I've looked around and all I can find in the various forums is how to MAKE a table read-only. Reversing that process seems very difficult.
The application is a copy of another that now exhibits the same problem. Each uses a different data mdb - part of the development I'm doing involves changing a different table. I'm developing changes to the application in this separate copy.
I can't tell if other tables would have this problem - the table in question is the very first used (initialization routine) and I can't get past it without deactivating a bunch of code.
How best to go about designing a new table that shows any records matching a specific user name field from a parent table (without changing any records in the parent table).
For example: Any record in the column "user name" matching "Craig" in the parent table should be displayed in the new table.
I also would like for the new table to update automatically anytime a new record meeting the user name criteria ("Craig" for example) is added to the parent table.
I have a Form created for Hardware Allocation.
I have following Fields. Allocation ID(PK), HW ID, User ID, HW Status, Assigned Date.
Values of HW Status = Active, Inactive, Decom, In Stock etc.
What I want is explaind below example
HW XXX is allocated to User ABC and the Status is Active.
Now When I want to reallocate the same HW XXX to Another User XYZ then Make the current status as Active. But before doing that the form should force me to change the Status of previous allocated to user ABC to anything other than active. Because One Device can be active to only one user at a time.
i,e Combination of HW ID & HW Status(Active Only) should not be duplicated.
I have three linked tables [Regulator], [RuleBook] and [Rules] (each has a corresponding form for data entry).
In the "Rules" form, when you select name of the regulator, the rule books dropdown down is filtered to show only the rulebooks for that regulator. the code I use is:
Private Sub Regulator_Change()
Me.[Rule Book].RowSource = "SELECT [ID],[Rule Book],[Short Code],[Regulator],[RegName],[Short Form],[Active] FROM" & _
" [RuleBook] WHERE Regulator = " & _
Me.Regulator
Me.[ShortReg] = Me.Regulator.Column(3)
End Sub
Basically, if I select the FSA as the regulator, The Rule Books drop down is filtered to only show the FSA Rule Books. If I pick OFT, I get the OFT list etc. This all works fine.
In the [RuleBook] table, each entry has a yes/no tick box called "Active".
The reason for this being that the regulators change their rule books quite regularly, but from an audit perspective, I can't delete or overwrite the old ones once they are no longer valid.
What I want to do, is further filter the rule book list to those where Active=True so that when I select FSA, I can only choose from their current rule books and not the ones that are no longer relevant.
I have an Access database with millions of records.I am only interested in a subset of records (250,000+) that I would like to analyze in an Excel pivot-table. My issue is; how do I best export this information to Excel.I've tried filtering and exporting, but all records are exported. I've tried copy and paste but only 65K are allowed. Is there a better way to do this, perhaps linking the Access database?
View 1 Replies View RelatedI have a text box (txtInput), is there a way that I can filter results on a form based on txtInput.text?
View 1 Replies View RelatedHey guys im a bit stuck and would really appreciate any suggestions...
I have 3 tables:
Table 1: Products
Product_Name
Table 2: Suppliers
Supplier_Name
Table 3: Prices
Product_Name
Supplier_Name
Supplier_Price
Table 1 & 2 have a relationship to table 3, with a many to many relationship. i.e. many products can have many suppliers.
This part works well and i have a form that shows each product with a subtable that shows that products suppliers.
However, i want to be able to filter to prices table to show each individual supplier and what products they supply.
I appreciate they time anyone took to read this and hope i made it clear, and if any one can help like i siad i would be very gratefully :)
When using the MS Works database the "Find" command makes a new table of all records that include the chosen words.
The "Find" command on Access 2002 does not do this, nor does any filter command. Is there an easy way to do this in Access?
Thanks
I want to filter the information displayed on a form using the values I select in text or combo boxes.
I want to filter the form using one or more of the following options.
Call Ref - text box
Location No - Combo box
Area - combo box
Status - combo box
The combo boxes are taking their values from other tables within the database.
Can anyone help me develop the code needed to filter the form.
Thanks
hello
i have a data sheet form which I need some help with!!
I have a lot of data that I need filtering.
The first filter is for day and the second is for time of day.
I.e. i want to be able to click on a date (using the calender from MS datepicker) and have the datasheet return the records for that selected day.
But I would also like another field that can filter it down to a specific time of day. e.g. 27/06, 13:00 returning all the records for this specific time slot.
At the moment there is a filter for date AND time but I would like date AND/OR time.
Also I would like to have it setup so it automatically gets rid of data over 2 months old, is there a way to do that, if not automatically maybe with a macro/command button??
Thanks for you help
i have a form bounded to a table called street.
this form has 2 bounded text boxes:
country: lookup field to the country table
city: luukup field to the city table
i want to do the following: when GetFocus on the city text box, i want to filter in thi stext box for all the cities that belong to this country (value in country text box)
how?
Hey all I am having a problem with my form filter. I was wondering if you can just direct a filter from form 1 to form 3 without referencing form 2. I am thinking not cause I am having a problem getting the filter to work. Here is the code I have in my load form.
framfiltval = "CONSTR_LOCATION = " + "'" + Form_PID.ADDRESS3.Value + "'"
Form.Filter = framfiltval
Form.FilterOn = True
Thank for the help in advance
Hi
I have this database that list companies and what type of loan they have. I am having a hard time thinking of the right type of filter to use. I am looking to select multiply types of loans and have it filter out the companies that have that service. I was thinking of a list box or options but I am having trouble with the table. My question is how would you go about it? Thanks
hi
hope someone can help.
I'm making a form to select country/state/city for members
i made a table with 3 columns country,state,city
i wrote down the states for 2 countries (the ones i'm gonna use)
the city is left blank (since i don't want to write down all the cities just yet)
i'm looking to do:
When i try to display the Country as a drop down using a query that selects the column for country, i get a list of the same country the amount of times it is in the table for each state.
I only want to see each country once. even though in the table it is written several times.
Is there any way that I can import a text file and split the data into three columns without having to go through 65000 lines of text.
It is basically a print off of a directory structure. I have a very large text file that lists the files in folders for each of hundreds of users. I need to divide the information up into three columns so that the below data:
BOBSongs
2003-07-15 12:10 PM 1,474,564 blue.mp3
2003-07-15 12:09 PM 858,204 orange.mp3
2003-07-15 12:10 PM 1,665,028 yellow.mp3
BOBsongshappy
2005-08-23 03:01 PM 917,504 jolly.mp3
2003-07-15 12:09 PM 331,005 joker.mp3
BOBfiles
2005-08-23 03:01 PM 917,504 writing.doc
ends up looking like this:
BOBsongs1,474,564 blue.mp3
BOBsongs858,204 orange.mp3
BOBsongs1,665,028 yellow.mp3
BOBsongshappy 917,504 jolly.mp3
BOBsongshappy 331,005 joker.mp3
BOBfiles917,504 writing.doc
I easily imported the file into Excel, but it is still all in a column. Any advice would be appreciated.
Hi all,
I'm creating a database for agents to use at work. Because they will all be using it at the same time, I need to create a combo box on the form that will filter the contents to only show those with their name in them. Is this possible?
Thanks!
Hello All,
I am new here and was wondering if anyone has ever had the following happen:
When you 'Filter by Selection' in a table for NULL values the number of records shown are less than the actual number of records with NULL values.
For example, I tried this with a particular tables looking for NULLL records in a particular field and while I could clearly see that the number of NULL values was x, the number returned upon filtering on NULL in that field was less than x.
Any idea? Your help is very much appreciated.
Thanks!
Hello Everyone. I'm not all that new to access however my problem does exceed my experience and I'm hopeing someone out there maybe able to help me.
A while back I began to build a database to keep track of post production activites such as what items were being produced on a perticular production line. Its my job to book all these items in according to date, line, item, order and qty.
This was all good and simple until it was decided that I had to assign a category to each item. Their are multiple models to one perticular category and to make things even more difficult the same item could be produced on more than one production line.
I work within a Pool company where their are 7 production lines, each with their own purpose and facilites of making certain products until you come to other products that could be produced on any of 3 or more lines.
So, I made a table 'Category' which lists the different types/acronyms for products and the lines in which it could be produced on.
I than created a new column within my Post Production table called 'category' and chose to use a drop box so I may select which category to assign the item. The drop box shows both columns 'Catefory','Line'.
The problem I have is that theres 40+ rows within the Category drop box and because the same name of the category may appear more than once simply beginning to type in the category name isn't good enough.
Is there a way to filter out which categories is listed within the drop box according to which line it maybe coming off once I've already selected which line within the same row?
I've tried selecting a relationship and createing a query both failed.
WarrenG.