Search results

Hi, Something weird going on! On my main form I have a subform which holds two table values. [Roles] & [TrainLevel] example of this looks like this: Plant Manager - T1 Assistant - T2 and so on for about 12 rows with different roles, each with different training levels. This subform...

Anybody know how this works out? INSERT INTO `MyDatabase` VALUES (1, '3454', 'nneqinexdtdthkdse'); The answer = Aardvark Its from a course a friends doing where It gets to inserted into mySQL database, 1 being the ID. Not sure what the other values will be but the text should then be scripted...

Hi need help I have a couple of fields in a query, [RegistrationDate] and [ExpireDate] Person completes a course and enters the date in the RegistrationDate field which is a form textbox. ExpireDate is the calculated base on a number of years I've added as a validation period. eg.. 2 years So...

Hello People, I'm in need of help, just can't get my head around why this doesn't work? I'm dealing with 3 or 4 fields names, Indate: [ExpireDate], [CurrentDocVer], [TrainedVerNo] The idea is: If the [Expiredate] is > than today then the named field Indate: replies "Expired" else "Live"...

Hi, Been pondering over this problem for some time now! What I'm trying to do seems quite simple in my head and happens lots of times in lots of applications. Copy and transfer selected data like names from one table to another. I have one table called "Attendees" which holds peoples names...

Hi, Been pondering over this problem for some time now! What I'm trying to do seems quite simple in my head and happens lots of times in lots of applications. Copy and transfer selected data like names from one table to another. I have one table called "Attendees" which holds peoples names...

Hi - Can anybody please help with this? Im trying to transfer some Access table values into an excel spreadsheet - Its been working for a good few years but all of a sudden and I think since converting from Access/Excel 97 to 2003 this part of the transfer has stopped working. Error msg says...

Hiya! I'm currently in thought mode on how do I do this in Access. I'm collecting data for tankers coming on site. I'm interested in the date when the tanker arrived and also when it leaves site. What I then to do is work out how many days the tanker was on site for. (I can do this bit)...

Hi, Struggling at the minute with this problem. I'm trying to open a form and filter the table contects depending on which button is pressed. eg. Once the main form opens, I only want to see records that contain the products for the given button that’s been pressed. eg. Button 1 pressed =...

Hi - Need some help - I have a subform called [Attendees Subform] which loads in a main form called [Attendees] When the subform loads I have it set with a default view datasheet. One of the fields within the subform is called [Indate] and would either contain the words "Live" or "Expired"...

Hi - I'm stuck again!! I'm trying to setup a print preview option for a report based on two dates. User is asked to select a Date from: and Date to: from two combo boxes. This bit works fine and gives a report based on the two dates. In addition to this - I'd like to also be able to select...

Hi - I have a subform which stores 2 bound fields and 2 that are populated via an iif statement based on the 2 results from the bound fields. What I'm trying to do logically sound quite easy - Getting access to do it is another thing. Bound field 1 = [date1] Bound field 2 = [course length]...