Search results

  1. A

    Find a record, SubForm, Help.

    Post a db please
  2. A

    ODBC limits

    Mmmmm ..... do you have access to the certain libraries ? We have a number of libraries with different sets of tables. ODBC admin sets user access to the libraries and tables within the library.
  3. A

    Notes Calendar problem....

    I thought I did what you have asked As you load form1 you will see 3 records ... new one will reflect the date = to date_picker. Select 2nd of January ... you will have only one record as of 1st of January To filter out the records with the Sign OFF check mark (16/03/2005) Go to design of...
  4. A

    Notes Calendar problem....

    Converted to acc97
  5. A

    update query to add percentage and round

    Yournewfield: Round(([Youramountfield]*1.1)/100)*100
  6. A

    Removing Duplicates while keeping a running total

    Looking at your example ( which is not a running sum ) you can do the following SELECT Yourtable.[Part Number], Sum(Youtable.quantity) AS Quantity FROM Yourtable GROUP BY Table1.[Part Number];
  7. A

    Sending a record to a subform query

    You can create an append query with selection criterion eq to recnumber field on the subform. Now when the button is clicked it will run an append query then will set the amount value to 0 and refresh archive subform.
  8. A

    Notes Calendar problem....

    Is this what you wanted?
  9. A

    Trouble with filter

    Can you post your db?
  10. A

    Validating data

    Check onclick event of the third tab. Or click alt+F11 and search the modules for the text you see in the message.
  11. A

    Calculating two fields from a form and a subform

    =nz(DSum("[subformsourtableNumberfield]","[subformsourcetable]","[Fkeyinysubformsourcetable] = [PkeyMainformsourcetable]"))+[MainformNumberfield] This is the example of my calcs on the form.
  12. A

    EASY ACCESS problems...PLz HELP ASAP! Don't want to fail my class..*fingers crossed*

    =iif([Product]=Home,1,0) if you leave the formula like this in access it would be automatically turned into =iif([Product]=[Home],1,0) as it will assume that HOME is a name of a field. Correct spelling would be =iff([Product]='Home',1,0) "re: Qty/Price/Freight formula, I got this one to...
  13. A

    Having a Calendar show today's date

    On load event of the form place a code yourcalendarcontrolname.today
  14. A

    two questions- (two frames and html form)

    http://www.mvps.org/access/resources/downloads.htm/accwebfaq-10-10-00-a9.zip try this link
  15. A

    using sum on two subforms for main form

    I know that you have resolved the issue but for the reference http://www.mvps.org/access/downloads/syntax_for_subs.zip
  16. A

    TheImpossibleSubformsearch

    post your db please
  17. A

    a challenge

    Go to Tools Options Advanced .. set the default record locking method to whatever you need to.
  18. A

    Forms sourcing from multiple tables

    Why do you want the same set of data to be in another table if it is already in the first one. I mean the name and the contact info
  19. A

    Using sum function between forms

    Go to the tables tab open instockcontrol table in design view and set property of ProductID field : requered - yes. Would be good to set the same property for all the fields you think are required to have values in order to avoid the junk records. As for preventing the records being entered if...
  20. A

    Using sum function between forms

    The field is updated every time when the data on the main form gets loaded. So ... you can put a button on the main form with onclick property me.requery , which will recalculate the field on demand otherwise you will need to track all events which effect the calculation. I mean if you add a...
Back
Top Bottom