Search results for query: *

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...

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...

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...

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...

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...

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...

How can I check in simplest way whether the current database file is read-only because the file itself is such or the it was opened by so from the command line? Ferenc Nagy |\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New! | \ |...

I have a database full of garbage. I want to sort out the queries which are not needed. But if I delete a query which is used 1. in another query 2. as row rource of como or list box in a form 3. as row source of a table field 4. in a module :-( I have to dig it out from an auld backup...

Once upon a time I could use the common dialog constants x= cdl... Now I have to copy their values from the help screen about the Common dialog x= &H... Where are the common dialog constants defined? Which is the library or reference what I must register again? Thanx...

Gentle List Members, I want to compare two versions of the database. How can I get a the lines of a macro one by one, like lines of the modules? My current workaround idea is to analyze the macros and expont the result in a text file or as object definition table. Thanx...

Gentle list members: I have the following task: I want to print the original Russian certificate number on the nationalized certificate of a Russian radioactive source. When the operator types in the Russian characters, Russian font is unavailable. If I say her that she should learn the new...

Gentle List Members, Where can I learn API calls from Visual Basic and Access? What should I read? My special problem: I want to read a value from the registry. I have a rather cumbersome solution. 1) Import the registry chapter in a tex file. 2) Attach the text file to Access or read this text...

Once upon a time I could use the common dialog constants x= cdl... Now I have to copy their values from the help screen about the Common dialog x= &H... Where are the common dialog constants defined? Which is the library or reference what I must register again? Thanx...

When I used Personal Editor to edit source code for dBase II and Pascal I made macros to make structures like IF ... THEN ELSE END IF, or SELECT CASE ... CASE CASE ELSE END SELECT I pushed ^I or ^S, the macro wrote the above lines and empty lines between the the went back to the IF line...

We make report as plain ASCII files then show them by Winword. Let the use format the report as she/he likes it! We had a program line to open a text file Shell "winword filename.txt". WinWord was in the path, so it worked. Somebody told that the presence of wordpad can be assumed but...

I want to reuse codes as DLL-s instead of copying modules everywhere. How can I make a DLL from my Visual Basic 6.0 string manipulation modules? Which should be the type of the new project? Where are the .OBJ files in Visual Basic 6.0? How must I use a linker? More exactly: they are written not...

Gentle list members, Do you know about a shareware program which can compile an mdb file into an exe file? Regards Ferenc Nagy Ferenc Nagy |\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New! | \ | |...

I want to install a database as Runtime Acces and a .mde data file. I have made a CD by Package and Devolopment Wizard. The setup frightens those would-be users who does not speek English because it displays a terrible mixed language dialog: Application name in Hungarian Setup in English and...