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

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

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

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

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

Hello all, OK-I should probably start off by explaining the situation- basically i have several forms. - One search form, and an employer form are the ones that im concerned with at the minute- Previously i had code that searched a the database - ive lost it now!! it wasnt working properly...

Hello all, having a few probs with a feature id like to incorporate - i have a seperate search form in my project-from another form - call it an employer form... when the user searches for an employer- say Microsoft - the details come up in the list box.. i can work with that ok- and all i have...

Hello all, the following is my code for searching through a database.. I realise that this is a bit of an over-kill for searching through databases - but its the way i learned way back in vb3-and old habits die hard!!! Anyway-the problem is that it doesnt seem to be looping around again if a...

Having some problems with my code- can anyone suggest whats going wrong with it?? the error handler calls this sub and passes some global variables - errnum, errdescript & errsource Whats happening is that when an error does occur i get a run time error 55 - file already open -can anyone...

Hello all, Im having a few problems with how i should carry out a procedure.. i have a search form.. something similiar to the one found in Windows 9x/NT the thing is this search form is searching for records in a database.. held on a seperate form.... the results from the search are displayed...

I know this isn;t strictly the place for DB questions - but im having problems with DAO- When i go to add or update my database i get the action was cancelled by an associated object.. can any1 tell me what kind of thing does this??

Hello everone, I want to take data from some forms within my project - and place it into certain cells in excel.. i.e. each time i want the data to go beneath the existing data.. Heres what ive got so far.. 'open the app dim xcel as new excel.application 'make it viz xcel.visible = true...

Hello, can any1 help-im having trouble with the tab control. VB6.. I want to be able to click on a tab - when the tab is clicked i then want the program to go to another form.. Cant find any way to do this.. can anyone help...?? Thanks in advance.. Paul

Hello all, Another problem: When i go to produce a document thru VB6 i can produce it fine and dandy.. However-when i go to quit the application-it throws up 1 or two errors.. The first - Word is still printing or something to that effect.. Which prob means it takes its time to get to the...