Search results for query: *

Hi, I am trying to create a query that does not return any records with the same BoxNo (box number) if those records also have a scheduled destruction year that is <=Year(Now()) I’ve spent almost 16 hours trying so many different IIf statements and expressions that I’m so confused. So, I hope...

Hi there, I'm have trouble tweaking the javascript for a search engine so that it sorts the result descriptions "desc" alphabetically. The search engine is otherwise running successfully on our internal website. I found the code here: http://www.javascriptkit.com/script/cut154.shtml Please...

Hi there, My dilemma is deciding if setting up my particular data in separate tables would be beneficial or make revising this data on an as needed basis by an end user more complicated than if were to store the data in one table. My data is approx. 50 different records retention periods, which...

Hi, I have a triple cascading combo box setup that works completely fine. The trouble I’m having is getting a text box related to the second combo box to autofill based on a selection, and I've spent more than 8 hours trying to figure it out! Here's the senario: The user selects a Class...

Calling all experts! I need your help! I need to create conditional formatting (like highlighting) for multiple field values that do not match in my report that is based on a Union All query. First, you might need to know that my Union All query (detail below) returns all rows in tables A and...

Hi there Access Gurus! I have a data entry form that I want to use to create new records in a table that will be used to update another table. Most of the text and combo boxes work, but I’m having trouble with one text and one combo box that have expressions in their Control Source. I’ve...

Hello there, I’d like to combine the text values from multiple fields from one table in one new field, for each record, and null values are involved. There are really a dozen fields to combine, but to make discussion easier, let’s say I have 6 fields to combine: Expr1 Expr2 Expr3 Expr4 Expr5...

How would you solve my problem? Senario: Table1 has 1 colunm of numbers (each greater than the previous by 6), field name is priceline: 10, 16, 22, 28, 34, 40, 46... through 298 Table2 has these fields: materials (number) markup (number) priceline (lookup field) Form1 has these...

I need major help with my form that has triple cascading combo boxes. Combo box 1 is bound, combo box 2 and 3 are unbound. They cascade perfectly, EXCEPT when it comes to using them in a form where I need to have my selections of each combo box save to the underlying table AND work...

Why is my report giving me weird decimal results for the calculated field adding the number I have listed, which are connected to an underlying table with number fields? 0.45 0.4 0 0.5 0.1 0.1 0.55 and 1.000000 field with: =Sum([fieldname] Would like 0.55 and...

I've tried everything I can think of! Underlying table has number fields where I need various entries formated exactly like these examples:.05, .5, 1, 1.5, 250, 3500 field size is: Single format is: General decimal is: Auto Report has text boxes with these settings: format is: General decimal...

Help! Is it possible to perform a mail merge with documents in a Binder? My binder has a form protected Word document with form fields and an excel workbook. I would like to merge info from excel into the word fields. I can do this when these docs are not in the binder, but WHEN THEY ARE...

Hello! I have an Access 2000 table or query that is NOT sorted ascending or descending, which is what I want. The table or query is the data source for a report that must reflect the record order as defined in the table or query. My report settings are as follows: sorting and grouping: field...

Hello! I have an Access 2000 table or query that is NOT sorted ascending or descending, which is what I want. The table or query is the data source for a report that must reflect the record order as defined in the table or query. My report settings are as follows: sorting and grouping: field...

Hi, can anyone tell me &quot;DistinctCount:&quot; refers to in the Table Indexes section of my Analyse/Documentor document for a table? Example of print out: Table Indexes Name Number of Fields All RecordsContents Clustered: False DistinctCount: 10 All...

Hi gurus! If I have this formula in my update query: IIf([Descriptions Retentions]![Perm]=Yes,Null,DateAdd(&quot;yyyy&quot;,([Descriptions Retentions]![DeptRet]+[Descriptions Retentions]![WrhseRet]),[A/P Records]![DateTo])) How can I get it to return 12/31/yy no matter what date is in the...

Please help! How can I get a form to sort by more that one field? My form order by property is set for [Table].Description, and my table is sorted by both Description and date. I need the records in my form to go in the order of description and date. Thanks for anyone who can help!

Hi! I am having trouble with a formula in the Update to: of my update query. I can get it to update a date field in the underlying table with this formula: DateAdd(&quot;yyyy&quot;,([table1]![Number1]+[table1]![Number2]),[table2]![Date]) but, if a check box in another field is checked, I...

Sorry, left subject off first thread! Thanks in advance to as many of you who will be able to give me answers/options: I have a form with two combo boxes, each has an SQL row source property that returns unique records from two different tables: descriptions and sub-descriptions. In the...

Thanks in advance to as many of you who will be able to give me answers/options: I have a form with two combo boxes, each has an SQL row source property that returns unique records from two different tables: descriptions and sub-descriptions. In the first combo box, I have 15 descriptions...