Search results for query: *

I have a stored procedure that I would like to run within an Excel macro. The usp_ has input and output parms. I currently have multiple examples of running usp_ to bring back record sets to .Net apps and Excel. I am struggling with the code needed to establish parms going in, then using the...

I have a web page that includes a datagrid. A button at the top of the page allows you to add a new record. When pressed a new record is added to the database(SQL Server), then the page is re-displayed showing the previously existing records and a new one. All entries in the datagrid are...

Our plant uses a QA tracking application that was created and distributed by our division headquarters. The database is written in Access 97. The Db is split with a .MDB as the back-end and a .MDE as the front end. The Db has Users and Groups with all the permissions tied to the groups. The...

I have a critical application here at work that was created using Access 97. This is a shared system which is why we are unable, at this time, to convert to Access 2000 or SQL Server with an Access front-end. At times we are asked to export raw data into Excel. Unfortunately, our tables...

I am trying to create a form that includes a drop down for record selection. I have added an ADO Data Control to my form because I like what I have read about these vs. other dsn connections. I was able to hide the ADO Data Control and use it to populate a DataCombo control, but when I try to...

I am attempting to create a report that will print out on a special form. I need the data to print at the very top of the page. I have gone into "Tools", then "Options", then "General" and set all the defaults to zero. When I go into page setup, I can still only...

I have an Access 97 database(actually 2, cause it has been split) that I need to convert to 2000 and clean up some bugs. I have tried to create a new empty 2000 db and import into/export from old, in attempt to get all of the objects. I keep running into permission problems. The old db only...

I am working with an Access 97 database that has a security piece on top of it utilizing a workgroup. Some how the file has been corrupted and no one can access the data. I have tried to create a blank database and import the objects from the troubled database and I get stopped because of...

I have just finished creating a visual basic form that allows the user to enter a lot number and number of labels to print. This process then looks for an entry in an Access table and generates the label(s). On the input screen, there are 5 fields: lot prefix(2 numeric), lot number(3 numeric)...

Is there any way to add values to a Combo Box Value List from the open form, not adding values in RowSource in design mode. I know this can be done if the values for your combo box are coming from a table. I am just curious, can the NotInList property be used to add to a list not a table...

I am writing a VB 6.0 application to generate bar coded labels. The data that I need is located in files on an AS/400. I have a M/S Access 97 database that has the files I need in it, the tables were built by linking via ODBC to the AS/400 files. The user enters search criteria that is...

Can anyone tell me what creates ".pdl" files. These are showing up in an individuals Temp folder. Thanks in advance for your assistance.

I have an Access 97 table that stores elapsed time for a number of dial settings, these records are written to the database once a shift. These values are stored in hh:mm:ss format. I need to add these together for a date range. I know how to isolate just the records that I need. I need help...

We are in the process of converting all of our MS Access 97 Db's to 2000. I have a VB executable that uses an Access Db for security verification. The Db converted to 2000 just fine. When I tried to run the VB app, I got a run-time error '3343': Unrecognized database format. I am not able to...

Can you create a column in a query that will return the greatest value of a group of other columns. For example, you have a record in a table for each machine number and four readings, a total of five fields. For machine #1 you want to know the highest reading. So, the sixth column in your...