Search results

Hi all, I have a form, with subform as datasheet. I have successfully exported filtered data on the subform to excel. Ultimately I want to export the filtered data into a mail merge and selecting a template stored somewhere on a network drive. But first I am trying to perform a simple task...

Good morning all, I have a form which allows me to delete some records from it but not all of them, with the latter producing an error 3200 The Record Cannot Be Deleted or Changed because table "tblMain' includes related records. My database structure consists of 3 tables, with tblMain on...

Good afternoon all, I have built a DB with a series of forms and I am looking to output data to excel. I have a main form containing some buttons and a subform which is a datasheet. I can filter the datasheet using the datasheet filtering properties. However when exporting that...

Hi all, I have created user input form and to help with ease of input, I have decided to pull records in to a list box, user selects an item and the item updates to the bound text box field. The textbox populates but produces an error and I cannot continue unless I clear the text box. run...

Hi all, I have a listbox on my form which initially pulls in data using a query as it's rowsource. To help with filtering, I have put numerous comboboxes on the form. The comboboxes are populated using data in two other tables. Once a selection is made, using the SQL in my query mentioned...

Good morning all, I have a bound continuous tabular form, that pulls in my data that I need. However, based on data content in one field of a record, I want a checkbox in the same record enabled, so the user can check it if necessary. I have created a record set using the form as shown...

I have a form with continuous sub form. The main form contains a combobox, populated from a query which pulls in specific data (time) from a table The subform is linked to the combo box on the main form. Based on the combobox selection, the subform updates with associated records with the...

Good morning all! I have a listbox on my form, which has a column count of 2, and widths 1.7cm, and 15cm respectively. The width of the listbox itself is 9.2cm In form view when the listbox is active, there is a horizontal scroll bar, it does scroll to the left, but not right to the...

Hi all, Is it possible to run a basic select query to pull records based on multiple strings entered by a user? I have a query with field criteria - Like '*' & [Type In MMDBID:-] & '*' This allows the user to input one MMDBID and the records are retrieved from the db. I can also use the...

Hi all, Can I call a specific switchboard page from VBA? I can open the default switchboard form itself using code docmd.openform "switchboard" The switchboard page I am trying to open has a switchboardid = 2 and I have trIed to use this condition in the code DoCmd.OpenForm...

Good morning all, I have developed an application using Access 2010, with numerous forms which I have locked down so users cannot get access to the design section of the app, using the toolbars However, one part I overlooked is if a user right clicks anywhere on the form, they can access the...

Good afternoon all, I have added a listbox to one of my "edit" forms and I have set the rowsource in the form_current code section to retrieve data from a table based on the value in a form field List174.RowSource = "SELECT tblCodesAddEdit.Auto, tblCodesAddEdit.[IOE Code]...

Good afternoon all This one may be for the forms section so please feel free to move to teh correct forum. I developed an access db application for an end user in work, which consists of 6 tables and two forms. The form I have a problem with consists of 3 of the tables, in a one-to-one...

Hi all, As simple as this seems, this is giving me the run around!:banghead: I have 3 check boxes in a table and form associated. Based on the values of these checkboxes, and different combinations, other controls become active or inactive. This is working fine for me in the form on...

Apologies for the repost - My previous thread was bombed and I was directed to this location by a mod http://access.mvps.org/access/forms/frm0031.htm After reviewing the above thread I have got this far with referring to the subform. But I am getting a property let and get failure message...

Hi all, I'm looking to reference to fields on a form when sending an email using code. One field works fine once it has the focus but then trying to reference the second field I run into problems. I could create another text box on the form and allow it's value to equal the two values of...

Hi all, Im about to release a small app and after some testing I have found that my hyperlink options are not available, when the field is right clicked - see attached screenshot I have removed all security features (Tools Startup), code from the form_load and form_current - but this issue...

Good morning, I have a form button containing the following code to send an email to multiple recipients. It currently reads from a table (tblEmailList) with one field (EMail). The code reads all email addresses using a recordset Dim stSubject As String Dim strEmailAddress Dim...

Good morning all. In a form, my aim is to track changes in fields. Once I have a list of changed fields, I'll run code to send an email and list teh fields in teh message body. Email is fine, but I am having problems gathering the data. On update of a field / text box I get an error the...

Good morning all....You can say I'm a novice access user. My background is VBA coding, Access and Visual Basic programming, but that is well over 12 years ago now. Different career paths led me to desktop and network administration. I have been asked create an application in access to pull...