Search results for query: *

Dave, Thanks for the response. I looked at my BIOS settings as you suggested, and Com1-4 are set to disabled. I tried changing COM 1 from disabled to COM1 3F8 IRQ4 and to COM2 2F8 IRQ3. Either of these settings causes the message 'Serial Port 1 Resource Conflict' to be displayed when...

It sounds like TrackRecord is interpreting %f &quot;<Enterprise Code>&quot; as a string instead of a fieldname. For one thing, most development systems don't allow spaces in field names so are you sure <Enterprise Code> is the exact fieldname in TrackRecord>? If so maybe it wants it without the...

Right-Click in the project window, hover over Add to open the Add submenu, then choose CrystalReports8.5 (you can also access this from the project menu). This will bring up a wizard that lets you create a report using the standard Crystal Report Wizard, create a blank report, or load a report...

does the client have access? Ruairi Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production? For innovative, low cost solutions check out my website. www.plccontroltechnologies.com

I have a Windows NT 4.0 server where the mouse stopped working. It is your basic 2 button serial mouse. It used to work fine with the 'Microsoft Serial Mouse Driver'. Then it stopped working. If i choose change on the general tab of the Mouse applet in control panel it shows Microsoft PS/2 Mouse...

jbeale, You don't want to use the %fieldname parameter. I'm assuming that you don't have the code to read the parameter in your VB project. If not, you need to add this code to your VB startup form to read the parameter from the command line. The function 'Command()' returns the command...

Sounds like you have 'Save Data With Report' set to true. This is an option on the File menu. Ruairi Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production? For innovative, low...

Try this: Sub FindDelta() Dim x As Long Dim CellName As String For x = 1 To 21 CellName = &quot;D&quot; & Str(x) If (Range(CellName).Value > 90) Then CellName = &quot;F&quot; & Str(x) Range(CellName).Value = 5 End If Next x End Sub HTH Ruairi Could your manufacturing facility...

I tried the code in the FAQ using the outlook object. This seems to work fine except that outlook pops up with a dialog saying &quot;A program is trying to send an email on your behalf. It could be a virus. Do you want to allow this. &quot; to which a user has to answer yes before sending it. I...

mmilan, Declaring the variable As Form would work just as well as declaring it As Object, either way should function the same behind the scenes. They both just pass the form's window handle (hWnd). My using object rather than form was totally arbitrary. Ruairi Could your manufacturing...

Nagrom is right that you cant pass the name of a form this way, but you can pass a refrence to the form using the Me keyword. These changes should fix it: public sub clearTxtBoxes(FormToClear As Object) with FormToClear .txt1 = &quot;&quot; .txt2 = &quot;&quot...

Use this instead Open ThisWorkbook.Path & &quot;\Update_testfile3&quot; & Format(Now(), &quot;ddmmyySh&quot;) & &quot;.txt&quot; For Output As #1 you will get a filename like Update_testfile32901024911.txt Ruairi Could your manufacturing facility benefit from real time process monitoring...

I have a report that prints from a VB app through the CR8.5 Report Viewer. There are several subreports that are linked to the main report by parameter values. In all there are 36 parameters (4[ParamsPerSubreport] * 8[Subreports]). For some reason one of these parameters is always prompted for...

i don't use the sql querey designer, but i have used the SQLQuereyString property extensively. I normally design the report through the Crystal Reports application and then choose 'Show SQL Querey' from the &quot;Database&quot; menu. Then i copy the querey, paste it into vb, leave most of it...

It is a problem with the runtime files that are being distributed with your app. To put it nicely Crystal Reports dependency files (.dep, the ones that tell the p&d wizard or whatever install program you are using what files are needed) have some problems. To put it more accurately they are crap...

Hey all, How about this, there are fewer women in IT because fewer women have the training and skills. The reason for that is simply that less women take the classes or spend the time to learn the skills on their own. Who knows why, thats just the way it is(i don't have hard statictics to...

njitter, MS has been moving away from DDE for a long time. It is an ancient technology. They continue to support running macros when DDE data arrives, although you won't find it in any current docs. In the workbook AutoOpen macro (i think thats what it's called, anyway it's the one that...

I'm haven't used IFIX, however this is how you would do it in VB. Any platform that supports VBA should be the same. Dim ObjXL As Excel.Application 'create an instance of excel Set ObjXL = CreateObject(&quot;excel.application&quot;) 'open a workbook ObjXL.Workbooks.Open...

Thanks scrabble, that worked. I'm still a little curious why that one gets asked for and not the other parameters, but it works and thats the important thing. Thanks again Ruairi Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to...

Try this format. There may be nothing wrong with putting the name of the other proc's variables and the = in there, but you definitely don't have to. Exec GENERATERECURRINGTASKSTEST @p_CASEIDY, @p_TASKIDY, @p_ASSIGNEDTOIDY, @p_PRIORITY, @p_DATEDUE,@p_TASKACTION, @p_USERNAME, v_recurperiod...