Search results for query: *

Thank you all for your help!! QB

Hi all, Can any one please help me how to check which computers/users are currently access to the Server? Or is there any way to view the event logs which users have logged on/logged off the server? I appreciate any help QB

Hi all, I have been able to get the maximum value in a WORKSHEET by using LARGE(array,k). However, I could not find the specific cell where the value locates. Can any one help me here? Thanks QB

It works very nice. I greatly thank for your help

Thanks for your response, PHV I coppied "EndTime/86400, "hh:nn:ss" to Format. I tried to type 200.36 (in second). When I review it, this line "(EndTime/86400 hh:nn:ss)" appears, and when I click on the field, I can see the number that I typed. When I click on different fields then the line...

I'm not really familiar with coding in Access. I don't know where the code suppose to be. Could you please tell a bit more how it's gonna work. And what is the field is double, is it should work with the same coding. Thanks

Hi all, I have a table with ActionID, Date, StartTime and EndTime. The start time I have is in time format. The end time which is the duration of action is in seconds. The question how to convert it to HH:MM:SS format Thanks for any help

Hi all I've been searching in previous posts, could not reach the right solution. I have a combo box which looks up data from another table and a text box for date select from a calendar in main form. I want to search for a record base on the combination of these two fields to display in...

I'm thankful to join this forum. I owe ton of thanks to both of you, Remou and Roy. Thank you again

I was unsuccesful, there are only File, Edit, Insert, Records, Window, and Help appear in the Menu bar. Is there another solution? I'm crying

I need an urgent help here guys. I have made a copy of my database and tried the Tools/Startup option. And guess what.......I delete my original DB, now I only I an uneditable version left after playing with Startup option. Can anyone help me how to get the full menu bar back. Any help would...

I think I figured out the way. Thanks a lot for your help, Remou

Yes I did. I did both, right click on each specific table and also mark hidden from Tool/Options/View. Thanks for mention the word "front end", I could not even think of the right words

I did all that before I posted this question.....which didn't do what I want. Cuz I see some database have nothing but forms are visible, mean users can able to see and access forms only. I check the Hidden objects and select Run permissions as User's. I still can see all my objects. Is it weird?

I have a sily question. How can I make all tables, queries,... disappear in a database except for the form only? Anyone could help me, please

This is it. Thanks a lot

Hi all, I have problem with form creation in Access. As I know, if we have a form and want to add combo box, list box, or command button by click on each from toolbox, then we click on the form, the window wizard normally pop up automatically. I don't have that option work, although I tried to...

PHV, I have a blank there. Is it what I had missed making the code doesn't work???

Thanks PHV, I tried the code you post, no matter what HearderName I tried, it still give me deatail of the first record. The combo box's control source I have set = HeaderName, Row Source Type = Table/Query Is there any mistake here???

For more information The error I had is________Run-time error '94': Invalid use of Null