I am trying to configure my dual nic pc and have run into a wall. I would like use 1 nic for internet surfing and 1 nic to be configured to run VPN securly to my work place. I use a cable modem hooked into a 4 port wireless router. Both nics then run into this router and on to the net. I am able...
Thanks MinusM
That sql worked perfectly.
Your right, perhaps ([start time]-1-[end time] is/was not the right way to calculate time, but, hey, it worked for anything that ran under 24 hours. It was only jobs that ran over that 24 hour time where I ran in to issues.
Thanks again
Kirk
I need to calculate time greater than 24 hours for some jobs. The table data is in date/time format but I can not get access to calculate job run time over that 24 hour hump.
The table data looks like this
Event Start time End time
job 1 7:24:09 AM 3:49:48 PM
I then run a query that gives me...
Hi Sathandle,
Just to clarify, my code has nothing to do with setting up the "AllowShiftKeyBypass" propertys. These are 2 different and equally good ways to do hide the database from users.
Kirk
Hey Jim,
I created a main menu form that opens automatically when the database is opened. On this form are, among other buttons, 2 ones called run time and developer. Run time removes from view the database and everything else except the main menu. Developer button puts all information back...
It sounds like you trying to hide your entire database from users? and only let them see a form to input data.
I have created a database that has a front end form and that is all they see. Only the form. All other information about the database is unavailable to them. I as the author can turn...
Thanks for the very prompt reply Allanon.
One word can make a big difference or no difference at all.
I added your AS SumOfcopies FROM Table6 and volia perfection.
Must have been my brain on snooze, after all I am at work.
Thanks again fhr the post
Cheers
Kirk
I am setting up a photocopying query based on a table with the following criteria.
Date = the date the record is entered into the database.
Center = the center that will pay for the copying.
Copies = the number of copies that were printed for each center.
In the query I can group by center and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.