Search results

hi i want to be able to lock a field on a form after the user updates it, i have an if statement but i cant seem to get it to work, can someone take a look at it and tell me if theres something missing from it Private Sub Form_Current() If IsNull(Me.cboVehicleID) Then...

Wow, thanks for the replies, I'm gonna have a look at the code now, just for your info, I'm not giving the user the option to deselect and of the records, as there will only be a maximum of 12 needed, so I'll remove that variable from the equation. Sent from my ONEPLUS A6003 using Tapatalk

i have a combo box on a continuous sub form, what i want to do is, when i make a selection from the combo lets say for example, apples, on the next line, i dont want to be able to select apples again, so the option is removed from the selection

Thanks for the reply, I e done it from the form instead. Sent from my ONEPLUS A6003 using Tapatalk

thanks for the reply, is there a way of auto filling a field from the query?

hi i have a query see below SELECT Table_Bogies.Bogie_ID, Table_Bogies.BogieSerialNumber, Table_Bogies.BogieShortName, Table_Bogies.bogieType_IDFK, Table_Manufacturers.ManufacturerName, Table_Bogies_M2M.Stores_IDFK, Table_Bogies_M2M.DateAdded, Table_Stores.Location FROM Table_Vehicles RIGHT...

so i have resolved this issues, thank you for the pointers, what i did was on click of the button Private Sub btnAddWorkType_Click() DoCmd.OpenForm "Form_WorkType_NewEntry", , , , , acDialog Forms!Form_PlannedMaintenance_NewEntry!CtrlPlannedMaint.Form.cboWorkType.Requery End Sub

ive edited my post above

ok so i open the form_workType from a button on form_plannedmaintnenance code is to open "form_WorkType" Private Sub btnAddWorkType_Click() DoCmd.OpenForm "Form_WorkType_NewEntry", , , , , acDialog End Sub then i have on form_WorkType Private Sub btnSave_Click() DoCmd.RunCommand...

thanks for the help everyone, but ive tried all of the suggestions, but non work, one thing i failed to mention, not sure if its a cause but the form_plannedmaintenance form is still open, would that cause an issue with the requery?

hi all so i have a form called form_plannedmaintenance_newentry, and a sub form on this form called, sub form_plannedmaintenance. in the sub form, is a combo box called cboWorkType one the form is a button, to open another form called form_workType this form creates new entry selections in...

WOW Thank you so much, i have been trying to solve this for weeks

Ok, so if I upload some.sample.data with my report, could you tell me whether it could be replicated with sub reports please? Sent from my ONEPLUS A6003 using Tapatalk

i hate to bump posts, but does anyone how i can achieve this please.

hi im trying to create a criteria to filter a query based 02:00 yesterday and 02:00 today i have tried [DateField]+[TimeField] as expr1 between Date()-1 & #02:00:00# and Date() & #02:00:00# but its not filtering, please can someone point in the right direction please

It's the way the report is layed out, it pulls data from various places and displays that data, in a datasheet format, for each subform Sent from my ONEPLUS A6003 using Tapatalk

I'm using sub forms in my report, as I require a continuous form. How would I add a dummy record? Sent from my ONEPLUS A6003 using Tapatalk

hi so i had an issue today, that had me stumped, and it was when i was emailing a report in pdf format, there was no data being displayed on the report, it turned out that when the sub form on a report hs no data, it wont display, not even the header. so my question is, how do i force a sub...

so i think i have identified the cause for this, when there is no data in a sub form, it will not display on a report in print preview or pdf, it wont even display the headers of the sub form.

hey thanks for the advice, i thought i was onto something, when you mentioned about the form being open, so i created a report to display the data, and then email from the report, but still no joy, plus i set up a print preview button, and that also shows no data, can you explain to me what you...