Search results

Hi, I have a split database on a network (LAN). (The network is pretty fast...MS Word and other apps load quickly) The Access database backend contains 1 major table with 65 fields and only 10 records in this table. I have a form in the front end. When I switch this form to design or layout...

I have a form containing a combobox. This combobox is populated via a lookup table. This table contains two fields: ID and FirstName. The combobox is set to allow multiple values and is working ok, however, my problem is that I cannot add a new item to the combobox list using it on the form? I...

Hi, I have an Access 2010 (Web) Navigation Form containing 2 tabs. Tab1 contains Subform1, while Tab2 contains Subform2. I want subform2 to be related/influenced by subform1; so that a record shown/selected in subform1 results in the related records in subform2 to be shown. Like a parent/child...

My report is reporting all records :mad: I just want to report the current record. Is there a setting in the report properties to only report the current record? Thanks. Jason.

Hi, I have a small Word doc (43kb) embedded(?) (not linked) as a record in an OLE field. I have a button on a form (record source = table containing Word doc), when clicked I want to open the Word doc. Question 1: What is the button's "on click" vba code to open this word doc? Question 2...

Hi, My attached database contains a problem with the linking of the subform "SubFrm_Projects_Highlights" to the MainFrm. When entering data into the subform (while nested in the main form) I get an automation error. I want to link the subform so that it is filtered by Staff Name and Year...

Hi, I have a form1 containing a subform(datasheet). I have a delete record button on the form1 which, when clicked, I want to delete the current record in the subform(datasheet). I'm not sure how to go about doing this. I'm not sure of the delete record code required, given it is a delete button...

Hi, I have a combobox displaying a list of years...2009, 2010, 2011, etc. I want to set the combobox's default value to year(now()) -1. i.e. 2009. My options are to put some sort of expression in the combobox's default value property OR use VBA code. Any suggestions on an expression or VBA...

Hi, In the code below, the Undo cmd is not working. It seems to be too near the MsgBox procedure. How can I end/close the MsgBox AND THEN perform the Undo? Thanks in Advance. Private Sub Form_Dirty(Cancel As Integer) MsgBox ("Message Here") Me.Undo...

Hi, I have a Delete Record button on a Main Form which works fine, however, if I insert a subform into this Main Form, the Delete Record no longer deletes? (The subform contains another subform). Perhaps the problem lies with the record source select statement within the Main Form?? Any clues...

Hi, After OK is clicked to close a custom error msg dialog box, I want to perform two Undos followed by a switch focus. When I perform this manually with my mouse it works fine, however, my code below to perform the same task using Vba doesn't work, specifically the Undos don't undo. I'm...

I have Form1, TextBox1 and Subform2, TextBox2. A user incorrectly enters data into TextBox2 before TextBox1. I wish to clean up this mistake and then switch focus to TextBox1. I'm having trouble with the cleanup TextBox2 bit. I am trying the Undo command, which does enable me to switch back to...

Hi, I have a Form1 containing a Subform. The Subform is based on a table and when a required field in this table is not entered the default "field is blank" error occurs. I am trying to error capture this default error and display a more helpful message. But what happens is the default message...

(Newbie) Hi, I'm trying to get the "Stenosis Grade Code" field value to be updated to the value of "1" or "2" but it's not happening. Is the txt in green and red below correct? Private Sub Form_AfterUpdate() Select Case Me.[Stenosis Grade].Value Case 1 Me.[Stenosis Grade].Value = "<50%"...

(newbie) Hi, I have a Form with a Combo Box. The Combo Box contains a Value List. When a value is selected, I want this value to be stored/written to a field in a table. How do I get the value stored/written to a field in a table? Thanks. Jason.

(Newbie) Hi, I'm trying to delete a record from a table based on the item selected in its List Box. The error I'm getting is "Argument Not Optional" (see bold below) Private Sub btnDelete_Project_Click() Dim varSelectedItem As AcRecord Dim strSQL As String varSelectedItem =...

(Newbie) Hi, Form 1: has a List Box bound to Table 1. Form 2: has a Text Box bound to Table 1. When I enter text in Text Box and click "Add" button on Form 2, I want this text to appear in the List Box in Form 1. Code so far... 'Form 2: Private Sub btnAdd_Project_Click() DoCmd.Close...

Hi, I have a table named "Call". I wish to add (concatenate) the text "Call_" to the front of every field name in this table. Can anyone suggest the VBA code? Thanks.