Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tbassngal

    ItemData (combo box value not writing to table)

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

    Loops

    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"...
  3. tbassngal

    Combo Box Issues

    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... ???
  4. tbassngal

    Combo Box Issues

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

    Dim Database ???

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

    Dim Database ???

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

    Assigning Value to Subform

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

    Assigning Value to Subform

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

    Assigning Value to Subform

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

    Access 2003 to Access 2007 .select error

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

    Access 2003 to Access 2007 .select error

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

    Query / SQL Criteria

    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 = "...
  13. tbassngal

    Query Question - +/- Criteria

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

    Query Question - +/- Criteria

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

    Compile Error - Wrong Number of Arguments or Invalid Property Assignme

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

    Compile Error - Wrong Number of Arguments or Invalid Property Assignme

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

    Row/Column Data Clear - Excel VBA

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

    Row/Column Data Clear - Excel VBA

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

    Run Time Error - New Excel.Application

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

    Run Time Error - New Excel.Application

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

Part and Inventory Search

Back
Top