Recent content by tbassngal

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