Search results for query: *

Hi I'm using a combo box to display a list a staff, which the user selects. The combo has a row source set to a SQL query statement with 2 columns. The formatting is set to display the 2 columns when selecting a staff member. The second column is a Yes/No field in the source table. It...

Hi I need to print on demand 7 external PDF documents. I've already successfully implemented the legacy methods of using the shell command and passing the /t print command line, as shown here: thread707-860631 I now have Adobe Acrobat & Reader 8.0 where this method no longer works. There is a...

Hi I'm very new to coding in CSS, and I did a very basic dreamweaver / x/HTML/CSS intro course a few weeks ago. (I'm using Dreamweaver Mx 2004). Under advice from the teacher, my Html has is divided up into Divs. I've got divs for page, header, content and footer. Within content I've got divs...

Hi My Access Database creates a Word Document using automation. I'm using the Find.Execute method with ReplaceWith to insert a string where I have a place marker. Set objRange = mWordDocument.Content objRange.Find.Execute FindText:="DateCcbPayableLong", Replacewith:=strDateCcbPayableLong...

Hi Dudes Does anyone have any experience using the Word Find Object and Execute method with the ReplaceWith parameter? objRange.Find.Execute FindText:="List", Replacewith:=strList, Replace:=wdReplaceOne I get an error when strList is around 280 characters long, but not around 220 characters. I...

Hi In short: does anyone know if the Word Find Object has a limit on the size (number of characters) that can be used in the ReplaceWith parameter? It seems to fail around 280, and probably has an undocumented 255 character limit. In Detail: I've got Office 2003. My Access Db VBA code uses...

Hi My access database tests a version number in the backend against the number in the front end and if their is an update, I want to launch an access database installer and close the main database. The code I have found in text books and on microsoft websites is not working. An runtime error...

Hi My explanation is first, and Question is at the end. My relational db design experience says the way to design lookups is to have a table for each category of lookup. It gets a bit clumbsy with several small lookup tables each only containing 5 or so values. I have seen a few others do it...

Hi I'm getting this error when starting Win XP (SP1). Note "smc.exe" is the free Sygate Personal Firewall. --------------------------- smc.exe - Application Error --------------------------- The instruction at "0x054a2b75" referenced memory at "0x0000000c". The memory could not be "read"...

Hi I'm planning the following as part of a home office network. The following ADSL modem is also a cable and wireless router and has 2 cord inputs for VoIP phones. ZYXEL P-2602HWL ADSL 2+ MODEM/ VoIP/ 802.11G WIRELESS ROUTER + LIFELINE For the VoIP function, I want to use Doro 550S which...

Hi I have the 3 month trial version of SQL Server 2000. I just want to learn the product and at this stage I am not planning to use the product in a commercial environment or as a Developer for some time. If I install the product now, when it expires can I re-install it on the same machine...

Hi InStrRev gets the second space " " not first in A2k VBA6. Here is part of my code strStreet = "16 Hely St" 'Value actually from a database 'Value has been trimmed so has no leading or trailing white space. I've tried these variations: lngPosn = InStrRev(strStreet, " ") lngPosn =...

Hi I'm running the following line of code from the main form in a combo box on the after update event. I am trying to change the caption value of a label on a sub form, that is also on a tab control. The Object Structure is: Main-form > Sub-Form > Tab-Control > Label The code is...

Hi Can I delete a lock file when no-one is using it? Do I need a windows administrator to do this? Context I have a master copy of my front end on the network and I give users a batch file which will make a copy from the network to their hard drive. At some stage in my absence, the master has...

Hi I'm not clear about when exactly a variable will have the value "Empty" I have read that it means the variable is "Uninitialised", but when does this occur, and when does this state/value change. Is it when you have declared a variable but have not set a value? Also, is it possible for an...

Hi I'm running W2k with Sygate Personal Firewall over a dialup connection. I've been reviewing my firewall settings and noticed after Norton Antivirus did a Live Update, mstask.exe was sending considerable traffic out onto the net. I blocked the traffic and investigated. mstask.exe is the...

Hi Is there a maximum number of controls that can be placed on an Access 2K form? If so, I assume a subform counts as one control, and the controls on the subform don't count towards the total for the main form. Thanks for your help. Paul Zollo9999 A+ / VBA Developer [thumbsup]

Hi In Access, I've used the SysCmd object to create a Progress meter in the status line. Is it possible to do the same thing in Excel? The code below is not recognized in XL. 'varReturn = syscmd(acsyscmdinitmeter, "Progress", intRowEnd - intRowStart) In my XL code, I added a...

Hi In Access, I've used the SysCmd object to create a Progress meter in the status line. Is it possible to do the same thing in Excel? The code below is not recognized in XL. 'varReturn = syscmd(acsyscmdinitmeter, "Progress", intRowEnd - intRowStart) In my XL code, I added a...

Hi This follows on from a previous post and shows my ignorance of XL-VBA objects. thread707-690573 What is out of range in the code below ??? Debug shows the string strWkShtDatafile has the correct string value for the sheetname ie "Svcs-Master". and the strX has the value...