Search results

I'm building a form and I have the following code which works to a degree: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.date_stamp = Now() Me.Export_ctrl = "2" End Sub the code adds a modification date if a record is modified and also flags the record as a '2' which means it has been...

I'm trying to design a query that uses a Boolean expression to create a calculated field that looks at a field to find whether the looked up field = 1 OR 2 I'm not sure on the syntax see below and help me with the parentheses etc: Newfield: IF([Accom_record_card]![Export_ctrl] = 1 OR 2 THEN...

why isn't this working? i've tried load of variations on this now but i can't seem to get my date field to update based on the value in the other field - i can do it with a check box but a checkbox is not what i need to use

cheers I will give these idea a go... thanks i will probably be back soon

lookup table not yet - why? for each record there'll be a certain code - each code represents a combination of criteria - as above - the codes eventually become the related field between this (badly developed by an unknown colleague) flat table access database and an SAP database and a...

eggwater the code will in turn be used to calculate costs though - does that matter?

Okay i will have three or four fields that i need to use to create a new field that shows a code based on the data in the other 4 fields . e.g. if the following is Location field = 'Manchester' Rsidence field = 'Brookfield' Room type field = 'Standard' Bedding type field = 'With Towel' These...

i'm having trouble getting this to work I'm new to VB coding - i've successfully implemented some code before but this is proving a problem

I need a date field in a table that first automatically shows the record creation date - i think i have this sussed - default value = now() etc... however I need this to update when a certain criteria is met in another field - e.g. If field = 0 then creation date field stays the same, if field =...