Search results

I'm currently using Excel and PivotTables to extract and analyze vast amounts of data. (up-to 25,000 records with many variables). The problem now, is that the size of the excel-file is starting to exceed its limit (130MB). So, I would like to use Access instead (it this a good idea??). So, my...

I have this form where there's mention of CompanyID In a subform, I have the information about all the contacts of this Company. In order to see full detail information for a particular contact (of that particular Company) I have a Combobox with a query. At least: that's the whole idea...

I have a subform which shows records... usual stuff. However, when I turn on the scrollbar, it always shows the scrollbar... also when there are no or a few rows in the subform. Can I make the scrollbar of a (sub)form conditional? -- so, if the form needs more than so many space because of...

I have a query which is run in a subform... however, I need a value from the parent form. How do I link to this value in the parent form? The query should look like: SELECT tbl2.name, tbl.number FROM tbl1 LEFT JOIN tbl2 ON tbl1.aID = tbl2.aID WHERE tbl2.aID = parentform.[aID] Now, the...

I have two Combo boxes which work as selection boxes for the detail form. So, if one Combo box selects Name - the detail form is filled with the information belonging to that Name... However, I have two combo search boxes: one for Name and one for Clientnumber. They both work fine, but I would...

I have a form which shows contact information. I have added a combo box which automatically shows the information of the selection in the combo box. So, far no problem. However, what I would like is that (since there will be a lot of contact in it) you can search inside the combobox. Say, for...

I have this form which shows an order.... linked to this order are the client, the principal company, and the company that carries out the order. The information for these three companies are all stored in one table (since the information is very similar). Tables look like: tblOrder - OrderID -...

I have this form which shows the contents of a table... however, this table is linked to another table. How do I show the results of this linked table in the form? Table_person - Table_personID - PersonFirstName - PersonLastName - EmployerID (linked to table below) Table_Employer - EmployerID...

I'm completely lost... I don't understand the logic of Access. What I want to do is update a value in a form when another value is changed. What I have now is: "Value" - onChange - run macro "25Procent" This macro does: SetValue Item: [Forms]![Tarife]![Value25] Expression...