Search results for query: *

I have a table in EXCEL 2010 that has conditional formating to color cells in 12 different columns with 16 different colors - is there a way to say :: SORT TABLE by ANY(or all) COLORED CELLS Willie

In older versions of Microsoft Office (Excel) when CREATE MACRO was used in the notes section of the Macro it would write the name the Macro was given and the date it was created on. In 2010 it only lists the name of the Macro. Is there a way to have the created on date appear when using CREATE...

I have an excel document that takes a long time to print. The solution is to open the document in page break view, print the document, and return to normal view. I do this usually with a Macro and the Macro works but the Macro placed in the ThisWorkbook section does not??? Private Sub...

I have an excel document that takes a long time to print. The solution is to open the document in page break view, print the document, and return to normal view. I do this usually with a Macro and the Macro works but this in the ThisWorkbook section does not??? Private Sub...

If you select a range on an Excel Spreadsheet (A1:C3) how can you report that range to VBA code? Willie

I have two Excel spreadsheets I've used for years. A worksheet in one has three named ranges that represent the ITEM you wish to reference, the FIELDS, and the TABLE the information is in. In another spreadsheet I have formulas that use these names to return information ---...

I have a spreadsheet I've used for years. It has a ton of VBA code behind button clicks. It references a lot of books both inside the document in other worksheets and in another spreadsheet. It has a form that prints with a page break. I have a button for saving the record and printing the...

How do you ask the following in VBA Is ActiveCell.Row between 5 and 10? Willie

Can you have a form open in Datasheet view, Doble Click a cell and have it open as Form View, without it reopening the form? Willie

I have a table with 2 records in it one NUMBERED 371 and one numbered 408 (the last record). I put a go to the last record button on the form and I also have code in the On Open event --- DoCmd.GoToRecord , , acLast ---, it will only open to 371 ?????? Willie

I have a main form called MoldList and a sub form named MoldHistory. On the mainform is a field named Rework. If this field has a date, the mold is out of service. The subform is a form that lists the work to be done on the mold. If the Rework field of the subform is Null I need the subform to...

In the following code I get an error message that reads Compile Error Wrong number of arguments or invalid property assignment, do you know why? It is set to a button click in a sub form to update a linked mainform record. DoCmd.RunSQL "UPDATE MoldList SET Rework =...

How do you put breaks in an UPDATE SQL to continue it on the next line (it's to long for the window)? SQL$ = "UPDATE MoldList SET Rework = IIF(Me.Scrapped=-1,DATE(),"") ; Notes = IIF(Me.Scrapped=-1,Me.Reason,"") ; [LastRepair] = '" & Me.[LastRepair] & "' ; [DL] = '" & Me.[DL] & "' ;[DLn] = "...

I've gone round and round with the concept of Normalization. I've decided on a 125 field table. Most of the fields represent Periodic Table Elements - Mo Ni Mn Cr, etc. This is because we run samples, maybe 10 or more. A normalized database is Lot Element Percentage 3555 Mo...

Can you have a mainform with a combobox that lists field names from a table, change the RowSource for a textbox in a subform. Table 1 Table2 NameofFields Mo Ni Mn Mo Ni Mn Main combobox > Mo < Ni Mn ------------------- Sub Textbox >>...

I have 3 or 4 queries that get blended into one query. I have another set of queries that have the same key fields. This set of queries shows an entire set of different information. What I'm trying to do is have a form with a 'KEYFIELD' box. This box will be linked to one of the tables that...

I have a worksheet that list information by months. All January first, then Febuary, etc. I have a column that list the last entry of the month with TEXT(CELLDATE,"mmmmm"). So the last entry for Januray in this column list January. I was wondering if there was a way to loop through with...

I have a calculated field on a form HM. =IIf(DMin("[ID1]","[Production Schedules]","HNumber = " & [HNumber] & " AND SJoin = '" & [Sjoin] & "'")=[ID1],DSum("[PourWeight]","[Production Schedules]","HNumber = " & [HNumber] & " AND SJoin = '" & [Sjoin] & "'")+[KBw],"X") HM will either give me a...

I have a form that has a field called HM. HM is either going to be a number or an X. I have a combo box that is set to yes or no. I want to disable the combo if HM = X and enable it if Isnumber(HM). Willie

SQL$ = "UPDATE CIDtbl SET [" & Me.Parent![1] & "] = " & Me.Parent![elm1] & ",[" & Me.Parent![1] & "] = " & Me.Parent![elm1] & " WHERE ([CIDtbl].ID = " & Me!ID & ")" Let's say that the preceeding gives me UPDATE CIDtbl SET [] = 0, [Mo] = .15 WHERE ([CIDtbl].ID = 137 ) Is there a way to say...