Search:

i want to make a list of those clients in the table tblClients whose field CompanyName is repeated as the same or equal.There are some wizards in the query window but i cannot use them on my...

Yes, it OK now.Thank you

Dear Hans

I thank you for your reply which i applied. I think i have not explained correctly what i need. What i need is the following. In the items 1 and 2 from the report in the attachement, the...

In my report i have a control showing either -1 or 0. I would like thecontrol to show the word "turneddown" if the figure is -1 and 0 if the figure is 0.Is it possible ?

In the private codes of the form i use the command DoCmd.Close acForm, Me.Name which is very convenient.But i need to use now public codes and i
cannot use it anymore, neither can i sue only...

How can i delete with code a shortcut on the desktop? Since th desktop has different names in the different computers,is there any way to refer to the desktop and delete the link there?
For example...

Thank you, Dear Hans. My code now is great ! Super !

Thank you so much for your explanation.I get no errors now but i do not get the shortcuts.May be i cannot get them with the endings i include ?

Thank you very much for your email.I have rewritten my private function to be named GetDBZList and have written
GetDBZList Me = Mid$(strList, 3) so with your help it is all right with the...

In the attachement i have applied,and that works fine, i wanted to add on a code to get also the short cuts ending with .lnk on the desktop.I put the foolowing code:
Private Function ShortCuts...

Can i open the same database through internet in another town? I mean to set such a link as in the networks in our office? For the time being we send databases made with autoexec that unpack...

thank you for the advice.Where could i ask for building a web interface ?

Can i open the same database through internet in another town? I mean to set such a link as in the networks in our office? For the time being we send databases made with autoexec that unpack...

Oh My God ! There is not a single file with an ending mdb on my desktop ? I am awfully sorry !

I want to get the list of the databases present on the desktop.I can do it for other folders, but not for the desktop.I am applying the example where i fail to get the list for the files on the...

How can I limit the right end of the screen? When I am writing, I want that the end of the screen for writing stops at say 14, while I am not stopped to write further to the right and I cannot read...

I use a function for copying all the tables from a database.Can i add on an argument to copy Structure Only tables?
Below is the function i use
Public Function ImportAllTables(DBName)
Dim...

Is there any code to make the tables in a database somehow disabled or allowing no edits
as it is in the forms?

Thank you so much for your advice.I applied it and it did work. Whwn i tried to intergate it in my coe however,i coldnt change the option.
What may be the reason for that?
Public Sub HideTables(f...

In the command bar Tools- Options there is a field Hidden Objects.Is it possible to set this field to False by code?
I have a function that hides the tables.It is an excellent function made by Hans...

CopyFile may be not the right word, maybe copy object,but what i need to know is can i copy a query from Database B , rename it and send it to Database C ?
Access is so powerful, perhaps there...

I want it to do it automatically by code, since this process repeats itslef with me many times.I need a code something like
FileCopy(/forums/images/smilies/cool.gif....
Is it possible ?

I find myself in database A. I want to copy a query from Database B, rename the query toQueryNew aqnd send it to Database C.
Is it posssible ?
P.S. i mean sending it by code

In my report i have a control source with DLookup that is all right.However, when i try to put it as code in the OnOpen event of the
report,i receive the mseeage that you have entered an...

What is the command to move controls? I have a control placed in the last of the row in a form.I want this control to
be moved temporarily in the first place and take the place of an already...