Recent content by iroyal2016

  1. I

    how Rename output(pdf) file in vba code?

    hello every one, after searching on websites for solutions to my problem which is : how to rename my pdf file that's include name and let say the date of today, and I found the answer for that, and I would like to share with you : Sub CreatePDFandRenameit() Dim x As Variant Dim y As Variant...
  2. I

    Q:why recordCount with query give 1

    but I gotta say something:- FIRST: I am new here. Second: I didn't ignore any one, but sometimes I couldn't understand. Third: I did follow all steps in the video step by step Last: my goal was to get the result without any editing because I've seen it in the video work perfectly good., that...
  3. I

    Q:why recordCount with query give 1

    thanks it works
  4. I

    Q:why recordCount with query give 1

    SORRY, BY MISTAKE ----- but still, it doesn't work .
  5. I

    Q:why recordCount with query give 1

    maybe it will work, but I gotta understand why this code doesn't work with me even I watch the video and follow all the steps one by one. I know that I can get count record in another way, but I want this code work. thanks
  6. I

    Q:why recordCount with query give 1

    I tried to fix my Code : Public Sub getCount() Dim db As Database Dim rst As Recordset Dim x As String Dim strSQL As String strSQL = "SELECT Employees.Company, Employees.[Last Name] FROM Employees;" Set db = CurrentDb Set rst = db.OpenRecordset(strSQL) With rst Debug.Print .RecordCount...
  7. I

    Q:why recordCount with query give 1

    Hi, I'm new in this forum and welcome all I have a small question : Public Sub getCount() Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String strSQL = "SELECT Employees.Company, Employees.[Last Name] FROM Employees;" Set db = CurrentDb Set rst = db.OpenRecordset(strSQL)...
  8. I

    hi every one..

    Hi every one I'm new in this forum, and an emglish is NOT my mother lungauge , but i'll try to understand each of you .. and the about reason that I register for it : TO help the ( biggners) and to learn from ( experts ) I want be useful as much you..:D and that's it... goodluck everyone:)
Top Bottom