Search results for query: *

HI! I have a Find button in a form created using the wizard. Is it possible the dialog box that appears when pressing the Find button to be in a specific position in the form? How can i change the position of the dialog box. Thanks in advance

Thank you so much both for your valuable help!!!

Please help me! I want to have a button in a form that when i click it , it finds the max value of a Table field and appears only a message saying that: the Max value is... Thanks

sorry about "????" shown in the question. (Format([Forms]![AP_Control]![hmer2_voith],'yyyymmdd')) Is Null Why can't this happen? If i don't type any value to the form hmer2_voith will be null, so i say that if that's null then take all the values (*) meeting the criteria from the table

Through ??_Control FORM I give values to ????????????? , hmer_voith and hmer2_voith. If I don’t type any values to hmer_voith and hmer2_voith I take no results at all. hmer_voith and hmer2 are DATE fields. In VBA I have the following code for these fields: If IsNull(Me!hmer_apo) Then...

Thank you for the help. Well, I have done the split but how do i give to the tables in the back end the read-only attribute? Maria

How can I make all the tables of the database (Access 2000) read-only?

After checking different date formats I have end up to the following: If I have the date format as mm/dd/yyyy at the Control Panel -> Regional Settings, which means that I follow the same format in Access, then everything works perfect. On the contrary, if I have the date format as dd/mm/yyyy...

I see that the above remark (dates that don't work can all be valid interpreted as either mm/dd/yyyy or dd/mm/yyyy) specifies the problem. I checked that if I ADD at the table tblholid the dates that have the problem as mm/dd/yyyy (i.e. I already have 02/06/2001 and i add 06/02/2001) DLOOKUP...

I use DLOOKUP to check the dates in a table. I use the following: ch = DLookup("dateholid", "tblholid", "dateholid=#" & newdate & "#") Some dates doesn't seem to work, i.e. when I check the dates 06/02/2001, 08/02/2001 11/05/2001, 12/05/2001 and...

Hello to everyone, The primary key (aa) in a table is autonumber (long integer). I checked the data in it some days ago and everything seemed to be ok, similar to the following: aa name ... ... ... ... 1494 John ... 1495 Helen ... 1496 Eric ... 1497 Nick ... 1498 Mary ... ...

I think you can find an answer at your 2nd problem at http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/703/qid/35663 Maria28gr maria.karakiza@usa.net

My report retrieves data from a query that shows questions and answers. The report has among others, 2 text files (for the question and the answer) with properties can grow =yes and can shrink =yes. When I preview the report, the data in the text boxes are ok. The problem is when I export the...

I have already given an answer to this problem. Come to http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/703/qid/35663 to view. Maria maria.karakiza@usa.net

To display all the columns in a crosstab query, even if the columns contains no data: Use the ColumnHeadings property to specify all the columns you want to display, ie: "January", February, etc. With this way you also specify the order of the columns. Also, have a look to Access2000...