Search results

Hello, CBID is a field and I am trying to pull M06, S06 and R06 out at the same time.

SELECT tblLeaveBalance_Cashables1.Facility, tblLeaveBalance_Cashables1.Division, tblLeaveBalance_Cashables1.Position, tblLeaveBalance_Cashables1.Name, tblLeaveBalance_Cashables1.[Class Code], tblLeaveBalance_Cashables1.Class_Title AS Classification, tblLeaveBalance_Cashables1.CBID...

Well...it runs the marco..but what is the macro is in the Module??

Re: Urgent--Macro passing value Sorry... I am trying to open the DB with a Macro...now I need for the Macro to pass a value

Does anyone know what the code below means?? '" /x Marco1",

That's so discouraging...but Thank you.

I was wondering how to do a crosstab query and have to column headings I need the Organization Number and the Org name..so something like this 4005 4010 Office of HQ Office of Accounting Is this possible?

Hello, I have a few reports will it open all of them as they are clicked on. Also I want to open in "View" for some resaons it wanted to print

Hello, I have a dropdown list of reports that is supplied by table. I also have listbox that are populate by another table. I want to be able to run the reports from the dropdown and from the listbox ....whatever the selection is to pull that info from the report and display. I know Access...

Hello..My title says it all. I want to be able to clear all the contents in my fields (which are bound to my table) with a click of a button

What about for the a combo box..same thing???

How do I do that with the code I have??

Hello, I have a code that when I delete my entry on the form it gives me Run-time error '94: Invalid use of Null Here is my code Private Sub Remarks1_AfterUpdate() Dim rst As DAO.Recordset Dim strRemarks As String strRemarks = Me.Remarks1 If strRemarks = "" Then Exit Sub...

Try putting me.Refresh at the end after it performs everything. I am new here too...but I am picking it up

Hello JHB, I used a different code that works. Which is different than the one I posted

What I would like for it to do is to Look at BC1Chng and if there is a number...then do the rest of that stuff. If there is nothing than leave the Remarks1 blank

Can someone help me understand what this code is doing??? I don't understand the third line and I think that is what is confusing me. Dim memoContent As String memoContent = Me.Remarks1 If Nz(Me.BC1Chng1, "") <> 0 Then Do While Not Me.Recordset.EOF memoContent = Me.Remarks1...

Hello, i tried the Update query and it asking for a parameter Value to be entered. Another question..Where do I place the If Nz(Me.BC1Chng1, "") <> "" Like I said I am pretty new at the coding.

The only problem I see with the is when you say it matches the value...I just want it to check to see if there is a value in BC1Chng1??

Hello I do know how to do a Update Query but not how to refer the value of a control in an Open form.