Search results for query: *

MichaelRed, In addition to reading your FAQ, I've actually reviewed all 88 threads where you've pointed folks to it. Unfortunately, I couldn't find where anybody was ever helped with incorporating your code into their application. They either knew what to do with it, or they banged away with...

Seems to do the trick. What did setting it as an index do to fix? Would the previous worked had it been PK? Thanks!! Mike

I get error with acbGetCounter_767 as the caption and 3251: Operation is not supported for this type of object.

PHV, I've added field Yr as text to tblFlexAutoNum_767 and populated like: Yr CounterValue 06 251 07 1 08 1 I'm guessing I now need to change: If intLocked Then acbGetCounter_767 = rst![CounterValue] rst.Edit rst![CounterValue] =...

I've got an "autonumber" working with some code from "Access Cookbook"... yeah! But what I need is for the Seq# to be dependent on txtYr field. If txtYr is "05", then the Seq# should be 1 higher than the last record entered with "05". And, when the next year rolls around and the first record is...

MichaelRed, Thanks for the response. I've searched the forums and have found many approaches to automatically incrementing numbers. I will review these and try to find a solution that works for me. If you could provide an opinion on one question it would be a big help... Should I leave the...

The database is used to track publication change requests for numerous technical documents controlled by my department. I have two problems... 1)What's the best way to keep the Request Numbers unique while also ensuring the Sequence# is always 1 higher than the previous record, and starts over...

That sounds right, there is null values. The left side is a cartesian product that gives me all tails and all months. And, not every tail has a record for each month in qryDelaysAndCanx. Is there a better approach or should I just run with this since, if I ignore the <> field, I get the results...

I'm hoping someone can tell me why my crosstab query has an extra column labeled "<>"? Here's the sql, BTW how do I go about putting it in the pretty little box all you code masters use? TRANSFORM Count(qryDelaysAndCanx.ExType) AS CountOfExType SELECT rqryMonthsAndTails.CalMonth...

I want to be able to change the 'sort by' on a form by clicking on any field's label. I'd like something similar to when using Windows, the clicked label sorts that field and displays an up/down arrow to indicate whether that field is sorted A-Z or Z-A. Thanks! Mike

kobooky, No, my Excel template has only header and column names. When I open it, all the rows from the Access query are displayed in the spreadsheet. Anytime I open the Excel, it is populated with current data from the Access database. Mike

I created Excel templates for each report and used the Import External Data tool. It was real easy to set-up using the wizard. Each time I open the template, it automatically refreshes the data. I then click save and it creates the new report file, leaving the template for the next time I want...

PHV, The data which I import into my database already has date and time as separate fields. Would you recommend concatenating them during the import update query? If so, I assume I'd use the CDte function. Or, what about creating a new field in my query that concatenates the date and time, and...

I think I need an IIf statement that says IIf t47Ex_1.ExDate = t47Ex.ExDate then t47Ex_1.ExTime < t47Ex.ExTime. But, nothing I try works. Thanks, Mike

Alex, thanks for the tip. I want every record from last 20 days that occurred before the current record. If current record Date is 1/20/06 and Time is 13:40, I want all records between 1/1/06 and 13:39 on 1/20/06. If I set criteria to say t47Ex_1.ExTime < t47Ex.ExTime, then it will exclude all...

For each record, I'm trying to get all previous records from the last 20 days where Tail and ATA are same. This SQL works but if there's two records for the same Date, I get 4 records which I understand. I have another field [ExTime] but I don't know how to set the criteria to return records...

dhookom - Thanks for your response. I took a look at your sample, but don't see anything different there than on mine... except mine don't work. Mine wants to put all 15 "categories" on the same X-value as one series. Or, the graphs show up with only the borders (the query returns correct data)...

My query [qryIssue6_3MoRates] has 3 fields: CalMonth, Issue, 3MoRate. There is 360 records - 24 Months x 15 Issues, with the 3MoRate value for each. qryIssue6: SELECT qryIssue4.CalMonth, qryIssue4.Issue, IIf(Sum([qryIssue4_1].[SRD])=0,0,Sum([qryIssue4_1].[Ex])/Sum([qryIssue4_1].[SRD])*100) AS...

I'm trying to answer a few fundamental/basic questions before I move any further with my application. If anyone has any recommendations, or suggestions where I could go for some insight I would really appreciate it. I have many fields of information that I want to be able to data mine and...

Remou, Thanks for the response, but I was hoping for an expression that I could use in the 'Update To' field in an update query. Mike