Search results

I believe he means instead of a period there should be a comma: "Sometimes I don't know when to shut up, but cupcake's been telling me that for a while now." The correction you made however would also make sense. But while I'm here, congratulations! Regardless of where you've posted, it's...

Couldn't agree more. This happened when I was only 10 and I still remember vividly watching it on TV. Even if you despise America you had to somewhat respect her willingness to go for another vault with a bad ankle to help secure gold for the US.

It's true, there are a few around here I could probably scope out...just gotta scrape up some money...stupid college ;) I guess a buddy of mine brews his own varieties beer, and some of what I've had is pretty good. I guess I could try brewing myself as well...

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