Search results

got it http://www.databaseanswers.com/data_models/index.htm Thanks!

Some time ago I remember seeing a link to a site where a member had posted sample data schemes, relationships and templates for various types of databases. What was the link? Thanks, vetter

Ideally yes, but this data already comes from a data source that is in that format. I can't change the format of this legacy system.

I have 2 tables that have sales data, one for 2002, one for 2003. I would like to combine them to have all the data in one table. The format needs to be like: Cust, Item, 2002, 2003. If I have a cust, item that was purchased in both 2002, and 2003 will this show up in the same row? If the...

I've in the past seen a helpful article on how to take an employee/ supervisor table to create an employee hierarchy. It would start with an employee lookup on their supervisor and so on until it reached the top. I believe that it was done by simply adding the same table in the query multiple...

If you are looking for some books for reference see http://www.developershandbook.com/ . These guides have helped me IMMENSELY!! Also, what that developer is charging is not out of the possibilty. It may or not be a fair price depending on what the application entails. It takes a lot of time to...

Instead of using the loop...why not use the printout method Place this in a command button code to fire the opening of the desired report: DoCmd.OpenReport "YourReportName", acNormal, "" Then in your report activate event have DoCmd.PrintOut ,,,,Forms!FormName!TextBoxName Hope this helps, CT

Check out MS KB Article # 123079 for a host of user/group functions http://support.microsoft.com/default.aspx?scid=kb;[LN];123079 HTH, vetter

I've always used the Ken Getz code (defaultprt.zip). You can get details from Dev Ashish's site at: MVPS - THE ACCESS WEB

Check out MS Knowledge Base article: #209215 - How to Reset the Page Number on Group Level in a Report http://support.microsoft.com/default.aspx?scid=kb;en-us;209215&Product=acc or MS KB # 131937 - How to Reset "Page of Pages" Numbering for Report Groups...

In the past Microsoft has made all the knowledge base articles for a particular release of Access available as a download file. Does anyone know if they have an updated version for Access 2000 or XP? I've only been able to locate the 97 version. Thanks, Vetter

I am creating a report and have a query that is sorted on dollars and pull out the top 10 dollar amounts. Now what I want to do is get all the other items and sum them up to get an "other" category. I'm able to do this currently by creating an unmatched query using the query wizard between my...

Andy- There are many, many packages that can do remote control of machines some are free (http://www.realvnc.com/), some are pay(GoToMyPC, pcAnywhere). WindowsXP includes the software to do this as well as the clients to setup on different versions of Windows. Do a search in google on "remote...

This is what I've done in the past. 1) Type my text in MS Excel. Set the wrap text. Align the cell to show your text like T e s T 2) Copy the cell. (Ctrl+C) 3) Paste into Access Form. (Ctrl+V) I don't have to do any shift enter tricks, can have more then one word on a line, etc. HTH, Vetter

I've used a hand-held device before with a db. In my case, when the user opened up the data entry form...it set the focus to my key field. When the user scanned the barcode, it went straight from the reader to the db form(no text file or intermediary step). I was using a symbol technologies...

I've used a hand-held device before with a db. In my case, when the user opened up the data entry form...it set the focus to my key field. When the user scanned the barcode, it went straight from the reader to the db form(no text file or intermediary step). I was using a symbol technologies...