Search results for query: *

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.

Thanks PHV...I will gve this a go

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

Phew MajP that is some coding..I will give it a go...thanks for your help

Dohhhhh!!! thanks GingerR I should have realised.

Is it possible to disable the right click option on an MS Access report?

Thanks MazeWorX but I am floundering, but your still a star for helping me.

Thanks MazeWorX, this is gogin to be tough. I have tried creating a dummy table and reports to see if I can hang them together. Is there no chance of the tables (without data) as I could easily populate them myself with dummy data

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 think I will stick with the latter option, in just activating when I publish. I have a habit of keeping several copies so I will keep it smple I think. Once again, thanks for your help

This works fine...I just need to make sure I have a backup and I remember where my hiddin button is...

Thanks PHV...I will try that instead

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...

Thanks lameid...I will try this and get back with the results.

How can I stop people using the BREAK (shift) key to open Access in edit mode? I have tried this in the past but failed!!!

I will.

After a bit of tweaking, and with your help, I got it to work. Thanks very much, your a star

I have a query in Access which for this example has one field, IP_Address. I can issue the like function as below: Like *.*.40.* and this will show me all IP_Addresses on the 40 Lan. Likewise, Like *.*.200.* will show all the IP_Addresses on the 200 Lan. As there are many of them and they...

Still no luck I am afraid. I have to be truthful at this point and mention taht I am not a VB expert and I believe SPLIT is a VB function. I am trying to do this this in a query or Event Procedure within Access. I understand there is a similar way of doing this in Excel, but alas I am unable...