Search results

  1. C

    Query and report building?

    Sure, but you can go ahead and post it here if you like. As far as the auto number goes, it will start at one... add every time you add a new record to that table. If you start with one, add 20 records, then delete those 20 records your second record will have a number of 22... It does not start...
  2. C

    Query and report building?

    Well, thats a lot of explaining :) You can look at the relationships, that will show you how the tables are joined or related. Also you can open the query and put it in design view. That will show you how it is setup. try using the wizards to create queries, tables, reports... That will also...
  3. C

    Query and report building?

    See if this at least answers your questions....
  4. C

    Query and report building?

    OK, I am taking it your three items are fields. Action, Setting, and Genre. Put those three in a query. Simple way to show you what it is doing is in the criteria of the fields put "Pick Action", "pick Setting", and "Pick Genre" when you run the query a parameter box will pop up... in your...
  5. C

    Gotorecord Next if previous record Less than current

    How bout an "if...Then" or "Select case" using the "Greater then" or "Less then" to determine which code is executed?
  6. C

    Discussion For RIBBON

    Agreed! We deal with VBA as a separate topic.... The ribbon is here to stay... like it or not... so we now deal with XML...
  7. C

    Calculation using a value from a form and a sub-form.

    Is the form and subform built on one query? If so it would be much easier to put the calculation in the query.... paths sometimes get tricky... I like to use the "Expression builder" let it build the path...then copy and paste it. Also, look for a missing "=" sign in the control source of the...
  8. C

    Easiest way to do...

    Yes, thats what I meant by your subform would be "filtered"... In your criteria you reference the fields on the form. So if you have a project date field [ProjectDate] you would reference the employee available dates in the criteria of [ProjectDate] as "Between [EmployeeDate1] and...
  9. C

    Ignoring Required field

    It sounds like you have your validation code on the field...combo, and not on the forms beforeupdate event...... :confused:
  10. C

    Part lookup / Part add record form

    OK, I would suggest a combobox in place of your "Text1" But, first, you do not want to, or need to, and you should not store your "description" of item in both tables. Use a combo built on table A with field "ItemID" and "Description" Use the wizard... Do not pick the "hide" button. In the...
  11. C

    Part lookup / Part add record form

    Sounds like you first need to look at "normalization" It looks like either have or you are going to have, the same data in multiple tables... A No-No.......
  12. C

    Easiest way to do...

    My two cents........ I think I would first add another table... Should like you need to track "AvailableTime" of employees. Then in your join table I would add ProjectTimeStart and ProjectTimeEnd... or whatever it is you want to call it..... On the main form beginning and ending time/Date, and...
  13. C

    Access 2010 at the SDC

    I remember the day when I could build a MS Frontpage website and store the data input from a form in a Access DB on that website... Doesn't seem like too much of a stretch to expand on that to make a fully functional Access DB online.... OH WAIT!!!! Then they couldn't sell sharepoint..... my bad.
  14. C

    Delete record harder than it seems

    Usually if the button created by the wizard doesn't work there is a reason..... These are products? Has a product being deleted been used in another record? If so, do you REALLY want to delete it?
  15. C

    Displaying Web Images in Form

    I'll give this a shot in the dark..... having never worked with sharepoint I don't know if this applies... But... You should never use a Drive letter when linking FE to BE... The G drive on one computer might be the F drive on another..... Always link using My Network Places...So use a path to...
  16. C

    RE-install problem

    Hope someone has had this problem....... Had a problem with XP, did a repair... XP is working fine (as far as I can tell for now) But I had to reload office 11, and was trying to get my Access back on... I loaded 2002, works fine, when I run the 2003 upgrade it appears to be installing...
    • CEH
    • Thread
    • Replies: 0
    • Forum: General
  17. C

    Field to show Day of Week

    Try this........ =Format(DtmSessionDate.Value,"dddd") On your control source of "Day of Week"
  18. C

    Focus Problem

    Sounds like you can just set the focus with the code.... at the end... last line.. something like..... Me.TextboxWhatever.SetFocus
  19. C

    Displaying movies within a form

    Ah..... I've been here so long I don't remember it doing that :) Well, the app does work with video. You add "Media player" or whichever to your "Programs list" and then add the mpg or avi to "image" It is throwing an error when you add a "mpg" but if you ignore it, it will open the mpg in the...
    • CEH
    • Post #10
    • Forum: Forms
  20. C

    Displaying movies within a form

    I'm lost.... Are you trying to attach something to your post and it won't let you???????
Back
Top Bottom