Search results

Ok, thanks, that does make more sense. How then do I get it to delete the record that is currently selected in the form's list box, then? Is that what your "me.SomeTableID" handles? Does the "me" grab whatever record is selected? Thanks.

Ok, right. So, debug kicks me to the line highlighted below, which is kind of obvious, as that was the error, but that doesn't help me determine why this command isn't available? 'Delete Currently Selected Task Order Private Sub cmdDelete_Click() On Error GoTo Err_delete_Click Dim...

Could you point me to a resource showing me how to debug to determine where the error occurs? I am pretty new to Access, and if I knew how to determine where in the code the error pops up, I might be able to figure it out on my own... I can tell you that the error probably occurs in the delete...

I have a form for an administrator to manage task orders. It is composed of a list box and some text fields to modify the currently selected task order in the list box. There is also a button to delete the currently selected t.o. record. I have very similar forms for other things, such as...

Here is my code for one of the forms. On this form, there is a "cancel" button that runs cmdCancel_Click(). On this button, I have the cancel property set to yes. Could you help me determine where it is that I am getting this "The OpenForm action was canceled." error when I press the escape key...

No worries. Thanks for your time. It's Access 2007. Basically, when I click on my "cancel" button in a form, in the "Other" tab of the properties there is an item called "cancel". Setting that to "yes" should denote that that button is what will be triggered when pressing the escape key in that...

Sorry. I wasn't very clear. I had a custom "cancel command" that does as stated, but in the windows where I'm having trouble, I set the cancel property to "yes." This allows typically for the command or button with the cancel property set as "yes" to be triggered by pressing the escape key. Some...

I have some forms in my database that have the cancel command (which closes the current form and opens the parent form) set to "yes". Some work as expected when I press the escape key, but some return an "The OpenForm Action was Cancelled" error and terminate the session. Any ideas on what/where...

Yeah, it's just going to be the amount of standard working hours per month (based on 40 hrs/week minus holidays). Yeah, if I could straight-up automate it, that'd be best! I'm just too new to Access to know how to do that. Could you point me in the right direction to do that?

Ok, thanks. So, in my add new month working hours form I wan the user to be able to select the desired month from a list of the twelve in a dropdown. How can I display all 12 possible months without having them stored in a table? Thanks. Also, with those date functions, can I just use that in...

@John Ok, thanks for those functions, I wasn't aware of those. @lagbolt Thanks, I think I'm tracking with you. That MonthName function looks like what I need, and, as far as time being a dimension, I agree with you, I think. So, basically I would just need my tblMonths storing MonthID...

I am new to Access, so bear with me, please. I have the following database setup: tblMonths MonthID (unique ID for a specific month instance) Year (year of specific month instance) MonthNumber (1-12 representing actual month of specific month instance) Hours (working hours in specific month...

sweet, great tip.

Wow, ok, can you tell I'm new to Access? That worked easy. Thanks for your help!

I am not totally sure what you mean. This is my VB code: 'Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer) ' ' If KeyCode = vbKeyReturn Then ' Call cmdLogin_Click ' End If ' 'End Sub

I have a login form that handles the "Enter" key always selecting the "Login" button. However, when incorrect credentials are provided, a pop-up is displayed notifying the user. When pressing "Enter" on the pop-up to select "Ok," the keypress is carried through to my login form, thus trying to...

Ok, so, when the db is opened, a user logon form is the first to open. The load event for this form that throws error 3265 even when the back-end db is found is as follows. Private Sub Form_Load() On Error GoTo Err_FormLoad Const conLINKED_TABLE As String = "tblUsers" If...

Ok, thank you. So, I am using the code in the first response here to check before my user logon box pops up whether or not the back-end database can be found. http://bytes.com/topic/access/answers/866587-checking-linked-tables-startup It is throwing code 3265 even when the back-end database...

Thank you so much! I'm new to Access. Does using the shift key just disable anything set to run on launch?

I have developed a VBA check on launch of my Access 2007 database application to see if the linked back-end database is found. Something is wrong with my code, and now I am locked out from editing my database. When I open it, I get my vbCritial message box notifying me that the back-end db is...