• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

Search results

  1. V

    IsNull - Switches

    Hello Mates need your help! I;m Using If IsNull(ItemCode) = True Then How can I specify other table Name and then Field name If IsNull(tableNamehere, fieldnamehere) = True Then Something Like That... Thank you!
  2. V

    Editing SubForm Data From Main Form!

    Hello Need your help. I want to edit, add, delete data of sub-form field (it Is a Memo Field) from main table... Please Help!
  3. V

    Sequential Numbering Auto "Bar-Code"

    Please Help of Implementing Sequential Numbering Auto "Bar-Code" I need that Bar-code automatically assigned to a new record when registering. Here is the Standard Example: 5555-01-001 1. Barcode Must be only in Numbers (Minimum 9 digits) 2. First 4 digits are fixed numbers (Must not be...
  4. V

    Building New Database!

    Hello Dear Friends! I'm Building New (Office Assets) Database from the very beginning, and your Help, Suggestions, Opinions and Ideas about this will be highly appreciated... I Created a Tables and please look at it and suggest if something is incorrectly or is not well normalized. Greatest...
  5. V

    Limiting Rows By Given Number In Continuous Form

    Hello Friends, I have a Question about limiting rows by given number in continuous form.... Please look at picture: I want that the continuous form on my sub form to be limited by a product quantity, that users accidentally not enter some extra data...... Thank you In advanced
  6. V

    How To AutoNumber a Continuous Form In Access

    Hello I have very simple Question... I wonder How to simply Auto-number continuous form as we simply do in the Reports like: =1 (With Unbound Text-Box) I searched, but found nothing. Thanks
  7. V

    Need To Convert Expression To VBA

    Hello Friends.... I have a question I need to rewrite my code which I made in Expression and need to convert to VBA, if it is available: =[UnitPrice]*(((100-[Deprpercent])/100)^Int(Format(Date(),"yyyy\.mmdd")-Format([DateOfPurchase],"yyyy\.mmdd"))) the idea is: I Placed this code on unbound...
  8. V

    Can't Sum On the Report Footer

    Hello Friends, Need your help! Something wrong, Can't Sum On the Report Footer In the detail I have Unbound Text-box "LossMoney" With Expression =Nz([Price])*Nz([Qt3]) working ok giving the correct results. Now at the footer of the report I want to sum the "LossMoney" Tried many variants, but...
  9. V

    Linking DISTINCT & NON DISTINCT Queries

    Hello Dear friends, I have a question if it is possible and is the right way to join 2 Queries, 1 Distinct and the Second non Distinct Both of them is working properly independently
  10. V

    DISTINCT Records By Command Button

    Hello I have a question About DISTINCT The Records by a command button. I searched but, can't find anything like that.. I have a Continuous form based on a query and I use "SELECT DISTINCT ........ it works perfectly DISTINCTS the records as needed, but i want to add on the form a command...
  11. V

    Exclude Unique Value Field From DISTINCT

    Hello Mates Need your Help! I have report which is based On a QRY "QRYName" I use distinct, for example: SELECT DISTINCT QUERYDATA.Product, QUERYDATA.Brand, QUERYDATA.Model, FROM QUERYDATA I want to add a bar code but how to exclude it from distinct? Thank you in Advanced
  12. V

    Installing, Registering Font(s) Form Access

    Hello Friends Help Registering Fonts From Access form: I have One font which is not a standard font and is not included by default in Windows, My fonts Place Is D:\DB\RES\Fontname.ttf If i copy my front end database to another PC I need that user could click reg button and the font to be...
  13. V

    Universal Path to Form Images Folder

    Hello Friends I have a question and could not find an answer for this. I have an 'images' folder in my Project folder (For Example D:\DB\IMG) DB is the folder where My access project file is and IMG is the folder where all the Access design images and icons are stored. Everything is OK No...
  14. V

    Creating Transparent Forms

    Hello Dear Friends, Please help.. I want to make a transparent form in my project, I tried many variants (Found in The Web), but not worked well, had many errors and the form was very uncomfortable.... I wonder If it is possible to make The form Like in the image:
  15. V

    Question About Clone, Duplicate Records

    Hello! Having a form command button on it, being clicked it duplicates, clones the current record, everything is OK Now Question: If I want to have 10 identical records then I have to click on It 10 times, is there any solution to specify a number of clones, duplications (for example If I...
  16. V

    How To Recalculate All Records

    Hello Mates! I Made a command button to recalculate the field values (For Emergency if somewhere accidentally was left not calculated) here is My Code: Me.Sumall = Me.Quantity * Me.Unitprice It works only the current record (Which I See on the form) My task was: To search the given field...
  17. V

    Can't Filter Combos!

    Hello Friends, I can't filter combos i tried some variants but without success, I use on my form some VBA... Please See the example: When Open a "FORM" There is filter combo when you select something it must be filtered on second combo..... Please Help!
  18. V

    How To Attach A Cache To The Combo Box

    Hello Mates, I need your help or Suggestion: I have a form with combo box (I'm searching data from it, it works well), Now I need to cache the keywords in the combo (that combo could store frequently searched keywords). Thank you very much
  19. V

    Choosing Destination Report

    Hello, Please Help! I have a form With A button on It: Here Is The Code On Error GoTo Err_Preview_Click Dim stDocName As String DoCmd.Close stDocName = "DATA" DoCmd.OpenReport stDocName, acPreview Exit_Preview_Click: Exit Sub Err_Preview_Click: MsgBox...
  20. V

    How To Display Date In Other Language In Report or Form

    Hello Dear friends, I need your help! I played with it, searched in the web, but without any results and goals. So what I need.... As usual I use Date (Long Date) in English as default, because we use that standard at our office... But there are some kind of reports to be generated with The...
Top Bottom