Search results

It is just one table that I want to delete from. It has 13 fields. 3 of the fields can change based on your job, section, and team. I need to be able to look at the personal data stored din another table (this is the data that shows the current job, section, and team). Based on those 3...

Hello, I have a DB that tracks training for my company. In the DB, training is broken down 4 ways. Required for all, for specific job, section, and specific team. My issue is that people occasionally change job, section or team in the company. I need help finding the records that are no...

My code looks like this now Option Compare Database Public Function TaskUpdater() If Time() > "9:30:00" Then DoCmd.OpenForm "frm_training", acNormal, "", "", acEdit, "" Form_frm_Training.btnAddUpdatedTasks_Click End If End Function

I did that and got a complile error, member not found. Then I remembered what you said that it had to be a public sub... so I went and changed it from private to pubilc. Now, I get a type mismatch error. Ideas?

So, I heard from a local friend something about set focus on the command button and then sendkeys mouse click... can that work?

I already have a hidden form in the background that keeps users from closing via the close button because I have an on click set up for an exit button to copy the DB to a seperate location. With all that said, I want this event to happen on close(before my DB copy) if the time is after 1630...

I am trying to set up my database to check the local time and then, if the time is after 16:30 run an update. my update is a form that runs from the on click of a command button on another form. My question... after searching the forum and finding nothing, is... how do I make access click the...

I found a threat that had that code specifically, I posted there... it is in macros under ribbon. Can you help on that thread, I have no response in it yet. The macro works when I run it manually, but not when it runs auto on open.

sweet, thanks... here is my code, can you tell why the ribbon is still visible? Option Compare Database Private Sub Form_Load() Me.Visible = False DoCmd.OpenForm "switchboard" 'hide the ribbon DoCmd.ShowToolbar "Ribbon", acToolbarNo End Sub Private Sub Form_Unload(Cancel As Integer) If Not...

It works when I run my macro manually, but does not work when the macro runs on it's own on open. Help?

done... I have put the action to openform, chosen the form and changed the mode to hidden. Next?:)

Access 2007. I already have a new form made.

exactly, now how do I do that? I load my "Kick-Em-Off" form hidden (How do I make a form hidden? How do I make it load on open?) with the AutoExec macro. (How do I make the macro?)

ruralguy... fancy meeting you here. In the explanation above, can you elaborate for me? I need to do exactly that, but am still in the dark as to the whole working.

I am not near as savvy in access, can you hook me up with a little more detailed version of how to do this from scratch? How to make the form the way it needs to be in the properties and such?

I moved the backupcopy above the "If me.dirty" and now it works. I have to admit, I am not certain why... I think it may have something to do with the order access is processing the code. Thank you for all the help and patience, now I begin working on automation. How do I make an event run on...

OK, still lost here. My limited understanding tells me that the function name is backupcopy() is that true? It is in the 2nd line... "Public function backupcopy()" Am I still misisng something?

so, backupcopy.newdb where newDB is the name of the module?

Got the runtime thing. Where you ask "What is this?", that is the name of the module the function resides in... how am I supposed to call the module into action? Second, what is missing in the function?

Also, how do I program something to run automatically on a set time? Specifically, I want to have a module run at midnight that checks a certain table for updates and then applies those updates to the records it applies to.