Search results for query: *

I am using a datepicker on a form, and when I reference that datepicker field in a query to help filter dates, my results are not filtered correctly. The syntax in my query is as follows: Between Forms!frmProjections!DTPicker3 And Forms!frmProjections!Text232 The code above is under the...

Hello All, I have an Access 97 database that is passing values from a form via a url/hyperlink to two fields on a .aspx form. I can get one of the values to pass correctly, but not the second. I created a public constant, as you can see, so that all I have to do is type that variable name...

Hello Everyone, I have created a SQL stored procedure to pull data from various SQL tables. I have also created a pass thru query to be able to not pull all of the data, but just records based on a date range. The pass thru query's syntax that works looks as follows: exec...

Hello All, I have a crosstab query report in Access 97 that I am currently working on. The data is being displayed correctly on the report, but I can't get the totals to show in a group footer. I get zeroes, but I don't get the summed totals for each column in my report. It works in the...

I have some VBA code that is behind two activex comboboxs, and I have some code behind four activex buttons. All my code works just fine, but at certain places in the code, other code runs in between this code. It's very frustrating, because they are firing when they're not being called. I...

Hello All, I'm trying to copy data from a table in Excel 2007 that is linked to a query in Access 2007 into another worksheet. If I open the file using Excel, it doesn't seem to have a problem. If I use VBA, and open this file from an Access 2007 database, then it gives me a 1004 runtime...

Hello, I am opening an Excel spreadsheet from Access 2007, and when I try to change the data in that spreadsheet, and save it, it tells me that it's in read-only mode, and I have to do a Save As and change the name. Is there a way to open the spreadsheet in edit mode. Below is my code that I...

Hello All, I am currently trying to filter a querytable in Excel 2007 by using an activex combobox that is not on a userform. Below is a copy of my code that is not working. I get an error that telling me I need an object, but when I create an object it still doesn't work. Private Sub...

Hello, I have a spreadsheet that sends an email after the file has been uploaded to a SharePoint sight. The email has a hyperlink to the SharePoint site address to where the file was uploaded. I want to give that hyperlink an alias so that the email will look alot neater than it does now. My...

Hello, I am trying to use a report created using a crosstab query. The problem that I am having is that it will not let me use that report as a subreport in an existing report. Access 97 gives me an error message that says that a pass-through or crosstab query can not be used as a control...