Search results for query: *

I have a form that contains a subform/Datasheet. This datasheet displays multiple records. There are 5 fields, one called Total. Currently if the user selects 1 record, I can get the data (using msgbox) from the Total field by using the following syntax Msgbox [subfrmOrderDetails]![Total] This...

I have a customer that is using a pre-printed form with 3 duplicates (printed on a dot matrix). He has been using an access application that is very clumsy, and I am trying to fix some problems he is having. Currently, there is a form that allows him to enter data. One of the places on the...

I have created a small Access database system for my customer (an OEM manufacturer) that is to be distributed to multiple distributors. I have 1 Main Database and 2 Backend Databases. 1 Backend DB has pricing and specifications, while the 2nd Backend will contain all distributor created data...

I have a subform that is displayed on a form. I have combo boxes that can be used to change the query criteria, as well as the filter applied to this subform. I would like to display how many records are in the subform. In fact, I would like to make the subform not visible, and just show a...

I have a subform with 10 fields. The User enters multiple records (lets say 5 in this case) into this subform. After entering these records, they can choose to save the records as part of a set. I have one field called [SaveName] in the subreport. If the user enters a valid Save Name (One...

Rick, The combobox has 5 fields in it with only the 1st field visible. When the user selects a combobox value normally (in the datasheet), I pick up the 4 invisible fields (using .column(1), .column(2), etc), manipulate them and place the 'manipulated' values in the remaining 9 fields in the...

Rick, The datasheet is actually a subform on a form. If I put the button in the subform and have Call PartID_AfterUpdate it works ok. I want to have the button on the Form, so I tried Call [subfrmOrderDetails].PartID_AfterUpdate and Call form![subfrmOrderDetails].PartID_AfterUpdate but I...

I have a Form that is showing a Table in Datasheet View that has 10 Fields. The 1st field is a Combo box. When a value is selected from this Combo Box, I default the remaining 9 fields to values related to the Combo Box Value using the "After Update" Event. This seems to work...

I have a calculated field that is being created in a query by extracting the Date and Time from a Text field called DateTimeTextField (Because there is stuff other than text in this field sometimes). I am using IIF statements to filter out the text, but will not include that here, as it will...

I am currently using DoCmd.OutputTo to export a report to XLS, RTF, and HTML. I currently have an image (company logo) on this report. This logo does not get exported when I use this DoCmd.OutputTo. I tried to use an unbound object frame instead of an image, but also had no luck. Any help...

I am currrently trying to attach a report called (rptQuotation) and fill in email address, subject, etc. to Microsoft outlook by using the DoCmd.SendObject. The following is what I am using DoCmd.SendObject acReport, "rptQuotation", acFormatXLS, "email@anywhere.com", , ...

I have been struggling with this 'reset' to default settings problem...until I bumped into your solution. How did you find this, as the checkbox under tools/options/general is not real intuitive. How can I find a list of other fixes available in SR1? Is SR1 the same as SR1a? thanks, Ken