Search results

thanks for the reply, for the time being, i can live with date, so ill re address this at a later date, but thank you for the help.

thanks for all the help i have gone back to my original method Private Sub btnYesterday_Click() On Error GoTo btnYesterday_Click_Err Forms!SubForm_ENG_MCU_Dashboard_MCUReportButtons.txtSecondDate = Date - 1 + #02:00:00# DoCmd.OpenReport "Report_ENG_MCU_Tracker", acViewReport...

if thats a better way, then great, i had originally done it that way, but then someone said use vba

thanks, so code executed, but didnt filter the query, it displayed all records

sorry i dont understand, do you mean in the variable?

thanks for the advice so i ve done that, and the error comes back with Syntax error ( missing operator) in query expression '[dateTime] = Between #27/10/2018 02:00:00# And #27/10/10/2018 02:00:00# here is me sub Private Sub btnYesterday_Click() On Error GoTo btnYesterday_Click_Err Dim...

ok so i tried filtering through vba like this Dim FirstDate As Date Dim SecondDate As Date Forms!SubForm_ENG_MCU_Dashboard_MCUReportButtons.txtSecondDate = Date - 1 FirstDate = Forms!SubForm_ENG_MCU_Dashboard_MCUReportButtons.txtFirstDate SecondDate =...

thanks for the reply, im not sure how that would work with between dates, please could you explain?

hi i have a report that is bound to a query, what im trying to do is open this report based on different dates. so i have two buttons on a form, these buttons have some VBA to fill a field on the report, this field is then used in the query to filter the data so the button vba is Private...

so i had to create two update queries, but worked a treat.

thanks for the idea, look promising, just one question, as the data that needs to be changed riesides in the same field, can i change all the different data, in one query or will i have to make a query for each change?

hi its not a text box, its a field from a subquery

hi im trying to build a dlookup from a table and a query the table is Table_RunInLocationNames Id RunInLocation LocationName SubQuery is SubQuery_ENG_MCU_InServiceIssues_ReturnTimeLocation Vehicle_ID VehicleNo ReturnTime ReturnLocation what im trying to do is change the field data in...

thaks for the reply all i really want to do is display the values under a column and row header, it really doesnt matter which is which, i need to be able to split the data into columns, and rows, the criteria is per dimension, lets say length and the worktype is cavities and flats, i need to...

when you say raw data, what do you want to see? just the data, or table with headers, the screen shot is just a select query, thats been grouped, and ive sum totaled the dimensions, length, width, depth, height, thickness, rollver

how can i aggregate the workype so i can use them as column headers?

ss1.png is the raw data from the query ss2.png is the desired output, so the row headers are the dimension types, ie length, height, width and the column headers are the work types, the values are the dimension values

hi i am trying to create a cross tab query but i cant seem to display the info how i want it. i have two tables table_wheelcavities table 1 wheelcavities_ID vehicle_IDFK DateAdded Mileage PrintName MaximoNo table_wheelCavities_M2M table 2 wheelcavities_M2M_ID wheelcavities_IDFK DateAdded...

thanks everybody for the help in sorting this, the only one i could get to work was Private Sub cboVehicleID_GotFocus() Me.cboVehicleID.Locked = Nz(Me.cboVehicleID, "") <> "" End Sub

i tried that, but didnt have any effect