Search results

  1. H

    What is this

    Hello, I tried to make my inventory database multi languages by trying to recall back what I made (Church membership database)by the help of community in UtterAccess. I tried to search if this is the form but none, so I guessed that this is the language or VBA Call FillFormLabels(Me.Name) Am...
  2. H

    Not showing date

    Hello, Some date fields are not shown in report when we print it, while in the print review/ display are shown well. Can anyone help me how can I solve the problem?. See attached. Thank you, Frank
  3. H

    Recombine the split database

    I want modify my database that is already go live. What is the best way to recombine the split database, because I want to change the structure to have a table for A company name, and also I want to make it a multi languages. Thank you, Frank
  4. H

    To format date on the report

    Hello, I want to change the format of the text column in my report. The content of the text is this: =[Forms]![frmReportselection_ReceiptbyItem]![txtstDate] & " to " & [Forms]![frmReportselection_ReceiptbyItem]![txtEndate] but It can not work, it always show this format mm/dd/yyyy, I want it to...
  5. H

    Not autofind in the description

    Hello, I noticed that any supplies description of our supplies starting with "#", e.g "#15 Citra Cide" This will not be auto find, so we have to scroll down and search on the combo window. Anyone can help me why, and how can we solve the problem?. Thank you Frank
  6. H

    VBA to avoid duplicate supplies item

    Hello any body can help how to avoid duplicate supplies in one go of the data entry in the form? As you can see in the attached form, I want the user as he type the same supplies name there will be a massage saying " this is duplicate, please enter it in the next data entry. Thank you. Frank
  7. H

    Report selection by customer

    Hello, I have already report selection by date for certain item supplies and then I will select by certain custumer/supplier, can I add the selection in this column of query? this: [Forms]![frmReportselection_ReceiptbyItem]![Combo_User] Thank you
  8. H

    Continue developping

    Hello, I keep continuing in development of my supplies database while it is going live. What is the best method to do it. I can do it in the office, but when I want to do it at home, the link path of the table after it was split, is different. What I had in mind, I export the link path at home...
  9. H

    How cab we add date selection on the report

    Hello, This is my selection date in my query: Between [Forms]![frmReportselection]![txtstDate] And [forms]![frmReportselection]![txtEndate]. My question is how can we have date from the above txtstDate and the txtEndate, because in the report header I will put Report selected from txtstDate...
  10. H

    export my report to excel

    Is there any way to export my access report to excel. How can we make the external menu be available in print review. or can we make a macro button to export the report to excel? Thank you. Frank
  11. H

    not to leave a field of main form blannk

    Hello, How can we make it not to leave a field blank such as customerID from the Main form, before it goes to the sub form as I marked in red in the attached form. Because when we got in the sub form, I can not get back to the previous field ( CustomerID}. and get stuck, so I delete the...
  12. H

    exit from the form

    Hello, can anyone help me how to make on the form : on Load, there is a message says" please do not use this form, still under development" the user press OK, then exit the form. Thank you for any help. Frank
  13. H

    access limit

    Hello, attached is my switchboard menu. Is there any simple way to not allowing anyone to access menu no. 1 " New Items of supplies", Or just to allow User-3. I have the user table with the field "Users". Thank you for any help Frank
  14. H

    What is new in the new version

    Hello, I keep updating my Inventory database that is already go live. My question is where can I store the information of each version. I do not want to keep in in the table, but just somewhere in the software that just the developer that can access it and know the information Thank you. Frank
  15. H

    TempVar

    Hello, I am gonna try like this class module on on load of each form in order to make user for Read_only on each form: rivate Sub Form_Load() Dim User AS String Dim LoginType As Integer User = Forms (Mavigation Form)!TxtLogin LoginType = Dlookup("UserSecurity","TblUser","User2") If...
  16. H

    new customer or supplier is not shown in Combo

    Hello in my supplies issuance form, there is a button to add for new customer or supplier. when I add it, it will not be shown on the combo box, until we close the form and open it. What event procedure shall I make on the combo in order to automatically showing the new added supplier, just if I...
  17. H

    how can I edit report grouping

    Hello I just copied the customer report to supplier report in order to make a supplier report gouping by supplier or items. Can anyone hlep me how to edit the grouping from cutomer id to supplier id as shown in the attached picture. Thank you Frank
  18. H

    bat file

    I want to create a bat file on excel by creating a button and by clicking it, it will execute to copy my FE to server folder or can I make a button in the Admin form/page to copy it's FE to the server?. Can it copy itself while it is open?
  19. H

    Form automatically goes to the right side or left

    Hello, what is in the property of the form that can place the form to the right side of the screen when we open it.
  20. H

    Pickup the value of the table on Form

    Hello, I want to pickup the value of a column in a table, but the source of the switchboard form is not from the table. I want it to show the version number on the form. I tried this:SELECT tblLocalVariables.ID, tblLocalVariables.Value FROM tblLocalVariables as the the source of the textbox...
Top Bottom