Search results

Got it. Thanks again!

Yes, this particular query returns data for a single record. I think this will do just fine . Thank you so much for your time!

Thanks! I'll start looking at this now and let you know if I punch it across the goal line.

I've attached the template; the blue-fill cells are the ones where I'd like to place the data from the query-based report. Thanks for your help.

The template is more custom than that. I suppose one option would be to import the data in table form into another spreadsheet in that workbook and then just echo it back into the end-product worksheet.

No, at the user's request I am pushing data from the database into an existing Excel template. These values will constitute the baseline or as-is condition of an asset. The user will have the option to tweak values in the spreadsheet to do a cost-benefit analysis (i.e., amount of money needed...

I have a report in my database that has a Select query as its record source. I would like to create a button on the report that launches an existing Excel worksheet On_Click. The worksheet will be a Cost/Benefit analysis, and I'm choosing to do this in Excel in order to to give the user the...

Yes, it does work for me. Text47 is a control on a form that I'm using, so it works when I assign a value to it. Otherwise, you would get an error message since you would be assigning a value to an undeclared variable. I set this up with an event handler so that when the User clicks in...

Private Sub Text74_Click() Dim fd As FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) Dim vrtSelectedItem As Variant With fd .AllowMultiSelect = False .Title = "Browse to Select a File" If .Show = -1 Then For Each...

When I run this module, the File Dialog box opens and I can browse to a file. When I click OK to close the dialog box, nothing happens. I would like to capture the file path and enter it into the current field. Any thoughts on what I'm missing? many thanks. Private Sub Text74_Click()...

I'll post code when I get it working. Thanks to pr2-eugin, I've gotten the reference bug worked out but now I have to get back into it.

Thanks so much for the prompt reply! I had to do a double-take since there are Microsoft Object library and Microsoft Access Object library in the same list of references, but I've got it now. Do you know off the top of your head if the Object Library 14.0 will create problems with someone...

I have a Access 2010 database where I want one of the fields on a form to launch the File Dialog box when the user clicks in the field. This field will contain a file path to one specific file. The File Dialog box will not open the file but rather it should only capture the path. Currently I...

Figured it out. I realized that I should have been looking at an update query to accomplish this. I built a SQL statement using a string and added the combo box value to it. Now when the combo box is updated, the StrID field in all the records is automatically updated. Thanks for your...

Thanks for the feedback! I went back and read my initial post and I may not have communicated my goal as thoroughly as I should have. I want the value selected in the combo box to be inserted in the [StrID] field of every record in the subform. I think your suggestion would pull in the value...

I am using the following statement to pass the value from a ComboBox (Combo38) on the main form to a field on a subform (BridgeMaintItems). The statement below only seems to modify the StrID field in the first record on the subform. For my append query to work correctly, I need to update the...

Thanks, Bob. I'll give that a try.

Thanks, this query was already being launched from a form, so maybe the answer is already close-by. Thanks for the suggestion!

I have several parameter queries in my DB. What is the most straightforward way to force the user's parameter value to be a member of a particular field in the database? I'd like to alert the user that they have asked for a report on an asset that isn't in the DB, then give them the...

Having a similar problem with one of my forms, found this link that seems to explain the problem. I haven't had time to implement the suggestion but everyone who has reports success. http://forums.techguy.org/business-applications/795546-solved-return-without-gosub.html