Search results

I am exporting a query to excel using: DoCmd.OutputTo acOutputQuery, "QueryName", acFormatXLS, , True The issue is that one of the fields is a memo field and the data is being cutoff. There is no order by or group by on the query. I found one post that said to get around this issue use...

Using Access 2003 and SQL Server 2005. The Access database uses linked tabled to the SQL Server. I have a 1 table query where I am trying to return data for a search form. Here is the query: CaseID = Forms!Search!cboCase This works fine. However, when I try to get the query to return all...

In Access 2000 I have the following: Table: tblDoc FieldName: DocID I need to run an update query that will change the format of the values in the DocID field to add a zero on the end if the number to the right of the decimal is only 3 digits. The number of characters to the left of the...

I have the following sample data: LON09844 NUOS00101 NU-U00092 I am trying to subtract one from the end number. The following code worked until I realized not all of the number sequences began with 0. NewField: Left$([BegBates],InStr(1,[BegBates],"0")-1) &...

I have a form where a user can add a new record. I am trying to prevent duplicate records from being entered with the following code: If DCount("[MobileNumber]", "tblMobileNumber", "[MobileNumber]=" & Me.txtMobileNumber) > 0 Then MsgBox "The mobile number " & Me.txtMobileNumber & " is already...

I have searched the forum and haven't been able to find the exact solution to my problem. I need to create a primary key field that is an autonumber field; however, I need to generate the field via a different means that the datatype = autonumber. The reason I need to do this is as follows...

I have a continuous subform in which I am having troubles keeping the focus on the current record that the user is on. For example, there are 3 records in the subform and the user changes record 2 or 3. The user is then taken back to record 1. I have used similar code on other forms and...

I have a combo box on a subform that I would like to limit the user to the list. However, when I set Limit To List = Yes . . . the user can not type in a value if they know it even if it is in the list. The error message states: The text you entered isn't an item in the list. The text is in...

I added the code referred to in the following article to turn off the mouse scrolling completely within Access. http://support.microsoft.com/default.aspx?scid=kb;en-us;278379&Product=acc2000 However, my problem now is that my other code which was working before is no longer working. For...

I have a form which opens to a filtered record. Problem if the user deletes the record for some reason it goes to a new record. I created the delete button using the wizard and added a line to close the form.

Is there a way via code to "Send To Back" a textbox. I am setting the focus to a textbox so I can't make it invisible but I don't want it to show on the form.

I have a subform with a combo box. On the after update event of the combo box I have: DoCmd.RunCommand acCmdSaveRecord Me.Requery The value in the combo box determines what data is populated in the other fields on the subform which is why I am saving the record and requering the data. The...

I have a subform where the default view is single form. On the after update event on my combo boxes I have the following code: rs = Forms!frmReq!sbfReqItems!txtReqItemID DoCmd.RunCommand acCmdSaveRecord Forms!frmReq!sbfReqItems.Requery Forms!frmReq!sbfReqItems!txtReqItemID.SetFocus...

I have a main form with a continuous subform. On each record on the subform the user can check a box which if true will open up a new form. The Subform is built on TableA and the popup form is built on TableB. The primary and foreign keys in both tables is called RegItemID. The problem is as...

I have a continuous subform in which a user picks a value from a combo box (cboField1). This value filters a list for another combo box (cboField2). In turn, when the user picks a value from cboField2, three other text fields get populated with data. Everything works great until a user goes...

How do you pass a field value as an OpenArgs For example, I have a field on my form called ReqItemID I tried DoCmd.OpenForm stDocName, , , , , , ReqItemID and DoCmd.OpenForm stDocName, , , , , , Me!ReqItemID and DoCmd.OpenForm stDocName, , , , , , "[ReqItemID] = " & Me![ReqItemID"

I have a form that uses the following code to handle 2 forms opened in an adp with the same record source. see the following article: http://support.microsoft.com/default.aspx?kbid=304181 Dim rs As ADODB.Recordset Set rs = Me.Recordset.Clone rs.Bookmark = Me.Bookmark DoCmd.RunCommand...

I am using Access 2000 and SQL 2000. I am creating an adp. I have a form (frmMain) with a subform (frm_sbf). On the subform the user can open another form (frm_popup) to update additional information on a particular record. The problem occurs when I close frm_popup and then try to move to...

I have a continuous subform with 2 combo boxes. The value the user chooses in the 1st combo box determines what will show up in the 2nd combo box. This is working OK. On the current event of the subform and on the after update event on the 1st combo box the 2nd combo box is requeried. The...

I have 2 combo boxes. Combo1 = State and Combo2 = City. The values in Combo2(City) is dependent on what state the user picks in Combo1. The problem is I can't filter the values in combo1 based on the state in an adp. I can do this in an mdb but don't know how to do it in an adp. Thanks!!