Recent content by ion97

On opening my form I have added the following code in order to change the backolor according to the value of a specific field in that form: If Me![Field].value = -1 Then Me.Section.BackColor =10053222 Else ...... However when the form loads I get an error message Compile error: Argument not...

How can I do that? I' ve tried to create a delete query, to delete all records which do not match records on another table (the first table looks up values from the second). Although I've made the right selection (I get the records that I want to be deleted), when I try to run the query I...

Ok, now it works. All I did was changed dim rs As recordset to: dim rs as DAO.recordset Does anyone know why this happend and how come it worked previously? Could this cause any more problems in the future?

I' ve used the following code in order to add records to a table using the not-in-list event: Dim Db As Database Dim Rs As Recordset Set Db = CurrentDb Set Rs = Db.OpenRecordset("tblËÅÎÅÉÓ", dbOpenDynaset) On Error Resume Next Rs.AddNew Rs![ËÅÎÇ] = NewData Rs.Update If Err Then...

No lookup code, just the Row source property is set to: SELECT [tblAUTH].[ID], [tblAUTH].[NAME] FROM tblAUTH; All I want is to have the name appearing on the text box, not the ID number

For a specific field which looks up values from a table, I want to use a text box, not a combo box or a list box. When I do so I get the first column (bound column) of the table, which is something I don't want. Can I use the text-box and have the second column displayed? Note: I don't care...

Is it possible to have a multi-select list box on a form and then filter the contents of a query, so that we get the records matching any of the selections? For example, when I insert to the criteria the expression Forms![ListBox], everything is fine when the Multi-select property of the list...

Isn't it possible to use a Calendar Control in an unbound form? I don't seem to be able to set the "control" property of the calendar to the textbox I wan't to link it to. When I do so, the calendar is not updateable.

A combo box is looking up values from a table. Is it possible to update the contents of that table by using the NotinList Event and avoid the Warning Message?

In order to create a "browse" button I've used the code in http://www.mvps.org/access/api/api0001.htm The button works perfectly well. However, what I want to do is to asign the chosen path to a specific text box (with it's hyperlink property set to true). Using something like...

Ok, I got it! the save as... dialog box opens correctly. But how is the selected path transfered to the text box? (the text box "is hyperlink" property is set to yes"

I have tried it, but strangely enough it works the SECOND TIME I click on the button. What am I doing wrong?? Thanx for the help.

How are the contents of a subform refreshed ? I want to have a "data entry" form, with a button next to it. When the user clicks on the button the new record is saved and the datasheet at the bottom of the form is refreshed with the new data.

A combo box on a form is bound to a table with three fields: id(autonumber), LastName and FirstName. Is it possible to display the name in the combo box like this: Smith, John ?

I have a database with information on articles (author, date published etc) stored in my hard disc or/and CD-ROM's. The articles are in various formats (pdf, html etc) Is it possible to have: 1) a command button on my data entry form which will enable the user to choose the path (such as...