Search results

Ignore me :D Was just a case of copying the whole code into the forms current event. and seems to work. Is there a cleaner way to do this?

keep short and simple, struggling to find a definative way to input this on web.. i have a combo that is bound to a set list, each selection sets a number of other combos visibility to either true or false. moving records this does not happen. i know i need it to requery but where and how? i...

Thanks By long version I assume you mean that this works anywhere.

I have a case statement to show hide fields as applicable. I need to hide/show a couple of fields in the subform based on the main form selection but cannot work out how i have to reference this in my statement. Mani Form = Record Subform = Record_Cylinders Field to hide = QtyUsedRecovered...

Hi Guys As i showed in my original post, i have a join table already, i understand this. It was the master child fields i dint understand and also because im using two combos in the cylinder sub form from two seperate tables i was struggling to get this right. However, i've now solved this...

Ive done alot of reading and am starting to understand to record source, control source and row source values. However im struggling with the master/child relationship. If i have 3 tables to which my form is produced from: Documents DocumentID(PK) .... DocumentDetails DocumentID(PK)...

Hi James Thanks for the response. Ive worked around this issue by rearranging how the data is stored. However, how would i go about this as im sure its going to crop up once i add more data and have to split the tables again: RefrigerantTable: RefrigerantID(PK),RefrigerantType (at present...

I have a sub form to which the tables have referential integrity checked. There are two PKs in this sub form that i need to update on the fly. the relationship is as follows: Refrigeranttype,RefrigerantID(pk) 1-~ Cylinderserialno(pk), RefrigerantID(Fk), Tareweight, netqty When i add a new...

Hi Guys, After consolidating/rewriting all my sub queries to remove grouping and merge into one on testing I have realised that i need to break it down slightly. Been trying for hours now to get the result I need but now is the time to ask for help. HELP!! Or even shout:p The current Result I...

Right, after just writing a whole post and then the iPad battery going flat and me losing it all :( I'll keep it short. Shutdown day and reserved day I have realised are the same so that's gone I agree these should just be a standalone table to make input easy I do however need to add an...

1: yes day field has the day of the week as a set lookup list, so no need for this then. 2: Different Table_Days will apply to different contracts: For instance: three different christmascalloutdays(daytype) this year will apply to three different engineers(employees) or as we have now...

like this? I see what your saying, your educating me :) thanks

Ive had a change about after speaking to you yesterday, alot of tables gone, i also see what your saying about the day types, ill have a play with this later. How do i go about the attached pictures: Form created for entering holiday information with subform for the dates requested (now a one...

That is correct, shutdown days is when we close up for the xmas period, normally three days per year. If these days fall on a partime employees working days then they form part of their already used allocation of holiday. christmas callout is for our engineers. an engineer is on call for one...

Oh, am i on the right track here for a function: How would i then use the result of the If into another caluclation within the function? Public Function Holiday(ContractLength As Integer) If [ContractLength] / 12 < 1 Then result = 0 If [ContractLength] / 12 >= 1 < 2 Then result = 1 If...

haha, cant win lol. I can see what you say for the year, i can create a lookup list for the field itself. What about this situation: ShutdownDay, ContractDay, DateRequested, ChristmasCalloutDate These are all many to many relationships. Take for instance ChristmasCalloutDate: We will enter...

For now im just focusing on the basis of a fulltime employee, a constant 20 days standard hoilday entitlement factor in years of service (1 day extra for every full year employed (max 5) just to learn how to write a query, a function(thanks minty) Once i am confident on the basics then i will...

Hi guys, thanks for the comments. maybe I'm being dumb, maybe I'm missing the whole point here 😬 Just adding a bit of data to the db then I'll upload. To explain: The point of the db is to calculate employee holiday entitlement for a given year. This can be very complex due to: pro rata part...

Hi All Ive got all my tables sorted now for a work database project but am struggling a little with the query side. Im calculating holiday entitlement for employees based on numerous factors and would like some help combining queries Today is my first day ever writing SQL so please bear with...

Thanks Missed that even though so logical. However iv changed the design of the tables as its quite specific to collection and returns (multiple types of forms) and that way wouldnt have worked with th other info needed. Opened my brain a little tho thnks