Search results for query: *

Hi all, I have the following sub procedure. The combo box is being filtered as I want it filtered and the control source is Desc1 but cboDesc1.value does not write to the table... cboApplication.value does. Any ideas? Please help. Private Sub cboApplication_AfterUpdate() Dim sSQL As String...

Can someone help me by adding looping code for 3 cboDesc boxes, cboDesc1, cboDesc2, cboDesc3 Private Sub cboApplication_AfterUpdate() Dim sSQL As String 'MsgBox "The Code is Executing!" 'clear cboDesc1 Me.cboDesc1 = Null sSQL = "SELECT Desc1 FROM tblApplicationDescription"...

Okay, I think I have it figured out but how would I make it so that the Desc1 was populated 3 times without having to copy and paste code 3 times. Loop ??? I haven't done this in such a long time... ???

Hi all, I have used this code before in previous databases but am now having issues of cboDesc1 = null and it shouldn't be. My sSQL is correct. The funny thing is when I run this code, the cboDesc1 box becomes dimmed out and unclickable but has no value. I am eventually going to have 3...

Have it figured out, I was missing the reference - don't know how to delete the thread, sorry! Missing DAO 3.6

I keep getting a compile error on Dim MyDB as Database. I've even tried adding as DAO.Database but that doesn't seem to correct the problem. What am I doing wrong? Private Sub cmdAddNew_Click() Dim MyDB As dao.database, rcsTest As Recordset 'MsgBox "The Code is Executing!" Set MyDB =...

I obviously meant "incorrectly" vs correctly. "I am certain I am just not identifying the subform correctly in the syntax.

I am not sure where I am going wrong... I've tried to add the code under both forms - separately testing of course. I am certain I am just not identifying the subform correctly in the syntax. For example, in this example: Private Sub cmdOpenRefSub_Click() With Me![subfrmReferences].Form...

First, I am having a hard time with the syntax for a subform. I can't even get the code to realize I am on a subform. Next, I have a main form frmAddDoc with a field txtTitle and a subform subfrmReference that loads from the main with an on_click event button. I have a field txtTitle in the...

Hi all, we have been upgraded to Access 2007 without our knowledge of it coming and a critical program for us is halted now as a result. Some of the code that it is stopping on is: Dim xlTemplateWorksheet As Excel.Worksheet xlTemplateWorksheet.select I get an Access error box that says...

Hi all, we have been upgraded to Access 2007 without our knowledge of it coming and a critical program for us is halted now as a result. Some of the code that it is stopping on is: XLTemplateWorksheet.select I get an Access error box that says: Automation Error, The server threw an...

Hi everyone!! I have an SQL statement that I didn't write and I barely understand it, but this is what it looks like: strSQL = "Select distinct [Program Code],[E_Name] as Name,count([Project Id]) as NumOfProj from " & strTblName strGroupBy = " GROUP BY [Program Code],[E_Name]" strWhere = "...

jsteph, you are right... but this is a request that was made of me. I am almost looking to get duplicate values. This is not my table... this is a co-worker who is taking a stab at trying to do something else. Basically - there are looking for products within a range of the same length - give...

Hi all, Just wondering - is it possible to create a new query field based upon data from another field using criteria of +/- ??? Now, I know that this doesn't work but there has to be a way. Example: I have a field of data that is titled "Length" and say the value for that field is 48 on one...

It worked great, thank you! I've not used cells so much - I didn't realize I could use only the starting and end point instead of listing all the cells. Thank you thank you!!! Tina

Hi everyone! When I have just two cells listed to .clear, this works. When I add all the cells I need to be cleared, I get the Compile Error "Wrong Number of Arguments or Invalid Property Assignment" Should I be using something else other than Cells??? Please help! Sub RemoveStuff() Dim...

Bong: if the density is <=0 then the information in columns is cleared. The idea here is that if it is the same PID number, then I don't want to see duplicate Expenditure costs for items with density <=0, only for items with density >=0 with the same PID #. Does this help? Starting at row 4...

Hi all, I am new to Excel VBA and haven't a clue how to get started here. I have the following spreadsheet: ColA, ColB, ColC, ColD, ColE PID #, Type, Density, Expenditure1, Expenditure2 116211, NEW, 30, $130,943.46, $295,834.92 116211, Modify, 0, $130,943.46, $295,834.92 116211, Unk, 0...

Skip - I've already done that... :-) Thanks for your help anyway - please let me know if you can think of anything else.

Yes - Excel 11.0 Object Library (we are office 2003) but still Access 2000 here.