Recent content by misubud

hello, I have one duplication job that keeps returning a 191 error. All other duplication jobs are processing without issue. I suspect that due to resource delays 9i.e. multiple duplication jobs queueing for the same drive) i suspect that another job has already duplicated the image and now the...

Hello, Am writing code to temporarily create a custom command bar on load of an excel worksheet. Command bar is then populated with a command button relating to each of the workbooks sheet tabs. ----------- Set cbar = Application.CommandBars.Add(Name:="WorkSheet Navigator"...

Hello, I am in need of a userguide / support document for am using brightstor r11.1 Can anyone point me in the right direction as to where I can download one. Thanks in Advance.

Hello, have recently been left in the deep end and am drowning slowly.. :) am using brightstor r11.1 jobs are set to auto eject the tape after backup completes. I am not at the host site so unable to reload the tapes. I am needing to run a test restore first thing after backup completes, but...

Thanks guys.. "there is no way around this. read the whole file, line by line, and write each record into a temporary file. " That's what I needed someone to tell me. I was under the false impression that you could insert into an existing file. Some well worded and helpful responses. Thanks

I've tried different things but can't get this to work. I have a text file (call it "file1.txt") "file1.txt" has the following text lines; line ref:aaa line ref:bbb line ref:fff I have a check string in an forms textbox; i.e. ddd I want to be able to open the text file and add the check...

Hello, I'm ok reading from .txt files and writing to new ones... BUT I'm wanting to work my way through an alphabetised text file and insert a line mid way through the file. Is it a simple matter of open file for input as xxx write xxx, "blah blah" when im at the appropriate place? or is...

Hello, I've previously done some programming in VB and VBA, but want to start learning VB.Net. I cannot for the life of me find anywhere to download the visual studio.net package..... could someone point me in the right direction...

I have need to run a vba .sql query. standard querys are ok, but anything like the below example, falls over, I presume due to the fact that the .sql contains a null value i.e a "", and hence the app doesn't know when the.sql string has finished. How do you include quotation marks("") within a...

Thanks Heaps PHV. Did the trick! Must have been tying itself in knots with the "activedocument.saveas". Once again, THANKS!

Am getting unusual error when trying to open and save word documents from excel vba. The following code works fine on the first run. Opens doc, saves as a new file, with values placed in bookmarks. The problem is that even if I delete the saved file, i.e. 1234.doc, I receive the following error...

New Record on button click. I have a number of fields on a form. On a Command Button click I need to be able to add the info from the fields to an existing table as a new record. For example: Take the info from Text1 & Text2 and put it as new record in the table called 'tblTime' under the...

thanks! worked a treat! just have to remember it for next time :P

Hope this will be a quick fix for someone. I am able to shell to explorer.exe, but i need it to open a specific directory. ie on button click, open explorer.exe and open the folder of the current project.(ActiveWorkbook.path) any assistance appreciated.

Thanks a million!