Help With Autofilling Fields From One Form To The Next
Jan 31, 2005
I am sure this has been asked a thousand times, but I couldn't seem to find a thread.
I have a form, which contains a subform. When in the subform, I have a button to create a new main form and I want it to prefill in the data from some fields on the subform.
It looks like it should work, but #1, when I am in the main form inside the subform, the botton does nothing. If I open only the subform, then it at least works.
And #2, it definitely captures the values that I want, but it doesn't fill them in on the form.
Here is my code:
Private Sub Command44_Click()
On Error GoTo Err_Command44_Click
Dim doc As String
Static tit As String
Static desc As String
doc = "Business Requirement Document"
title = IssueType
desc = Issue
DoCmd.OpenForm doc, acNormal, , , acFormAdd
BRD_Title = title
BRD_Description = desc
Exit_Command44_Click:
Exit Sub
Err_Command44_Click:
MsgBox Err.Description
Resume Exit_Command44_Click
End Sub
Any help would be MUCH appreciated!!
View Replies
ADVERTISEMENT
Sep 20, 2006
Hi all, and apologies for starting a fresh thread about this, but I can't find exactly what I'm trying to achieve via the search function, although I'm hoping it's just something simple I'm missing.
I have a small database that allows the user to click on a button to go an Add New Records form, which they then fill out. At the moment, the record number gets autofilled and they start entering details. However, one of the details they must enter is a unique record number, consisting of the month, the year, and a number between 01 and 99 (so the first new record created today, for example, would be record 090601, the second 090602, etc. The first next month would be 100601, and so on).
At the moment, I have to rely on people to manually enter this number, which requires them to view the current records first to ascertain whether there have been any previous records created that day (to prevent duplications).
What I'd really like is to have the this records box autofill when entering the form with the current month, current year, and then the number of the record for that day. However, it should automatically look at the last record created, and, if there's a match on the month and year, add one to the last 2 digits to ensure a new, unique record. So, for example, I have three records this month, listed as numbers 090601, 090602, and 090603 respectively. I go to create a new record, the box should autofill with the number 090604 and create a new record accordingly.
How do I acheive this?
View 14 Replies
View Related
Jan 25, 2012
I'm VERY new to MS Access 2010 - in fact, I used some online youtube videos to get me started with the database I'm currently working on.
Here's what I have so far: 2 tables, one for customer information (name, phone, addy, etc) and one for invoices (inv #, customer ID (which should be the same as my primary key from the customer info table), phone, services rendered, etc etc)
I'm currently working on a form for Invoices, where I can simply put in the customer's name, date, cost, etc without having to look up the ID# and phone number for every time I use it.
View 1 Replies
View Related
Jul 21, 2005
I have a table that keeps putting a zero value in the new recordl. It was previously an autonumber field. I changed that and deleted the zero from the default value property.
How do i get rid of this???
View 2 Replies
View Related
Jan 5, 2006
Hi there!
It's been almost 10 years since I've done any work with databases, so I'm really REALLY rusty and I barely remember how to do anything. I was wondering if you guys could help me out with a question I have in making a form.
I have 2 tables. The first table has a list of names and ID's. There exist some duplicate names, as some people are associated with more than one ID.
And there are two fields to the ID. One is Called the Client Code, and the other is the Client Division.
So the 1st table, in datasheet view, is basically:
# | Last Name | First Name | Client Code | Client Division
The second table is a list of addresses based on Client Code and Client Division:
# | Client Code | Client Division | Address 1 | Address 2 | Etc
----
What I'm trying to do is the following:
I'm trying to create a form such that as I'm typing in a last name, it does autolookup and auto filling. I may have multiple people with the Last name of Smith, so then it dynamically creates a dropdown box with all possible unique first names associated with the last name Smith. And after I choose/type in the first name, I get to two more dynamically created drop-down boxes that list all possible Client Codes and Client Divisions associated with this name. After choosing that, I figure it's a simple autolookup to populate the address fields.
Does anyone have any insight on how I can get this done? Another piece of functionality that I'm trying to work into this is that if the name doesn't exist or if there's a new Client Code and Client Division or a new address, the data gets automatically added to the respective tables.
Does anything of what I wrote make any sense?
Any help would be greatly appreciated.
thanks
Imants
View 1 Replies
View Related
Nov 17, 2006
I am creating an Access program for logging in Parcels that are delivered and I am having some problems.
I have a Table called 'Contacts' and within this there are 4 Columns: 'Names', 'Departments', 'Extensions' and 'Emails'.
I also have a Form and there is 1 Combobox and 3 Textboxes relating to this Table: 'Addressed To', 'Department', 'Ext Number' & 'Email'. (see http://c0ld.homeip.net/parcel_log.jpg for details).
What I would like to do is select the Name from the Combobox (Addressed To) and the have the other Textboxes (Department, Ext Number & Email) get auto-filled with the corresponding data that’s within the Table for that Name.
If anyone would like the .mdb for this, please PM me.
Thanks for your help in advance.
Ross Hurrell
View 7 Replies
View Related
Apr 13, 2008
I created a form in Access that retrieves data from a table. Inside the form, I am able to access/populate data fields with data from the table. I also have data fields, inside the form, that requires key-in data. I have some how lost the ability send all data field information to a second table and clear existing data fields for new entry.
Questions: What settings, code or buttons can I use to send/store data field information to a new table? What settings, code or buttons can I use to automatically clear all data fields from my form once data has been sent to the new table?
View 7 Replies
View Related
Jan 29, 2014
I have a totalquery that runs fine and give me the sum for both fields I'm looking for but I can't get the outputs to fill the fields on the form. I have tried the Dcount query in the control source but that just returns an error and locks up access.
Code:
SELECT [Tble-wcDelays].Causedby, Sum([Tble-wcDelays].HoursDelay) AS SumOfHoursDelay
FROM [Tble-wcDelays]
GROUP BY [Tble-wcDelays].Causedby, [Tble-wcDelays].LinkingID
HAVING ((([Tble-wcDelays].LinkingID)=[Forms]![Frm-ePlusCent]![cleanID]));
That is the query.
View 14 Replies
View Related
Jun 20, 2006
Hey Everyone,
I am stuck trying to figure out this problem. I have a main form "frm_tirelog_600" which has 4 combo boxes "cboleg",
"cbocar", "cbopos", "cboserial" on it. The first 3 combo boxes are used as criteria on 1 of 3 subforms that I have.
The fourth combo box "cboserial" is used for the criteria in a query on another subform that I have called "frm_mount_600_subform",
which is independant from the main form, I hope I have explained that clearly enough. What I need to be able to do is
have the subform fill in 3 of the fields on it "leg", "car", "pos" with the value from the 3 combo boxes on my main form. I
can get it to show in the fields but not write to the table. I have searched the forum and have not been able to locate anything
that would work and really need any assistance with this. Im not real strong in the coding department which is where I
beleive this could be done.
I have attached a copy of my DB which I hope will better explain it. Any help would be greatly appreciated
View 8 Replies
View Related
Jun 13, 2006
I am very new at Microsoft Access. I have two forms, A and B, that are filled out by two different users. Form A gets filled out first than form B gets filled out. Each has a name box as well as a birthdate box and a few other similar text fields. However, each form also has a few distinctive fields. I was wondering how I could input the common information in Form A to Form B so the user of Form B does not have to spend time retyping the name and birthdates again. In other words, I want to synchronize the similar records between the two forms. I would like the values to appear in a table as well. I would greatly appreciate it if someone could help me with the visual basic code. Thank You.
View 1 Replies
View Related
Sep 30, 2013
I would like to create a command button on my form that copies values from 5 fields in the current record into a new record leaving all the other fields blank except for the new record ID.
The fields that contain the data that I want copied into a new form are:
1. Member_Name
2. Member_ID
3. Account
4. UBH/PBH
5. Assigned_WRCA
View 8 Replies
View Related
Apr 27, 2005
I currently have two forms: frmE_SAFind and frmE_SAOrder
frmE_SAFind shows results from a query including fields [txtIDPO] and [dtmDate]
Example:
IDPO Date
btnOpnFrm 6543 2/1/05
btnOpnFrm 5681 1/1/05
frmE_SAOrder shows order details including [txtIDPO] and [dtmDate]
I have a open form command button set up on [frmE_SAFind] that opens [frmE_SAOrder]. Is it possible for me to modify its properties so that when the open form command button is clicked, the order details in [frmE_SAOrder] will represent the order that the user is selecting via the btnOpnFrm command?
Example: If I click btnOpnFrm for 6543, [frmE_SAOrder] will show me PO 6543 details.
Hopefully I made myself clear enough to understand. Thanks for your help!
View 1 Replies
View Related
Sep 23, 2005
Hi there,
Can someone help me on this issue?
I want to copy Postal Address Information to Visit Address Information wthin the same record, in my Contact Database that I am building at the moment.
I want to copy 4 fields to 4 other fields within the same Record.
This the current code I use for the Copy-button:
---
Private Sub cmdCopyFields_Click()
Dim v1 As Variant
Dim v2 As Variant
Dim v3 As Variant
Dim v4 As Variant
v1 = Me!Field_a.Value
v2 = Me!Field_b.Value
v3 = Me!Field_c.Value
v4 = Me!Field_d.Value
RunCommand acCmdRecordsGoToNew
Me!Field_e = v1
Me!Field_f = v2
Me!Field_g = v3
Me!Field_h = v4
End Sub
---
The underlined part (acCmdRecordsGoToNew) is false part of this code, because it copies the Adress Info to a new record, instead of copying it in the same.
-Is there someone that can help me with this problem, to make the copy-button in the Form run properly?
-Are there other options to achieve te same?
I have put in a attachment, to give you guys a visual example of what I mean.
Thanks in advance,
Quinten
View 3 Replies
View Related
Feb 26, 2014
I have the form (PROJECT DETAILS) that displays a specific record's information, one record at a time.I would like to click a button to export 5 specific fields (name, phone, address) of that form ("Project Details"), based on the PK "AssignNr", and then insert those fields in an already created Excel form that has those fields blank, but other fields filled in.
And then, as part of the same macro, I want to have the Print pop-up come up in the Excel form to select where/how that file will get printed.I've tried exporting from the Project Details form, but it exports all the records. And then I am not sure how / where to code the vlookup formula (if that's even necessary) to take the data from the exported file, into the existing Excel form that needs to be filled in.
Can this even be done in one macro, or do I need to create two - one to export data from Access to Excel. And then another in Excel to vlookup the details from the exported file, into the existing Excel file.
It would be nice if I didn't have to put in what the vlookup criteria is. (i.e. AssignNr (which is the PK)) - if it could just be taken from the PROJECT DETAILS form's current record selection.
View 4 Replies
View Related
Apr 11, 2005
I have one main form with 3 tabulated sub forms.
My main form consists of two fields.
When the user clicks tab 2 (subform 2) or tab 3 (subform 3) the main fields should hide
I tried to achieve this by using the on click event at the tabbed forms. I referenced the two main fields and used the visible property followed by a form requery. It didn't work.
thanks in advance
View 1 Replies
View Related
Nov 13, 2004
I'm trying to sum up the hours of a sub-form on the main form. I've followed the instructions in Access Help so far. I've created a text box in the footer of the sub form with the following control source:
=Sum([Mon])
which should sum up all the hours in HoursMon fileds.
Then I've created a text box on the main form with the following code in the Control Source
=[frmTshtProj Subform]!SumMon
But it doesn't work. I get a #Name? appear in the box instead of a total. Any ideas?
Thanks in advance
S
View 6 Replies
View Related
Feb 2, 2006
Hi
I'm quite a biginner at this and I'm making a support form based on a query because I made a search function.
Now I would like to add some fields in the same form, but these are made in a nother table. How do I get these fields in the field list?
//Mikael
View 3 Replies
View Related
Feb 4, 2006
Hi,
I have a combo box which has the follwoing options:
Column 1 Column 2
1 Wedding
2 Funeral
Now you can select via the combo box and the field will be populated with that choice.
Now I have a additional field that needs to display the following.
If the combo field shows Wedding, then the addiditional field needs to show £200.00
If the combo field shows Funeral, then the addiditional field needs to show £100.00
:)
View 6 Replies
View Related
Apr 29, 2008
Hi All,
I am really new to all of this and used to use excel for this stuff.... yes I know... I can hear the screems already .......... :):eek::rolleyes:
What I am trying to do is lock some fields in a form when they are entered so the data can not be changed after they move onto the next record. I think this might be done in the table but can not be sure.
Can anyone point me in the right direction? or some pointers please. Any help would be good.
Many thanks
View 3 Replies
View Related
Feb 18, 2007
Hi,
I have a form that has a field called scope of work which is a combo box that you have 3 options to select from.
I have set up a table called scope of work which has other fields
ie: Scope of work, Est Man Hours, Normal Rate, Overtime Rate and Est Due Date.
The combo box works fine selecting the scope of work but I want the fields on the form to automatically fill in the other information. Say they select option 1 in the scope of work based on this option it will fill in 40hrs at $150 per hour normal rate and $180 per hour overtime rate and this will take 4 weeks to complete. Based on the start date field it will also calculate 4 weeks from now for the completion date.
I have tried everything from queries using SQL statements, joining tables one to many etc.. and for some reason I cannot seem to get it to work for me and I've spent hours searching around for a solution..
If anyone has any ideas it would be greatly greatly greatly appreciated!!
Thanks a Bunch
View 1 Replies
View Related
Mar 14, 2005
Hi everyone :D
A friend just came to me with an Access related questions that has me curious. I think that I have seen what he is trying to do before but couldn't puzzle it out myself.
Here's the basics, he has two items on his form, the first is a drop down box and the second is a text box. The table that these two items are connected with has 3 fields (auto number, ARS, and description).
What he wants to do is link the two items on his form so that when an item is selected from the drop down box (from the ARS field) it will auto-fill the text box with the information from the description field of the same record.
Hopefully I explained this clearly. Can anyone out there be kind enough to provide direction on how to do this?
Any help would be appreciated!!!!!
View 1 Replies
View Related
Apr 25, 2005
i have a field called case number and i have several forms that relate to this number, what im trying to do is bring the case number from my clients form to the other forms with a command button that opens the other forms so the user does not have to enter it in, also after they have entered all the data they need, to the case number needs to be written to the tables of the other forms. i hope this is clear enough thanx in advance
Justin
View 4 Replies
View Related
May 10, 2005
Hey guys..
the fields in my form don't update for some odd reason. i tried making another form and it works fine there. But i want these fields to be enabled on the current form because it will be the main menu and i want it to be there already.
the record source is fine, all the properties are fine... but it does not update..
there is a combo box which updates perfectly..
any idea ??
View 3 Replies
View Related
Jun 20, 2005
Hi, I ve just registered and need your help.
I need to have a form that has three data fields equal to the table's names and a combo box.
But those fields have to execute a query in "realtime" which means i fill in my parameter and is executed like in query design mode by pressing a button.
Also the combo has the followinf function:
I choose something (a vlaue) and it is taken as a parameter too.
All of these , of course will output the results (of the query) not in a form, but in a report.
Could some give me a clue, (example perhaps ) :o to that?
View 2 Replies
View Related
Jul 15, 2005
I want a quick-n-dirty method of filling char or numeric fields on a form with leading zeros. Can I do that without VBA?
View 3 Replies
View Related
Sep 9, 2005
The answer is probably in here, but I can't find it... so I have two questions.
1) On a form, I have a field with Company Legal Name and Company Trade Name, most cases the company trade name is the same as the legal name. So what I would like to do, is add a button next to the Company Trade Name field so when clicked it would automatically copy the text data from legal name to trade name.
2) Same scenario as above but with mailing and shipping address if it is the same.
View 2 Replies
View Related