Search results

  1. D

    Car Event | Few Errors

    Hi all, i have been sick for quite a while,But back on track now.In the past i was building a car event db and would like to finish it.I have checked it out and there seems to be a few errors that i can't remember anything about. you must have outlook installed otherwise some missing...
  2. D

    Tools Menu > References. - Should I Select All.

    Hi all, Should I select all the check boxes under the tools menu > references in vb. as this is what I have been told as it stops errors in databases that reference a library that's not available. Thanks
  3. D

    Backup Utillity - Compile Error: User Defined Type Not Defined

    Hi, I have a backup utility in which I previously used all the time. Now it's come up with the following error Compile Error: User-Defined Type Not Defined Usually you selected your paths and then clicked back-up. If you had a registered copy of WinZip it created a backup called e.g...
  4. D

    Car Event db 95% finnished - please review a few small errors

    This database is for a car event that's held once a year. It has been a work in progress for about 15 weeks now and is basically finished. There is only a couple of errors and not sure where to start. The database is so big it is getting a little out of reach for me to organize everything. Idea...
  5. D

    Auto Pop-Up Box When Clicking On A Field.

    Hi, I have a Category form with a products sub form so that upon selecting a category it displays the products for that category in the sub form.What i want to do is have a pop up box so that when a person clicks on the product name in the sub form it pops up saying you need to open the...
  6. D

    Before Posting

    Found this on the net should be a definate for everyone before posting.:D Before Posting
  7. D

    Form and subform help

    hi, i am after some help on setting up a form, let's say you hold a car event every year. (car event 2004, car event 2005, car event 2006) your entrants could come to each of these events. I have an entrant form and would like to add a event subform with a combobox that you can select each...
  8. D

    Quick Query Question

    Just a quick question. is better to use a query for a form or just link straight to table. e.g you have tblColour, this table has ColourID & Colour.should you build a query including all fields then build a form from that query? Thanks
  9. D

    IsLoaded Error

    Hi, I have resently finished my customer servicing db and have noticed an error. When you try to add another user, you get an error; (See IsLoaded-Error.gif) Because it is Complete you can download the DB @; (300kb) Click Here Any Help would be greatly appreciated, Thanks. Dean Welch
  10. D

    Feedback on DB Please

    Hi, been working on this database for the last 9 months on and off, and was after some feedback on any final tips. the database is for holding info about customers that bought machines (wood chippers) as we use MYOB for financials this is just really for the workshop for the employess as to...
  11. D

    IsNotNull In Query

    hi guys, I have this query which looks up machines by there serial number, It brings up a pop up box saying "What Serial Number" which is where yopu type in the serial number of the machine you want to view. But i would like to display an error message if no serial is entered, is this possible...
  12. D

    Sychronizing Combo

    Hi, I have done a search and can't seem to find anything on synchronized combo boxes, sooooo, If i had tblCateories with CategoryID & CategoryName, And tblProducts with ProductID, ProductName how would i sychronize these. I have seen the example on Microsoft but cant seem to follow it. Thanks,
  13. D

    Database Check

    Could somebody please check over my database, it is finished and just would like some last minute Input. Click Here Any Ideas would be greatly appreciated. Thanks,
  14. D

    Table Help

    I thought i was finished but seem to be running into some trouble just wondering if yous could have a look at the tables and relationships and see if they look alright. As I am starting to get confused. This is access 97 Version db 97 version
  15. D

    Form Help

    Hi, Thiought i was finished but still need some help with my customers form, what i want to do is be able to view the parts needed to do a service on a customers machine.i curently have the customers form and machine details sub form, but if a customer has 3 machines i want to be able to select...
  16. D

    Stand alone DB

    can anyone help me with making a database work even if you have not got access installed, i have done it before a long time ago but can not remember what it is called. Thanks, Dean :confused:
  17. D

    Form design

    can somebody help with my forms please, check them out and let me know of any improvments to be made. PASSWORD IS THE USER NAME!!! SAMPLE IS IN ACCESS 2002 VERSION. Thanks Dean
  18. D

    Design Suggestions Please

    think i should be posting here as it is more of a design question, i would like a list of customers who have bought machines off me, the machine they bought, the serial number e.t.c, parts used in a service on this machine.This way i can click a button to display a list of items needed for the...
  19. D

    Form Suggestions

    Can anyone suggest a good form layout for my database below? I have also included the database in access 2002 version! tblEvent EventID (int autonumber not null primary key) RaceID (int foreign key to tblRace.RaceID) EventName EventTrack EventDate tblCar CarID (int autonumber not null primary...
  20. D

    Please Suggest Forms

    Can somebody help with form layout for my database please? (e.g sub-forms maybe.) database is in access 2002 version! Thanks in advance.
Top Bottom