Search results

thanks for your reply, the query doesnt take any data from anyother table. ive tried to find a solution to reseting the query, but to no success, if you have any suggestions i be very greatful in hearing them

thanks for the reply, ica nsee the PK in the linked tables, ive checked all of them

hi thanks for the reply, ive checked the primary key in the MySQL database, its present set correctly, the relationships are set up aswell

hi all i have recently migrated my BE Db to a MySQL server, for the most part its stabel a few loading issues which i have resolved, however i seem to have come across a problem i cannot see a resolution to i have a form called FrmManHoursAdd in this form i have a subform called...

ok so i think ive solved it, but just for clarity please could someone confirm Private Sub TxtVehNo_GotFocus() [TxtVehNo].RowSource = "CbxQryVehicleName" End Sub

I've decided to deploy my backend into a MySQL server, and works well for the most part, but there is some issues with load times on some of the forms, so i need to quicken the form loads up, most of my forms are relatively fast in loading, but one of them has 10 combo boxes on it and this is...

Gents thank you very much for this solution, the query one worked a treat, i had tried the IIF(), but missed out the VAL part of the function. every day is a school day

here is the form and sub form plus tables and queries

is a screen shot ok?

ive tried all of the suggestions, but nothing is displaying, but i also get no errors, not sure what im doing wrong. not sure if this makes a difference but both these fields are on a sub form, displayed on a main form, but both forms are not bound, TxtUnitStatus is an unbound text,

thank for the reply, ive tried that its still not displaying anything, the only thing i havent mentioned incase its causing the probelm, the textbox is unbound.

thats the first way i tried it, still didnt work

hi all i have two text boxes, TxtOpenStatus and TxtUnitStatus when the TxtOpenStatus is 0 the TxtUnit Status should display "Serviceable" and if its 1 or above, then it should display "Out Of Service" heres what ive got so far but it doesnt work, any advies would be appreciated Private Sub...

thank you, thats worked a charm!!

hi all i have a piece of VBA that converts a form into a PDF and emails it to a recipient, what i cant find or do , is change the layout in side the .Body of the email How do i go to the next line for the email, so for example Hi All, please find attached info Regards

hi thanks for your reply ive tried that, but it doesnt return what i want it to. what i need is for it to return no records when all of the parts are assigned to vehicles, so when the most recent record for TblPart.SeriaNumber where TblEventPartLocation.Vehicle_IDFK has a value and...

Hi, im trying to create a query that will return the most recent record based on a unique number here is me table set up TblEventPartsLocation EventTrackableParts_ID EventTracker_IDFK Vehicle_IDFK Part_IDFK PartLocation_IDFK TimeStamp TblPart Part_ID SerialNumber Quantiy TimeStamp...

thank you for the reply the reason for the TblPartLocation is for traceability of the part, so i can track where the part has been, ie what vehicle,

Hi all, im trying to create a model to manage parts from one location to another, two locations are either on a vehicle or in stores, im currntly trying to manage it like this TblEventPartsLocation EventTrackableParts_ID EventTracker_IDFK Vehicle_IDFK Part_IDFK PartLocation_IDFK TimeStamp...

thanks for the reply, do i need to open/run the query in order check the query?