Search results for query: *

Hey Duane, Thanks for your help. Here is what the SQL looks like. SELECT ([polnenddue]+30)-Weekday([polnenddue]+30,1)+6 AS [Due Date], polin001.polnenddue, [polnenddue]+30 AS [Date], Sum([recqty]*[polnlp]) AS Cost FROM polin001 WHERE polin001.polnsoln)="X" AND...

My mistake!! The DateAdd() function has syntax that looks as follows: DateAdd("ww",Forms!frmProjections!Text147,Forms!frmProjections!DTPicker3) The Text147 field is the number of weeks that need to be calculated. That was an error, but that's not my real issue. The real issue is that the...

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

Hey Mark, Thanks for your assistance. I had to make a few modifications, but this is what my global constant and code looks like. Public Const CRWebRequest = "http://webtest1/crportal/RequestReport.aspx?" FollowHyperlink (CRWebRequest & "Name=" & Me.Name & " ?&txtTransID=" & Me.TransID)...

Hey Mark, The other piece of the code that I forget to add looks as follows: FollowHyperlink (CRWebRequest & Me.Name & " " & Me.TransID This is under a click subroutine. So when the user clicks to button, all of the necessary data is pre-populated into the web form so that the report can...

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

Duane, Sorry, I was trying to send you a picture of the SQL design view dialog, but you already know what that looks like. Sorry for any confusion.

Hello Duane, Thanks for responding. I was wondering can this be done without using VBA. I'm trying to make this as simple as possible. I'm pretty decent in VBA, but I just wanted to figure out if this was possible from the SQL view of query design.

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 Duane, I figured a great way to make my crosstab report work. It didn't require any code, any changes to my tables. It was only a change to my crosstab query. Steps are below: 1. I went back to my crosstab query, and in the QBE grid, I right-clicked on the area where you put tables...

Duane, It's a great honor to have you responding to my thread. I've seen much of your work. I really appreciate you taking the time to respond to my thread. I'm a decent Access Developer with the desire to always learn more.

Hello Duane, The intColumnCount represents the column number in my crosstab query, the lngRgColumnTotal() represents the sum of the column numbers, and the conTotalColumns represent the max columns that my crosstab will generate. The dynamics as far as the column headers and the actual data...

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

Yeah, I caught that, and fixed it. Thanks a million away!!

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

Thanks Skip. It worked great!!

Thanks Skip! I'll try it and let you know.

I am not trying to do it from Access. Skip, I was telling you the whole process. Access opens the file. Then after the file is opened, Access closes, and only the Excel file is open. Then the code runs to refresh a querytable in worksheet called Data in Excel, and then copies that refreshed...

It resides in a subroutine called Workbook_Open so that when the workbook opens, it can refresh the data and copy it.

Skip, I thought that once the workbook was opened, I could refer to any worksheet that was in my workbook since Access is now closed. In the code sample that you show above, I was just telling Access to activate the first worksheet when it opened the file. That first worksheet is a user guide...