Search results

This is an A2 project? What the hell did you do for A1 then?! Bloody heck. Personally, I would forget about hooking into the telephone (by whatever means) and just ask them for their contact number. Much easier. And it's what my local pizza place does. :D

It's not advisable to compact via a macro, just do what mailman said :D

Of the form I guess. So every time you change record, the qry will run. No idea if it's right, just throwing ideas out there.

Nothing ever looks "right" the first time you do it. Input some dummy data, say atleast 10 records to see how the relationships/design works out.

I finally did it - haven't opened Access all day. I was fed up of it, and I've only just right now did it. First big clue was namliam info about FORMAT returning a text string, and not a Date/Time value as I thought it did. This is what was royally buggering me up the arse. So my 3rd query...

Just dumped in the current working SQL statement and it's picked up no errors. Will have a play tomorrow at work too. Thanks for that link :cool: Doesn't look like this is possible to be honest, or atleast not with Time.

Something over VOIP maybe? No reason why you shouldn't be able to hook in whatever program for VOIP and yank out the number.

Whack that code into the OnCurrent event?

LMAO. Thats what staring at horribly written SQL statements will do to you. Send ya loopy! :D

The query is fine. Here is the SQL for that query... SELECT Bookings.Interpreter, Bookings.DateOA, Format([EndOA]-[StartOA],"hh:mm:ss") AS TimeDone FROM Bookings WHERE (((Bookings.Interpreter)<>"Agency A" And (Bookings.Interpreter)<>"Agency B" And (Bookings.Interpreter)<>"Agency C" And...

Wouldn't Format(<fieldname>, "mm:ss") work?

I would start with: tblMovies tblGenres tblRatings Then fill in 10-20 movies, and start experimenting.

This is what is happening, no idea how to resolve it though. I've renamed the offending fields to DateOA, EndOA, and StartOA. Still getting errors. [TimeDone] is the field created in the query. It is obtained by [EndOA]-[StartOA]. All of the data contain in those two fields are times, and...

This should work right? SELECT Interpreter, AVG(TimeDone) FROM qryForMack GROUP BY Interpreter But that is STILL returning errors. I've tried enclosing (TimeDone) in Square brackets. And it STILL spits an error back at me. I'm going loopy trying to nail this. I'm "stacking" queries. By...

Sorry mate, you are gonna have to spell it out for me. My brain has turned to mush trying to do this. Every which way I try I always end up with the 2 same error messages.

Tried that aswell. Errors out! This is driving me nuts. /me going nutty

Change the Control Source to: =Format([your_field_name],"dd/mm/yy") PS, I hope this field in question isn't called/named Date. That is a bad idea. Call it something else DateOfBooking or DateOfAppt etc etc. Date is a reserved word in Access, and it may through a wobbler later on down the line.

I was tasked with finding out what is the average time “Int X, Int Y etc etc” did in all of the five weeks in October 2007. I was able to narrow down most of the records (from a 6500+ record DB) using a simple query. Gives… (Coloured blocks represent a single interpreter) But what I...

Simply open the table and add the new field in design view. Then in the form, click on the 'Field List' button and drag the drop the field onto the form.

Thank you to you both.