Search results

I've been out of the loop for a while so I can't remember the best course of action here. I have a table with a list of Orders that need to be worked by a team in our company. I also have a form that Administrators use to select a batch of those orders to work. The options they select are...

So you already tried this? Does the wizard appear at this point? Also like hutchinsfairy pointed out, this only works from the task pane; not the toolbar button. The ribbon in 2007 might be in the same boat so-to-speak, as the equivalent toolbar button, so I would definitely try and find a...

Well, I know for sure that it works with Office 2003. That could be the source of the problem, but not necessarily so... What steps have you taken so far? and have you tried anything else without luck? Try to be as specific as possible.

Quick questoin for all you server admins. I am setting up a new box running Windows Server 2003 R2. This is going to function mainly as a test server for SQL but will also function as my home media server, ftp and http server. I have 380GB total to spare. I was thinking about partitioning...

Also, I believe you are missing some closing parentheses. Don't have time to find exactly where, but by my count, you're either missing some closing parentheses or you just have them in the wrong place.

Well, I'm going for it. Starting school in January and I'm going for a BS majoring in Database Management. I know Access and VBA like the back of my hand and I'm a fast learner, but I don't know everything I need to. There will definately be instruction on complex SQL queries, Oracle and DB2...

Does that system run on iSeries by chance?

True. Essentially, you would have to mirror the way Access records relationships and then displays that data in a visual format in the relationsip window. Anyone who's ever looked at the relationships system table in access would probably agree with you Gemma. Myself included. Difficult...

That, right there, explains it all IMO. Thanks for your input guys!

That's what I was thinking. For the purpose of preserving data, never having to delete records, I figured it was reasonable. I have found it beneficial to automatically include CreatedBy & DateCreated to almost every table I create. This helps with tracking and so forth. Adding those fields is...

Do you find it typical to include a field called something like "IsVisible" to most of the tables in any given database, then create a corresponding query for each of the tables which includes all fields where IsVisible = true, then for anything you create in the future, you base it off the...

I started evaluating the work involved in incorporating seperate tables for city, state and zip. I feel like it might be out of the scope of this project. It would require updates any time a new zip code is created, not to mention the overhead (forms, queries etc.) needed to facilitate an admin...

Great suggestion RainLover. I am currently revamping the design. Please stay tuned for an updated copy in the near future. Changes and improvements will include: 1. Primary & Foreign Keys will follow a naming convention consisting of a 3 or 4 character prefix. E.g. tblEmployees' primary key...

Now that is a great 1st post! I'll definately be hanging on to that.

Thanks for the review. I really appreciate it. So what I've gathered is this: 1. Better employee management is needed I built this as an add-on to a much MUCH larger existing database which already had an employee table. I may decide to make the employees table a permanent part of this sample...

I don't understand. Is it not opening correctly?

Sounds like you could even create a new database to document the oracle db :p

I think that would be a great idea.

I think what's happening is you don't yet understand Relational Database Theory. You're trying to replicate something from Excel into Access, but you're still thinking in terms of Excel. Please corect me if I'm wrong, but that's just the feeling I have.

I'm building a crosstab query to show different totals and counts for monitoring scores. The query that the crosstab is based on has a date parameter where the user enters a start and end date (always a 7 day range) but in the results, I also need to see the average score for the previous week...