Search results

  1. G

    Sync Outlook 2016 inbox\Outbox with my database

    Hi all, Is that a way to sync the outlook tables (inbox and outbox) into an access database automatically? If so, can anyone to explain what I must do? Thanks
  2. G

    Auto increasment Datasheet form height

    Good morning, Is there a way to adjust (auto increasment) the Datasheet form height depending on the number of records; Thanks in advanced
  3. G

    Hide fields using vba into a datasheet form

    Hi, This is the solution, thanks all..!! Forms!Products!ProductID.ColumnHidden = -1
  4. G

    Hide fields using vba into a datasheet form

    Hi and thanks for your help but, it does't work..
  5. G

    Hide fields using vba into a datasheet form

    Hello all, I have the following problem and I need your help: Is it possible to hide some fields in a Datasheet using vba? I need to do that because this form used into two different main forms as a subform and and I do not want some fields to appear in either. Thanks in advance
  6. G

    Append Query with Autonumber

    Not, exactly the opposite.! Example¨ Table1 Auto: 1 ID: 100100 Auto: 2 ID: 100101 Must take the records from Table2 Auto: 1 ID: 100100 Auto: 2 ID: 100101 Auto: 3 ID: 100102 Auto: 4 ID: 100103
  7. G

    Append Query with Autonumber

    Hi, Attached there is a file for better understanding on what exactly I should do: In my database there are two tables, the Table1 (Master Table) and the Table2 (Child Table). Usually i have new records form one external file (accdb) which are included into Table2. What i must to do is the...
  8. G

    Dynamic query execution option

    Because i'm not running actually only Append Queries my friend, sometime i'm running Update Queries etc...
  9. G

    Dynamic query execution option

    Guys, The first part of the issue it is now OK. I just put the following code about to run each query i want dynamically. Private Sub cmdRun_Click() DoCmd.SetWarnings False DoCmd.OpenQuery txtSelect.Value DoCmd.SetWarnings True End Sub Since some hours ago i'm trying to solve...
  10. G

    Dynamic query execution option

    Hi Ramman and thank you very much, but Why to run this? Actually i mean why i must create a virtual btnRun? To do what exactly?
  11. G

    Dynamic query execution option

    Hello all, I'm trying to create a peer-to-peer automated update process and I need some help: On Form1 there is a Listbox showing the list of queries which includes into my database. By selectring the query I want to run you will see the Textbox to take the name of the selected query. What i...
  12. G

    Format time field

    Thanks Steave but, What i must do is: Lets say into Text1 is 0600, how can i modify the above code in order to have the remain result? eg. format(Text1,"hh:nn") Is that correct?
  13. G

    Format time field

    Hi all, I need your help for this: I have a Number filed (Single type) with input mask 99:99 for hours. The problem is the report and actually those fields for hours because i'm getting eg 0600 or 1000 without the upper / lower fines (:) (displayed as a numbers) Is there a way to displayed...
  14. G

    Urgent!! 2013 to 2016 Stops All Functionality

    sorry Isladocs
  15. G

    Urgent!! 2013 to 2016 Stops All Functionality

    Everything works fine..! Check if you select True the Macros and ActiveX settings...
  16. G

    Urgent!! 2013 to 2016 Stops All Functionality

    Ηι, I had something similar in the past and the problem was the office package, before the upgrade everything was fine and after that they install the Office 2016 but not the ProPlus Edition 2016.!... I fix the problem by removing the existing pack and install from the begging the new MSOffice...
  17. G

    eMail Databases with attachment option

    Gasmn i use the vba editor ... You mean the problem is because i put Variable and must be Variant? Please....if you want modify the code in order to solve the issue..(i will appreciate a lot)
  18. G

    eMail Databases with attachment option

    Really its so hard for me the vba......I tried to put the piece of line which June gave me but.......again stacked..!!! Please somebody wants to help..?
  19. G

    eMail Databases with attachment option

    Morning my friend June, Ok, i will test it but how can i write correct the code in line .Attachments.Add "C:\AlaskaLTC.pdf" in order to take the path into FilePath Field?
  20. G

    eMail Databases with attachment option

    Morning, Please all, try to use the attached example (new one) as well as add a Path and test it..!!! Unfortunately you just see the outlook became to open and then close immediately without send the email.... Really don't know....
Back
Top Bottom