Search results

Use the wizard to add an OpenForm button...select the one that says something about opening the form to a specific record.

I haven't done this myself, but it seems you need to: -Export it to a temp directory in excel format (transferspreadsheet?) -Attach it to the email (.attachments.add) -Delete it from temp directory

Sure, but remember it was your idea. As usual, I have numerous projects underway for work. If you need the code commented in the spreadsheet, let me know.

That's what I was saying back here... ...and you are not using a native Access 'Filter'...you are filtering by way of altering the select statement. Providing all the fields are the same from your form record source to your report record source, you can just apply the form's record source to...

Did you try it? Did it work? Tell us what it did if it didn't work...not just "It didn't work."

Check the attachment. It is by no means finished...just a start. You must place it in a folder that has some MP3's in it. Once opened, go to the user form in the Visual Basic Editor and hit F5 to run it. To see what's going on in the code, right click on the button and select 'view code'...

OK, here's what you need to do... - Open the report. - Filter the report. How do we do that? Open Report... DoCmd.OpenReport "MyReportName", acPreview Filter the report... (This assumes that the filtered form field exists in the report, by the same name.) If Me.FilterOn Then With...

I got something started for you...gotta go right now...be back later and post more.

It should work if you are applying a native Access filter to your form. Looking back at my suggestion, though, you should check the forms 'FilterOn' property before applying the filter, as when you remove a filter, it just sets the FilterOn to false.

You basically need to export it as HTML in a temp location, and then use that to create your email body. Check out this post.

I love making simple games in XL. This "Name That Tune" game sounds do-able. One question...How will the player answer? Will they type in the answer? Will they shout out the answer & the game operator will decide whether they are right? User typing in the answer could be problematic...

I am really hooked on Virgin Radio. There are about 4 choices, including the Classic Rock Player. For something a little lighter, I'd say BBC Radio 2.

You can make a tiny form that displays 'modal' in front of the report. Get as fancy as you want, but this is the basic kind of code you need... Private Sub Command10_Click() With Reports!report2 .OrderBy = "pname" .OrderByOn = True End With End Sub

I can't even count how many times and different ways this issue has been addressed on this forum. Did you try a search? Here's a good one.

If you're talking about a listbox, then you have to change the row source in the button click event... Private Sub SortByFirstNameButton_Click() Me.List1.RowSource = "Select PersID, Fname, Lname From MyTable Order By Fname" End Sub Private Sub SortByLastNameButton_Click() Me.List1.RowSource =...

Here is what the command button wizard writes for 'preview report', notice the part I added in red... Private Sub Command4_Click() On Error GoTo Err_Command4_Click Dim stDocName As String stDocName = "Report2" DoCmd.OpenReport stDocName, acPreview, , Me.Filter Exit_Command4_Click...

I'm pretty sure that the control events don't trigger when the would-be event is caused programmatically. Just add a .dropdown after your .setfocus.

I would use an array variable. You could do: Dim DOW(6) Then you can load it up... For i = 0 to 6 DOW(i) = ~whatever next i Now you can refer to DOW(n) to get the particular value you need.

I think the supervisor is just another employee. When you build a query, you can always put another copy of the employees table on the grid and link the supvID to the empID in the 2nd copy. If in doubt, look up "SELF JOIN"...it is the answer to the employee/supervisor dilemma.

Maybe... if Left(me.[combobox1], 1) = "b" then