Recent content by heather001

Print Problem Resolved I had the same problem with printing so I threw the BuildFilter Function into a Msgbox and found the problem to be the WHERE in the statement. Print filters apparently don't like this so I tweaked the code a bit and relocated the WHERE in the filter. Here's the old code...

I finally got it working with this code: DSum("DefectQty","d_sub1_DefectReport","[tblDefectCodes]![CodeID]='" & [tblDefectCodes]![CodeID] & "'") I think I was missing a punctuation mark or two the first time I tried this. Thanks for the help!

I'm not referring to a form control, hence I didn't use this method. Although, I did however try this method before my first post and I still had the same outcome as I described previously. I'll try this method later today when I'm at work and report back with my results.

no ideas at all???

Thanks for the help but I'm still having trouble. The double set of quotes were from trying to call it in a sql statement in vba. To narrow down the source of my problem I've since removed the date criteria so it looks like this: DSum("DefectQty","d_sub1_DefectReport","CodeID='[CodeID]") This...

Hi all, Sorry in advance for the long post. I'm designing a query based report in our Access 97 QA database that takes parameters from a user form. In the report header is a graph and beyond this graph is the detailed information for each defect. The graph shows what percentage each defect...

I can't figure out what I have wrong in my code. I've searched all over the forums and the help files in Access. I'm sure it's something simple. Could someone please take a look? =DSum([DefectQty],"d_sub1_DefectReport","CodeID= "" & [tblDefectCodes].[CodeID] & "" AND ""[InspectDate] >= #" &...

I have 2 identical databases with different data. The newer of the 2 databases was just for temporary use but we've decided to continue with the data that is in it. I would like to reseed the smaller of the databases starting with the last PK (autonumber) of the larger database and then append...

I took a closer look at the link I posted and was able to understand the logic and make it work to my liking. I did use a function as you recommended and it worked perfectly. I'm really liking the way functions make complicated queries a lot cleaner.

I have a parameter query that was discussed a while back Here where I needed help with a nested IIF statement returning multiple values. This has been working great until I was asked to add a couple more processes to the list. Now I get an error saying expression too complex. Ok, well I...

It works like a charm. I had to make some minor changes to get it to work for my needs. I've attached the code in case someone else needs to use it for ideas :) Public Function KyFld(Inp As String) As String Dim str As String Dim pos As Integer Dim xpos As Integer Dim TmpKyFld As String str...

This helps a lot! Thanks!!

Thanks for the response. I would prefer VBA since the If statement structure is much cleaner than in MSaccess code of IIF. I'm not familiar with how I would call the function from the query. Can you point me in the right direction?

I have a 3rd party database where I have no control over how the data is entered. I've been given the task of creating a Crystal report that would need to gather data from two databases. The link between the two databases in my report would be on a quote number. In one database, the quote...

Hi all, I've used these forums immensely when I need help with my databases. Thank you for all the help you've provided so far. I'm hoping I can get some recommendations for my next database project. I'm getting ready to design a database that uses an ODBC connection to link to our ERP...