Search results

Hi, I have a form (say Form X) that opens based on the ProjectID criteria in the query, which is based on a record selected from Form1 [ProjectID]. I want to be able to open Form X using information from 2 forms - Form1 or Form2, both using ProjectID. What I've done so far works, but I get an...

Hi- I couldn't find anything on this in the forum, but maybe I'm not using the right words to search. My combo box in a subform isn't listing all the records. There are 347 records which list alphabetically. When I try to choose a record from the drop-down list, the records end in seemingly...

Hi - I have a form with 3 tab controls. Within each tab there is an unbound listbox that lists tables. I want each list box within the tabs to select only specific tables relevant to the tab heading, but can't figure out the correct code. I'm able to select the tables using "tbl.Name Like..."...

Hi - The same text is being entered into a textbox for multiple records in a form. Is there some code I can use to have the same data in the textbox as in the previous record - so that the same thing doesn't have to be retyped over and over? And then when it's changed again, it will keep...

Hi - I have a situation where multiple users need to use a database without being networked. Users will be adding and updating information. I will then have to append this data to the Main Database, getting rid of duplicate information (if different users independently add the same information)...

Hi - Is there a way to change a table name so that it automatically changes throughout the database - so that I don't have to change every query and form that is related to that table?? Thank you.

Trying again: I want to populate a table (tblMHDPlantList) with records from another table (tblPlantList) using a combo box in a form. I then want to update the new tblMHDPlantList records in the form. The combo box works if the record is already in tblMHDPlantList. However, when I select a...

Hi - I would like to add a new record, selected from tblPlantlist, to tblProjectPlantList using a combo box (linked to tblPlantList) in a form. Once the new record is added, I then want to add additional information relevant to the Project in the form. It seems simple, but it's sure not...

Hi - I’m can’t seem to get the order of records in my combo box to work. The control source is PlantID from tblPlantCharacteristics. The rowsource is tblPlantList and the order is set to ascending by BotanicalName in the rowsource query. The order is correct when I run the query and in the...

Hi I am using a list box in a form (frmPlantListDialog) as the criteria for a query. The list box has 4 rows. I want the criteria to say: IIf([Forms]![frmPlantListDialog]![cboPType]=1,1 Or 2,IIf([Forms]![frmPlantListDialog]![cboPType]=2,3 Or...

Hi - I want to put a restriction on data entered in a 1st subform (“sfr2”), but don’t know how to write the code. Want I want to say is: If sfr2.cboBox = 6, then sfr2.QtyApproved cannot be greater than sfr1.FinalQty. I tried as an After Update Event: If Me.sfr2.cboBox = 6 then...

I have a report that opens from a form. The report looks to the combo box selection for the info to be displayed. I want that combo box selection to be displayed on the report, but I want column 2, not column 1. I put a text box on the report with the control source as: =...

Hi I would like to use 2 queries for one Report rather than having two separate reports or manually changing the RecordSource. I had the RecordSource refer to a combo box in a form for the correct query, but I get an error message saying there is no such thing. I've searched through the...

Hi - I have a filter that works in the Subreport when it stands alone but gives me an error when I put the Subreport into the Main Report. The Subreport is not linked to the Mainreport. My filter in the Subreport, in the OnOpen Event procedure is: Me.Filter = "Comments Like '*XX*'" FilterOn...

Hi - What is the code that I should use to have more than one IIF statement in a query - in the Expression Builder? AND doesn't work. I am trying to add 3 columns, but some columns have a null value and some don't, so I am saying IIF IsNull([Column1]), then add other 2 columns, otherwise add...

I am using a combo box in a form to set the criteria for a check box in my query. I want the user to be able to choose whether they want only the checked boxes to show, only the unchecked boxes, or all of the boxes. I have set the combo column 1 as -1(for true) and 0 (for false), which works...

I would like to use a form as a parameter for my query, but don't know how to do it. Right now my parameter is: Like ([CNTRT ID#: 1=Contract1, 2=Contract2, 3=Contract3]) and the user types in 1,2 or 3 when the Enter Parameter Value box appears. Instead of having that Enter Parameter box, I...

Hi, I am trying to convert the 1st letter of a field with 2 words to caps. I don't want vbProperCase because I only want the first word capitalized (it's a botanical name). I've searched through Access Help and the Forum, but haven't found any info on this. Can someone help with this? Thank...