Search results for query: *

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

I have searched and searched, I still can’t find a way to combine several different queries into one Data access page. Every time I try to add a different query access tries to create a relationship with the first query. I just simply want to display query out puts in a page for users to see...

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

Hi Skip I may be approaching this ting all wrong as it is. What our users do is run queries in a database like total new customers for the month as one of the queries. They then look at the end of the access datasheet and it may say 20 records for example. They then input that into an excel...

I have an excel worksheet that has about 10 rows of data I need to populate from several access queries. I can assign a query through the wizard for the first row and it works. But I don't have the option to assign a new query to the same column in a new row. all it allows me to do is edit the...

I have an access 2003 database we are using. What I want to do is there are reports where sometimes they want to sort by county, or country, or last name, etc and have it come up as a report they can print. I would like there to be a dropdown list where they can select the queries I created. SO...