Modules & VBA :: New Entry Form With Value From Another Form
Jul 16, 2015
I have two forms. Main form called "frmCarV" and another form "frmEngine"
The form frmCarV contains the its ID called VID that is connected with the frmEngine also.
I made a button on frmCarV form that when click opens form frmEngine as a new entry (because the form is for entering certain data) with the VID field already filled from the VID field in the frmCarV form where data about each car is put.
This is the VBA I placed in the button in the Main form frmCarV.
Private Sub btnUnosEvidR_Click()
DoCmd.OpenForm "frmEngine", , , "VID=" & Me.VID
End Sub
When I click the button form opens but the VID field is not filled, it stays blank. Also the VID field in the form frmEngine is a combobox.
I'm looking for a button that cancels an entry on a form. I want everything within that form to be cancelled including the Primary Key field. I currently have a button the uses the me.Undo code and then automatically closes, however this only clears the data that has been entered by the user. So when the user re-opens the form the primary key field is showing a 2 instead of a 1.
I have a form where customer data is entered. one field serves as a criteria for a query. If, for example, A is selected in the form the query uses the criteria "A" in the X field f query. However, if B is selected in the form, the query uses the criteria "B" in Y field of query.
I can easily do this by setting up two queries and having criteria A run in X field of query and similarly for B. However, it seems as if there should be a way for me to have one query and simply use the criteria in a different field.So, is there VBA that will update a given query's SQL to use one criteria in one case and another critiera in another case?
I've got a data entry form bound to one table. The form has four buttons:
- Clear Fields - Cancel - Save and exit - Save and add another (which should save the user input to the subform/table, clear the input fields, and allow the user to add another record)
I can't quite seem to get the "Save and add another" button to work. When I put some information in the input fields and click the button, it saves it to the subform/table perfectly, but when I try to do it again, it just edits the last record (the one just created).
How can I get that button to place the information from the input fields in a new record every time?
The _Click event for the button looks like this:
Code: If Len(Me.field1 & Me.field2 & Me.field3) > 0 Then Me.Refresh btnClear_Click DoCmd.Save End If
I Work for an NHS organization. A department here orders prescriptions and sends them out to Gp Surgeries. I have been tasked in designing a database to make this easier for them.
Prescriptions arrive on a Pallet. Each pallet has 100 Boxes of prescriptions on it. Each box Contains 2000 Individual prescriptions. I have a table which contains the following:
Box Number Serial Start Number Serial End Number
When the user enters the first box number and the serial start number, i need it to calculate the serial end number and insert another 99 rows into the table and also calculate the serial start and end numbers for these other 99 records.
I have a form for entry and some fields are computed or result of a query from another table. I have a function that looks up a value from another table like so
************************************************** ******** Public Function GetTargetType() As Variant GetTargetType = DLookup("type", "tblFormulations", "[tblFormulations!formulation]=Forms![frmNmsConsumptionEntry]![formulation]") End Function ************************************************** ********
Which works fine when I test in the immediate window.Then I have this form event. This however does not insert this value when I am adding records using my continuous form.
************************************************** ******** Private Sub Form_BeforeInsert(Cancel As Integer) Me!target_group = GetTargetType() 'Forms!frmNmsConsumptionEntry!target_group = GetTargetType() '[tblNmsConsumption.target_group] = GetTargetType() End Sub ************************************************** ********
making sure I can insert this value once retrieved.
I want to use the same form in datasheet mode for data entry and retrieval. When retrieving, all controls are disabled and locked. I am trying to enable and unlock them for modifying but that isn't working.
I have a database with a Main Menu Form, containing a Button that loads my main data entry form. When the Button is Clicked portions of the data entry form that is loading shows through the Main Form Background (e.g. portions of the navigation bars, and portions of the boarder on the form that is loading.)
I have got a db when I enter a new client in the client form it saves it in the table but when I return to the form the client I have just entered is still there so I cant enter a new client it does'nt clear the text in the text box can anyone help
I don't want the form to add the record if I put in a value in a field. I want it to add the record when I press a "Add information to a record"-command button. How can I do this?
I need to design a query using fields from two tables, from which I am creating an autoform for data entry purposes. I have done this before with no problem. Now though, I cannot enter data - the option for new record is greyed out. Is there something simple I am not doing? Please help!
And I have a table with those same fields: Name, Date, Description
How can I code a button to add a new row (record) from the form using the textboxes after they have been filled in?
I am familiar with the basic data entry mode, but for my purposes, it'd be best if I could do this without forcing the form to use the table as a Record Source.
I want to achieve Access data updates to two tables through the use of a single form. Fields are identical in each table. I set things up this way in order to view the whole report or a single page of the report, and to this effect I am using the two tables. Can anyone help?
Hi, need some assistance as a access beginner. First I’m not sure if I will need two related tables to do what I want (if so a brief description of how would be appreciated). I would like to create a data entry form (Material Requisition) where the body of the form contains basic information about the request (including a “Next Number” com. button, that will assign the next number using “Dmax” + 1, I think I can figure this out myself) and then have a sub-form where multiple items can be entered (requested) on the same “Requisition Number” as line items (if the line numbers will need to be identified as I’m sure they will, I would like this to happen automatically. I can/ have made basic databases with simple queries, reports and entry forms but this seems a little advanced for me right now. I would then like to generate a report grouped by the requisition number with their associated "line items". Any help or suggestions would be greatly appreciated. Thanks
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?
My data entry form has a button that allows the record to be saved. However, after saving the record, the form doesn't allow a new record to be added. The new form just sits there with the previously entered information in it. How do I go to a new record?
I have searched the forum and asked some of my colleagues about this and I do not seem to be getting anywhere. :(
What I need is to be able to use a (blank, ie showing no current records) form to enter data into a new record.
I have Tables A and B in a 1-to-many relationship and I need to be able to bring up a blank form which has:
1. a combo box, allowing me to select the relevant record from the parent (table A), and ... 2. blank fields (from the child - table B) to fill in with new data.
I can set this up using a standard setup, where all records are shown, but this is confusing to a dumb user, who really only wants to see relevant boxes for them to fill in without the distractions of data in fields they are not concerned with or with other records they do not want to know about.
Is anyone there who can show me a db sample of unbound data entry form. I want to control the builtin auto save of Access, because sometimes I don't want to save the data of my form..
ok, basically the way i am structuring my database, there will be several forms used to enter details into certain tables...
in my previous limited attempts, i have simply created forms using the 'wizard' which just makes a form based on that table (for entry)
what i would like to know is a very general question..
if you make a form from scratch.. say it is a completely blank form, if i place a combo box with certain entries in it, can i forefully edit a certain field in a table using those entries.
i mean, is there a way (within the properties section of the various components placed on a form) to make that value entered go into a particular field in a table.. without using any 'wizard' before hand to automatically put certain fields in.
Hi Can any one help me with a quickey. I have a form which shows short details of a building ie name town postcode etc. I have another form with 3 subforms to be able to enter new details of a building, the new client and the new agreement. This works well and is feeding the new data into the correct tables. When I reopen the short detail form it doesnot display the new records. I have a short piece of vba which allows ne to see the full details of a site when I click on the site name. A quick reply would be much appreciated. Thanks ChrisD
Can I use subforms to create ONE form that will do data entry to more than 3 tables at once in a relational db? How can I do this? Do I have to use Javascript, etc?
HI How can exit from an "DataEntry=True" and "AllowAdditions=True" Form without add a new record to the table ??
Any help please!!!!! Thanks Ps: i only can do that if i press 'esc' in the 'textbox', but that doesn't suits me. the form only have a 'textbox' and a 'commandbutton'
