Search results

The following IIF statement is not producing expected results. Additionally, Access is creating a new field named after the IIF string and inserting "<>FALSE" under that field's criteria. "<> FALSE" is only visible in the wizard and not in the SQL. Summary: ((Other Criteria) AND...

The listbox is provided only as a reference so that the user does not have to type the data. The user will end up manually typing the secondary data anyways. On the other hand I understand why Access would not encourage passing rogue data like I am trying to do. Do you think the design is...

The primary data is being passed to a bound text box. I need the secondary data to be bound as well and not only displayed. The unique key is only being used for the listbox. I am dropping that unique key and will be using the "primary data" as the key going forward in the query process...

Is there a way to create multiple control sources for list boxes? I would like data from two listbox columns to populate two textboxes of the same record. I know populating the secondary textbox can be accomplished through a query based on the primary listbox column. However simply passing...

The option to include/exclude properties are not provided in the "Control Name Change Builder" module, at least that I can find. But I will try the main module and uncheck the recommended boxes. Thank you.

I am using Rick Fisher's "Find and Replace" add-in to fix my non-conventional names. It worked very well when renaming tables, etc. Now I'm using the included "Control Name Change Builder". My problem is it not only changes the control name and references, it also changes the control source...

The current SQL is at work, but I was able to find this simplified code. The current includes an additional JOIN. Thank you again.

I have a Union query that is producing duplicate records due to small discrepancies in description fields. I only need the "key" field be unique, but the Query finds entire unique records. I have tried GROUP BY "Key", but I get expression errors. I am not having luck getting SELECT...

I am working in 2003. I have a couple Can_Grow text boxes in page headers that are restricted by the height of the page headers. The text cannot grow beyond the designed limit of the page headers. I have tried the following in the Report_Open event: Me!PageHeaderSection.CanGrow = True and...

I am working in 2003 and would like to highlight current rows in a continuous form. I found Lebans sample MDB at www.lebans.com/conditionalformatting.htm I pasted and reviewed the included modules and form code. On my form the background textbox is being activated and hovering above all the...

Thank you Galaxiom for addressing my problem with those two options. I think you are correct that the edit form should be single. This will cut down on mistakes with key order and other possible user obsticles.

I need to add text controls to a continuous query subform for additional user input. The user types Asset_No into Form1. Subform1 queries a list of circuits and descriptions for user reference. I added subform2 with the control source as a table for additional input for the key "circuit". My...