Search results for query: *

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...

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...

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...

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...

Ok, first off, I'm not a network or systems specialist...I'm just a programmer trying to muddle his way through this networking mess. With that said, here's the problem I'm having. We recently purchased a new machine to run Win2k Server that should be replacing our old server running active...

I'm trying to populate a data set with data from a SQL statement generated from within the code. However, upon running the Fill() method, the BindingContext of the dataset has a count of 1, while the actual row count of the table involved in the DataSet fill has a count of 2. So, I know my...

I'm running the following function on a set of files within a specifc directory. Private Function RenameFile(ByVal strSoldTo As String, ByVal strDirectory As String, ByVal strBackupDirectory As String, ByVal strSearchString As String, ByVal strTrans As String) Dim objStreamReader As...

This is a problem that recently surfaced. We haven't had any prior problems like this. On newly formated Win XP machines, we are trying to establish ODBC connections to SQL Server Databases. As security at my company is very very lax, we only use one username and password company-wide. After...

I am trying to truncate all but two spaces from a field containing customer names: IE: "JOHN T SMITH" should be "JOHN T SMITH". The number of spaces separating the First Name and Middle Initial is variable. I've thought of ways to do this, but my brain is at a...

Ok, I've searched all over for an answer to fixing this dreaded E_Fail Status error I receive when trying to run a VB report against a SQL 7.0 Data Source. The report ran fine the last time I tried, and nothing has changed in the procedure. Can anyone look my code over and tell me where I...

Can someone take a look at this code piece and tell me why my report isn't running. I'm using the same report in other places with almost exact properties in each place. My eyes are crossing and I have a headache. PLEASE HELP! rst274.Open mysql, sql, adOpenKeyset, adLockOptimistic Set...

Ok, here's my scenario: I have a complex query, referencing a SQL DB, already defined. I will be needing to add criteria to it as time progresses, and one of these criteria derives from a foreign table in an Access database. My question is this: How can I interpolate a recordset variable...

I am trying to add data to an Access table using ADO in VB from a SQL recordset. I am able to get the records to add to specified table, populating the same number of records as is the recordcount of the SQL recordset, however, it simply lists the first record over and over. I'm assuming this...

I'm trying to bind the controls of my data report to the corresponding fields in a recordset that I have created in a coded SQL Statement. I can't seem to get the syntax down right. I have the following: rst2.Open SQLP, SQL, adOpenKeyset, adLockReadOnly Load DataReport2 Set...

I have a table in SQL 7.0 that is maintained by an end user. Based on the values entered into a field in this table, I need to exclude records from a record set. Unfortunately, the user needs to be able to enter wildcards into this field. For example, I'm looking to fulfill something like...

I'm trying to cross the bridge from Access reporting to VB Reporting because Access doesn't seem able to handle the large complicated reports I need to run. I've thus been tinkering with the functionality of VB reports, but haven't been able to figure out how to do a few things. Here's my...