Search results

Yes, but the Subform still doesn't refresh. If I click the macro button and then go to the Home/Refresh All button at the top of the screen, then the Subform gets refreshed with the proper data. The query seems to work fine, but I can't get the data updated in the subform. I have the record...

I have a sub-form that has a query as its source. The user enters a value into an unbound text box on the parent form, and the query is run using the user-supplied value to filter the data. I have a button on the parent that launches the macro OnClick, but the sub-form is not updating after...

Thanks, I've gotten the Lebans link from other forum members but my IT protocols at work are preventing me from downloading and playing with it. Rich-text will be acceptable for most people; all the users who are most likely to swap reports by e-mail will have Access 2007 or later. Thanks!

Thanks. I don't think my question was phrased correctly, but your information is good. I found some code in the Microsoft library about version & build, and this is what popped out of a message box statement: "You are currently running Microsoft Access, version 14.0, build 7104." From your...

Greetings, I developed a database in Access 2010 with a feature to export a report via e-mail where the report is converted to a PDF. I've since learned that a large number of users where the database will be in service have Access 2003 on their machines, which doesn't appear to support the...

Thanks, it's good to know that. i thought it just might not be supported but wanted to make sure it wasn't a missing object library or some such thing. My company's security policy is blocking me from downloading the zip file, but I do appreciate the quick reply.

I built a database for a client using Access 2010; the client is using Access 2003 to run the database. One of the macro buttons that I built into all the reports is supposed to create a new e-mail message with the report attached in PDF format. Here is the language that I used...

Greetings, I have a database that I'm about to deliver to a client. There are many modules built into the forms to validate input, add functionality, etc. In order to get the modules to run, I had to attach several object libraries that aren't automatically loaded in the default database. My...

Problem solved; when the macro button is clicked, it launches a macro with an If-Then-Else construct. The If-Then portion verifies that it's a valid search value, if so, then the Else portion re-queries the form.

Thanks, that was actually my first strategy, but I'm pulling data from multiple tables and that was proving to be more trouble than it was worth. I have also had exchanges with Super Moderators on this form that said a filter was inefficient with large data sets, since the entire data set had...

Solved the first item by researching the FAQ over at AllenBrowne.com If both of these conditions are met, then the form will be blank: a) There are no records to display b) The form settings do not allow you to make additions There is a simple workaround on his site that involves setting the...

I have a form with a macro button on it; the form is bound to a query. The intent is that the User supplies a piece of data in the field next to the macro button, and then when the User clicks the button, a macro launches that validates the data. If the value is valid, then the macro is...

New day, new challenges. I added the necessary tables to the query and got all the necessary fields included in the query. I changed the form's record source from the table to the query. The form is visible in Design view but when I move to Form view, the entire form disappears (grey screen...

Thanks to everyone for the suggestions. I'm going to build a new query and bind the table to that. I think it's the cleanest route. Thanks again to all.

Greetings, I have a form with a table as the datasource. The source table is large enough to make searching for individual records unwieldy, so I have the User enter a specific value and then click a macro button. The macro that executes first validates the filter value, then filters the data...

Well, it took a little grunt work but the correct value is now being pulled into the form. Thanks yet again!

Greetings, I have a form that is populated by the User via a combo-box lookup. I'm trying to get an unbound field on the form populated after the combo-box is updated; the goal is that the field will have a value from a table (other than the form source) whose record can be found using the...

Thanks for the feedback. I gave up on the idea of making that work, went back to writing code and did away with the Combo Box. In its place on the form, I added a text box with a Command button located directly beside it. The User enters the value in the field then clicks the button. The...

I have a form that is bound to Table1 and I am using the value from a Combo box to filter the records. The Combo Box is populated with values from a different table. The SetFilter macro is triggered using the AfterUpdate event. When the macro fires, Access asks for a parameter, so I know it's...

Private Sub ExportExcel_Click() Dim oExcel As Excel.Application Dim oWkBk As Excel.Workbook Dim oWksheet As Excel.Worksheet Dim strFile As String Dim qSource As String Dim dbs As DAO.Database Dim qdf As DAO.QueryDef Dim rst As DAO.Recordset strFile = "Filepath.extension" Set oExcel =...