Recent content by thinair421

Thanks for the replies guys... I have sort of rethought this whole process. The reason behind doing this was so that after a year, we could store all of the data in a yearly folder (i.e. Data 2010) and basically restart the program. I am starting to think that maybe just saving a "backup copy"...

I have a database with roughly 100 tables in it, and I would like to essentially "back-up" all of the data in the tables by exporting them to excel spreadsheets (one spreadsheet per table). I know I could manually export each table one by one, but this is not really what I was goin for. Anyone...

Alrighty, did that. No longer asks for a password on the "busted" computer, but still no <Tools> option in access...its still gone. Any suggestions now? EDIT: On my computer it is saying that I don't have exclusive access to the database, and when I try to save its telling me someone else has...

OK so i opened it on another computer on the network, and logged on (to windows) using the same login i used to create the database in. Database no long has any security on it, and I have all admin rights. What is my next step here to safeguard my database from what almost just happened, and...

So, I have a rather huge problem right now. As of this morning my database was unsecured, so I decided to try and mess with/get used to the user level security settings/wizard...maybe not the best idea. What appears to have happened to me is that I can no longer edit my security settings because...

Excellent, thanks a bunch man. Really appreciate all of the help. I'm actually toying around with Access' security features right now, trying to weight out my best option here.

So my VBA knowledge is very limited (non-existent), this is my first database, and I'm currently not running the database on an SQL server so I'm not sure the effect that will have on this...but here is what I can tell you. The login form/table that I have created is based EXACTLY from this...

Sorry about the delay on my reply hudson... So I had actually never heard of an append query before (and I'm pretty bad with queries overall) so I read up a little more on how to create one. Only issue I have is which tables I am supposed to select upon creating the query, since as of now the...

Hey everyone, I currently have a login form. Consists of a username combo box which gets the UserID and UserName from a table (call this the UserName table...the UserLog table is different!...see below). Below is a password form, which of course the user enters. Upon clicking the Login command...

This works some of the time...but it still isn't quite right. There is still "missing pieces" around the boarder of my switches background (detail section background) which appear in random spots and sometimes there are scroll bars and sometimes not. I put the code under the switchboard form's...

So I have a password textbox where the user enters their login password into. After they enter it, if they press enter it essentially "highlights", or gives focus (as if I tabbed over to the button) but doesn't actually click/activate it. Is there a way to have the 'Login' button activated when...

Hey everyone, Got a little problem with my switchboard... When I start my DB it goes to my splash page, then to a login page, then finally to my switchboard. Switchboard looks great when it is first opened...(maximized, no boarders, buttons aligned). Heres the problem... As soon as I click...

Bob, Genius work man. It's doing exactly what I wanted it to. Many many thanks.

Sorry about the above post...didnt know you replied already. Anyhow I just read your post, and everything makes perfect sense, however I am pretty new to access and slightly confused by #5...I just want to ensure that if the user goes back on a record that the date is not overwritten. I'm...

Bob, OK your original coding the Before Update box worked perfectly, I just had it updating a different field (not the date) on accident. It works great now, my only concern is still if the user goes back to previous records, will they be updated to the current days date?