Search results

Done it. Been an idiot. Code is simply: - Private Sub ChkStartForm_Click() If Me.ChkStartForm = True And Me.Text127 = "Sharps" Then Me.Frm1Q1Response = "N/A" End If End Sub

*SOLVED* Hi All, novice I'm afraid. Issue I could do with some help with is all on a single form. I have a checkbox called chkStartForm and a Textbox called Text127. I want to auto change a combobox called Frm1Q1Response from 'Yes' to 'N/A' if the Checkbox is Clicked AND the Textbox has a...

To follow up on my last reply and to as to assist I have attached a File which shows the table issue. Again thanks.

Hi CJ_London, Thanks for the suggestion. Just did that and no luck. The + is still there. Must admit I had enforced integrity previously and had no issues. Any other suggestions would be gratefully received.

Hi. Many thanks for the quick reply. Before importing the data the + Sign wasn't there and I could 'pull up' records. Now those records, when chosen from the drop down list, are no longer shown and a blank form with NEW is shown, not the record. Before the import the table did not have this +...

I have a new database. I've imported data from an Excel 2013 spreadsheet to a Table (Contact) & obviously not being, it would appear, at all proficient I seem to have caused an issue with 'pulling up' data stored in the tables via various forms. This issue is not limited to the Table I...

Thanks for the advise. My query is only to show the absolute last record saved, using this to populate a field in a form. If I use a date this will it not return all records for that date (unless I use date & time) and may relate to a number of different invoices for that date. I was...

Many thanks for this & taking the time to reply. Couple of questions, if I may: - I'm assuming this relates to the query element of my question. I wasn't using a date presently in the table, just AutoNumber as Unique identifier (& highest number to identify the newest invoice). Is using...

Hi All, I'm a novice to this (last used access 5+ years ago [97]) so please bear with me. I'm trying to create in access2010 (1) a query that returns the latest record (newest) in a table called 'Invoices' and then (2) places this value in a form called 'FrmInputInvoices' as the...

Hi All, Not done this for many a year. Used to be ok at Access along time ago but decided to start again. Suspect my postings will be very basic - so much has changed.:) Helpee

Welcome. Now that sounds very familiar. My angle too as not done this for years Helpee.:)