i have field 1 field2 field3 and field4.
I would liek to sum all 4 fields. but some of the fields are not populated therefor my sum field does not sum that record.
Sum:[field1]+[field2]+[field3]+[field4] 'this does not work
Any idea why a combobox would not populate? :confused:
When the form is opened, it is opened with DOCMD.OPENFORM with selection
criteria to send only those records for a particular dog (dogregnbr).
The query for the rowsource of the combobox works when run from the
query design window.
combobox: cboTrialDt (trial date)
combobox control source: trialclassID (from tblDogTitles)
form record source: tblDogTitles
The query for the combobox rowsource is:
SELECT tblDogTitles.dogtitleID, tblTrials.trialdt
FROM tblTrials INNER JOIN (tblDogTitles INNER JOIN tblTrialClass ON
tblDogTitles.trialclassID = tblTrialClass.trialclassID) ON
tblTrials.trialID = tblTrialClass.trialID;
tblDogTitles has the following fields:
dogtitleID - PK
dogregnbr - FK (key to record in tblDogs)
titleID - FK (key to record in tblTitles)
trialclassID - FK (key to record in tblTrialClass
and then some other fields not involved in this problem.
I have another combobox setup similarly that does get populated
properly. It's control source is titleID.
It's rowsource is:
SELECT tblDogTitles.dogtitleID, tblTitles.title
FROM tblTitles INNER JOIN tblDogTitles ON tblTitles.titleID =
tblDogTitles.titleID;
After explaining why this is happening, do you have a suggestion for how I can get the trial date (trialdt) from tblTrials to display for the current dogtitle record (tblDogTitles)?
Thanks.
Regards,
SueB
Hey All, I have a main form PID and and Building form I need to have the data from the building table display on the building form, upon adding a new record. Since my PID form and building form are linked to show the same records. PID Form contains- PIN NUM, ADDRESS, PARID. The Building form contains, PIN NUM, DATE, PHONE, OWNER, SIZE, LOCATION... I open my main form filter my results for my reocrds to show up... PIN-20053227, ADDRESS-MAINSTREET, PARID-NEWFIE22. This data is obtained through the PARID table. Now I click on the command button to see my building forms, there are 6 records, here I have the ability to add, modify, delete, save... What i want to do is add a new record, but have some generic fields appear from my table. since my name, PIN, address hasnt changed. So I would like to click add, and have appear from the building table, OWNER, PHONE etc... How might I be able to do this?? Thanks- NOTE: Hey all I double posted this incase you didnt notice this in the FORMS, Form.
View 4 Replies View RelatedI have a table called tbl_workorders. One of the fields on this table is optional but because the lookup table is on the one side of a 1-to-many relationship using an auto-number key it is requiring that this field be populated to create a record on the workorder table. This is a problem because the field is optional.
tbl_workorders
WorkOrrderID(PK)
Field1
Field2
Field3
Field4
JobSubtypeID (FK-many) <---- Lookup field
tbl_Subtypes
JobSubtypeID (PK-one)
SubtypeDesc
Should I set the SubtypeDesc field to a default value of "none"? I know this is storing unnecessary data, but is there another option?
Hey All, I have a main form PID and and Building form I need to have the data from the building table display on the building form, upon adding a new record. Since my PID form and building form are linked to show the same records. PID Form contains- PIN NUM, ADDRESS, PARID. The Building form contains, PIN NUM, DATE, PHONE, OWNER, SIZE, LOCATION... I open my main form filter my results for my reocrds to show up... PIN-20053227, ADDRESS-MAINSTREET, PARID-NEWFIE22. This data is obtained through the PARID table. Now I click on the command button to see my building forms, there are 6 records, here I have the ability to add, modify, delete, save... What i want to do is add a new record, but have some generic fields appear from my table. since my name, PIN, address hasnt changed. So I would like to click add, and have appear from the building table, OWNER, PHONE etc... How might I be able to do this?? Thanks
View 3 Replies View RelatedAfternoon all,
This is one I haven't come across before.
I have a table with a list of contact details/company details etc. I would like to send an email to each customer in this list in one fell swoop essentially asking the same question but tailored for that customer (or as easily as possible).
Any help would be really appreciated.
Thanks.
I have a form where the user selects a client from a combo box.
Doing so populates 4 controls with info about the client, using the Exit function of the cbo box. The Record Source of the form in question does not store this info; it comes from a different table.
This works fine.
When the record has been saved and I come back to it, however, those four controls do not display the client's information, since the combo box hasn't been exited.
What's the best way to get the form to repopulate those controls without having to reselect the combo entry?
Thanks a lot for the help!
If I have a Report, with three fields (all data-type Text) named 'Jan', 'Feb' and 'Mar', and I want to have a fourth field (Unbound) alongside them, providing a count of the number of fields out of these three fields that are populated.
View 2 Replies View RelatedI have quite a simple problem I think, but i don't know if I'm able to explain it properly.
I have three tables:
one for contacts
one for the groups contacts are a member of
and a junction table to solve the many to many relationship there.
What I want, is to create a form, with a combo box with a drop down list of groups. When a user selects a group, I'd like all the contacts (including *some* of their fields) to populate the list box below.
So a user can easily view the members of each group.
Does that make sense?
** 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??
I have a very simple single-table database with 23 fields. Some of the records have only two or three fields populated. I would like to be able to print a summary of only the populated fields in each record.
It would Ideally look something like:
Record 1 Name
Field 1 Title: Field 1 content - Field 2 Title: Field 2 Content - Field 5 Title: Field 5 content
Field 10 Title: Field 10 Content - Field 11 Title: Field 11 content - Field 12 Title: Field 12 Content
Field 21 Title: Field 21 content - Field 22 Title: Field 22 Content
Record 2 Name
Field 1 Title: Field 1 content - Field 2 Title: Field 2 Content - Field 5 Title: Field 5 content
Field 10 Title: Field 10 Content
Record 3 Name
Field 11 Title: Field 11 content - Field 12 Title: Field 12 Content - Field 21 Title: Field 21 content
Field 22 Title: Field 22 Content
I have a number of tables in my database, and they're linked in with a form. I'd like to have a field in a form that's populated automatically based on what's inputted in a different field.For example, I've got one table with names and descriptions on widgets (name in column A, description in column B).
Widget 1 This widget is blue
Widget 2 This widget is green
Widget 3 This widget is yellow
When I'm in my form, I want when I select Widget 1 to have the corresponding text (This widget is blue) appear in a field below.
i would like to sum up 5 fields and save (or just show it in the form view is enough really) in a seperate field, i have managed to sum the 5 fields, but it summed up all 5 fields in all records, i'd like to have my form show the sum for the record, not the table.
it would be ideal that it would refresh when one of the 5 fields data changes, i.e from 1000 to 2000. again updating in the form view is what is needed.
SQL related with Spec combo box:
Code:
SELECT S.Key, S.Spec FROM tblSpecs AS S ORDER BY S.Spec;
NotInList code:
Code:
Private Sub cboSpecs_NotInList(NewData As String, _
Response As Integer) ' MODIFY SPEC ENTRY.
10 Dim db As Database
[Code]....
1) For some reason, txtMessage is not displayed on the form when NotInList is processed. I see it get populated properly in debug mode, but it never gets on the form. But txtMessage gets displayed normally in Add and Delete events.
It seems to do with the way NotInList works because txtMessage is displayed if I use acDataErrContinue. But that's not what I want; it leaves the combobox list open and can't save record if I close the form.
2) DLookup is used to extract the old Spec value to display in the message. I can see the old Spec in debug mode in cboSpec.column, but Listindex is -1 and unusable.
I don't know how to point to the proper record in the list. The only other way I can think of is to loop through the list comparing the Key, and then extract the Spec.
I don't know if it's more efficient to use lookup or loop.
I have a form for 2800 different records. I want to auto populate 4 text boxes based on the value of 1 combo box but when I change the data on 1 form, all the forms show the same data. I want to be able to able to change the data on each form and save separately.I have Table with Tech Initials(PK), Full Name(689), CellNum(691), TestGaugeSN(630) and Cal Exp Date(632). Want to use Tech Initials to populate the rest.
Here's what I'm using:
Private Sub Combo687_AfterUpdate()
Me.Text689 = Me.Combo687.Column(1)
Me.Text691 = Me.Combo687.Column(2)
Me.Text630 = Me.Combo687.Column(3)
Me.Text635 = Me.Combo687.Column(4)
End Sub
I have a table with multiple fields and each record in the table may not have data for all fields. I need to write a query that will pull only the fields that are populated for each record from the table.
View 1 Replies View RelatedHi could someone point me in the right direction for this one,
I have a series of linked tabbed Forms. One of the Forms is mostly populated by Combo boxes which all work fine. My problem occurs when you go to add a new record and populate the form with the combo boxes but decide for some reason not to save the record but exit the form using the Close form command button or by using the close button at the top of the Form. Access seems to Save the record anyway. I have placed an Undo Cmd on the form to clear all text boxes which works fine but it does not stop a user from closing or exiting a Form by another means and stop them saving that incomplete record.
I would be grateful for any thoughts on how to solve this problem.
Thanks in advance
I tried putting the following code in the form unload procedure, but although it does generate the correct message, it doesnt stop the form from closing.
Private Sub Form_Unload(Cancel As Integer)
If [Starttime] > 0 And [Admin_time] = 0 Then
response = MsgBox("Please click on the stop button to stop the clock")
Exit Sub
End If
end sub
If the above condition holds, I want the user to click on the stop button before they close down the form. I'm guessing that the form is already commited to closing before the unload event? :o
Hi all,
I decided to create a switchboard using tools---> DB utilts---> SW manager.
i have managed to get this on the front end, altho the first button the contacts does't work properly. when i click it using that i cannot see any of the data that is in the database? but if i go out the switchboard without pressing anything on it. and goto contacts form the data is there?
Wired? or is it something simple i have missed?
Thanks
Shrew
www.dsltech.co.uk/310506.zip
I am trying to use a combo box to control which table a data entry form will write data to. I want to create a form that has a combo box to select from a top level table that I will call "Stores". Once a "Store" is selected from the drop down, the next field on the form will be a data entry field. The data entered in that field will be written to the table selected by the preceding combo box.
So, basically I would have say Wal-Mart, Macy's, Sears, K-Mart and etc, listed in my "Stores" table. Once I select one of the stores from the drop down, I would then enter a "department" name in the data entry field and based on which store I selected from the previous combo box, the data would be written to that stores department table (which each store will have its own department table), e.g., WalMartDepts, MacyDepts, SearsDepts, etc...
I have a form for data entry that have multiple comboboxes. I am trying to get one combobox to base its "list" on an entry from a previous combobox. The first combobox is based on a QuantityType table and has four options.
The next combobox is based on a ProductDesign table and will have close to fifty options. I want to limit the ProductDesign combobox based on the QuantityType selection which will give the QuantityTypeID. This will refer to the QuantityTypeID linked to the ProductDesign table.I have created a query that looks like this:
SELECT Product_Design.Product
FROM Product_Design, Quantity_Type
WHERE Product_Design.QuantityTypeID = Quantity_Type.QuantityTypeID
AND Quantity_Type.QuantityType = [Forms]![Product]![Qty_Type];
This Query works and if I simply run the query I get the needed information from it.What I would like to do with this query is to populate the ProductDesign combobox with this data.I have tried putting the query in the RowSource field but I get an empty combobox without the data. The strange this is that the combobox must be getting something from the query because the length of the combo box varies based on my QuantityType selection. I.E. if I select "Single" in the QuantityType, the ProductDesign dropdown shows three empty places for data whereas if I select "Multiple" in the QuantityType I see that there is ten empty places for data.getting the combo box to actually show each option?
trying to identify if 2 fields within a table have been populated i.e.
Check date field and restaurant field, if these fields have been populated do
this
errStr = errStr & tmpDate & ", "
Else
validStr = validStr & tmpDate & ", "
[Code]...
I have an order form that auto-populates details from the customer table into adderss and contact controls. But I don't want it to auto-populate when the underlying order table already has data in the related fields. Here is the code I use on Load form event...
======
Private Sub Form_Load()
'Use this version if the ID is a number
Dim x As Variant
Dim strControl As String
Dim lngID As Long
'If parameters exist, use them
If Len(Me.OpenArgs) > 0 Then
[Code] ....
How does one store the value derived from a combo box to another text box in a form?E.g. Supplier name is a combo box. The combo box has 2 columns, supplier and supplier ID.the supplier name stores the supplier in its own text box.When you select the supplier, the supplierID appears in another text box.I need to store this supplier ID.The control source is =[suppliername].[column](1) When I look up the table, the supplier is captured in the supplier name but the supplierID is not captured in the supplier ID field.
View 14 Replies View RelatedI have a main form (in a single form view) that show a record from a table. I am going to add a sub form (probably a continuous form view) which can show a list of fields (probably a name) from all records from a child table that match condition PrimaryKey = ForeignKey.
What is the best way to make the list of the fields sort of clickable so that I can click on any of them and e.g. open a form with information about a child record? Should I look for hyperlinks in reports, a list box, a continuous sub form with records?
I found the IDatomation Datamatrix barcode in the ActiveX controls.
Is buying their software the only way to actually get this barcode to work?
Any other way to create a 2D matrix that can be populated with data and scanned once printed?