I would like to make filtering in a form as e-a-s-y as possible for a group pf people who have mostly never used Access. I need some help with an idea.
I have a form they fill out to enter their data... but then they later might have to come back in to edit the record or add additional data. There are only two fields on which they would navigate to records: MyName and ProjectNum.
I would like to have a header in the form... or something like this idea... that would have these two fields in it. With each of these, there would be a "Go To" button that would filter the records shown in the form to either those that are under their name or the single project record. I don't want to train them on "Filter By Selection" or "Filter By Form" because I hide the toolbars in this database. Also, as this is a shared database, I need their filter to be deactivated when they select another button or close the form.
Any help is GREATLY appreciated. As you can see, I am just no good at this and reeeeeally need some help here. Thank you.
I have a form with a list box that is filtered by the entry made into a combo box. It works fine except that I want an option which shows all records in the list box. I tried using the formula below in the query criteria for the list box but it returns no records when I select All in the combo box. Why won't it work? Is there a better way to do this? Can anyone help?
I have a bound form, in its heading I have a combo box which lists three choices. Basically I want to filter all my purchase records by checking a field PUOrderNb (Example: PO200100025) against the choice made in the combo box, namely DE (for demand), PO (for Purchase order) etc. On the after update event of the combo box, I have the following code:
Dim strfilter As String strfilter = " left ([PuOrderNb],2) like " & cboFilter.Column(1) Me.Filter = strfilter Me.FilterOn = True
When I make a choice in the combo box, I get a window asking me to enter a parameter value and it lists the value of the combo box choice as a sort of a title just above the white input fame.When I type in PO for instance, the program does correctly filter all order numbers starting with PO, but the whole point of having a combo box is not to have to type anything.The other odd thing is, when I change the choice in the combo box, after my first choice, I do not get this parameter question but nothing happens as to filtering. The first choice remains active.
How can I get the value from a field in one table (in the sub form) to copy/insert into a field in another table (in the main form) when adding a new record?The main form and sub form are linked using parent/child linking, and the sub form is in a tab.I have table A (Visit Dates) in the main form which is used to record the date of a visit to a church. Table B (Quarters and Peals) is used to record an event that took place at that church during that visit. Note that not all visits in table A require a record to be created in table B - but half or more do.
In tables A and B I have a field called "QuarterOrPealID" and these are both primary keys, though the field in table B is set to 'no duplicates' and in table A it's set to 'duplicates allowed', as table A has its own auto number/pk. They are both linked in the relationships.
So, when I add a new record to table A using the main form, I might then need to click on the tab in the sub form to create a new record in table B, which has to be linked to the same record in table A. When the "QuarterOrPealID" auto number/pk is generated in the sub form (table B), I need that value to update to the "QuarterOrPealID" field of the main form (table A), so that when I'm viewing these records the form pulls all the information nicely together.
I've just returned to work after kids and started managing a large Access database related to health, back-tracking over many years.
Currently in filling a form we physically enter: Apples 2.2 red apple 2.4 red apple cut 2.45 Oranges 5.6 Cucumbers 8.5
Is it possible to get field 2 to automatically fill with a number code due to the text typed in field 1?
FWIW, I'm confident at more basic Access e.g making follow on default value = Dlast("field""table") type stuff but the more complex stuff I haven't touched since Uni over a decade ago and you will need to be gentle while I blow away the cobwebs
I have a form that users will use to add new records (customers).
There is a field named VAT_Registration_no
First of all i want some code to check for duplicates in that field only,before entering the next field.If the record exists i want to show a msgbox and set focus to the vat_registration_no field. Also I want the same thing to happen if the vat_registration_no field is empty.here is what i have tried:
Private Sub VAT_registration_no_AfterUpdate() Dim btest As Boolean If VAT_registration_no = "" Or IsNull(Me.VAT_registration_no) Then MsgBox "Please enter a Vat Registration No.", vbOKOnly, "error" Me.VAT_registration_no.SetFocus Else btest = True End If End Sub
and to all other fields:
Private Sub textfield_Enter() If Not btest Then Me.textfield.SetFocus End If End Sub
If I just press enter to go straight to the second field I dont get a msg. If I write something and delete it and press enter i get the msg but when I press ok the cursor goes to the next field. I want it to go to the vat_registration_no field again. And I also want this to happen even if dont write something and then delete it.
I am creating a database tracking physicians and their contracts. I currently have two tables: PhysicianT and ContractsT, with corresponding forms to enter information in them. I have an issue with the Contracts form; I want to be able to select a physician from a dropdown list (looked up from PhysicianT) and have Access autofill their Physician ID #.
PhysiciansT looks like this:
physicianID (AutoNum) name (Calculated) 1 Barker, Bob 2 Burgundy, Ron 3 Stark, Tony
Upon selecting Barker, Bob from my dropdown list, I want "1" to appear in the Physician ID # field in my Contracts form.
I have a login screen to open a form. I would like to filter the form based on what user logs in. In my tbluser, I have a trainer name, a UserLogin, and a password. I would like the form to filter on trainer name based on userlogin.
I know the code: DoCmd.ApplyFilter , "Trainer = 'Joe Smith'" but how to I edit the code to change as the tbluser changes?
Trying to do the following: Having built a table of customers, I need to have an automatically generated ID number for each that IS IN ORDER - which rules out Autonumber and it's gapping tendencies. So, I've developed a new CustID field and set it to "Number", and now just need to figure out how to get it to pull the previous entry and add "1" to it. So it would look like this:
CUSTID NAME 1 Bob 2 Fran 3 Phil 4 Tom 5 (ready for next entry)
Any way to use a function I don't know about, or program some type of solution? Thank you
I have a large database for my company, a portion of it stores Genres of different music tracks. In this genre field there would several genres that fit into the 'feel' of a track, and we need each genre in it so our playlist queries work.
I.E Punk Pop Rock. But some because some themes are more dominent some users may enter Pop Rock Punk, this gives the same result in our playlist queries but leaves over 700 diferent types of genre feilds because of all the repeating (Punk Pop Rock and Pop Rock Punk are two distinct entries)
Is there a way to type all the genres in and the field take it's set combination of them to stop different orders of words. We currently have 25 different genres and this leaves alot of unnecessary duplicating.
This does however need to be quick and easy to type as many tracks are processed in a day.
I would like to force entry to a txtbox via code. the txt is named txtssn and would like that if data is not entered a message will advice users to complete the entry and the mouse cursor should go back to that txtssn.
I have a database that has a combo box for CITY entry... Of course each city would have a different zip code... I would like my ZIP CODE field to be suggested (or entered) automaticly according to which city is chosen in the city field...... Can someone help???
I have a user who would like the value from the last entry into the form's title field text box to show as the default value when he clicks on enter new issue button to bring up a new record. I do not know if this is possible but I thought I would check for him.
i would like some help on how to validate a user's entry in a form. i have a query that calculates number of hours remaining for a particular customer. when a user submits the number of hours used on the form, i want to check that this value does not exceed the number of hours they have remaining. and display a message box if they dont have enough hours remaining. any suggestions on how best to do this? the query has a where statement like 'WHERE customer = customer_code' so customer_code is entered by the user. how do i set this so that the value for customer_code is taken from a field on the form?
Is it possible to ensure that if a particular field has a specific value, ie, 'yes' then the reaminaing fields on the page are automatically set to 'no' by default?
If No is selected in the field in question then this would subsequently allow the other fields to be set to any value.
I haven't been able to figure out the code to require entry (for a new record) in a field on a subform - anyone can help with this?
The situation is a contacts database, and each new contact should have a (or multiple) Person Roles entered as well, which is their relationship to the organization.
I have a field in a form that contained 8 characters long (Ex: ZWXX0001). The first 4 character always stay Constance. However the last 4 characters I'd like it to increment by 1 after each time user press enter to go to the next record when they do data entry. If this possible will save my user a lot of time. For Example: ZWXX0002, ZWXX0003, ZWXX0004 . Is this possible? Thanks in advance..
I've join a small company who uses access to store a route card system. Unforunatly it's partially broken and nobody seems to know how to fix it. Instead of bodging it forever i'm hoping to fix it.
My access knowledge is fairly limited so please keep it simple
The route cards are fairly standard, the primary key beening the route card number, the are various fields material, order date, etc.
The problem is when you enter the data into 3 of these fields access repeats the data to all the forms. At the moment we're having to leave them blank and fill them in by hand, which means we don't have the data on computer.
In a table I have 3columns with the primary key of MemberID. Of the columns in question, one is StudentID and the other is StaffID. What i want to do is that if a use enters the information in MemberID, he will not be able to input in the field in StaffID and vice versa.
