Search results

I have information from two different sources about subsystems (areas of an industrial plant). One is a to do list with items that need to be completed and the other is to do with checksheets that need to be completed. The information from each source is completely different but both refer to...

Hi, suddenly the Property Sheet has very wide columns. So wide that it is unusable. The "Add Existing Fields" screen is the same. I am unable to get to the edge of the column to adjust it because it is off my screen. My Access is now unusable because of this silly issue. Does anyone know how...

Hi, I have a field of delivery dates, DelDate, and want to include a field that shows the sequence of the deliveries. I would call the new field Seq. For example, the earliest date would have a field value of 1, the next earliest would be 2, etc. If multiple records have the same delivery date...

Hi, I am trying to set up conditional formatting to show Green for <1 , Amber for 1 to 14 and Red for anything over 14. I have the expressions as below: Expression is [Text24] < 1 Expression is [Text24] > 0 <15 Expression is [Text24] <14 The middle expression with > 0 < 15 doesn’t work. How...

Hi, I have a query that seems to open without any problems. It opens with 63 records. When I create a report using the report wizard only the first record from the query appears on the report. Also, I notice that if I try to set a Sort in the query I get a message, Invalid Procedure Call. What...

Hi, I have a query, qryCC_Data, that I can open from a command button on a form using the code below in the command button’s on-click event. Private Sub Command7_Click() DoCmd.OpenQuery "qryCC_Data", , acReadOnly End Sub I also have a listbox on the form, List5, and would like to be able to...

Hi, I have a database where a welder can be selected from a listbox on a form. When a command button is pressed a report opens filtered to show only records for that particular welder. The listbox is set up so that only one value can be selected, not multiple values or “All”. The listbox is...

Hi, I have a form with a subform where the user can select multiple items from the combobox in the subform. I want to make it impossible for the user to select the same value twice from the subform for any given record in the form. I tried to do this by setting up the intermediate table behind...

Hi, I want to have a form/subform where I can enter information for new students. On the main form I would be able to enter standard info such as name, address, contact details, etc. I want to be able to select and assign subjects for each student. I am thinking that all subjects would be...

Hi, I have a form where the user can select values from combo boxes to populate a Products table, tblProducts. The combo boxes get their values from individual tables for each field, for example tblManufacturer. I have it set up so that each combo box has the Limit To List property set to Yes...

Hi, I have a query based on two joined tables. There is a report based on the query. I had a parameter query set up where a user could enter a Job Number and the report would open up filtered for just that job number. I want to have a list box on a form where the user can select a job number...

Hi, I have a listbox on a form where a value can be selected and then command button pressed to see a report filtered by the selection from the listbox. I am getting an error "Item not found in this collection" when I press the command button. This is code I got from this site years ago...

Hi, I have a form frmContacts where a person’s name and address etc can be entered. There are comboboxes for Country, State and City (in that order). I want the State and City comboboxes to be not visible until a value is selected from the Country combo. I have done this using...

Hi, What is the best way to represent Country, State and City? Should there be individual tables for each of these three fields? Or should there be one table that contains all these fields? (with the values coming from an individual table for each field?) I would then want to use these...

Hi, I have a Combobox called cmbLevel and want to set a default value. The default I want is “Standard” and this is a value in the table that is the source for the combo box. What would I need to put in the Expression Builder or the Default Value row of the Data tab in the Property Sheet...

Hi, I have a form where the user can select values from Comboboxes and the values are stored in a table. The problem is that while the form displays the values I want to see the table only displays the ID’s. I want to create a report from the tables so the ID’s are worse than useless. How can...

Hi, I have a query with fields Make, Model and Colour which have the values provided by a Combobox drop down in the source table. I want to include a calculated field in the query that concatenates these together to give a description of the vehicle. Vehicle: =[Colour]&” “&[Make]&” “&[Model]...

Hi, I have a Form where I can select car characteristics such as Make and Model from Comboboxes to create a record for a particular vehicle. This works fine. I also want to show the Make at the top of the form in a Textbox, however, rather than showing Ford, for example, it shows the ID number...

Hi, When I am building a query and need more columns I try: Design, Insert Columns. It does absolutely nothing. I don't get any new columns. How can I get more columns in my query design window? Thanks very much Dave

Hi, I have a query based on two other queries. The source queries show TotalCost to-date for activities for the week, with the field ActivityNumber being the unique identifier. There is a query containing costs for the week just ended and another identical query showing costs for the week...