Recent content by S3066

The field is already a string with leading zeros. Thanks

Hello, I'm linking a subreport to a main report, using a character field (employee number) in the main container report to link to an employee number prompt in the subreport. The problem is, for employee numbers with a leading zero, the subreport at runtime generates an empty result set. All...

That's on ... Still having the issue. Very strange. The only difference I can think of is maybe the other database where I CAN see the shortcuts was saved in Access 2007 (not converted to ACC2007 but some other object change was made while in Access 2007). Frustrating

Hello - I have custom groups of shortcuts I had created in Access 2003. In Access 2007, I cannot see those custom groups. What's weird is, I can see the custom groups in one database but not another. I cannot figure out why. Any ideas?

I saw a similar thread, but my code below is a bit different. Any ideas appreciated. It copies a Word doc into an Outlook email. The code below errors out at the .Active Inspector line. Further below I paste a version that DOES work; however, it comes up with the Outlook security message...

Has anyone found a way in Access 2007 or beyond to SORT by "Description" in the Navigation Pane? That ability was present in Access 2003.

It turns out what fixed the issue was taking the union query, making a select out of it, and selecting from the selected union. E.g., SELECT FROM (SELECT FROM ...), where the ( ) is the union.

Hello, I'm running Crystal reports on the web. I'm getting the infamous java.lang.NullPointerException error when running the Crystal report on the web. The Crystal report runs fine on my PC. The text of the error is as follows -- anyone have any ideas? Caused by...

Found a tidbit on the URL below. Basically, shared values reset to zero when drilling down?! A suggested workaround is to place the subreport in the group header, but that won't be practical in my case. If anyone has come up with other creative workarounds, feel free to share. Thanks...

Hello -- when double-clicking on a summary value to open a drill-down detail tab, the latter doesn't show a shared variable value that I'm pulling from a subreport. Do shared variables not appear in the drill-down detail tabs? Thanks!!

All the SQL consists of is {call query.QueryName}, where QueryName is the name of a stored procedure. The other settings are in the ODBC Connect Str. Maybe another way to approach this problem is, if anyone has a way in VBA to RESET or initialize the ODBC connection established in an Access...

Thanks for your response. Here's my situation in somewhat more detail: I'm using the same single ODBC driver in these multiple pass-through queries. What's different is the parameters specified in each pass-through query. In one query, I need to specify the parameter as simply "ODBC;" because...

Hi Group -- does anyone know how to initialize the ODBC connection stored in an Access session? I have a series of pass-through queries, and I need to establish a different ODBC connection for each. Just hard-coding the ODBC Connect Str property in the query's properties doesn't work because...

Will do; thanks for tip.

Hello everyone, I have a Crystal that I want to refresh through VBA. The database connection and datasource is already saved with the Crystal. Any ideas on how to accomplish the refresh? What I'm trying to do through VBA is essentially simulating the user action of clicking the lightning bolt...