Search results

ah, therese the code i stole...the one that tells me who is in the database http://support.microsoft.com/?id=198755 My database opens a hidden logout form, if the time of day exceeds the Time i put on a table, then it makes the form visible and starts counting down 3 minutes, after the 3 min...

I grabbed a module a while back from Microsoft's site, i cant remember the name, but what it does is tell me who has the database open (via computer name). The problem I am having is that when the database closes (DoCmd.Quit acQuitSaveNone) the ldb file still shows people logged in. I double...

Just wanted to share. I was tooling around with another way to do this and found a way that I think I like best. I made a query for the table, but set the criteria to Null. When the query opens, it has no records to display so your wheel mouse and page up/down arrows don't go anywhere but you...

I tried this out, works fine as well. Thanks

Opps, I stuck it in the wrong spot. Thanks again

The form itself opens fast and out of 60 users, we only see about 100 records entered a day, so having to reopen it when they need to use it isn't that much of a problem. I will check the Cycle Record out when I get back to work today. What I did yesterday was follow RuralGuys suggestion...

Hi Guys, Once again I am playing with access and have a minor issue that I'm hoping you can help me out with. If there a setting or code that I can use to prevent people from going to a new record? When the form opens I want it to go to a new record (done already), but after that, I don't...

Great idea. With that I can write the error to a table and check a box showing that it errored and why.

Hi Guys, I have an Onclick button that appends info to another db. On occasion, the sql doesn't work. I was thinking of adding some sort of error handling to this to try to alert the user when it fails. It never effects the same user and its somewhat random. Out of 200, I'd say 1 or 2 do not...

Hi Guys, I have taken over a db from a former employee. He locked the databases down by creating workgroups. The problem is that he stored the workgroup on his computer which is no longer available. When I try to modify any of the forms, reports, macros, or modules I get an error stating...

I failed to mention, I did try to use the First function, it chopped 1 record off, but left the others. Thanks for the advise.

Hi Guys, I wanted to delete some duplicate records off of a table. I went through the steps of copying the structure of a table to a new table then setting the Primary Key as what I wanted to be unduplicated. In my case, I have the Primary Key setup as the Account SSN and the Persons ID...

wow, that link is Godly, youda man

oh i suppose all that info is relevant =) access 2000, win2k im using the one from http://www.peterssoftware.com/isd.htm you load up a form with a timer on it on open hiding. it works most of the time, but sometimes it doesn't, im hoping to either fix the one im using or find a better...

what works for me with this issue is trashing the drop down off of the form and recreating it. not sure why, but it works

Hi All, I have been using the ever popular Inactive Shutdown form that I found of the web for about a year, the problem I am having is that it doesn't seem to always work. I intentially left the database open 2 days ago and it still has not shut itself down, its set to a 6 hour timer. The...

great guys, thanks for the help. So my next option would be to Open a Report based off a check box..ok, I modified the form no problem. So my next question.....if you would be so gracious is: How do I use form data as a record source for a Report? I tried putting [Forms]![frm_Name] as the...

ah yeah, that would help, we use Access 2000 at work

Hi guys, I am trying to use the Application.Printer object/function and my access program doesnt have Printer loaded, if i try it, the script fails looking for Printer is there anything special i need to do to make this work?

Heya, Lookin for the VB code to program a button to send a Form to a specific Printer. I know that you can set it in the Print Settings, but I want it to the button directly. Also, if its possible, I need to know how set the Print button to use a specific tray on the printer instead of the...