Search results for query: *

I have not PC at home until last year. I was a great relief to get rid of work troubles and have a rest to my eyes. I have got my father's used computer. It eats money, has less memory and has some troubles with Windoz version vs. CD-writer software version, so I cannot run some programs at...

TABLE A KEY NAME A ANNE B BRITTANY C CECILY D DORIS E EVE F FRANCESCA G GINA TABLE B KEY NAME C CECILY D DORIS E EVE >Try using DELETE A.* FROM A INNER JOIN B ON A.[Key] = B.[KEY]; Indeed: Remainder of table A KEY NAME A ANNE B BRITTANY F FRANCESCA G GINA Remainder of table B KEY NAME C...

Hi! I have tables A and B. 1.) How can I delete records from table A only, where A.KEY = B.KEY with a QUERY? 2.) How can I delete records from table A and B, where A.KEY = B.KEY with a QUERY? I have belived that DELETE queries do not work on joined tables? Somebody has shown me a solution to...

Biil, I have tried to send to you the text with attachments twice. NF Ferenc Nagy |\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New! | \ | | Institute of Isotope and Surface Chemistry | \ | -+- 1525 Bp. POB 77. Tel. :(36-1)-392-2550 | \| |...

Hi Bill, I send you this letter to you to your private e-mail, too. The attachment is not a complete database and it is too big for such a forum. In the newest tables " ... gazdag ..." you can find a list of the RichText controls and their control sources. My solution to the problem...

I have suffered for the second time from lost control sources of non-standard controls: 1) Calendar, 2) Rich Text. I have Access 97. In both cases I have a designed a form bound to a query. I have placed such control to the form 1) to edit date filelds 2) display text with upper and lower...

Consider the case that you have a damaged database but you can import its objects to a new empty one. In case of importing an object its creation date and LastUpdated property are set to the current time. Next day you see all objects having the same creation date (within the duration of the...

What is that Group? I know Groups as groups of users of workgroup administrator. I simplify my question: Which Windows API function sets the system date and time? Ferenc Nagy |\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New! | \ | | Institute of Isotope and Surface...

Consider the case that you have a damaged database but you can import its objects to a new empty one. In case of importing an object its creation date and LastUpdated property are set to the current time. Next day you see all objects having the same creation date (within the duration of the...

The thread went far from my intention. I have now the following primary key for LOG_FIRM table: computer+userid+when. E.g. PC1,NF,2002.10.18. 10:20:21[,?]. I have the following outcomoes: 1. adding firmcode to the key. If the clock has not changed manually then the chance for unique key is much...

Define two controls for the password, SecretP and WatchP, the former with password format, the later with visible characters.Use the workgroup administrator and check the Group of the current user upon loading the form. For low-rank user make the SecretP visible and the other invisible. For...

Have you tried 1. Join table A and B by two fields in each table a1,a2-b1,b2? 2. Copy the corresponding records of the MSysRelationships to a table CrucialRelationShips? 3. Delete the relationships made in Step#1? 4. Restore the relationships using the table made in Step#3, using a code like in...

VBSlammer, I have tried the cases 1. If there are special characters in the sheet name then it must be enclosed in apstropes and followed by a dollar sign. 2. It it contains apostrophes, then they have to be doubled and then the result must be enclosed in apostrophes and followed by a...

Gentle list members, In my Access 97 version I cannot print a hardcopy of the Relationships window. When I make screen hardcopy, the table names written in grey over black background are unreadable. On the other hand, unnecessary info is on the figure: the unrealated fields. Very important...

I have a rather complicate database. The relationships can be easily deleted with a few mouse clicks. That is very dangerous fotr the integrity. I exported the MSysRelationships to a table of an external database in more readable form. (I made individual fields from the attribute bytes of the...

Please help me to find the help topic where it is written. Ferenc Nagy |\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New! | \ | | Institute of Isotope and Surface Chemistry | \ | -+- 1525 Bp. POB 77. Tel. :(36-1)-392-2550 | \| |...

I tried DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel9, "T", "C:\A\X Y.xls", True, "$[W Z]" *Dollar ,opening brackett, worksheet name and closing brackett.* Anyway where is it written in a help file for everybody?[/i] Ferenc Nagy |\ /~ ~~|~~~...

I have an Excel table "C:\A\X Y.xls", a workseet on it "W Z". How can I link it to my databse as table "T"? I know that docmd.transferspresheet does it, if I have only one workseet in the table. How can I command that I need a a given worksheet (with spaces in its...

You state that that now() is more accurate than seconds. But if I execute a query, it will be executed *once*, so the same value will appear in all records. That is impossible in case of unique key. Ferenc Nagy |\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New! | \ | |...

I have log tables of changes, with unique index (who,where,when). The when field has date type. It stores the date+time until seconds. It works well when I enter changes manually. But if I want to log changes made by a query they can occur within a second, so the unique index causes an error. I...