Search results

Hello bob, Thanks for your response. I get the first error. The second error " & me.txtUser&. Should that read "& Me.txtUser &_ Thank you Bob, you the best

error on vba code hello bob, here is the database the form is frmqcplist1, to get to that, its the first button on the switchboard. Once in form, select a user/qcp combination and click display. I am trying to make the revision and revision date specific to combination thanks a lot...

Am still getting the error. Can I share my database

I get an error after the group by statement in my VBA code saying expected: line number or label or statement or end of statement My VBA is greyed out, after the group by clause. I suspect the error is before that. I have spent six hours on this. Can anyone out there help Sql = "INSERT INTO...

I am getting an click when I click the command button saying you cancelled the previous operation Private Sub cmdDisplay_Click() On Error GoTo Err_cmdDisplay_Click Dim strSQL As String Dim Sql As String ' <-------- 'Declarations DoCmd.SetWarnings off 'Delete data from...

The controls I want to filter from are txtuser and txtqcp from the main form. This filters into the subform that has two controls txtrevision and txtrevison date. My code look like this and I am getting an error on the third and fourth line 'Build SQl String If Me("txtuser" &...

Me.SubFormControlName.FORM.Filter = strSQL Me.SubFormControlName.FORM.FilterOn = True would go Me.txtrevisiondate.sfrmhistory.filter=strSQl Me.txtrevision.sfrmhistory.filterOn=True Would this go on the main form or subform

Rural guy, What should the sql statement look like

I have a main form that has two combo boxes, txtuser and txtqcp. My subform has revision date and revision text controls I want to filter revision date and revision based on the selection I make for a txtuser and txtqcp(i.e user BP and qcp 10000) so that on my sub form it would have the...

Hello Bob My textbox is unbound, using either of those still inserts blank rows into the subform

Another thing is that, when I use these two codes in the lost focus event of the textbox control, it insert a blank row in my subform Me.txtresponsibilities.Text = "" Me.txtresponsibilities.Value = ""

The problem with that code is that A textbox control does not have a current event

This code makes the data in the subform null as well as making the textbox blank. How can I make only the textbox blank after update

I have a main form with a combo box, containing a list of qcps(numeric values) on that main form is a text box to add to my subform data like references or responsibilities for each qcp i.e 10000 The problem is that when I add data to the text box and I click accept, which insert the value...

so what should it look like Adam

I am getting an error on my select statement with this code and the if statement. Can anyone help Private Sub txtRevisedCost_LostFocus() sql = "select * FROM projectupctable WHeRE Prj_no = '" & Me.prj_No & "' AND upc = " & Me.UPC" rs.Open SQL, CurrentProject.Connection, adOpenDynamic...

I have asked this question before, but I guess I am not making myself as non of the responses work. I am attaching a copy of the database to clarify matters. My problem is when I change the value of a row in datasheet view for a particular control, the whole column (Revised cost) in datasheet...

How do I make a dataset not updataable in MS access

I have a datasheetform that takes it value off a query. In my datasheet form there is textbox that has a value (unit cost),that it take off the query that feed the form. Then I have an unbound textbox(Revised cost) whose control source is unit cost. So I have two textboxes with the same...

I have a datasheetform that takes it value off a query. In my datasheet form there is textbox that has a value (unit cost),that it take off the query that feed the form. Then I have an unbound textbox(Revised cost) whose control source is unit cost. So I have two textboxes with the same...