Search results

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.

training as in physical exercise, like boxing training?

You can't do it quickly Add the drop down menues to your form and a button. On the button click event you build the SQL string of the query you want to run. I.e. Dim sMyQuery as String sMyQuery = "SELECT * FROM MyTable WHERE YourField = " & me.mydropdown1 & ";"

Your problem is not totally clear to me but it doesn't sound like there should be any problem.

Look into using unbound forms or catch the before update event of each field.

If you are struggling writing a large qurey with many tables and joins then you can try writing it in parts. Write a query that joins 2 of the tables, get it working how you want call it query1(no don't call it something sensible and meaningful) then do another query joining 2 of the tables...