Search results

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

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

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

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

I have created two menu bars. However, I want one of them to appear, only with certain forms, not always. Does anybody know, what to add on the onOpen event of these forms in order to do that?

I have a table-like form based on a Query. I want to change certain labels on that form, based on the number of records the Query has, for example: On the OnOpen event of the form, I want to add something like this: If number-of-records > 10 then Me!Label2.visible = false I haven't had much...

Is there a way to test/know if any changes or additions have been made since a specific form has been last oppened? I want to use this in order to avoid the error message I get, when I use the undo command in a form in which nothing has been added or changed, since it was last oppened. Thanx

When I have a form in data entry mode, there is no way to close this form once he started adding information to it. When I assign a macro to a button with the command "Close" and SaveOnClose set to "No", the information added is saved to the Table. Is there a way to get around this? I mean, what...

I have created a few pivot tables in my database which are based on select queries. All of these queries include a date field What I want to do, is to have the user to set a date which will filter the query (and accordingly the data viewed on the pivot table) However: when I use a criteria...

How do I transfer a specific value in a Query to a field in a form? To be more specific: I have a Query with three columns. I want the user to select a value from a combobox on a form (the combobox looking up values from the first column of my Query) and on another field on the same form to...

I have a data entry form based on a Table with three fields. An autonumber field (primary key) a person-codenumber and a field which looks up its values from another Table. On my form the last field is represented by a list box. I want the multi select property set to simple or extended. When...