Search results

Solved the problem thanks to this page: http://access.mvps.org/access/forms/frm0031.htm I needed to reference my main form in the code. Here is the code that ended up working for me: Private Sub SavedRec() Forms!fMain!fLastSavedRecord.Requery End Sub

I have a form that users use to input data into a table. I then have another form that shows the last saved/entered record. My intent is that after the data entry form is closed, VBA will trigger to refresh the last saved record form (named fLastSavedRecord). My VBA is: Private Sub...

Thank you for the reply, I will give that a shot!

wjs2031, you brilliant person. I've been fighting this issue for two days trying to pass some reasonably simple query results to Excel via MS Query but have been getting this too few parameters error over and over. Turns out the " vs ' was the issue. I went and replaced all "s with 's and now...

I have a form with two cascading list boxes. When the selection in the final list box is made, the user presses a button that opens a report using a macro on the button. I'm trying to create an If statement in the macro that says, if no selection is made in the final list box, display a message...

I have a report with a subreport that does nothing but show images (attachments in my query). Everything works great returning the images except they are shown vertically instead of horizontally like I would prefer. I have tried the Page Setup -> Columns route, but it's as if it doesn't apply...

Action: OutputTo Arguments: Form, Form_Name, Excel Workbook (*.xlsx), , Yes, , 0, Print

I think there is possibly an easier way. Instead of a toggle button, I could use a check box and within the criteria of each query I would put a formula that was something like: Nz([Forms]![fMain Menu]![chkbxReports_CustomerA],-1)=(Not Like '*' & 'CustomerA' & '*') This seems to work, kind of...

For anyone who has the same issue, the problem was much easier than I thought. I simply created a macro with an OutputTo Action and it works exactly as I wanted. Hope it helps any noobs like me.

I have a form with about 10 subforms on it, all of which have queries as source objects. All of these queries are based off the same table which contains a field for Customer. What I would like to do is have a toggle button on this form that, once pressed, essentially adds a "not like"...

Thank you for the response! I will certainly take that and see where I can get with it.

I have a form that I'd like to allow users to export to .xlsx via a button on the form. However I'd like to make it so that once the button is pressed, they are prompted to select a folder location before the export takes place. I thought I would find a lot more 'how to' on this specific...