Recent content by cuttsy

When you say the textbox is set to editable do you mean .Enabled = True and .Locked = False

Yes, sorry about being vague. I have some combo boxes that are used to build an sql string which is used to populate a list box. I was hoping I would be able to somehow use this same sql string to print the contents of the list box. Or even create a querydef and print that. I was hoping to...

Is there a way of doing this without crating a report?

Thanks, I just had this pointed out to me. That was a giant pain in the ass! I knew I was doing something daft. Thanks.

Couldn't get that to work. I have tried it with a siple query and even this rounds to an Int. SELECT PupilRegister.Pupil, PupilRegister.Activity, CDbl([Duration])\CDbl(60.0) AS Dur, CDbl([Preparation])\CDbl(60.0) AS Prep FROM PupilRegister; I'm getting very frustraited, It can't be this...

This seems a daft question but I have searched the forums and can't find an answer so I hope someone can help me. I have a table: Register(RegID, Pupil, Activity, Duration, Preparation) I have a query that I want to calculate the total hours the pupil has spent on activities. The Duration and...

Thank you. Got it working.

I don't realy know how to explain this but a college of mine has done something to her Access settings, whenever she tries to open a database it asks her for a User login password. The prompt is a box with Name: Centre Manager Password: If she types Centre Manager in the password box then it...

I would be very carful about your Female = Mrs assumption. Some people that go by the titles Miss or Ms I have found can be offended.

I have a form with a print button. When pressed it runs of a set of labels between 2 dates. I wish to keep a log of the print jobs that are done. Storing the date and time that the print was done, who did it and (The bit I can't figure) the date range of the print job. I am trying to make an...

I don't tend to use OLE objects I just have a string field with the location of a jpeg. i.e. C:\Images\BusCards\mybusinesscard.jpg

Give this a try. SELECT IIF(ELIGVENDORS.TITLCD IS NULL, [ELIGVENDORS.LSTNAM] & [ELIGVENDORS.FSTNAM], [ELIGVENDORS.FSTNAM] & [ELIGVENDORS.LSTNAM]&", "&[ELIGVENDORS.TITLCD]) AS [Full Name], ELIGVENDORS.YourOtherFields FROM...

Job Table J1, Do something, 01/09/2006, 05/09/2006 J2, Do Something Else, 01/09/2006, 02/09/2006 J3, Do Another Thing, 02/09/2006, J4, And Another Thing, 02/09/2006, 04/09/2006 Staff Table S1, Joe, Bloggs S2, Jane, Doe S3, Alan, Smith Assignment Table S1, J1 S2, J2 S2, J3 S3, J4 If you store...

Would it work if you just had a Job table, Staff table and Assignment table? Job(JobID, JobName, Started, Completed) Staff(StaffID, Firstname, Surname, JobTitle) Assignment(Staff, Job)

So in one of the tables your Primary Key is a composite key.