Answer Questions
JavaBoy how to open read only file that will be open for notification in word?
Hi i am tring to write a vb script that use word to do the following: 1 .open document from pc A. 2. open the same document ( use a "share" folder ) from pc B. the file will be read only but open for notification to the time that the file will be release for editing. 3. close file from pc A. 4. view file changes in pc B. any ideas on how to implement it thanks in advanced lior ...Show All
chrisarcher1 Help with Excel VBA Code
I am trying to format different spreadsheets. I need the data to be in the same cells for each worksheet. This data is in column A. I need to check to see if DBCS# ( ) is above Tour, and if so insert rows until Tour is in row 175, column A. The problem is that the number after DBCS# is never the same. How can I use an IF statement to make sure that the cell above Tour says DBCS# (whatever the number is) This is the If statement that I tried. If I put DBCS#46 in my IF statement, it will not work because the number after # isn't always 46. If (Range("A174:A174") = "DBCS#") And (Range("A175:A175") = "TOUR") Then GoTo label_177: Else: Do While (Range("A174:A174") <> "DBCS#") And (Range("A175:A175") <> "TOUR") Select ...Show All
PabloTola automatical start macro in access2003
I develop system from MS Access Ver.2003 when user open this file MS Access 2003 will show msg security warring . I want to code for using automatical start macro in access2003 help me please. Thank hi, best way is to use a splash screen (form) for the database that is set as the startup form. In the form you can place any code you like and if you have a switchboard then make sure your splash screen loads your switchboard before it closes. The security warning will remain and requires you to reduce your security permissions for your macros or you need to sign your project. Hello, If you name any macro "autoexec" it will execute on start up. Is this what you are looking ...Show All
syhzaidi MS Office document and image writer print driver
Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. Hi to all! At me a problem with installation Microsoft Office Document Image Writer under Windows 64-edition SP1 with Office 2003 Pro full instalation. On a step 3 at me in the list is not present Document image printer writer port. Somebody faced a similar problem ...Show All
Samoyed Indeterminate behavior from DoCmd.TransferSpreadsheet in Access 2003?
Hello, I am sending the output from 2 different queries to spreadsheets via DoCmd.TransferSpreadsheet. When I set up one query, it quite nicely overlaid the data in the spreadshet on the Tab with the same name as the query. This was good. When I set up the other query, it insists on creating a new tab every single time! This is Bad. Why oh why will one query work the right way and the other work the wrong way (Kinda Urgent). Creates new worksheet every time (BAD) DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryEligibleAppsForAGivenSchool", pathString + txtSSName.Value Uses previously created Tab (GOOD) DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Eligible ...Show All
Fluxtah Validation list macro
Hi I need help... In my drop-down validation list when I select let's say "Apple", I want a message box to come out, only for "Apple", let's say" Attention: You selected apple. We remind you that this item..." If I select, let’s say "Onion" nothing should be came out. Could someone help me with this, I think by running a private macro Hi, You can put some code in the Change event of the sheet that has the data validation on it. This assume the cell is B1. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("B1")) Is Nothing Then If Target.Value = "Apple&qu ...Show All
progames25 DLookup help?
Hi there - im building a contact management system and require some help. I have previously had help with VBA in terms of defining what users can and cant do within the system when logging in via a username and password which was incredibly useful. Im now at further along the route and now want to incorporate an activity system that will record all hours that employees will have worked against clients. However we have a lot of clients! The users login name('login_name' which is held in 'tblusers') is also entered into a 'leadofficer' field in 'tblcompany' so that we know which user is responsible for managing that client - this is done through a combo box on the company entry form so it looks up the values from the table 'tblusers'. On th ...Show All
David Kreps Open PDF file
Hi everybody, I'm creating a program in MS. Access but I just want to ask:, how to open *.pdf(extension) file in visual basic access (vba) thanks in advance. :-) By double clicking the desire path in the data sheet view, the *.pdf file name would be open. For example: Path = \\ipc154\contract\filename.pdf when you double click that path in the datasheet view it will open. Do you have code for that application sweet Hi sweet66 - sorry but ive been away for a while - yes that was exactly what my code did but it also allowed you to browse for the file and insert the path into datasheet view - a guy called Derek Smyth who is one of the fou ...Show All
SBorch Take out the ability to input values on combo box?
How do I take out the ability to input values on a combo box For instaance, if I want the user to select the month Thanks, that helped a great deal. Now, how do i make it default to the first item I had the listbox down right but i had it before i listed all my items. What do you mean Great, thank you very much for your help. I had the listbox down right but i had it before i listed all my items. in other words, before i put anything in it, i was referencing something that wasn't there yet. Hi You can set the property "style" to fmStyleDropDownList You can set the ListIndex property to 0 in VBA code Combox1.ListIndex = 0 ...Show All
pc_bond Automation Error During Execution of Stored Procedure Using ADO
When the execute statement below runs an automation error occurs. I have tried it with both stSQL strings defined below. Dim cnt As ADODB.Connection Dim rst As ADODB.Recordset Set cnt = New ADODB.Connection stSQL = "Proc1" ' stSQL = "exec Proc1" With cnt .CursorLocation = adUseClient .Open stADO Set rst = .Execute(stSQL, , adCmdStoredProc) End With Any ideas kedst1 Try asking this in the data.oledb newsgroup: news://msnews.microsoft.com/microsoft.public.data.oledb <BLOCKED::news://msnews.microsoft.com/microsoft.public.data.oledb> -- Cindy I'll take a look in the other forum. Thanks. kedst1 H ...Show All
Ken Young Excel Macro to Capture Live Webcam Image?
I am attempting to write a macro which will access my USB connected camera, grab a picture, and paste it into an active cell. I am able to do this manually by simply locating the cursor at a cell location, selecting "Insert - Picture - From Scanner or Camera", Selecting the Twain resource for my camera, Selecting Custom Insert, Selecting Take Picture... and viola, the active view from the webcam is placed into a cell I don't expect a macro to do all of this, however, I would like to create a simple keystroke macro that will just bring up the Twain dialog box which has the "Take Picture" button displayed. I have been toying around with the VB objects in the WIA library, but have not yet been able to successf ...Show All
Giugio AutoExec will not execute properly
Hello there I have an .dot file in the Word 2003 start-folder. When opening word, the file is read. The autoexec-macro should make a new entry with a number of commands and subcommands in the standard menubar. On about 300 PC's this works fine. On a few ones only part of the commands appear. All PC's run W2000 and Office 2003. Any idea regards Jurgen Ok, i've been working through the code to see what it actually was required to do. You mentioned that the entries menu_protection_set, menu_protection_clear and menu_archive are the only ones that appear within the custom Menubar. Well, those entries are the only ones (next to the "Formulare und Dokumente") who don't to have a IF .. ...Show All
xplosiv_1 opc
I am trying to develop an opc - da client using .net technology. Have gone through the documents on opc and opc client and all, but am still not sure how to implement it, can someone give me a direction on how to start with it Hi Eric, Sounds like you know what you're talking about ... Can I also butter you up and find out if you know anything about using an OPC interface in VB.NET that was designed for VB6. The problem is the RSiOPCAuto.dll that Rockwell use to interface to their OPC server (RSlinx). It only accepts Arrays with lower bounds of 1 which is not possible in VB.NET. (see refs below) 1) http://www.control.com/1026218609/index_html 2) http://www.control.com/1026222355/index_html I ...Show All
Aamir Iqbal Copy text from textbox to clipboard?
How to copy just the text from a textbox to the clipboard in VBA (MSO 2000 - Excel). I can copy the entire textbox but I only want the text (not the box). My brain has gone to sleep and I can't do it :( can in VB but do not want to reference VB components. Cheers. NM I have the same emergency. Could you post the code snippet you used please. I can't find any reference to " PutInClipboard" Emergency over.. created the text as a dataobject and used PutInClipboard. Not enough caffeine yet this morning!! Graham, reference to PutInClipboard is here: http://msdn.microsoft.com/archive/default.asp url=/archive/en-us/office97/html/output/F1/D ...Show All
Andre&#39;s InsertDatabase is returning error "Word was unable to open the data source"
The code I'm trying to use is below. It is taken from MS help for InsertDatabase Method. But seems I must have missed something. In the code, "wd" is "Word.Application", the SourceFilePath has the path and name of an Excel spreedsheet (.xls). I also have a comma delimited text file in the same folder as this Excel spreadsheet. The only difference in their names is the .xls and .txt. The text file works, except that a dialog box opens asking what the delimiter is between fields. But the Excel file just gives the error, "Word was unable to open the data source". HELP!!!! Please. With wd.Selection.Range .Collapse Direction:=wdCollapseEnd .InsertDatabase _ LinkToSource:=False, DataSource:=SourceFile ...Show All