Search results for query: *

Hi there, I'm having a few problems with the activechart object in Excel. I'm extracting a set of data from a database and importing it into Excel. - I can get the chart object itself working - but when I increase the dimensions of the data (i.e. 15 rows and 15 columns) - the chart doesn't...

Hi adscrims, I had this problem a few months back when working with Word 97. I cant remember specifics (i.e. error numbers or anything like that but by the looks of things i worked around this by simply delaying CPU operation for a few seconds. As i understood it the problem was the file being...

From memory-as ive finished this project-but intend to use it in other projects-i had around 10 forms in the project dealing with a number of things. The error handler showed a different form allowing the user to send a bug report or resume program operation. When you switch forms as far as i...

festivista97: No problems-i've had plenty of help from people in this forum so im happy to give something back. The variables errnum, errdescript etc are declared globally on each sub the following would happen: sub dosomerandomthing() on error goto errhandler: 'invoke an error s=3/0 'this...

Ive just re-read your reply - i didnt mean that you cant run vb exes over a network - i actually mean the VB6 application itself-it cant be shared over a network. Sorry for the bad explanation.. Paul

Thanks for your reply. The compiled version is being run on a local drive (the c drive of my machine) - which is also networked- but all the required files are held on the c drive - the relevant ocx's etc. The files size is roughly 350kb - a smallish application which isnt going to be doing any...

Hello all, im wondering what could possibly be the reasons for my VB6 enterprise version project not working on a network!! The code was developed and compiled on a stand-alone pc. The compiled version was then taken and placed locally onto the hard drive of a networked machine(im assuming...

Thanks for your replies.. I mulled over this all last nite then went back in this morning and worked it out in 3 lines. Dim acc as new access.application acc.opencurrentdatabase "C:\program files\agswe\system files\workexp.mdb", false acc.docmd.transfertext acimportdelim, Import...

Hello all, This is a seemingly complex problem.. Basically i want to import a csv file from Excel and import it into an existing table - called dbemployer. Ive researched a few ways but they havent worked.... Any help would be greatly appreciated! Thanks in advance Paul

Hello all Previously ive had a search that isnt a string comparison. As an enhancement id like it to be. My code(which as usual- is pretty messy) frmemployer.dbemployer.Recordset.MoveFirst frmemployer.dbemployer.Recordset.FindFirst "employer_name='" & txtsearchemp &...

Hello all, i know this is strictly a MS Access forum problem but ive had some good ideas from a lot of the people in this forum so i thought id give it a go: Basically my app uses MS Access 97 with VB as a front end.. i want to put the ms access db onto a server (public drive) and it will open...

Hello all, Just a quick question on programs that construct Variable tables. I've been out of the programming world for the past few years-since VB3/4.. I specifically remember a program that would allow you to create a variable table (and converted it into word)(vb2doc????) is there anything...

Can anyone suggest a way to validate a date entered into an access database??? i.e. if someone enters a string or incorrectly formatted date- it reconverts it to the proper format (i.e. dd/mm/yyyy) Also could someone advise me as to the SQL statement required for a partial match search - i.e...

Thanx very much for your reply to my question. It was most helpful..! As you might have guessed im a beginner at SQL and was wondering how one might construct an SQL statement that matches partial data from a database. Say the user types in "tek" and the database entry is...

Hello all, the following is some code that ive wrote to catch a search for certain elements that exist in a database. The thing is that it contains too many IF...THEN...ELSE statements! Which isnt conducive to good code.. Can anyone suggest a way around this... Perhaps a case statement??? If...

Hello all, Having a slight problem when saving a record in one of my Access 97 databases. Basically what happens when my record is updated is that the database jumps to the first record in the file. I assume that this is because of the database being re-organised to include the new record. Can...

Hello all, Having a slight problem when saving a record in one of my Access 97 databases. Basically what happens when my record is updated is that the database jumps to the first record in the file. I assume that this is because of the database being re-organised to include the new record. Can...

this is what im using to call the code... systemsearch "employer_name", txtsearchemp, Listemp ive now revised the module code to this: Public Sub systemsearch(sysfield As String, syssearchdata As String, syssearchlist As ListBox) recsfound = 0...

Hello all, having a problem with some of my code- i have a module which is called from a separate search form - call it frmsearch.. the database its searching is on another form- call it frmemployer... below is the how the procedure is called: systemsearch frmemployer.dbemployer...

im not sure that i understand what either of you mean by passing the recordset... Any other suggestions??? Thanks in advance... Paul...