Bounding Fields In A Form

Jun 22, 2006

Hello,

I am having trouble bounding form fields that I have created to show data.

In summary:

I created a Form with a bound table that will enable me to scroll thru records. When a record comes up I want to be able to use a combo box to bring up the applicable correponding information based on the record and combo box option chosen. Upon choosing which option I would like from the combo box I would like the default data to come up in the empty fields that correspond to the option I chose in the drop down box. I would also like to input data on empty fields and save the whole record.

Is this feasible?

Thx

PE

View Replies


ADVERTISEMENT

Bounding Fields In A Form?

Jun 23, 2006

Hello,

I am having trouble bounding form fields that I have created to show data.

In summary:

I created a Form with a bound table that will enable me to scroll thru records. When a record comes up I want to be able to use a combo box to bring up the applicable correponding information based on the record and combo box option chosen. Upon choosing which option I would like from the combo box I would like the default data to come up in the empty fields that correspond to the option I chose in the drop down box. I would also like to input data on empty fields and save the whole record.

Is this feasible?

Thx

PE

View 2 Replies View Related

Bounding An Unbound

Jul 28, 2006

newbie question
Is there anyway to bound an unbound text box to a print command button ?

View 14 Replies View Related

Bounding A Filed

Oct 16, 2006

i have a form "send mails" which is unbound
it have a combobox field "to" ,i want it to bound to a field "names" in the table "email"

View 3 Replies View Related

Bounding A Subform To A Combo Box

Dec 4, 2005

hi

im trying to create a form that has something of the following structure

the main parent form has customer details which is straight forward

the main form also has a combo box which contains the name of a supplier

the first subform has supplier details so that when i click on the above combo and select a supplier their details come up in here.

now i also have a second subform on the main form which tells me the orders that this customer will make this shows me all the orders the customer made relevent to the above suppliers products

i know the above sounds like a strange implementation - i dont know if its been done already but i was hoping someone could point me the right direction for a correct implementation to do this.

many thanks

View 1 Replies View Related

Creating New Table From Form Data Fields/clreaing Datat Fields.

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

Forms :: Adding Fields In A Table And Having Output Fill Fields On A Form

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

Updating SubForm Fields From Main Form Fields

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

New At Access: Update Simlar Text Fields In One Form Based On Another Form

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

Forms :: Button To Copy Values From 5 Fields In Current Form To New Form

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

Open Form Command Button Fills In Text And Date Fields From Previous Form

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

Copy Button In A Form To Copy Fields To Other Fields In The Same Record

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

Modules & VBA :: Export Specific Fields In Form To Excel Form

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

Hide Fields In Main Form By Clicking Sub Form

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

Problem With Total Of Sub-form Fields On Main Form

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

More Fields In Form

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

Form Fields

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

Locking Fields In A Form

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

Autofill Fields In Form

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

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 6 Replies View Related

Linked Form Fields

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

Using Fields From A Table On A Form

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

Form Fields Do Not Update

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

Query Through Form Fields ?

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

Zero Fill Form Fields

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

Need Help With Copying Form Fields

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







Copyrights 2005-15 www.BigResource.com, All rights reserved