mazin
Content Type
Profiles
Forums
Events
Posts posted by mazin
-
-
Teacher: Johnny, define "miracle", please.
Johnny: There are no miracles, sir!
Teacher: Imagine you climb a 100 meters tall tower, you fall on your head and you survive. How do you call it then?
Johnny: A coincidence, sir.
teacher: Well then, and if you climb the same tower for the second time and you fall on your head again and you survive?
Johnyy: I would call it an extraordinary coincidence, sir.
Teacher (a bit frustrated): But if you climb it again, and you fall, and you survive for the third time, then how would you call this?
Johnny: A habit, sir!
0 -
Once upon a time there was a shepherd. He was standing by the side of the road, looking after his flock of sheep.
Suddenly, a brand new Cherokee Jeep appeared and stopped near the shepherd. A young man wearing a Hugo Boss shirt, Yves St. Laurent trousers and Nike trainers got out and said to the shepherd:
‘If I can guess how many sheep you have in your flock, will you give me one of them?’
The shepherd looked at the man, looked at his sheep – who were eating grass peacefully – and said: ‘Yes, OK then.’
The young man parked his car and took out his laptop computer and a GSM phone. Then he logged on to a NASA website and scrutinised the local area with the help of a GPS (global positioning system). Next, he created a database and 60 Excel tables full of statistics. After that, using a hi-tech micro-printer, he printed a 150-page report. Finally, he turned to the shepherd and said: ‘You have 1,586 sheep in your flock.’
The shepherd replied: ‘You’re absolutely right, I do have 1,586 sheep in my flock. Now you can take your sheep.’ The young man took a sheep and put it in the back of his Jeep.
When he had done this, the shepherd said: ‘If I can guess your profession, will you give me my sheep back?’
‘Yes,’ said the young man.
‘You are a business consultant,’ said the shepherd.
‘How did you guess?’ asked the young man.
‘Three things,’ said the shepherd.
‘Firstly, you came here when nobody asked you to.
Secondly, you charged me a sheep to tell me what I already knew.
And thirdly, you have no idea what I do, because you took my dog, not a sheep!’
0 -
@ Malmst33n[RPM]
Welcome to our (your) forums!
You express yourself quite good in English.
For your question about the logo: I got the logo from somewhere (I no longer remember it). It was already transparent by its creator.
However, you can post in Graphics and Designing Art to get an answer by a qualified member.
Wish you good luck.
0 -
Yes, I know that we could write a batch file to search all drives for the "MSOcache" folder & delete it if found, but it would be even better to disable LIS, in the first place. Does anybody know how to do this in o2k7?
Welcome back , prathapml, with your hot topics!
I, finally, decided to go o2k7 (with a lot of effort to revive my o2k3 Access databases; not completely, yet!)
However, I haven't found a generic way for disabling the creation of LIS.
The only way, so far, is to install all features of the package and to run them from computer.
Thank you for your topic.
0 -
I can just say: WONDERFUL!
Shall we get the file?
Thanks.
0 -
Re-uploaded!
See the first post.
0 -
how many of these can you add? i added 20, and that`s it?
I added those you see in my posts. I don't know if there's a limitation.
0 -
It happens, quite often, that I need to print some reports in a place where the
available printer is not the default printer set by my system.
So, I designed this form (attached as Printers Form), to help display installed
printers on my machine. Then, I can just click a printer in the list to set it as
the default printer during current session.
Credit for code is inside the form.
Well!
I, also, created Autokeys macro; so that I can only press F12 on my keyboard
to open that form, instead of opening it within my user interface.
However, that macro has no relation to the functionality of the form. You can
delete it.
Printers Form is a standalone form that you can import to your application and
it should work instantly.
I hope someone finds it useful.
Any suggestions or ThankYous (or DamnYous!) are welcome.
0 -
Changed topic title to better reflect request.
Thanks, man.
0 -
Well!
You haven't mentioned if the two Pcs are on a network or not.
You haven't mentioned if each database conssists of a single file (tables and other objects)
or two files; back end with tables and front end with linked tables and other objects.
In either case, I'll mean "database with tables" when I refer to DB1 or DB2 in the following lines.
Let's call the database on the other PC "DB1" and the database on your (or whatever) PC "DB2".
Let's assume that there's a table named "MyTable" in both DB1 anf DB2.
Now, you want to append records from MyTable in DB1 to MyTable in DB2.
Then, copy DB1 to your PC if the two PCs are not on a network. If the two PCs are on a network,
you don't need to copy DB1.
Here'e how to append records from DB1 to DB2:
1- Open DB2 in design mode. You can press SHIFT while opening DB2 to get to this mode.
2- Go to File --> Get Extrenal Data and click "Link Tables...".
3- When the "Link" dialog box appears, browse to where DB1 is.
4- Once you click DB1, the "Link Tables" dialog box appears displaying a list of tables
5- Select "MyTable" and press "OK".
Or press "Select All" to link all tables if there are records you want to append from, later.
6- When the "Link Tables" dialog box disappears, go to "Tables" page (in DB2, of course).
7- Since there's, already, a table named "MyTable" in DB2, the linked table will be named "MyTable1", automatically.
8- Now, go to "Queries" page. Create a new query using "Find Unmatched Query Wizard".
9- When the wizard appears, select "MyTable1" on the first page and "MyTable" on the next page.
On the third page, select a key field in each table. Key fields should be the same, of course. Press the button "<=>".
On the next page, press the ">>" button.
On the next page, name your query as AppendMyTable. Select "Modify the design" then click "Finish".
10- While in design view, go to "Query" menu and choose "Append Query...".
11- When the "Append" dialog box appears, select "MyTable" from the list of table names, then click "OK".
12- Now, in the last column in your query (where it says "Is Null"), delete the field name that appears in the row "Append To:".
13- Close the query agreeing to save.
14- Now, run the query. It will append, only, the new records from MyTable1 to MyTable.
Start, again, from step 8 through 14 for each table you want.
When you finish processing all tables you want, delete all linked tables.
Now, you no longer need DB1. You can delete it and use only DB2.
NB: I suggest that you change the topic title because this is not a JOIN.
0 -
What I can understand is that they are exactly the same database with the same design and same tables.
And, the only difference is that tables in each of them has different records. And you want to append the records of the first database to the other, then delete the first one; then finally use the second one.
Am I correct? If so, let me know!
0 -
@ machkris
Attatch your file to your post, and let's see what the problem is.
0 -
The correct criteria expression for dates is:
Between #06/06/1977# And #06/06/1982#
BTW, all date/time formats are readable by MS Access,
no matter how they look, as long as they are correct formats.
0 -
anybody help...how do add oemlogo.bmp & oeminfo to XPCD ? step by step please...
Thank...
0 -
I'm sorry, man. Each version has different files and reg keys.
There are newer versions of Winamp MSIs on forums. Search for one.
Good Bye!
0 -
Thank you, Martin H!
It's, probably, a bad habit of mine when posting in MSFN forums.
I, basically, assume every one reading my post knows that I'm working in an unattended environment.
Thank you, again, for clearing things up.
0 -
Resolution in winnt.sif is for your desktop, not for your BB.
Here's the solution for BB resolution: http://www.msfn.org/board/index.php?showtopic=78312
It'd be cool to share how you change fonts!
0 -
If you uninstall vista tp6, it should be back.
Otherwise, get the original msgina.dll from your orig source ane put it in system32.
0 -
Thank you for the compliment!
First, I just assumed (my bad!) you install those apps from your HDD.
And, this is why I used %SystemDrive% in my script.
Second, it's ALWAYS SAFE to use the command "ExpandEnvironmentStrings" with
predefind variables like %SystemDrive%, %WinDir%, etc. (my bad, again!)
So, my first script should be like this:
var WshShell = WScript.CreateObject ("WScript.Shell");var SysDrv = WshShell.ExpandEnvironmentStrings("%SystemDrive%");//expanding my current system drive
WshShell.RUN (SysDrv + "\\Install\\ACDSee\\ACDSee.exe /S");//running EXE with silent switch
WScript.Sleep(5000);//time taken by the installer to unpack and install its files
WshShell.SendKeys ("%{F4}");//this is Alt+F4 to close whatever active at the moment
Third, accordingly; the scripts of creating shortcuts should be as follows:
- This script creates a folder for the shortcut to be placed in. Then, it creates the shortcut, itself:
var WshShell = WScript.CreateObject("WScript.Shell");var fso = new ActiveXObject("Scripting.FileSystemObject");//needed for the "Dest" variable
LinkPlace = WshShell.SpecialFolders("AllUsersPrograms");//needed for the "Dest" variable
var Dest = fso.CreateFolder(LinkPlace + "\\Accessories\\Extra");//this creates the Dest_ination shortcut-folder
var ProgFile = WshShell.ExpandEnvironmentStrings("%ProgramFiles%");//expanding my current directory of "Program Files"
var Link1 = WshShell.CreateShortcut(LinkPlace + "\\Accessories\\Extra\\PDF Reader.lnk");//puts a shortcut in the Dest_ination folder!
Link1.TargetPath = (ProgFile + "\\PDF Reader\\PDF Reader.exe");//where's your EXE?
Link1.WindowStyle = 1;//Normal Window; not Maximized or Minimized.
Link1.IconLocation = (ProgFile + "\\PDF Reader\\PDF Reader.exe");//where to get the shortcut icon from?
Link1.Description = "Foxit Reader";//Comment.
Link1.WorkingDirectory = (ProgFile + "\\PDF Reader");//the source folder of your EXE.
Link1.Save();
- This script creates a shortcut in an existing folder:
var WshShell = WScript.CreateObject("WScript.Shell");LinkPlace = WshShell.SpecialFolders("AllUsersPrograms");//this is: "%AllUsersProfile%\Start Menu\Programs"
var WDir = WshShell.ExpandEnvironmentStrings("%WinDir%");//expanding my current directory of "Windows"
var Link2 = WshShell.CreateShortcut(LinkPlace + "\\Accessories\\System Tools\\System Configuration Utility.lnk");
Link2.TargetPath = (WDir + "\\pchealth\\helpctr\\binaries\\msconfig.exe");
Link2.WindowStyle = 1;
Link2.IconLocation = (WDir + "\\pchealth\\helpctr\\binaries\\msconfig.exe");
Link2.Description = "System Configuration Utility";
Link2.WorkingDirectory = (WDir + "\\pchealth\\helpctr\\binaries");
Link2.Save();
Fourth, the CDR (a user-defined variable) variable you used in your script is what I use when installing from CD.
You can see it in many of my several scripts spread around here.
Fifth, when you can't switch between the selections with TAB;
then the buttons on the interface (setup screen) have their TabStop property set to "no".
In this case, the selectability of a button is still possible if a button has ampersand (&) in its caption.
When a letter in the caption of a button has ampersand before it, it's called "keyboard accelerator".
For example, if you press Alt+I when &Ignore (seen as Ignore with underlined I)
is displayed as a button on some interface; the command "Ignore" will be executed. (see the pic)
So, if the button you want to click has a keyboard accelerator, then (in my example) you should use:
WshShell.SendKeys ("i");//set answer to ignore
HTH
0 -
1- Extract WINNTBBU.DLL from WINNTBBU.DL_. A simple way is to rename WINNTBBU.DL_ to WINNTBBU.cab, then use WinZip to extract WINNTBBU.DLL from WINNTBBU.cab.
2- Use ResourceHacker (or whatever) to change graphics/text in WINNTBBU.DLL.
3- Use WinntbbuED to view/review your work and to change text colors to your liking.
4- Use MODIFYPE.EXE to check your new WINNTBBU.DLL.
5- Re-cab your final WINNTBBU.DLL to WINNTBBU.DL_ again.
HTH
0 -
This is how I create a shortcut in a shortcut folder that does not exist:
var WshShell = WScript.CreateObject("WScript.Shell");var fso = new ActiveXObject("Scripting.FileSystemObject");//needed for the "Dest" variable.
LinkPlace = WshShell.SpecialFolders("AllUsersPrograms");//needed for the "Dest" variable.
var Dest = fso.CreateFolder(LinkPlace + "\\Accessories\\Extra");//this creates the Dest_ination shortcut-folder.
var Link1 = WshShell.CreateShortcut(LinkPlace + "\\Accessories\\Extra\\PDF Reader.lnk");//puts a shortcut in the Dest_ination folder!
Link1.TargetPath = ("%ProgramFiles%\\PDF Reader\\PDF Reader.exe");//where's your EXE?
Link1.WindowStyle = 1;//Normal Window; not Maximized or Minimized.
Link1.IconLocation = ("%ProgramFiles%\\PDF Reader\\PDF Reader.exe");//where to get the shortcut icon from?
Link1.Description = "Foxit Reader";//Comment.
Link1.WorkingDirectory = ("%ProgramFiles%\\PDF Reader");//the source folder of your EXE.
Link1.Save();
This is how I create a shortcut in a shortcut folder that exists:
var WshShell = WScript.CreateObject("WScript.Shell");LinkPlace = WshShell.SpecialFolders("AllUsersPrograms");//this is: "%AllUsersProfile%\Start Menu\Programs"
var Link2 = WshShell.CreateShortcut(LinkPlace + "\\Accessories\\System Tools\\System Configuration Utility.lnk");
Link2.TargetPath = ("%WinDir%\\pchealth\\helpctr\\binaries\\msconfig.exe");
Link2.WindowStyle = 1;
Link2.IconLocation = ("%WinDir%\\pchealth\\helpctr\\binaries\\msconfig.exe");
Link2.Description = "System Configuration Utility";
Link2.WorkingDirectory = ("%WinDir%\\pchealth\\helpctr\\binaries");
Link2.Save();
For your request No. 1, see this post:
0 -
You can add this line above the %{F4} statement so that the script brings focus to your Window.
WshShell.AppActivate("Documents");//part of or the whole name of the running Window
Change "Documents" according to your situation.
For timing, it's not, practically; a problem. You just use sleep time that's equal to or greater than the actual installation time.
0 -
Well!
Let me assume you want to install ACDSee 3.1. (I haven't done it myself!)
Then, you need both files (ACDSee.exe and ACDSee.js) in the same place.
Let me assume, again, you put both files as these; on your CD:
$OEM$\$1\Install\ACDSee\ACDSee.exe
$OEM$\$1\Install\ACDSee\ACDSee.js
At installation time of Windows, $OEM$\$1\ will be C:\, or whatever your %SystemDrive% is.
So, your JS script will be like this:
var WshShell = WScript.CreateObject ("WScript.Shell");WshShell.RUN ("%SystemDrive%\\Install\\ACDSee\\ACDSee.exe /S");//running EXE with silent switch
WScript.Sleep(5000);//time taken by the installer to unpack and install its files
WshShell.SendKeys ("%{F4}");//this is Alt+F4 to close whatever active at the moment
5000 means 5 seconds.
When the installer finishes its work (but still waiting for the shortcut folder to be closed), it's time for %{F4} to do its job.
So, adjust the sleep time to the time taken by the installer to unpack and install its files.
However, since the path to ACDSee.exe is written in the script, it's not obligatory to put both files in the same place.
Using that script means that you will not call ACDSee.exe from your CMD (or whatever).
If you use a CMD, then you call ACDSee.js, like this:
Start /Wait %SystemDrive%\Install\ACDSee\ACDSee.js
NB: As mentioned, many times before, run your scripts before installing your AntiVirus programs. AV progs might block your scripts.
Hope this helps.
0 -
In such situations, I use a JS script. Some others use a VBS. Both are effective.
0
The B.O.O.K.
in Funny Farm
Posted
The B.O.O.K. - A Low-Tech Breakthrough
Announcing the new Built-in Orderly Organised Knowledge device (B.O.O.K.). It's a revolutionary breakthrough in technology: no wires, no electric circuits, no batteries, nothing to be connected or switched on. It's so easy to use, even a child can operate it.
Just lift its cover. Compact and portable, it can be used anywhere - even sitting in an armchair by the fire - yet it is powerful enough to hold as much information as a CD-ROM disk.
Here's how it works: Each B.O.O.K. is constructed of sequentially numbered sheets of paper, each capable of holding thousands of bits of information. These pages are locked in with a custom-fit device called a "binder" that keeps the sheets in their correct sequence. By using both sides of each sheet, manufacturers are able to cut costs in half. Each sheet is scanned optically, registering information directly into your brain. A flick of the finger takes you to the next sheet. The B.O.O.K. may be taken up at any time and used by merely opening it. The browse feature allows you to move instantly to any sheet, and move forward of backwards as you wish. Most come with an index feature, which pinpoints the exact location of any selected information for instant retrieval.
An optical "B.O.O.K.-mark" accessory allows you to open the B.O.O.K. to the exact place you left it in a previous session - even if the book has been closed. B.O.O.K.-marks fit universal design standards; thus a single BOOK-mark can be used in B.O.O.K.s by various manufacturers.
Portable, durable and affordable, the B.O.O.K. is the entertainment wave of the future, and many new titles are expected soon, due to the surge in popularity of its programming tool, the Portable Erasable-Nib Cryptic Intercommunication Language Stylus (referred to by the acronym P.E.N.C.I.L.S. to those in the trade.)