Search results

Unfortunately, the Replace method doesn't work for what I'm using. The structure I have is basically a numbering system for the outline of a report. For example, 1.1.1.1 = Corrective Maintenance.System Level.Identify Error.[First task at this level]. So, wind up with some weird numberings like...

The way Bob mentioned work. Then I just placed a transparent box over the information I didn't want. Perhaps not the cleanest way, but it worked. I'm curious, though, how would I enter the Alias expression? Would that be a new column in the source query?

That's clever. I'll give it a shot. I just wonder if I can then keep those fields out of my report.

I need to break my report up into groups. I have no problem doing this, except that Access wants to add its own sort method to the group. This report draws from a query that has a rather complex set of expressions that sort the field the way I need it. I am just trying to figure out a way to let...

Thanks. Bob, I couldn't get it to work because the code apparently had issues with some expressions I had set up in the query that populated the form. (My key has a numeric structure like an IP address, and the expression was used so I could sort the records by key in ascending order). However...

missinglinq, The issue is that I need specific records based off the filter in the form, though. I don't have any issues exporting information from the form to Excel, but it exports all the information despite the filter.

John, I get a message saying the object couldn't be found. The object from the strSQL statement, i.e. strSQL = "SELECT * From [KSA_by_Media Query] WHERE ([ID]=" & Me![ID] & ");"

I have a form that allows me to filter data for the user. I would like to be able to export that filtered data to Excel. I found a solution on here by vbaInet, but I don't think I'm writing the code correctly. Here is what I have: strSQL = "SELECT * From [KSA_by_Media Query] WHERE ([ID]=" &...

Does it have to be Excel? Can you export it to Word? I think based off of Excel being a spreadsheet, that what you're asking may be exceptionally difficult, if not impossible, to do.

It wasn't working the way I originally did it. If the value was by itself in a field, then the records would return. However, if anything else was in the same field, it wouldn't return anything. I found a solution using Like "*" & "ATC" & "*" . That's what I was originally trying, but I was...

I will post the code first to put things in perspective: Private Sub Combo14_AfterUpdate() Select Case Me!Combo14.Value Case “ATC” DoCmd.ApplyFilter, “Synchronous = ‘ATC’” Case “ICW” DoCmd.ApplyFilter, “Asynchronous = ‘ICW’” Case “OT” DoCmd.ApplyFilter, “Synchronous = ‘OT’” Case “PA”...