Recent content by Trekk

Skip Thank you so much for explaining this, it makes sense now, all these programming books forget the small stuff like this Thank you

Hi I am new to SQL programming and I am trying to learn the language. Someone gave me some code to use that had to be modified but I need to understand what the code is doing could someone break it down for me. What does the '" stand for and why all the brackets strSQL = AddWhere(strSQL...

its called ASP runner pro, sucks but that is what we use

Also sorry it is an access 2003 database

Here is the function in the asp file,the program does not allow for where statements while building the SQL query so I was told it had to be put in on the before SQL load function strSQL=SESSION(strTableName & "_sql") templatefile = "After_Care_Reprot_report.htm" DoEvent "BeforeShowReport...

I was giving some code to use for an ASP page to use a where statement on a function called Before SQL load The code is strSQL = AddWhere(strSQL, "[CareCoordinators]='" & session("UserID") & "'") I need to also have it filter by the current month to display all records by the carecordinators...

I tried that but I cant seem to get it to work Here is my code Private Sub Form_Load() If Me.CareCoordinators.Value = "" Then Status.Value = "Unassigned" Else Status.Value = "Assigned" End If End Sub I tried pasting your code and just changing the names of the objects they were referencing...

I have 2 fields both are combo boxes. I need some example code that if one combo box is null no data in it then it will set the other combo box to a default value. One combo box is populated with usernames and the other is populated with status codes like active unassigned, etc. If there is...

Hi Skip no this is in access on a form, but I guess its all VBA?

I have 2 fields both are combo boxes. I need some example code that if one combo box is null no data in it then it will set the other combo box to a default value. One combo box is populated with usernames and the other is populated with status codes like active unassigned, etc. If there is...

I took the example of the code you gave me and tried to apply it on another query. The ASP program forces me to use the having function instead of where since it is a group by or at least that is what the program says. the error I get when I try to run the code is MS access error to few...

ASP runner already auto created the login page based on a table in my access database The reports are a simple select information from table where name = name. There is a column in the access database that is assigned to a user via a populate dropdown field. So my query is just trying to...

I have an access database and it also is used for some asp pages. There is a login page that was auto generated that create a session variable based on the login, again all set auto generated by the program. I want to create a reports page for users but have it pass their user id in the SQL...

I have several ASP pages that I have created from an access database. in access the database I have one form with several sub forms that are linked via master/child relationships. The form has several tabs which each tab is a sub form of the master. If you select a person in the master form and...

Hello I have an access 2003 database which I am trying to create a few access pages from a couple of queries. I can create a page through the wizard with one of the queries, however I have 2 other queries that display data that I would like to add to the page that was created by the first...