Hi All!
I'm working on a Personal Information Database.
I want my system to do the following whenever I
enter a person's ID:
If the ID is already entered before, I want all
the personal info fields to be populated with
the person's details.
If the ID is not entered, then I will enter all
the person's details.
Any help will be very much appreciated!
Regards,
CS.
I have couple of forms where...The users enters a name of the river where he/she was fishing in, I also have an option where the user can browse for previous entered rivers.I am wondering how this works, how do I let the information entered go automatically into the browse section and how can I prevent from duplicates will appear in the browse for previous entered rivers. thanxp.s is this something that I will work with in the table it self or can I change this in the form ???
View 1 Replies View RelatedI'm not a complete Access beginner, but I'm also far from an expert and not much of a programmer. So I feel that there's a chance this might be a relatively simple issue I'm merely making more complicated than it should be. But hopefully someone can at least point me in the right direction. (For the record, I'm using Access 2007.)
I've created a form to which I've added three tabbed pages. Each of these pages contains a subform the user can use to enter data into three different tables. The tables' relationships look to be set up properly, and there doesn't seem to be a problem with typing the information into the subforms. However, I want a single button press to update the information across all the tables and clear all the fields in the subforms so that the user can then go about entering the next person. I can't seem to figure out how to do this.
I downloaded a number of template databases from Microsoft, and some of them have exactly the kind of functionality I'm looking for: a "Save and New" button that inputs all the data across the tabbed pages and then lets the user start over from scratch with blank forms. I've spent a fair amount of time studying the various forms in the Student template, but I'm having absolutely no luck replicating that functionality. I basically want everything to work almost exactly the same as that, except with different field and table names (of course).
Can someone please explain what I'm doing wrong and how I might fix things, or at the very least how to look at the Students template database to get the information I need on how to do this myself? I'd be very grateful for any help on this matter. Thanks.
I am in the process of (attempting) to develop a database and application for Parking & Violation Management. I have two tables at this point: "Parking Registration" and "Violations" that are linked by a "Permit #". I have developed a form that will allow the officer to enter either the "Permit" or the "Licence Plate" of a vehicle to run a "Vehicle Check" query to produce specific information for the vehicle in question; which is what I wanted, kind of... The problem is that the resulting data pops up in "table" format, and contains multiple fields, making review of the data difficult due to its lengthy, linear nature. Is there a way to have those results appear in text boxes either on a separate form or the "Vehicle Check" form itself?
View 1 Replies View RelatedHey,
basically, i have an invoice form, and on this I need to add InvoiceDate to it. Now, on the form, I have =Date(), but this changes every time i open the form, so it dosnt actually record the date. I have to manually type the date in to the form, which is not very good usibility practice. Can anyone help? Ive tried searchin, but I couldnt fin much relevent stuff. CHeers
Alex
I have a form in Access where a report date is to be entered. We only want to show a date format like Dec-13. Month-Year. I set a input mask to keep this consistent when others are entering.
Now it is January and people are trying to enter their reports for December, when they put in Dec-13. It automatically changes to Dec-14. WHY!I tried to go to the table and change the date to the year 13, but it just keeps changing back to 14.
I have built a database to be used by several users. One of the tables contains some fields which I don't want some of the users to be able to see.
All users log in to the database with their own username and password.
How can I hide the fields to everyone except a specific group of users?
Thanks,
Gary
I am trying to create a form from questions listed in a table, add a yes/no column to it and then have it auto populate a data sheet with the question and the answer. how I can have the datasheet autopopulated?
View 1 Replies View RelatedI'm trying to get a listbox to display results of a query that are only related to the current record being viewed.I have a form (setup as a continuous form) that displays a vendor table. I have a query setup to reference what parts a vendor supplies, and I would like those results to be visible on the form. I would use a subform to make this happen, but if I try and drop a subform on the main form, it says it won't do it with a continuous form. So, the listbox. I copied my form, dropped in the subform, and took a copy of the SQL statement. I then took that SQL statement and dropped it on the Row Source of the unbound listbox. I do get a return of Parts and Prices, but its the whole list, not just a list for the currently displayed vendor. My SQL is currently thus:
Code:
SELECT tblPrice.[Part Number], tblPrice.Cost, tblPrice.[Price Date], tblPrice.[Bulk Discount], tblVendors.[Vendor Name]
FROM tblVendors INNER JOIN tblPrice ON tblVendors.[VendorID] = tblPrice.[VendorID];
I have tried to wrap my head around it, and I'm stuck. GoogleFu has also failed me, as I can't find something quite on point to what I'm doing.
My friend is looking for the database to auto populate a date, based on information already entered.
A Learner Starts his/her private tuition lessons on dd/mm/yyyy and pays for 6 weeks, the next lot of payments is due on dd/mm/yyyy...
Hi, I was wondering if anyone could help me.
I have a simple database, consisting of two tables and one form. I'd like the form to display information mainly from the first table (table 1). For this, I have used the Form Wizard, which works well and displays as it should. My problem comes when trying to display data from table 2, without using the Form Wizard.
I have a simple field called 'Number' in 'Table 2'. I'd like this value displayed in a text box along with table 1's data. I've tried using the expression builder, which gives me something along the lines of:
[tbl_Table 2]![Number]
But this is displayed as:
#NAME
...when I open the form. Could anyone explain how I do this correctly please? All I'm trying to do is display data from other tables in the form.
Any help is much appreciated.
I've created a query called "JobHistoryQuery" and a form called "JobHistoryMultiForm", this displays all Jobs related to an Asset and all the information about that job. There are some fields (BilledMonth, BilledYear, BilledValue, Parts Required, PartsUsed), however, that I would only like to see if I need to see them (as there is quite a lot of information on the form and ideally, I'd like to be able to see the key information from each job from that asset with ease). What I would like is to create a button that says "Billing" and "Parts" for each job and it brings up a pop up window displaying that information.
View 11 Replies View RelatedI've established a many to many relationship using a junction table.
So I have 3 tables (A for "materials", B for "batches", and J for "junction")
Form A is linked to table A, and contains a subtable linked to a query from table J. This allows me to input materials into table A and then list all of the batches it may be used in that are in table B. I successfully got this to input all the batches and materials combinations in table J.
Now on form B, which is linked to table B, displays the batch information, with the subtable J.
My problem, is that only the materials primary key is showing, not the other information that should be linked from table A.
I am trying to get a form to display certain information based on the data in another box. I have to input some exam results and want to assign a level to them. So, if they score < 13, the result would read "Below Entry 3" if between 13 and 21 "Entry 3" etc If this was a spreadsheet I would use an if function, but I am not sure that I can do this here
View 14 Replies View RelatedIs there a way to display/hide the information on a subform using a checkbox?So, when the checkbox is checked, the fields are blank but when the checkbox is unchecked, the information displays?
View 5 Replies View RelatedI'm trying to figure out a way to get my access database to auto-populate data into a field based on the information I type into the first record.
So what I'm looking to do is that when I type a name into the UserName Field it will automatically fill in the rest of the field with the same information.
To clarify I'm looking for a way so that when I type something into one record it will fill the rest of the field in with that same information.
When entering information into a blank form, I would like to be able to continue entering information to another additional blank form after my last entry. Is there a way to continue to a blank form after entering information into the previous blank form? I would just like to continue without having to close the entire form and then reopening another form.
View 7 Replies View RelatedI would like to first state that I am new to Access and trying my best to pick up on skills, so pardon if my questions seemed redundant or illogical. I'm trying to create a sort of quick-access/all-in-one Access form that..
1) Displays contact details stored in an excel sheet
2) Opens application on click
3) etc..
I am able to get pointer 2 sorted out, however am having trouble with pointer 1.
I have the contact details stored in an excel sheet, of which I am aware of how to import it into Access. However, my idea was to have a tab where firstly there are 4 buttons, say buttonA to buttonD.
I want it to perform an action such that when i click buttonA, 5 other buttons (say button1 to button5) appear on the right of the 4 existing buttons.
If I press buttonB however, button6 to button10 will appear and replace the button1 to button5 at the same spot.
After which, if I press button1 etc, there will be a field where contact details are displayed (name/number/etc) and it switches as I press different buttons.
I would like to know how on a report to make a button action that when i click it present information from contact list (full contact details).
View 1 Replies View RelatedSo i have a access database with a main field that we can call vendor # (LIFNR) and another called Company code (BUKRS). There are multiple company codes under a single vendor #. Example:
LIFNR
BUKRS
0000010535
1010
0000010535
5060
0000010535
5610
0000010536
1010
0000010536
5060
0000010536
5610
What I am trying to do is create a 3rd column where i can have a unique row for each of these fields without it repeating. There is no unique identifier in this table and that is what i am trying to achieve.
I have a searchable form that display information on agreements other companies have with us. If a company requests an inspection we have 30 days to go out and complete it.
I am trying to create a message box that will display all inspections that are due within 5 days when the form loads. No luck so far, only broken dreams.
Is it possible for message boxes to use expressions and display information that fits the criteria?
I'm trying to understand how data is passed using foreign keys.
I'm using Allen Browne's 'Don't use Yes/No fields to store preferences' at: [URL] ....
I've also downloaded his sample DB, RelationBasics, to use as a guide.
Attached is my version of the Student / Sport DB as described on the webpage.
I use 2010 at home (saved as 2003 version) and 2003 at work (JPNSE OS). Both result in the same thing.
The problem I'm having is I cannot get the actual sports to display in the combo-box, only the Sport_ID number.
I've tried building both forms with and without actual data in the TBL_Student & TBL_Sports tables, but no mater what the result is the same.
Please help,
I want to make field to insert automaticly data from other filed but without tax (18%)
example
I have filed [Iznos] where the price is with tax and I want to make another filed where data will be entered automatically and without tax
I tried in "defaul value" to enter
[iznos] * 18/100
but don't works.
Thanks
Please help,
I want to make field to insert automaticly data from other filed but without tax (18%)
example
I have filed [Iznos] where the price is with tax and I want to make another filed where data will be entered automatically and without tax
I tried in "defaul value" to enter
[iznos] / 118
but don't works.
Thanks
What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
i have a subform name(SUBSAL)in this subform i get reocrds for some employee as select combobox Name(CMBEMP).some employee having 2 record or some having 6 record as their transaction
i have sum of transaction at subform footer field but when only 2 records shows in subform it shows a major gap or blank space in subform detail section.