Search results

  1. B

    FIFO

    Hi all There no idea coming to my mind to how to perform me. That is what I need. Suppose I have purchase table with following data Batch no. Quantity. Date. 1001. 100. 01/01/2014 1002. 50. 02/01/2014 Now supposingly sales as follows Date. Quantity invoice no 05/01/2014. 125 1 10/01/3014...
  2. B

    too few parameters. expected 1 Error

    please help when i use the following code with Query have criteria too few parameters. expected 1 Error the code Code Tags Added by UG Please use Code Tags when posting VBA Code Please feel free to Remove this Comment...
  3. B

    Import txt file

    i have text file want to import but need to ignore first row and make second row contains field names
  4. B

    send file by mail VBA

    Hi my friends the following code to attaches all file in folder and send it by mail auto I need to make the code not to sent mail auto but preview the mail and I will send it manual [ Dim mess_body As String, StrFile As String, StrPath As String Dim appOutLook As Outlook.Application...
  5. B

    Split same report and attached to Email

    hi my friends I have a report include 3 Pages I need to make a bottom when I click on it , auto generate an outlook mail with 3 attached ( Page 1 - Page 2 - Page 3 ) as a PDF I use the following code Private Sub cmdEmail_Click() Dim strpath As String Dim arr() As Variant...
  6. B

    Repair

    hi all i need to know if i can make a buttom with code to repair access database
  7. B

    option buttom

    hi this my first time to use option buttom but i have one problem i have 2 option (1 & 2 ) i need when user select 1 system auto unselect 2 and when user select 2 system auto unselect 1 However , i only selected please
  8. B

    split numbers

    Hi my friends I have a big issue First I have a 2 table the first on contain the name of transaction and quantity EX : quantity Name of transaction 4000 HQ1 4500 HQ2 1500 HQ3 The second table contain the split data EX : Split to quantity baher 5000 yassin 3000 selim 2000 So I...
  9. B

    Error when change to 64 ( username )

    i have the below code it work in win 32 when change to win 64 , i have error Option Compare DatabasePrivate Declare Function apiGetUserName Lib "advapi32.dll" Alias _"GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As LongFunction fOSUserName() As String' Returns the network login name...
  10. B

    Error Too Few parameters

    Please Help
  11. B

    chang Name

    need VBA Code to rename Table1 to table2 thx
  12. B

    chek Yes/No

    I have a "continuous" subform which is linked to a table which has a checkbox field. I would like to create a Check All/Uncheck All in form
  13. B

    data from web

    need to link data from web to tabel the web is --- http://www.egx.com.eg/English/marketsummry.aspx and need to auto update when open table Please help
  14. B

    collect data from web

    i have a web and need to collect data to my database
  15. B

    Append to other Protect with password DB

    Hi ,, i have a append Query Name is ( Run ) and DB Name is ( Old ) Need to append to DB Name ( New ) with password is ( 123 ) in Tabel Name ( Run new ) both DB in C:/ Can any one help me Please :D
  16. B

    Auto Backup

    Hi all Need database to make self-backup every day in the same time
  17. B

    Auto Close Database

    Hi all I have a access database in share network need to put code to close database when the user I idle for 15 Min
  18. B

    how Can make texebox Circle

    how Can make texebox Circle thx
  19. B

    Primery Key

    how can change notification massage
  20. B

    page number

    i need to change report page number to be page 1 of 1 ( NOT 1 of 3 ) depend on group ( invoice number )
Top Bottom