Search results

Hello- I have a question on building a form to update two tables in my database which have a 1:M relation. 1) tblSecurityFamily (One)-Primary Key=SecurityFamily_ID (autonumber) 2) tblSecurities (Many)-Primary Key=Security_ID, Foreign Key=SecurityFamily_ID These...

Thanks everybody! I got it to work.

Thanks for the reply! but unfortunately, it is not in a different table to begin with as I just get the single table with all the data in it vs. having two separate tables.

Hello- I am trying to create a query from a single table that has these two fields: PricingDate and SecurityID. Each week I get new data that is appended to the table. What I want to find is the New SecurityIDs that were not in last week's. Thus, I am looking to restrict my recordset to just a...

Here is some SQL I picked up from searching..... SELECT COUNT(qryIndexRets.INDEX_RET) AS CountOfRets, Int(Min(qryIndexRets.INDEX_RET)) & "-" & (int(min(qryIndexRets.INDEX_RET)+max(qryIndexRets.INDEX_RET)-min(qryIndexRets.INDEX_RET))/5) as [group] FROM qryIndexRets GROUP BY...

thanks for the reply. the bin values will be discrete as I would like to determine the number of bins (that is why I have it as a input variable in the function "categories") I will be storing in the bins the counts of each value in the table that fall within each just like the partition...

Hello- I am trying to create a frequency function that dynamically creates the bins and then counts the occurences for each....however, I am having some trouble getting what I have to work.... I know about the Partition function, however, my dataset will have negative values in it thus I...

Printer is saving the PDF in My Documents.....However, I tried your code modification and still getting errors on the same line....I still don't get why when I set SourceFile equal to the code following it and then step through it SourceFile is showing me a blank variable?? Thanks for your help!

OK. Still bumping my head on this one.... this is what I got Set fso = CreateObject("Scripting.FileSystemObject") Do Until rs.EOF rptName = rs!Report_Name DoCmd.SetWarnings False DoCmd.OpenReport rptName, acViewNormal pathToDest = "D:\Documents and Settings\My...

Thanks for the reply! Code is getting hung up on: fso.CopyFile("C:\Pdf.pdf", pathToDest) Syntax Error Not sure how to manipulate these. Thanks!! EK

Hello- I currently have the code below that loops through a table with named reports and prints them to PDF. The code works fine except each report is overwritten by the next report in the loop because all of the reports are being saved under the same name. Sub LoopReports() Dim db As...

Security_ID is what links tblHoldings to tblSecurities. The reason they are separated is that tblSecurities will be a historic list of securities while tblHoldings will only be the most current and have numerous other attributes as well. Would this not be the best way to set-up a relational table?

Hello- I have a question regarding doing an Update query from one table to another when the table relationships look like this: tblProjects Project_Code-Primary Key Project_Description tblSecurities Security_ID-Primary Key Project_Code tblHoldings Security_ID-Primary Key IssueType...

Hi Paul- Thanks for your reply...I had some trouble logging back in so I created a new user name.... I've done some tweaking of my code and I am very close to getting it to run.... Sub FundName() Dim db As Database Dim strSQL As String Dim rs As Recordset Dim FName As Variant strSQL =...