Link Form To Another Form Based Upon Specific Data
Feb 1, 2005
As the DB is too big to put as an attachment i have attached the relationships.
I have a form 'Call next customer', based upon call details table. Within this the Customer ID field. I want to place a button on the form 'place an order for this customer' which would take them to an uncompleted order form but with the Customer ID already filled in.
I have managed to this to some extend but the button directs me to a completed from for that customer - a past order.
Any ideas? I will, around 6pm tonight (1 Feb '04) upload the database upon my website to view: www.lecoqsportif.co.uk
Thank you very much for your time.
View Replies
ADVERTISEMENT
May 19, 2015
I have 4 forms in my access file. Now I have 4 buttons in html and I wanted to know if there was a way to open a specific form view based on the button click in the html page.
So access will open and show the form that is linked to the selected button in html.
View 14 Replies
View Related
Jun 9, 2010
I have two tables and two separate forms. [ID] is the link between them. (I cannot do a subform in this case).
Form1 displays 3 records
Have control button that goes to Form2 where [id] = NumID (NumID is "long" variable)
Have control button on Form2 to go back to Form1. It needs to go to the same record it came from. I don't want use a where clause (e.g., where [id] = [id]). This works, but the form1 is now filtered. I need all records available in Form1, but I want to go to the record it was on when the button was clicked to go to form1
Example:
Form1, record1, ID=30
Form1,record2,ID = 35
Form1,record3,ID = 40
Select record3,ID=40, then click on button to go to form2 (has where clause where ID=40).
Form2 is filtered and is correct.
Click on button to go back to form1. No Filter. It goes to 1st record (record1,ID=30). I need all records displayed, but need to be on record2,ID=35.
View 4 Replies
View Related
Jun 27, 2013
I'm trying to send at report based on a Query from a specific form.
Everything is (almost) working fine, except the fact that I can't get a criteria into DoCmd.SendObject method.
My code is:
Private Sub Kommandoknap212_Click()
On Error GoTo MailTilGodkendelse_Err
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
Dim MailAtt As String
Dim intSearch As String
[Code] ....
View 6 Replies
View Related
Dec 31, 2014
I have a form "frm_PatientNew" based on table "tbl_patients", this form contains a button "cmd_NewVisit" which is supposed to do the following: opens the form "frm_NewVisit" for recording a new visit for the last recorded patient in "tbl_Patients", I found many approaches depending on DMax and Dlookup and they worked fine just if "frm_NewVisit" is bound to "tbl_Patients", but "frm_NewVisit" is bound to "tbl_Main" which acts as a container for all information (patient data, visit data,service done and service provider), so the form "frm_NewVisit" contains fields from different tables. I wonder if I should create "frm_NewVisit" as unbound form, then adding fields from different tables to it and using vba to populate "tbl_Main",
View 2 Replies
View Related
Mar 22, 2006
Hi All,
I have a db with three linked (related) tables. I have a form that has, at present, only one of these tables as a data source. Now I want to bring a couple of fields from another table into that form.
I know how to link a table to two data sources when first creating a table. But how do I do it when the table already exists?
I tried Table Design View | View Properties | Data source,
but that allows only one data source. If I link to another, the first disappears.
Thanks.
Adrian
View 2 Replies
View Related
Mar 22, 2006
How to link additional data source to a form
Hi All,
I have a db with three linked (related) tables. I have a form that has, at present, only one of these tables as a data source. Now I want to bring a couple of fields from another table into that form.
I know how to link a table to two data sources when first creating a table. But how do I do it when the table already exists?
I tried Table Design View | View Properties | Data source,
but that allows only one data source. If I link to another, the first disappears.
Thanks.
Adrian
View 4 Replies
View Related
Dec 18, 2014
I am trying to save specific data from a data entry form to a specific depending on what the user selects from a dropdown/combo box.
So if the user selects "test company from the combo box, that data (from that form) will save to the Test company data table.
View 5 Replies
View Related
Jan 9, 2012
I am new to Microsoft Access. I have built two entry forms for product release information. I have a drop box under the label customer for each specific customer. I would like for this form to send the data entered in the form to the customer specific table from the customer names in the drop box. I have tried to research and execute this myself thus have been very unsuccessful.
View 14 Replies
View Related
Jul 29, 2013
Can I look up and verify data on a "second" form based on a selected record from first (still open) form.
I am trying to allow users to select a User Name from a combo box list and then open "Change Password" form when they select "Change Password" for that selected user name.
My problem is that I can't figure out how to associate and verify the data tied to the user name selected on the previous (Login) form ( I am trying to validate the old password tied to that selected record).
I have the first login form created, and it's working just fine. I also have the change password form created (and it's displaying the user name selected from the first form using:
Code:
Private Sub Form_Load()
With Forms![frmLogin]![cboUserName]
Me.txtPwdChgUserID = .Column(2, .ListIndex)
End With
EndSub
I also have the code written to validate and confirm old password, new password and validate new password (when the save button is clicked). I have yet to update the password with the new password (still trying to figure that out).
Attached zip file has screen shots of the two forms.
View 3 Replies
View Related
Aug 31, 2011
i want to do a report that display the data according to a form. for example: in the form i write the name of the company and 2 dates and i click the button and it opens me a report that contains data about this specific company and between those two dates.i thought i could do this with creating queries and when you write in the form it changes the criterias (the criterions) of the queries and the report will be based on the queries.how form can change the criterion of a query. or is there better way to display specific data according to a form.
and i have related question: i did a form that has a sub form (i mean a table in my form) and textbox. i wanted that when you write in the text box, for instance, name of someone the subform display all the rows which contains this name. but i cant connect the textbox to the subform, it only displays the rows that which contains this name but it does it in it own order.
View 2 Replies
View Related
Apr 1, 2013
I have a suppliers table and a products table. Two forms, Stock form with combobox to list Suppliers and a sub form with combobox that lists Products.I want to select a supplier from the Stock form and then the combobox in the subform to only list products directly sold by the Supplier.Have dabbled in SQL as follows:
SELECT Products.ProductID, Products.ProductName
FROM Suppliers INNER JOIN Products ON Suppliers.SupplierID = Products.SupplierID
WHERE ((Stocksubform.SupplierID=Stock.SupplierID))
ORDER BY Products.ProductName;
View 2 Replies
View Related
Jun 26, 2013
I have a bank of 8 machines, I need the user to enter one record for each machine in order. I currently have these machines in a combo box, but any other method would be fine.
When the user opens the data entry screen, I need it to open a data entry with that machine selected and the machine number pasted to the [Machine_No] field, when the user has finished entering the data (mainly yes/no tick boxes) I need them to click a "Next" button and have the data entry form to move on to the next record, the next machine on the list. This needs to be done in machine order as listed. I would then like the "Next" button to be hidden or disabled or changed to "Finished" (Close Form button)when at the last machine in the list.
Is this possible. I am using Access 2010 ...
View 2 Replies
View Related
Apr 1, 2013
I have a form and this form shows some values from one table. One of the fields named as Key. I want to open another form and show the record that has the same value as Key.
I am able to make this with filter but the form opens and when the user navigates the record, it creates a duplicate value in related table.
I want to open form and find specific data to display and then stop at this record.
View 1 Replies
View Related
May 2, 2013
I am currently creating a database in a hierarchical system that is to be used by multiple users to enter information specific to them. The tables are arranged like this:
Owners
Modules
Tasks
Highlights
Theses are connected using primary ID's and Particular Entries in the next table so they form a hierarchy - when you expand owners it brings up a list of Modules attached to that owner, then expand each module and it brings up a list of tasks associated with that module, expand the task and it brings up a list of highlights associated with that task. This is all very straightforward of course but what I would like to do is create forms that basically match so that the users can navigate from their name, through their modules and tasks and then add highlights to each task.
For this I have been using continuous forms to list all the different entries and inserting a button in each entry that I would like to link to the next form and find the specific data, however when I try to do this the button always without fail will just return all the entries from the form rather than the specific ones requested. I set up the button using the wizard and select 'open form and find specific data' and then select two entries that are identical on each form. I have trawled the internet quite a bit to try and find why this is happening and have inserted various bits of code etc into the embedded macro in an attempt to make it work but to no avail.
I wonder if there is something I need to activate on the form that the button connects to aswel or if I need to connect these forms using the relationship that I used to connect the tables (I am still using a unique identifier).If I connect to a single form it will display the first entry on the list (and I can cycle through them all) on a continuous form it will display all entries starting with the first.I would like it to display all entries for the selected record on the form.
View 1 Replies
View Related
Aug 25, 2011
I have a subform in which I want to put in a Command Button to open another form.
I used the wizard as per normal, but when you come to matching specific data fields, there is nothing in my left hand column of the sub form. I have checked the record source property and it is bound to the correct table.
I have read that this is an issue with Access 2007? Is this the case or am I missing something obvious here?
View 3 Replies
View Related
Jun 14, 2013
I have multiple buildings that I own. Each building earns a monetary amount each day. Some days they earn $0, some days they earn $1,000. This is all kept track in a data base in which someone manually enters the information each day.The three fields are:
Building
Date
Profit
I have narrowed a query down to one building, and I am interested in two things. How do I write a query that shows a 30 day peak (the most profitable 30 days). In other words. I want to see the following
Building: GNB Tower Date: 02/14/13 - 03/15/13 Profit: $25,162
The next thing I am interested in is a 7 day peak from within these 30 days. This shouldn't be too difficult if I can figure out how to query these 30 days, I can query 7 days out of those 30 days. So this bigger mind stumper is the first one.
out of a date range of months and months (Let's say 10/12/13 - 6-14-13).Once I figure this part out, I am sure I can figure out how to compile all buildings into one large report with their 7 day peak and 30 day peak.
View 1 Replies
View Related
Nov 28, 2011
I have a form that lists records in a table. I would like to have a hyperlink beside each record that will open the data entry form and navigate to that specific record. Right now, the use can only open the form for all records and has to use the record navigation buttons to find the desired record.
View 1 Replies
View Related
Sep 19, 2014
I have a Table with 57 fields. I would like to display this table in a form as a subform, but only certain fields depending on what selection is made in a combo box.
For instance, if the user selects "Missing Information" in the Combo Box, then the form will show a few standard fields such as ID, Market, Sales Manager, and then some specific ones such as date missing information requested and date missing information received.
If the user selects another option, again the standard fields will remain plus a few different ones.
I have done much searching on this and feel like I am so close but so far. I have looked into controlling the record source of the subform, columhidden =false and a multitude of others. All of which may or in fact probably do work in this situation but I can't seem to put it all together.
View 4 Replies
View Related
Sep 17, 2014
What is the best way to accomplish this? I have a database that split into the Front end and the Back end. The form that the users entering the information uses the queries from two sources. One is the a table within Access and the other is an excel spreadsheet that I link to it. How can I update /replace the Excel spreadsheet while users are using the form of the front End?
View 9 Replies
View Related
Jul 23, 2013
I want to hyperlink from a query direct to the relevant record in a specific form. I have a hyperlink field in the form which shows up in the query. When clicked in the query, this hyperlinks to the form but I cannot make it select the correct record in the form.How do I get it to select the correct record?
View 3 Replies
View Related
Mar 20, 2013
I have a form which uses a parameter based query to present an individual senior doctor with a list of names for of individual juniors to provide an assessment report on. When the first form opens the user enters their RespondentID.
Once senior has decided which names to comment on I have another form which has the questions to be answered which is opened by clicking a button on the first form.
How can I pass a parameter from the first form to the second so that only the records relevant to that senior doctor are displayed? The underlying table has 60 senior doctors and 20 junior doctors. The senior doctor is identified by the field RespondentID in the first form. I've tried putting a WhereClause in the FormOpen command but I still get a dialogue box asking for the parameter RespondentID when the second form is opened.
View 2 Replies
View Related
Mar 22, 2006
** Additional Note: Could I possibly just have a field in my main form that pulls data from another table? Warning: bad with code**
I'm not sure I'm looking at this correctly and have tried to figure it out (For about two weeks now). I really hope someone can help with this.
I have to add a "Multiplier" to my form. I have tried this numerous ways but it's not working properly.
What I need is to have a main form with a subform only displaying the relevant field (that being if this month/year and location match up between both the subform table and the main form that is displayed, then show this value in the subform on the main form). With this multiplier displayed, another field in the main form is then multiplied by this value.
Is this the right way to do this or no? I'm open to basically anything. It's just that the 'multiplier' changes from month to month and rather then have people manually enter in the multiplier to the main form for every day of the month, I'd rather a field be automatically populated and therefore the other field automatically multiplying by this.
Is this possible??
View 1 Replies
View Related
Feb 19, 2007
Newbie here. Just trying to make a characteristic (e.g., color) of a button change based upon contents of a form field. Can anyone please adivise. All help is greatly appreciated.
View 3 Replies
View Related
Mar 6, 2008
Just wondering... is this possible.
I have a database with 200 clients. If a user pulls up a record and the customer's insurance has expired, is it possible to change the background color of the form so that this automatically alerts the user that this customer needs to be contacted and the record needs to be updated?
Or are there any other suggestions that may serve the same purpose?
View 1 Replies
View Related
Mar 2, 2007
Hi,
I have a form with a subform, Both of them are based on a query.the form
displays a productid and its details ,and the subform has matching
productnames for that productid.
Now i have a search on the main form wherein the user enters ( search
for) the productid, once they click search button, the form should show
that particular prod id and details and subform loaded accordingly with
that productid matches...seems simple but how do i code this in VBA??
Basically populating the form and subform with data based on search..
i am using ODBC coonxn with backend oracle tables..
any help would be highly appreciated!
Thanks
View 2 Replies
View Related
