Search results for query: *

Hiya guys and girls, Does anyone know of the correct way to assist in the following: I have a master workbook which needs to import data from various other workbooks (all columns the same etc). I have got it browsing to choose the next workbook to import but am struggling on reading the rows...

To make this work (realise its years ago!!) would have to do something like the following: 'call required procedures when buttons clicked cbcEdit.OnAction = "EditLine" cbcAdd.OnAction = "AddLine" cbcRemoveFilter.OnAction = "RemoveFilters" Where "EditLine" etc is a named macro...

Hiya all, Does anyone know how to change the fonts (i.e. Arial, 10 Bold) of the text displayed on each of the "page" tabs?? Cheers Gav

Cheers for all this by the way, I hear what you are saying about the code but the thing is it works for 2-3 days and then stops (thats the problem) - the code has been cut and paste to protect the innocent thats why the names dont match up, was doing this on the fly as i was juggling other...

Me neither been banging my head against a brick wall here but thank you for your comments anyway.

The exact error message is: provider error '80004004' Unspecified error /nameoffolder/_classes/_dependancies/something.asp, line 98 Thats the line that is the .open command.

Sheco, In the global.asa is the following (dont like the look of it lol!! as i said i inherited this!) anything there that looks bad to you?? <script language="vbscript" runat="server"> Sub Application_OnStart Application("Visitors")=0 End Sub Sub Session_OnStart Application.Lock...

No it just returns the same error. Once we reboot he machine it works fine (until about 2-3 days later that is!).

No sorry for the confusion CloseDB() is actually directly called from call DataDB() (was trying to change the names!). Other people have suggested server permissions for the folder where the database lives (any thoughts) but that would not explain why it stops every 2-3 days would it? If that...

Yes unfortunately it does with the following: Private Sub CloseDB() On Error Resume Next rsDB.Close Set rsDB = Nothing Set rsDBTemp = Nothing Set cmdALL = Nothing conDB.Close Set conDB = Nothing Err.Clear On Error GoTo 0 End Sub Checked how many users were in the actual database and...

Hiya all, I have inherited this problem from someone else. We have asp pages that call an access database. Every 2 -3 days we have to close the web server down (asp and access db on same server - i know!). I am assumming that the problem lies with connections not being closed to the server...

The organisation name is a string of anything between 1 and say 60 something along the line of &quot;Argyle County Council&quot;. We have to compare new data coming in with existing data and if it exists link the new data with the old data, if it does not exist fine it just gets inserted into...

Hiya all, Having a touch of trouble. Inporting data from excel (not important) into a temp table before committing the data to the &quot;real&quot; table we want to be able to do a comparison on the &quot;Organisation Name&quot;, to see if the details already exist. The best we have come up...

Hiya all hope you had a good weekend. I have a form on which i have a list of attachments. in the following format: File name : xxxxxxx File Path : xxxxxxx I want to be able to put a browse button next to the File path txtbox and the results of the browse to be displayed in...

Hiya all, I am trying to pass an opening argument from one form to another. for example i am passing ID 4 to another form. The problem is that the second form is a access created form showing all fields in a particular table (using access recordselection buttons on bottom left of screen)...

Cheers Mate. Gav

Hiya all, Does anyone know how to set pagesizes for an abnormal size the size of the paper is 80x190 (thats in millimiteres) i know it will something like this but could anyone help? ActiveDocument.PageSetup.PaperSize = 80, 190 ActiveDocument.PageSetup.Orientation = wdOrientPortrait...

Thanks bill!! Gav

Hiya all (again!!) I have a main table with an ordered date and a actual delivery date. Im trying to query the database for all the equipment that has been ordered and not yet been delivered oras been 7 days from ordering and not been deliverd. Does anyone know the SQl for this kind of...

I had a bad feeling that was going to be the response :-( cheers all anyway