Search results for query: *

This is good stuff, and I will hang on to it. But, I need to see how output parms are handled, not a record set. Thanks. wfw

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

Thanks for your response. I'm really not sure what the .MDW file that the division developers were signed-on with looks like. My fear is that they did not open the .MDB with the correct .MDW. They may have been using the default (SYSTEM.MDW), completed their application changes, then created...

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

Your 2 cents is very helpful. Thanks for your quick response. I like code that I can actually get my hands on. Programming with recordsets provides code that can be used over and over. I have done this many times with Access Dbs, but this time I am attempting my first shot at connecting to...

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 don't need password recovery software, I already have access to one of those. I need something to run through an Access database and simply remove all of the permissions. It would be nice if it would return it to a db with default security. Thanks for the suggestion. I'll keep looking. wfw

I have tried the wizard, I get "no permission to import/export". It does state that in order to de-secure, that you must be a user in the "Admins" group within the workgroup information file that the db is secured with. This is very frustrating. Back to the drawing board...

I tried it, the back end converted just fine. The front end hit me with "no permission to convert this database", immediately. When you look at the permissions, all of the object owners are coming up "unknown". The user "Admin" has no rights, which goes against...

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