Search results

Hi JHB, I do have tables for each field. This is where the lookups in the main table get there values. Basically, I want all the fields to have there values in individual tables, then have them all bought together in a single table and have that table as the source for the Form where users can...

OK, I gather that is not a good idea. So I changed my fields in the table to Textboxes and now even the values in the table are showing just ID's! The form I use to populate the table has comboboxes with drop-down lists so the user can select a value (and I can control what they enter). 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...

Hi, I have a table with a hyperlink field that I use to link to PDF documents. My users can then open the hyperlinks from a report based on the table. The PDF’s are located on a network and previously when I linked to them only the document name was displayed in the hyperlink field. Now when I...

Hi, I have a table that contains just an autonumber ID field and a text field, ModelName, where model names of cars can be entered. I have a Form where the user can see what models are already in the table and then add new models or edit existing models. On the form I use a List Box to...

Thanks very much, ridders

Hi, I have a table, tblLocations, that contains various place names. In this table I have a unique ID for each location that is an Autonumber Data Type. There is another table, tblLocationDetails, where the Location is used to provide the place name of a place (town, city, etc). In the second...

Thanks very much

Hi, This may sound a little unusual but I am putting together a report where journal entries for the week are displayed and I want to make it look a bit like an actual journal or diary. Is it possible to make the background of a report look like paper? I mean parchment or the kind of paper you...

Just tried this and it works perfectly. Is there a way to make it work if I select more than one Project from the listbox, or does that require VBA? Thanks

Thanks very much, June7

Hi, I have a form where I can select a Start Date into a text box, a Finish Date in another text box and select a Project from a listbox. In the query criteria row for the date I have: Between [Forms]![frmDateRangeANDProjects]![txtStart1] And [Forms]![frmDateRangeANDProjects]![txtEnd1] In the...

Re: Query filtering out more rows than the Criteria I set (filtering out "blank" rows Thanks very much, guys

Query filtering out more rows than the Criteria I set (filtering out "blank" rows). Hi, I am trying to filter a field value out of a query. The Field is called Discipline and the value I want to filter out is called IND. In the criteria row for field Discipline in the query I have <> ”IND”...

Thanks guys. It is working now. I had entered formulas into the criteria rows of the two fields of interest in the query. I deleted these and it worked straight away.

Hi, I have a query, qryJobCardsOnly_10, with a field Reporting Discipline Category. In the Criteria row for that field I have: [Forms]![frmSelectProjectsSUMMARYREPORT_WEnding17]![lsbProjectSel10] There is a report, rptJobCardsOnly_20. In the Data tab of the Property Sheet the Record Source...

Hi, I have a report that shows the drawings that are related to a particular Part Number. The Part Number is selected from a Combo Box on a Form (frmPartNo). The drawing numbers appear on the report as hyperlinks and by clicking on a hyperlink the user can open a PDF drawing of the part. I...