Search results

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...

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

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 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

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...

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 have Field "BC1Chng" which requires user input. I want to be able to write a code to reference to "BC1Chng" if there is an input in that field for any record...I want to copy the Remarks into each record in the Remarks Field. I was able to get the remarks1 field to loop through...

I have a code that I am currenly using with a button to move to the next record. I just want it to loop by itself. I am currently having to press the Update button for it to move to the next record. Thank You Private Sub UpdateAllComments_Click() Dim memoContent As String memoContent =...

Hello, I have one module that I have it set on a button for each of the four forms. I works fine for the first form and the second form..it doesn't. My forms have subform where the button is and that's where I copied the code on all four subforms. Any ideas?

I have two fields..on two different forms..the output needs to be the same. FormA.field b = FormB.field a FormA.field b is a calculation on form A....the end result. On FormB that needs to be my beginning number. I have tried everything that I could think of..also the fields are a part of...

I am having problems with my INSERT statement: INSERT INTO [FINAL_TABLE_CROSSTAB](OrgName, CostCenter, Fund, PEC) Select [Final_Table_AllotQ].OrgName , [Final_Table_AllotQ].CostCenter, [Final_Table_AllotQ].Fund, [Final_Table_AllotQ].PEC, from Final_Table_AllotQ WHERE...

How do I populate fieldA in formB with FieldB from FormA.. So Field is the last numeric field in Form A..so I need to the take the calculation value of that field and be the starting value in formB.

Hello, I have one memo per change (user input)...I need to have the comment the user inputs to copy into other records that were queried. I tried insert. My coding does one of the records or all of the records ..I need it to copy just to the queried records ...and I have a query but no...

Here is my code...if I take out the where statement..it copies the remarks all the way down my table to all the records...with the where statement..it's prompting in for parameters.. Private Sub Remarks1_Click() Dim strMsg As String, strQry As String, strRemark As String strMsg =...

Hello, I have a crosstab query which i would like to append to my table..can't change it to a append query...it changes the structure. Anyone?

hello i removed the DIsTINCT in my query to move some field to be updateable on the form. Once I did that my detail section of my form was empty ..why and how do I fix this problem

I am trying to input info into my form I got Me.TotalBC1.Value = Me.TotalBC1.Value Now it's saying the "Recordset is not updateable" and I can't find it for the textbox where to change it to an updateable field

Hello, I am not sure what to call these items except as action items. Where can I go to figure out what is Me.txtX.Value I understand the Me and TxtX is the text box...but where can I get a list of the actions. .Value .Locked etc... I am new to Access..Only three months into making...

I have a query that I am running based off two tables. To one of the tables I add a few blank fields as my boss wants me to calculate the accounting portion. I work at an budgets unit but as IT. Anyways, I ran the query and opened it in a form for the Analyst to input their numbers. So every...