Syquest
Have you tried bypassing the router entirely?
If the laptop connects correctly, there may be a conflict between your router and Safeboot (this is apparently a VPN and encryption utility) or the Active Directory settings added to your laptop (which I assume is a company machine). Ask...
What is the reason you're trying to create such a large array? There are other ways to work with large arrays other than in an array that would be too large for available memory.
For instance, you could implement a sparse array (look at a data structures book) and put the array elements in a...
Random number generators are all too often thrown into a compiler as an afterthought. There are a number of algorithms that work better (and are more random) than the ones that originally came with the compiler. Do a bit of research (start with Knuth's Seminumerical Algorithms, but there are...
Some questions:
Are x, y, and z arrays or scalars? Are xx, yy, and zz deeclared the same way as x, y, and z?
Show the declarations also, as well as the compare code ArkM asked you for.
Pat
With a multiprocessor machine, you should be writing the code in vector notation [like A(B:X,C:Y), for instance]wherever possible. This was certainly true of the Crays (I took a class years ago) and should also be true of more modern architectures.
If your computer has a compiler designed to...
My PC is a 4 year old Toshiba laptop, with a Pentium 4 and a built in sound chip set. The chip set is soldered to the motherboard, and is not replaceable. The stuttering only started about three months ago, probably around the time iTunes was updated to support the iPhone. I assume the "Apple...
I have had a similar problem with stuttering video and audio on my Windows XP Home PC. It turned out to be a service installed by iTunes called "Apple Mobile Device." Disabling this service (which is needed only if you have an iPhone) made the stuttering go away. Note that my PC has a basic...
PHV: this is the right direction. In a VB module, this seems to work best:
DoEvents
Forms![folder form]![Child20].Form.Refresh
'Me![Child20].Form.Requery 'your suggestion,changed to:
Forms![folder form]![Child20].Form.Requery
DoEvents
Pat O'Connell
Just played with Refresh again.
'Print Ops Logs is the form with the subform
'in question:
'!!!Requery doesn't seem to work until the subform is
'clicked on:
Forms("Print Ops Logs 2").Requery
'!!!Refresh does work without clicking on the
'subform, but redraws...
There is no main form record in this case, just the temporary records saved in the table behind the subform. The table is used to create a number of reports for printing, then the subform table is cleared.
Pat O'Connell
Strangely enough, no; I tried a requery and a refresh. The refresh code's still there, but doesn't help. I'm suspecting that some property of the subform or the underlying table is not right. Data goes right into the table, but doesn't appear in the subform until I click on the subform. Very...
I'm maintaining a Access 2003 application that has two forms. Each form uses a combo box (shipment prefix) and a text box (numeric identifier) which are then concatenated to create a shipment ID. An Add button puts the shipment ID into the table behind a subform on the same form. The table is...
There is a data control in VB3; look on your Toolbar. However...
For most work, you'll need to connect to your database using ODBC and DAO. Furthermore, the 16 bit ODBC can't connect to newer databases, so you might need to migrate to VB 5 or 6.
Pat O'Connell
Visualize Whirled Peas
Well, that's a del feature I didn't know about--helpful!
Recursing del is a part of the solution, but the rest of the functionality would help too. Anyone else?
Pat O'Connell
Visualize Whirled Peas
Wayyyy back in the mists of time (early 90s) DOS and Windows 3.x ran in 16 bit space. In those days, there was a program called sweep.exe that would start in the current directory and execute a DOS command (with arguments) on that directory and all of its subdirectory tree, e.g.
sweep del *.bak...
This is how it's done in Access (roughly):
SELECT [Cash_Receipts].ID, [Cash_Receipts].batch as CBatch, [Cash_Receipts].cash_amt as CCash, [Cash_Receipts].check_amt as CCheck,[accounts_receivable].Batch as ABatch,,[accounts_receivable].cash_amt as ACash, ,[accounts_receivable].check_amt as...
When you do an export, there are some hidden gotchas:
1. Export to a 1-2-3 file specifying the .wk4 extension, or Excel (which can create CSV files) won't import the data correctly. Also, long fields will be truncated to whatever 1-2-3 defines as the maximum cell text length.
2. The Structured...
Belated reply--
The reason I can't move the database to Oracle 9 (or 10) is that we don't have licenses for these versions. Also, the database is normally accessed from a construction management program called Maximo, and I would be changing the design at my peril.
Finally, this project was a...
Mufasa, you've got a star for pointing me in the right direction, and your suggestion worked on the original field once I changed the newlines to blanks instead of nulls. However, the field I was searching was the wrong one. The right field is declared as a Long field (effectively a BLOB full of...
So far, so good. However, it seems like converting the CR and LF characters to nulls is the wrong thing to do when exporting as text; the Description is truncated at the first Null found.
I think I'll try again by converting the CRLFs to spaces.
Pat O'Connell
Visualize Whirled Peas
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.