Search results

Update a table with a selected Field in a combo Box is unsolved and I can not post a reply, I get an error message

On the Book Update/Delete form, I want the On Change Event Of the Authors Combo Box to update the BookLibrary TBL field “AuthorsID” when the user selects a new Author

Choosing an item from the first combo does automatically pick an item from the second combo. This is what I want it to do. The posting is How do i Set the Selected Field value In a 2nd combo box with a field in 1st combo box once a field is selected in the first combo box?

I keep getting the message, Your content can not be submitted This is likely because your content is spam-like or contains inappropriate elements Please change your content or try again later If you still have problems please contact an administrator Even gets it on a blank reply

How do i Set the Selected Field value In a 2nd combo box with a field in 1st combo box once a field is selected in the first combo box? The 1st combo box is loaded with the contents of the Booklibrary TBL, which contains the AuthorsID. The second combo box is loaded with the contents Of the...

I want to update the selected record in a comboBox from a button not add a new record. I can add a record and delete a record.

The Delete code executes for The "Add/Delete Author Form", but does not execute for the "Add/ Delete Binding form.I must be missing some thing.

I want to select a authors name from a combo box and edit that persons name. Example name was misspelled. I would like to add it to the Authors FRM

On the authors form the button delete I have code to delete a record. It works if I select a record from the combo box and press the delete button and press next or previous buttons. It does not work by pressing the delete button alone without pressing the next or previous buttons it takes the...

I have a strange problem. When I copy an Access program, the copy program has some code that does not work. A few days ago the copied program ran fine, did not change the code since the copied program run. The problem code is on the Main menu form, the button is the Backup Data Base Data. If you...

I have a Combo box on the 'Authors FRM' and a button to delete the selected record. How do I code the button to delete the selected record??

From the Main Menu the first time the add a authors name button is pressed, I receive an error message. After the first time there is no error message.

How do I place the cursor on a field on a form when the form opens

I have a query with a date field named 'Date_Entered By Month' in the format of 'mmyyyy' and the query is sorted by the date field. I want the format in the report to be "mmmmyyyy'. How do I write the format statement?

I have this code on a TextBox on a form in the 'On Exit' event. The If (Systolic) > 999 Then, executes and the message is displayed. The focus is not set to the Systolic text Box, it is set to the next text box on the form. I tried 3 versions of the SetFocus. Can any one please tell me what the...

' strSql = "Delete * from [tlb Blood Pressures] where [date Entered] >= " & fromdate & " AND [date Entered] <= " & todate strSql = "Select * from [tlb Blood Pressures] where [date Entered] >= " & fromdate & " AND [date Entered] <= " & todate MsgBox " strSql=" & strSql DoCmd.RunSQL...

Getting this error massage in a criteria field in a query Between[[Forms]![frmSelected_Statistics]![(CDate lst_From_Date.Column(1))] And [Forms]![frmSelected_Statistics]![(CDate lst_To_Date.Column(1))]

trying to split a database get this error message the data base engine could not lock table 'tlbblood pressures' because it is already in use. I am using a stand alone computer. nothing is open in access

I have a text field in the format mmddyyyy and I want to covert it to a serial number.

I am a newbie to Access. I live in the us Georgia.