Hello,
I have a form "article" with a button "place an order". Click on the button opens another form ("order") where I should fill the order for the current article.
The problem : how can I tell to "order" form that I want to order the article I was on in my "article" form, and not another one ?
Thanks
I have a linked table tblHome which is stored in a Sql Server DB and I want to create a form with 3 fields in it i.e. fieldA, fieldB, and FieldC in it and a button.
I want to add values to fields fieldA and fieldB and fieldC and when I click the button I want the value in fieldA to update any records in the linked table tblHome which contains the values in fields fieldB and FieldC.
how to do this?
I have two subforms in a main form. book_sub and book order subform. there are various subforms which i toggle in book order subform window by changing their properties with command button on main form. here is the code -
Code:
private sub billq_click()
Me.BOOK_SUB.SourceObject = "BILLQ"
Me.BOOK_SUB.LinkMasterFields = "[BOOK ORDER SUBFORM].FORM![ORDER ID]"
Me.BOOK_SUB.LinkChildFields = "[order ID]"
private sub stock_click()
Me.BOOK_SUB.SourceObject = "stock"
Me.BOOK_SUB.LinkMasterFields = "[BOOK ORDER SUBFORM].FORM![BOOKCD]"
Me.BOOK_SUB.LinkChildFields = "[BOOKCODE]"
Now the problem is when i change billq to stock it shows parameter entry window with caption [order id] twice. after clicking ok it does toggle the form to stock. then when i click button for billq again it shows the same thing.
the code works fine except showing parameter entry window twice with every toggle.
Below is the formula that I'm trying to get a value from an other Form (Pump Settings). But I keep getting an error message .
=IIf([Result1]<4.1,0,IIf([Result1]>6.5,([Result1]-[Pump Settings]![Target ]),IIf([Result1]>4<6.5,1,"")))
I am building a tool rental data base.I have places a delete button on my Transfer form so the operator can erase any mistake that he/she just made on a Transfer ticket.When I push the button I get an error message saying that I can't delete the record because it is associated with 2 tables. I have one table the tracks the transfer and another that tracks the tools associated with the transfer.How can I delete the transfer and the associated tools records?
View 2 Replies View RelatedI have a form which contains a subform. On this subform, the user will enter several lines of container ID numbers. If one of these containers has errors, they check a yes/no box and a pop up form opens for them to enter the details of the errors.
I want two fields that are populated on the subform to transfer information to the corresponding two fields on the pop up form. This works when only one container ID has been added to the subform. However, when there are multiple containers in the subform and the container with the errors happens to be the second or third record on the subform, the pop up form always transfers the information from the first record to those fields.
I also have the subform requerying when the check box is checked so that the information saves to the table and the focus does stay on the correct record but the pop up form still opens with the wrong information.
how to transfer the information from the record that the user is currently on?
In my form my combo box displays a list from a query called DORP-HDR that has 3 columns
DORP-ID | CODE | NAME
and displays them like that is the drop down list
The form field that the combo is bound to takes the numeric-id field as its value. In the combo control wizard i nominated that value, and in the properties pane bound column value is 1.
and in the properties pane the row source is:
SELECT [DORP HDR].[DORP-ID], [DORP HDR].[CODE], [DORP HDR].[NAME] FROM [DORP HDR] ORDER BY [NAME];
So far so good. I have created lots of combo boxes before like this.
But this time i want the second field in the list (CODE) ALSO bound to another field in my form . So I want the combo to transfer two values not one. How do i do this?
Any way to transfer the data in an unbound textbox into a separate table.
User enters an amount into a textbox2, and then it does some calculations that involves textbox1 and textbox2. Finally, textbox3 has the final answer. Can textbox3 overwrite textbox1's data on the table and on the form?
Also, is there an "auto date" feature in tables? If new data is put into tables, Today's date appears on the date column?
Form1 contains the sub forms Form2 Form3
I open Form4 in dialogue: Amend records and close the form
What do I write in the code to do the following:
on close
Refresh or requery all of the forms.
I've tried
Forms!Form1!Form2!Form3.Refresh
Also
Me.Form1.Form.refresh
I'm developing a system which uses linked tables (to an Oracle database) and subforms. I'm trying to add functionality to create new child records, but am running into errors when saving these records.
Parent table is PATIENT, child is DIAG. I have my DIAG Form_Current event set up to detect whether a record is new. When this happens I populate the DIAG foreign key with the relevant PATIENT primary key, and run a query to the underlying database to find out the next DIAG primary key. I then populate all the necessary fields.
On attempting to leave this record however, I get an ODBC call failed error, telling me that the the primary key constraint in the database has been violated. The reason is that Access isn't saving the record to the underlying database. I've tried to prompt this using Me.Dirty and RunCommand acCmdSaveRecord, but both of these just generate type mismatch errors.
What am I missing? Is there some particular set up for linked tables and creating new sub-records that I need to put in place?
When I open a form 'Project Details' it throws up a parameter box asking for an 'ID'
I searched throughout the database but I can't seem to find the cause for the parameter.
I've looked at my queries, forms and table and also relationships. I don't have a field that's linked to the form called 'ID'
I've attached a copy of my relationships. Is there a way I can see what causes the parameter. I thought it was only set in queries, however there are no parameters set up in my queries.
I have a database containing two tables which are related through the Staff
ID number.
The first table Staff information is related with a 1:* relationship to the
bookings table.
I.e. one member of staff can book many courses.
I have created the forms based on these tables using the wizard provided in
Access 2003. Mid-way through the Wizard I used the option to LINK the forms.
When you open the Staff Information form you have a button which says
"Bookings". When you access the bookings form you are provided with a
listing of the courses the staff have booked onto.
My problem is that if I add any records to this bookings table they are
added; but to an incorrect staff record i.e. not the filtered record from the
staff Information table. How do I get added bookings to 1) Be retained 2) Be
retained within the filtered record already selected?
Please HELP!
Thanks for reading and sorry if this all seems a bit vague - not great with
terminology x
All; using ms access 2010. In the query I use for a report; I put a parameter so the user can filter a date. It works fine but now when I go to open a form that has a subform relating to the report; users get the popup for input also. This doesn't stop the form from opening but it is annoying. There is a subform on this main form relating to the report, but the subform has a table not query for the recordsource like the report. None of the queries related to the main form that's asking for the parameter values have the parameter inthe queries. How to get rid of the parameter popup?
View 8 Replies View RelatedI have a form called "frmManageACF", query called "qryACFFill".
On frmManageACF I have a combo box (name cmbACFFill) which has three cols. col1 = SiteID, col2 = Site code, and col 3 = SiteName. The combo box Bound column is set to 1.
In qryACFFill, results are selected where SiteID=[Forms]![frmManageACF]!cmbACFFill
The query when I hit refresh always gives me the 'Enter Parameter Value' dialogue box. I have used this method of dynamically updating a query def before so not sure why it isn't working now.
Why the Parameter dialogue box is always coming up??
i have two forms
Form 1 with combo box 1
form 2 with combo box 21
i set run query A with parameter as value of combo box 1 of form 1...i want to run same query (Query A) with parameter as value of combo box 21 on form 2 or combo box 1 on form 1.
Hi all, hope someone can be of help with this one. Doing a database for a pet minder and have chosen to use linked forms for a more user friendly interface. The problem I have is that when I enter data on the Animal Details subform relative to an owner it is not updating such that when I examine that owners record again the animal details have not been saved. i have enclosed the database please could someone have alook and point out the noob error I am making :o
Thanks Lol :D
Hi all...
Does it make a big differance in the size of your database if you have all the images in the forms and reports linked instead of embedded? I have about 15 reports all with graphics and and about 7 forms with graphics also... Just wondering if it would make a big difference if after I split the database and create a folder with the current graphics and just link them all.. Or would that be a waste of time...?
Thanks
R~
Can I open a "Enter Parameter Value" dialog box to capture and use the input without running a query?
something like
Code:
ParaBox ("Enter the Hostname", vbEntParameterVal, "Hostname Required")
or
Code:
Set pDialog = Application.ParaValueDialog(mso?????)
I need a short string input from the users at application load, and I'd like to use the "Enter Parameter Value" dialog.I'm about to build a workaround that will invoke a SQL statement to save the entry to a temp table, but it'd be nice if I could just call up that dialog box and store the entry as a VBA variable.
I can not remove the Enter Parameter Value. In the attached date base, go to frmEvents, and double click on one of the shows, and you will get that error. I have deleted lines of code, text boxes, and anything else that is associated with the txtSearchS.
View 14 Replies View RelatedI have a form which contains a listbox sourced from a query and several text boxes where the user can enter filters for the query. The query has references back to the form for the criteria, i.e. the filter for "Company Name" is handled in the query criteria as
Code:
Like "*" & [Forms]![HooversProspects]![SearchText] & "*"
When i exit this form in my un-compiled version it does not pop up an "Enter Parameter" box, however, when i exit this form from the compiled version it pop ups the "Enter Parameter" box for every filter I have.
How i can fix this? Perhaps change the rowsource on the query to null upon exit?
I encountered an error with my form when I used a combo box to get the set of data that I need. the combo box is from the look up value from a table, then I made a main form and attached a subform which is made from a query, after I put them together the form looks great not until I switch to another supplier or click refresh to get the new data.
One of my record is mixing to another supplier and when I checked the table where the data is recorded it was also change, so if I use this form and clicked on supplier1 the data is good, then switch to supplier2 and then click refresh or if I alt tabbed the data is there and its supplier is also changed.
I tried to delete it and retyped it but still the error sticks, also I tried to delete it permanently but still one of the data is mixing on a different supplier and its supplier in the main table is also changed. I'm using access 2007 and also a friend of mine tested it in access 2010 but the output is different it reflects the correct data.
ok can someone please explain this to me..
i linked the booking to the driver using the ids through the bookingdrivertable.
the italic fields are the ones i have included in my Query called "bookingdriverquery"
bookingtable
booking id (autonumber)
date (date/time)
time (date/time)
drivertable
driver id (autonumber)
name (text)
bookingdrivertable
booking id (number)
driver id (number)
after doing this i created a form using the wizard, choosing all the fields from the "bookingdriverquery"
when i opened my form, i hid the booking id and driver id (as they are autonumbers anyway)
i then added a date.. a time.. and a driver name.. pressed save..
the booking table had 1 record, the driver table had one record.. and the bookingdrivertable had 1 record (both the ids)
this is the outcome i wanted..
i would however like to use the booking id and link it to another table in the same way.. a customer table for example (using booking id and customer id)
i had trouble however doing this.. because to duplicate this above method means that my user will have to re-enter the same booking details on another form.. and then the customer details..
how can i link all this together.. if someone wishes ask me a question and i will try to explain.. someone help me please.
I have two forms linked by a field "JUVIS". My problem is that I can't get the second form to show data newly entered on the first form without moving to another record on the first form. I have a command button on the first form that
opens the second form. All works well, meaning the forms are synchronized,based on the JUVIS field, except in the case of entering new data. In this case the second form opens to a blank screen instead of showing the JUVIS field. The forms are both linked to tables not to queries. Any help would be appreciated
Hi,
i need help regarding linked forms..
i have a combo box in a form, where one has to select a country for example UK is chosen, then there is a button that when clicked it opens in a pop-up form and displays all the information related to UK.
so there are two tables : Country (CountryNo : primary key) linked to CountryInfo (CountryNo: foreign key) linked with a one- to -many relationship.
my problem is when you have to add new records to the form CountryInfo, how can i make the foreign key update automatically? thus when adding data to CountryInfo, the CountryNo must be the same to the CountryNo in the CountryTable..
any help will be appreciated thanks a lot.
I was recently asked to use access to create a data entry system for coders when they are coding videos. I was asked to create forms that only used fileds from one table of a set of linked tables. I need the tables linked with referential integrity so that I can combine all this information in a useful way later, however whenever I try run my forms, except for the first form that connects to my "master table", all of the rest that need to link to it give me an error message about an inability to maintain referential integrity.
Is there any way that I can have access treat my forms to all be a sequence. What I mean is that if I had a single form with all of the fileds from every linked table, there wouldn't be a problem with integrity since all the changes are simultaneous. Is there a way I can have access treat all of my individual forms as one whole so it deals with the data in a similar way? Thank you in advance to anyone who can help me!
I have an input form where all the data entered gets transferred to a single table. I also have a report created so I can print it off and view whatever information has been entered onto the form
At the moment when I go to view the report it is showing every record that I have previously entered using that form but I want it to only show the record I am currently entering.
The record source for the report is the table where the data is being stored.