Search results for query: *

Thank you all for all the answers. I haven't had time to test them (programming is secondary to all my other duties). The search for similar thread function wasn't working when I posted this yesterday but since then have found other answers so I am confident I will make something work. Thanks...

is there a conversion process built into access (or can be coded in) that would allow the entry of time to be left in hours and minutes and calculate the difference on it. Example the difference between 2:15 and 1:45 is 30 minutes. Of course 215 minus 145 is 70. Short of converting time to...

Thanks Randy - i think that will work. i have so little time to try these things it takes me a long time to respond.... but i do appreciate your input. Peggy

I am in design on the form. I use command button wizard, select miscellaneous and run query. Delete queries are not listed - just update, append and select. That, basically is my question. I am pretty new to that and like to keep things simple. Thanks, Peggy

I am using an unbound form to set up command buttons to run a series of queries. Why won't it let me add a delete query to a command button? Is there a way around it? Thanks, TVT Peggy

I feel so utterly stupid. I have gone thru and thru the wizard but NEVER clicked on the Miscellaneous Button. That is just what I needed. Thank you so much. Peggy P.S. The other way you mentioned looked way scarey!

I am doing a switchboard with an unbound form using the button key off the tool box. This opens forms fine but I want a button to run a query and I don't know how that works. Thank you, Peggy

Thanks PH - your suggestions led me down the right path. TVTPeg

The responses both dwelled on "direction" but I never used that word and isn't relavant. Here is an example of what I mean. Client: Joe Smith Pickup Time: 10:00 From: 123 His House To: 456 Doctor Lane Return Time: 11:00 and now with a command button create another record with this info...

In a scheduling database for door to door transportation I would like to create a return trip record by duplicating all of the original trip information EXCEPT reversing the from and to destinations and moving the the return time into the pick-up time. This would be done with a command button...