Search results

Hi, I have created a search query with a number of criteria. The thing is I've imported alot of data into my DB and alot of fields are empty in its record. These records aren't shown in the search results. So I'd like to adjust my query so that every record is displayed when no criteria has...

Hey, I have a problem which I can't figure out.... I have a form where one can select a company and for that company the website is displayed with some extra info. The problem is, when there are no records in the table (websites) an error occurs: No current record (3021). This is the code in...

Hey again, The resuls from a search are listed in a listbox. This listbox has a number of columns with data corresponding with a record (duh). The results also contain values which are selected from a combobox. These values are represented by (id)numbers. Is it possible to get the value...

Hey, I have a question about using a date in a query. I have a searchform inwhich a date can be enterred. The searchresults are the records > given date. The problem is I don't know how to this and another thing is, I'm from Holland so I have the dutch MS Access. The date saved in a record...

Hi, I've created a query which is used for searching a table. So when you have the searchform you can enter a number fields the search is based on. The problem is when a field is empty, I dont want to select the records inwhich the empty field occurs, but the all the records... I hope it's...

Hi, I have a form which contains data of a company. There's also a button which clears the screen so that a search can be made. So when you select a product which a company can manufacture, all the company's who manufacture that type of product are listed in a ListBox (on a new form). When a...

Hi, I've created a .dll to prevent scrolling in records on a form: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q278379 But my question is: When someone else wants to use my access-application on a different computer, will it work or not ? Thanx

This doenst work the way i want: Private Sub Form_Load() If IsNull(Form_form.text1) Then Form_form.chkb.Value = 1 'True doesnt work Else Form_form.chkb.Value = 0 ' False doenst work End If End Sub When the form is opened i want to check if a textfield is empty(null) or not. If its empty do...

Hi, I've built some forms in MS Access, but i have a question about that. I have a form with a listBox component. The values in this listBox are looked up in a different table. The thing is, when i want to save a record and no item has been selected from the listBox, an error occurs: You cannot...

Okay, Ive got 2 tables, one with companynames and some of their info en a table with employees. I have a form where a complaint can be written out. One had to select the company and an employee who works at that company. So when you select a company I want te have the corresponding employees in...