Search results

  1. G

    American eating challenge

    Found the source of your article: http://www.kgw.com/news/Woman-downs-Saylers-72-oz-steak-in-3-minutes-239644621.html
  2. G

    American eating challenge

    1) Restaurants with food challenges are all over the country. It's not normal for someone (anyone) to eat that much. 2) Most places will have steaks ranging from 6oz up to 22/25oz. 3) Prices ranging from $9USD to $30USD for most "normal" steakhouses. The upscale places will run $40USD to...
  3. G

    differences between require and include

    Sorry for the late reply Include will attempt to include a file you specify. If it doesn't exist, the script will continue, giving a warning. Require will do the same thing, but if the file doesn't exist, it will halt the script. The _once modifiers mean that it will attempt to include the...
  4. G

    i keep getting logged off

    If your connection has you changing IP addresses often, that may also interfere with your ability to maintain a single session for an extended period of time. Cheers
  5. G

    Excel file for income and expenses?

    Hi there, Do you still need a template?
  6. G

    Question Is it possible to integrate Word into Access?

    Your best bet for the letter is to build a Report in Access with text boxes for the fill in data. This will allow you to link a query to the report, based on expiration dates of memberships, and generate all of the letters you need at once. I can't speak for having the Access database linking...
  7. G

    One for the dates guys

    Weekday returns a number 1 - 7 (Sunday - Saturday by default) which corresponds to the current day of the week. If you take Date - Weekday(Date), you'll get the Saturday of the previous week. Adding 2 makes it Monday of the current week. Subtracting 5 takes it to the Monday of the previous week
  8. G

    One for the dates guys

    Try -5 rather than +2 Cheers
  9. G

    An experienced Access developer for $4.50 an hour

    I'm not terribly sure how this went from "someone is trying to hire a contractor at sub-minimum-wage" to "a cheap escort working for a pimp stole a CEO's wallet". 1) Hiring a contractor for an hourly rate below minimum employment wage is not illegal (That was the entire point of my first post)...
  10. G

    Relationship between tables ?

    Your new table should have a new PK, then have a new field for each of the two other tables' PKs
  11. G

    protecting tables from Importing

    Like I said, I have limited experience with 2003, but you should be able to make a separate mdb file and link to the tables in your first database. Then copy your forms, queries, modules, and reports to the new mdb, and make an mde from it. That prevents users from editing the table structure...
  12. G

    An experienced Access developer for $4.50 an hour

    I know Cali has some killer labour laws, but I'm not sure this course of action would be very fruitful. Elance (and other freelancing companies such as Freelance, which also acquired vWorker, formerly Rent-A-Coder, etc.) all work very similarly in that they serve as little more than an escrow...
  13. G

    protecting tables from Importing

    You can try separating the front end and the back end, which should only make the links importable rather than the tables themselves. I'm not sure if / how that works in 2003, but it's another layer they have to work through if it works. In general, Access isn't designed to be a true end user...
  14. G

    Queries on 20 tables

    Any luck or update on this?
  15. G

    Relationship between tables ?

    When you have a many to many relationship, you need an intermediate table which links the PKs of each of the tables. The general example is a store. An inventory of items, and orders. An item may be on multiple orders and an order may have multiple items. Create a table called OrderLineItems...
  16. G

    Hello from Philly

    Hello folks. I'm an IT consultant in the Philly area and work with many aspects of the insurance industry. I'm currently in the process of developing a proof of concept Access application / DB. I've been using this forum as a reference for a while now, and with the purchase of Tapatalk (I...
  17. G

    Queries on 20 tables

    If the tables must be unrelated, then you can use the Query Designer to bring in the tables you need, the fields you want, then click-and-drag the fields from the tables to make the join criteria. That usually works better for me than trying to create the query manually. I just did the same...
Back
Top Bottom