Search results

Hi! I've got a form based on a table. I would like to filter my form based on two combo boxes "cmb1" and "cmb2". I want the filter to be applied when pressing a button. The button vba is: Private Sub btnOK_Click() Me.Filter = "field1= " & Me.cmb1 AND "field2= " & Me.cmb2 Me.FilterOn =...

Would that setup allow me to edit the value as well as viewing it?

My idea was to provide the identifier by choosing projectNo and employeeNo from two combo boxes. Would that work? In that case how? :) EDIT: The table has a projectNo field, a employeeNo field and lots of more fields relating to what that employee have done in the particular project. There may...

Thanks for your quick replies both of you! I'm familiar with queries. The reason I use a text box is that I would like to both show the existing data in the record, but also be able to edit it. Is it not possible to link a text box to a specific record? In that case, what are text boxes for?

Hi! I don't understand how to work with textboxes. I would like a textbox to show values from a table on a specific column, but with a rowsource decided by 2 comboboxes. The problem is that I can't find a rowsource property for the textbox. How are text boxes of any use if I only can specify...

Hello! I've got a table with project info recorded on employee level. There's one column for projectNo, one for employeeNo and a whole bunch of other columns with info regarding that employee's contributions to the specific project. I'd like a form where you enter projectNo and employeeNo in...

You're my savior, thanks! :)

Thanks for your reply! Actually I remembered incorrectly regarding the problem. Sorry about that. I have several combo boxes for data filter, two of which are related. In the first one you pick (1) object type, and in the next you pick (2) sub type. Depending on what you select in (1) the...

Hi! I've got a form with combo boxes and an OK button. When OK is pressed, an report is opened. The report is filtered from the chosen value in the combo box. My problem is that if I choose a value and then change my mind and choose another in the same box, the report still shows data filtered...

Thanks, that worked! I created it by selecting a query and choosing "report"

Thanks, but I'm not sure as to how you added the fields.. I found the "add existing fields" button, but I can't seem to get them organzed as I want. I cant get the label and its corresponding textbox to be in separate areas. I want the label to be in the "page header" and the textbox in the...

Ok I'll try uploading the database. http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=44741&stc=1&d=1351703021 The report "rptRU_Alla" is created by selecting the query "qryRU_Alla" and clicking "Report". Thanks for your help!

I'm at work now and I've only got the swedish access version here. I can post a screenshot of it now and I'll try posting my english access version when I get home. http://i1164.photobucket.com/albums/q565/shinzai1/report_design.png...

I've got narrow margins, only 0.64 cm. I find it unlikely that they would block 2 whole columns. No matter what view I'm in the columns don't show.

Hi, I'm new with reports and with Access in general and I've got a problem creating a report based on a query. I select a query and then create a basic report on that query. My query has 17 columns, but only 15 of these are displayed in the report. The 2 rightmost columns are missing. I'm not...

Thanks, I'll look into it! In what ways is this method superior to my method?

Hi! I'm new to Access and have a question.. I have a form with several combo-boxes in which to choose parameters. Next to each combo-box I have an "OK" button with VBA code which opens a specific query with previous chosen value in related combo box as filtering parameter. Each button opens...

Thanks, that solved it!

Hi! I'm very new to Access and I've got a problem. I have a query looking like this: SELECT * FROM tblA INNER JOIN qryA ON tblA.ProjectNo= qryA.ProjectNo; It is supposed to select only the rows from tblA which has a ProjectNo equal to any of the values of the ProjectNo column in qryA (the...

That did the trick! thx :)