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...
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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.