Dear Tek Tips
I am looking for a good source (preferably a book) for all SQL DBCC commands and their uses.
Does anyone know wher I could get one and what it would be called.
I have a database which is holding time in and time out fields.
I can create a query that lets me create a calculation between these two fields, [timeout]-timein] however, I want a cumulative of those times.
An example might be:
TimeIn TimeOut
04:15:00 08:45:00
04:15:00 09:15:00...
Is there such a thing in Access as Mouse Hover. I want to be able to place my mouse over some text and an infomation box appear showing information about that item my mouse is hovering over and then moving the nouse to some other text, have a relavent message appear for that
How can I create a query by using the multiple selection option of a Combo or List box.
Say I have three fields:
Name
Address
Phone
I want to select Name and Address and create a query by selecting those options from one of the boxes above and then select Name and Phone and update the query...
I have some code (not written by me I hasten to add)for issueing and accepting a password from a MS Access TAB CONTROL ...When I input the password it still appears as full text, how can I fromat that part of the code so I am typing in * as is normal practice for PASSWORD entries...
I would like to be able to extract a part of a string (IP address) and strip out everyhting around a certains value. For example, I have an IP address 192.168.200.34, is it possible to only extact the 200 part and drop things either side including the periods (.)?
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.