Search results

Being one of few small town kids who actually didn't drink hardly at all before turning the legal age, I haven't had too much of a chance to get in to the "adult beverage" side of things. For me, nothing beats an ice cold Dr. Pepper. However, for the adult beverage side I typically enjoy a Bud...

Alright, this solution should work. Add wind direction to your query. Then, right-click anywhere in the window and click properties. Make sure the window that comes up says "Query Properities." If not, click anywhere in the query window as long as it isn't one of the query columns to change...

Is direction not stored into the table that your query is based off of?

Oh the joys of working at a University computer lab. The University decided it was time to upgrade to Office 2007, and as I'm sure most of us know it looks very different than previous versions of Office. Needless to say I had countless questions the first few weeks about how to save, print...

Hey all, I've got a couple of tables that contain numerical data that I am finding the difference between. Both are defined by the same PK, and with an inner join the query correctly shows the differences of all the PKs that exist in both tables. However, I need to have the query also show...

Yes, I'm using Access XP and it seems that it doesn't like it either. Thank you both for the help. If I can't seem to remember to not go back to design view I will try AccessRookie's technique. Thanks again!

Hey all, Is the following statement syntactically correct? SELECT tblFD.Payor_Code AS [Payor Code], tblFD.Payor_Name AS [Payor Name], tblFD.SRCol AS [S/R], Sum(tblFD.Inbnd_Bytes) AS [Inbound Bytes], Sum(tblFD.Otbnd_Bytes) AS [Outbound Bytes], Sum(tblFD.Bytes) AS Bytes...

In no particular order... 1. Garth Brooks 2. Matchbox 20 3. Brooks & Dunn 4. Journey 5. Metallica Of course this can vary by mood, but generally I can always appreciate listening to music by these artists.

Hey mafhobb how much HDD space is your database actually occupying? I've noticed that occasionally I get this error when my DB gets up to the 2GB size, and after compact and repair it works alright again. You may either need to clean out old, obsolete data or have data exported to a separate...

I had a similar problem with the too few parameters deal and believe the issue was related to my WHERE clause. Make sure everything in there contains a value because if it doesn't I think access doesn't consider it an actual WHERE "parameter", hence the too few parameters error.

Alright, no problem. I did find some references in my tables and queries that I thought I had cut off and removed, but turns out they were still there and for some reason randomly deciding to prematurely sort the data, which affected the assignments and whatnot. I've also implemented error...

I'm still working on finding a way to make a sample test file. The data isn't exactly something I can just give out, so for now I'll post my import code here. If you can maybe spot what's wrong in it then let me know, otherwise I'll continue to work on the test file. And I do realize my SQL...

Mushroom Cloud. Big one... Ha...yeah sorry for being a little (or a lot) vague. I was frustrated at the time I wrote the message so I immediately assumed everyone would know what I meant. The import process is somewhat elaborate, but has to be for the data im importing. The data comes...

Hey all, Would anyone have any idea why my database will properly import my data sometimes, then other times completely mess up the import? I can use the exact same data file and like it said, sometimes it imports fine and others it just messes up completely. I believe the issue may be in...

Seems to be the case. I found some code that may have worked, but access comes back and says that I cannot run C&R in a Macro or VBA, so I suppose I'll just set it to C&R on close and recommend that the user close and reopen the DB...thanks for the help though!

Hey all, I need to have compact and repair run after my import code finishes. How do I code that so that C&R executes at that time? Sendkeys may work somehow, but I haven't exactly heard good things about using that. Thanks ahead of time...

The data would be pulled from a query which gets its data from another table in the database. I don't know if comparison was quite the right word to use for this...I guess I'm more looking to find the difference between two dates and display that in a report. For example, say on 6/4/2008...

Hey all, I'd like to be able to compare data entered on two different dates (such as data from 6/4/08 and 7/3/08). I've kicked around a few things but can't seem to find a way to accomplish this. Any suggestions toward accomplishing this would be appreciated! The comparisons probably need...

Thanks for the input! I had to work with this a bit, but ultimately it pointed me in the right direction for getting done what I needed. Thanks again!

Yes, you are missing the & before your _. Try If (Me.CatCode = "Claim already paid/MBR rates no further entitlements/Duplicate Claim.") Or & _ (Me.CatCode = "Same city no entitlements / no per diem authorized in orders.") Then This should work.