Search results

Hello, I have the following piece of code, which is causing me a bit of grief at the moment. How do i pass a variable (labelName) to be used as a control name? For reference, i have labels that will become visible when the following code is executed by clicking on the corresponding control...

Returning Null Values as Zero Hello I have three fields in a query all from the same table. The Fields are: DateRange, No_Of_Orders, Priority DateRange contains integers from 0 to 11, No_Of Orders is a number field, and Priority contains either 'Y' or 'N'. What i want to do is sum...

Hello, This is a real Access 101 problem i'm having. I've got two years worth of data, that i need to group first by Year, and then by each month in the year. The issue i'm having is that the query groups by year no problem, but it then groups each month in alpabetical order (ie; Apr,Aug...

i've got the follwing function in my VBA code that is throwing out the error Can't find the field '|' referred to in your expression. Is their something wrong with my syntax? Dim LTotalF As Long LTotalF = DCount("Cri_Ref_No"...

Hello, I have multiple update queries that i would like to combine into one statement for performance reasons. I know you can update multiple columns in an update query, but the problem is all the statements have different WHERE clauses. I'm assuming this would be solved by using subqueries...

Hello, I got the 'syntax error' in the following query. The query works fine when i look for items that don't appera in the list on ONE particular day, but when i look for items that don't appear in the list within a given date range, the query falls over SELECT...

Hello all, I'm having a bit of trouble with the follwing VBA code DoCmd.RunSQL "UPDATE AlertsAM SET StationGroupID = " & Me.txtGroupID.Value & " WHERE(AlertsAM.AlertAMID) = " & Me.txtAlertAMID & ";" DoCmd.RunSQL "UPDATE AlertsAM SET StationID = " & Me.txtStationID.Value & "...

Hello, I have a list of items that need to be checked on a daily basis. At the end of the day i need to print off a report of all the items that have not been checked that day. The way that i am attempting to do this is by using a nested SQL NOT IN query but i can't get it to work. The code...

Hi Guys, I need to validate text entered into a text box using VBA. The text that will be entered needs to conform to the following criteria: 1. L[000], where [000] can be any number between 00 and 999 2. L[A][] where [A] can be be any letter of the alphabet, and [000] can be any number...

IHello all, I have the following bit of code that i want to insert the value from txtGroupID into a filed called GroupID in a table called AlertsID. I only want it to update the table when another the AlertID field in the table matches the value in a txt box called txtAlertID. The save button...

Hello all, I'm a bit rusty with access, and i can't find a discussion on this board to help. I have two combo boxes on the main form which i want to transfer the value in column one in each of them (an autonumber) to two text boxes on the subform. I have tried to do this by using the combo...