Browse by Tags

subracting the field values in two tables

I have two tables TABLE A and TABLE B each having one row and fixed number of columns. I want to have a TABLE C that contains the values of TABLE A - TABLE B example Table A Table B Table C 1,5,6,2,9 5,6,3,8,1 -4,-1,3,-6,8 Can I have a VBA code , query for it I really have too many fields in the table...

Posted to Access Coding/Macros (Forum) by microsoft on 05-04-2010
Restricting the criteria for combo boxes to specific values based on a certain field in a table

I have a simple Access Database where I use the field properties of tbLookUp to display a combo box at each data entry point. The combo box provides a list of possible values from tblSource. In my sample database you’ll see that I have “Widget1” selected as a value in fld1. In fld2, you’ll see the combo...

Posted to Access Coding/Macros (Forum) by microsoft on 05-01-2010
Command button to run query not including criteria

Hi everyone, I have a query (qryKPI113a) which references another query (qryKPI113) which references another query (qryFirstBookingAllInfo). I have date criteria in qryFirstBookingAllInfo referring to text boxes on a form - the criteria in full being: Between [Forms]![frmAudit]![StartDate] And [Forms...

Posted to Access Forms (Forum) by microsoft on 04-03-2010
Nested IIf syntax

I am trying to create a field "FinalDeductible" in a query. I am pretty sure I have it set up right, but I can an error: The expression you entered contains invalid syntax. Can anyone see it? FinalDeductible: Iif([StartingDeductible]>0,[StartingDeductible],IIf([DiscountDeductibleAmount]>0...

Posted to Visual Interdev (Forum) by microsoft on 03-27-2010
Nested IIf syntax

I am trying to create a field "FinalDeductible" in a query. I am pretty sure I have it set up right, but I can an error: The expression you entered contains invalid syntax. Can anyone see it? FinalDeductible: Iif([StartingDeductible]>0,[StartingDeductible],IIf([DiscountDeductibleAmount]>0...

Posted to Visual Interdev (Forum) by microsoft on 03-27-2010
Nested IIf syntax

I am trying to create a field "FinalDeductible" in a query. I am pretty sure I have it set up right, but I can an error: The expression you entered contains invalid syntax. Can anyone see it? FinalDeductible: Iif([StartingDeductible]>0,[StartingDeductible],IIf([DiscountDeductibleAmount]>0...

Posted to Visual Interdev (Forum) by microsoft on 03-27-2010
Disable the Confirm question for action queries in VBA

I am currently using Access 2000 and want to know if there is a way to disable to disable the confirm question you get when you execute and action query using the Docmd.RunSQl statement in VBA code instead of disabling it from the tools/ option menu.

Posted to Access (Forum) by microsoft on 02-11-2010
Access 2007 Union Query With Linked Tables

I have a union query with linked tables. When I run the code below with two tables it executes perfectly fine though when I add in the third table it errors saying: Error in your syntax near "union all select `pencolony2`.`penID`, count(1) from cowcolony2" Though when I run the code from the...

Posted to Access (Forum) by microsoft on 02-01-2010
Problem: How do I check tables to see if a field has data in it?

Hi experts, I would like to create some code/query that will check my tables to see if a field has data in it. As an example, I have the field ThreatTypeID in tbl1, tbl2 and tbl3. On my form, I have tbl1 as my recordsource. I have a button on this form to delete the record. the record contains the ThreatTypeID...

Posted to Access Coding/Macros (Forum) by microsoft on 05-30-2009
Problem: Reference query result in VBA

What is the syntax for referencing the result of a query (like a calculated field result) from within VBA? To keep this simple (realizing their are easier ways to get this particular result), suppose you build and run a simple sum query in VBA, like SELECT Sum(1) AS SumQ FROM aFile; What is the syntax...

Posted to Access (Forum) by microsoft on 05-27-2009

Page 1 of 1 (10 items)