Recent content by jaycast

Can you ellaborate on what you mean by "multiple popup windows"? Ideally, I'd like for there to be multiple popup windows--one for each report generated. However, that doesn't get me past the hurdle of having my filter page locked up while the first report is processing. I'd like the first...

The application I am developing requires a "filter" aspx page that will open a new "report" aspx page in a new browser window based on the filter criteria. The target report can take anywhere from 2-5 minutes to completely render, due to the massive datastore being accessed. Ideally, the user...

I have a situation in developing with a 3rd-party reporting app that limits my SP result set access to one result set per SP. The SP I'm trying to access returns multiple result sets, so I was thinking of writing a passthrough SP to the base SP to pull the specific result set that I need based...

Never mind. I was able to figure it out. Turns out the first row is considered a column header if column headers are turned on. Silly me!

The subject line pretty much says it all, but here's a little background: I have a multi-user database that currently employs temp tables for various functions. Naturally, numerous conflicts have arisen when two people try to create/access the same temp table at the same time. I'm re-creating...

I'm trying to populate a datagrid column with the paypal buy now button HTML that I am storing in my database. My goal is to have a table with merchandise information and a column that holds all HTML for the individual buy now buttons. Granted, this might not be the best way to do this, but...

I am just getting into the logic behind CSS and javascript (I'm coming from a VB background), and I'm trying to figure out why I can't get my JS-run dropdown menu to align its child items directly to the left of their parent items. The child items of the main list items align from the center of...

I recently developed an application that will print a barcode label using a third-party program depending on the UPC Code scanned into the program. The logic behind this is sound, however I'm running into an issue where if the spooler window for the label printing software is open (not...

Lol...ok, that all makes sense. What about Make Table action queries? If the query objects are resident in the front-end and they are called, wouldn't they proceed to make a new table object in the front-end rather than the back end? I think that's my biggest concern.

*winces* Yeesh, I was hoping I could avoid that. The logic makes sense and is sound, however since the database app has already been created and has been in production for years, splitting it doesn't seem to be easily accomplished. Is there any other way? Say it ain't so!

We have an application in Access 2000 that locks ALL objects within it if at least one other user has it open. That makes it really difficult to develop new objects or make changes to existing objects that aren't currently being used. I've done searches for this type of problem, but all I get...

Yes, the old server is running Win2K server (I said PDC because I'm still stuck in WinNT Network Mentality).

Ok, I was able to accomplish most of this 1-12 list, however, running the DCPROMO on the old server to remove it from being a DC failed. I got an error stating that a suitable replacement DC was unable to be found on my domain. The new DC Server is there and visible on the domain, so why...

Ok, adding to my own msg, I did a little more research. Apparently, Access will truncate memo fields to 255 chars when GROUP BY or SELECT DISTINCT is applied to a query. Now, my problem becomes: How do I get around this little issue so I can make my records unique. I'd like to avoid moving...

This seems to be a bizarre problem, but hopefully its not unique. This is an application connecting to Access DB. I have the following code that works well, but brings me more records than I need: OleDbConnection1.Open() OleDbDataAdapter1.SelectCommand.CommandText = "SELECT * FROM...