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???
View RepliesIn my current, new position, I have been asked to look into the possibility of finding out if there exists some good tests available to test how much skill someone has with Access.
Do you know of any existing tests or websites that do testing like that? If not, I may have to create one for us, but I didn't want to have to totally reinvent things if something good already exists.
Also, if something doesn't already exist, maybe we could get some people here to contribute to a thread with potential questions to ask.
I would like to add a check box to a form for invoices paid and then use that checkbox info in a query to strip off the service order if the box is checked for paid and creat a invoice for unpaid service orders only
any idea
I work in an environment with 7 computers networked to the same database. Until last week the database worked fine on all computers.
One computer was wiped clean and reinstalled with XP pro sp2 with all updates, office XP with all updates and also every other programs needed etc etc...
Now the database that every one uses will open up but will crash when the date filter is used in any form/report/query... This is the only computer this happens on and the error sometimes comes back with the following number 2147418113 but is intermittent. I dont think it is anything in the VB as it works totally on every other computer and worked fine on this one until reinstall of everything...
any thoughts anyone??...or has anyone ever heard of this??
I am developing one software in access 2000. Now where i stuck up is ... Customer is asking for " process flow chart" (steps in block diagram). The requirement is as below..
For a pen there are below operations
1. moulding
2. cleaning
3. polishing
4.assembly
Now these flow of operation is to be presented in block diagram. Please suggest me how do I do this in accesss? (in form or report)...
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.
Please see attachments.
POST.zip (384.0 KB)
database.zip (58.8 KB)
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.
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
Hi
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.
Thanks guys
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.
hello,
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.
Is this possible? Thanks.
Some records that users are inputting through a form are coming back blank in fields that are required. how do I fix?
View 3 Replies View RelatedHi,
Is it possible to restrict data entry for some users only on one field?
Regards,
B
Hi,
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.
How can I set the default value equal to the value in the previous record?
View 1 Replies View Relatedi 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.
Thanks in anticipation :)
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..
View 13 Replies View RelatedHi,
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.
Anyone know any possible causes for this?
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.
View 4 Replies View RelatedWhy is it that whenever I link a blank text field from my contacts database that it shows the first contact in my table? and how can i change that?
View 2 Replies View RelatedI have a Comments field on a form. I would like to set it up so that multiple comments can be added and logged at different times by different users. I have attached a picture of what I am looking to do.
View 4 Replies View Related