Search results

hi so i have a form with 8 unbound sub forms, each sub form is attached to a select query, each query is filtered uniquely, such as one date field is filtered to show just todays events, the date that is displayed in these sub forms can be changed for the source table, so i need the ability...

just a quick update i have resolved this issue, which was, it wasent saving the primary key, from the main form, this was being caused by, a field that was being auto populated, it was a Date field, because there was no input it wasnt assigning a new id to the form

yeh, thats what i have been trying to do, but i am unsure as to why its not creating a new deepclean_ID

yeh thats right i've added a button, in frm_Main, so you can see a new record being created, youll see it doesnt save the deepclean_ID

open form_ENG_MCU_NewDeepClean normally there would be a button, with and openform function attached to it

sorry, there was a query missing, ive uploaded a new version

thanks for the reply ill be montoring the upcoming deep cleans, with come query calculations, thats not the issue. when i save the form, it doesnt seem to save the deepclean_ID, in table_deepcleans

there is also standard cleaning, but that wont be captured on this database, then there is external washing, which will be captured the deep cleaning is based on a time scale, every 70 days external washing is every 7 days ther difference between two and three vehicles being cleaned per night...

ok, so i work for a railway, there are 149 vehicles, and everything is captures against the vehicles. one aspect is the vehicles require deep cleaning every 70 days, and it varies between two and three vehicles being deep cleaned everynight

so i have set up a many to many relationship and a form bound to a query to capture the data in the form, there is a sub form, the form is to capture cleans on a vehicle, the sub form is what vehicles are being cleaned when i save it, the junction table updates fine, but the deepclean table...

thanks any chance for the long answer :) how would the query go?

hi thanks for the reply this is not really an option to apply a second field. there must be a way of filtering the data in the query without this second field

I have a query with a number of fields and i want to filter the data based on a date and time filter. the filter needs to be between 02:00 today and 02:00 yesterday there is a Date field and a time field do i have to filter each field separately ie date field "between Date() and Date()-1"...

LOL ive sorted it now thanks

i dont understand how it references the user who is being created, as appose to the user who is creating

Hi i have a sub which creates a folder based on the active folder, my question is how do i make so it creates a folder when a new user is added to a table Private Sub btnSaveClose_Click() Const strParent = "\\dlreng01\Roberts$\Access\Images\" Dim struserID As String Dim strFolder...

hi thanks for the advice this is what i did to begin with, i do understand my database, maybe i should have been a bit more descriptive, i thought referencing the vehicles as customers, would have made more sense as i assume most people use a database to manage customers, order, sales etc

hi thanks for the reply when you say 4 vehicle fields are you talking about the table "Table_Vhicles"? the IDFK is the ID foreign key i am developing a function to manage images with out storing them in the tables

hi right i get ya ok so everything is stored against the vehicles so in this instance the vehicle will be the customer so all exams are carried out against the vehicles, but all types of exams can be carried out against the vehicles (many to many) when events occur against the vehicle, all...

hi sorry in dont quite understand the question, do you mean, you wish to know what industry i work in?