Search results

Problem solved...By me.

Hello David, hope you can help. See attached. Pic1 shows a screen shot when access running. The idea is after selecting SOP on the right, the roles subform adjusts to suit the level of training required for each role. T1, T2, T3 or Not required. Pic2 shows I have IDs selected to populate the...

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...

Galaxiom, Thanks for the reply. I so glad you know what your talking about. I kinda see what your saying but I'm still not with it. I've posted a couple more examples below, I don't expect you to answer all but if you could give me a couple more examples would be great. What do you mean...

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...

namliam, thanks for the reply. Sorry I didn't know there was another way to store date values other than using a textbox, which has been assigned as a date value. Can you please explain how and with what I should use instead of a textbox? I can appreciate the Format(date(), "YYYY") statement...

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...

Mihail, thanks for the speedy reply. I have looked closely, What's wrong with this? Indate: IIf(Nz([ExpireDate]>Date()),IIf(Nz([CurrentDocVer]>[TrainedVerNo]),IIf (Nz([RegistrationDate]=""),"Expired","Live")))

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...

VilaRestal, thanks for the help... I've call the people names listbox - [lstWanted] with 2 columns showing AttendeeFirstName & AttendeeLastName. For the Events form I only need to see peoples names that have completed the course so I'm just showing their names which at the minute its...

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...

Hiya Bob - Any chance you deleting the zip file database from the reply post

DJKarl - Thanks for the reply... Its all working ok now - lines removed and your right made no differance. Thanks Mike

c'on people - can't be impossible surely? I just want to copy some Access table data into excel named cells Just don't understand this Error msg "Application-defined or Object-defined error" Mike

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...

Hi, If a tanker on site for 30 days then you were right in the second part. (14 * 70)+(14 *60)+(2*50) Mike

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)...

Thanks for the link buddy - All working a treat now. Mike

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 =...