Search results

Hi! I've got a project database which I want to be able to present in a nice way. In one table I've got the fields: project no resourceNo (person working in the project) documentA-progress ducumentB-progress documentC-progress etc.. Each project may have many persons working in it with...

Hi! How do I hide records in a report based on a critera, for example textfield value? I saw a version of this somewhere and applied it to my db: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Resursnr = "UL" Then Cancel = True End If End Sub But nothing...

Hi! I've got a report with a bunch of fields. One field contains a hyperlink and the text is usually quite long. Currently access wraps the field around the text and this resuls in alot of rows in each record. How do I disable text wrapping in a particular field? Thanks

Hi! It's possible to calculate fieldA*fieldB in a new query field. It's also possible to compare these fields with IIF(). But why is it not possible to calculate the min/max of a set of fields by using a similar min() expression? Thx

Hi, I have a form (form2) based on fields in a couple of tables. Prior to opening the form I want to be able to filter based on EmployeeNo, ProjectNo or both. I use form1 to select the filter parameters with combo boxes and when I press OK it opens form2. In form2 I have an onLoad event...

Hi! I would like the "cells" in my report to change format (bold/color etc) according to the value of a checkbox in a query. The query is the same query that the report is based on. I've tried making a formatting rule on the field under "conditional formatting". The problem is that when I open...

Hi! I've got a report with alot of fields. 1) Would it be possible to include/disclude certain fields in the report based on some conditional (checkbox for example)? 2) Let's say it's possible to disclude say.. field no 5 from the report (counted from left side). Would it then be possible to...

Hi! I would like to enter data in table1 using a combobox as input source. The combo box gets its options (to choose from) from table2. I've tried setting the combobox record source to table2.xx and its contol source to table1.yy. However this only results in me being able to scroll through...

Hi! I've made a form related to a table. I want to be able to display and edit records in the table from my form. My problem is that I can only view data, not edit or add anyything. When I look at the form properties I see that: Allow additions = yes Allow Edits = Yes What am I doing wrong?

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

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

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

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

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

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

Hello, I'm very new to Access and have a problem: I have a table with fields as follows: ProjectNo, EmployeeNo, [+many fields which display dates when the employee was finished with different tasks in said project] Each project can have many employees, ie one row for each employee (but with...

Hi, I'm very new to Access and have question. I would like users to get filtered report data based on a combo-box or similar. How do I do this? I tried this: 1) I created a form "frm1" with a combo-box "combo1" choosing from values in a column in query "qry1". 2) I then made a query "qry2"...

Hi, I'm terribly new to Access, so forgive me if this makes no sense ;) Let's say you have multiple people inputing data to an Access database through forms. Is it possible to let these forms be opened as files directly through the Explorer file system? So that each person might have their own...

Hi everyone! I'm very new to Access, so please bear with me if my question may not make sense :) My situation is this: I have two tables in Access that each are linked to an Excel spreadsheet. The two spreadsheets have the same column headers. Table 1: Project no, date finished with task 1...