Search results

  1. A

    filter report

    I have a report filter that filters the reports by month and year: DoCmd.OpenReport "AttWholeCity", acPreview, , " Month = '" & txtCourseDateMonth & "' AND Year = '" & txtCourseDateYear & "'" I want the code to also show these two columns where there are null/blank values aswell...
  2. A

    query remove null rows

    I have a query SELECT TOP (100) PERCENT CONVERT(char(3), dbo.tblCourses.CourseDate, 0) AS Month, YEAR(dbo.tblCourses.CourseDate) AS Year, gp.OrganisationCode, gp.Name, gp.Address1, gp.Address2, SUM(CASE WHEN a.AttendanceStatus IN (9) THEN 1 ELSE 0 END) AS Attended...
  3. A

    Query help show all from table

    Hi I have a query: SELECT TOP (100) PERCENT CONVERT(char(3), dbo.tblCourses.CourseDate, 0) AS Month, YEAR(dbo.tblCourses.CourseDate) AS Year, gp.OrganisationCode, gp.Name, gp.Address1, gp.Address2, SUM(CASE WHEN a.AttendanceStatus IN (9) THEN 1 ELSE 0 END) AS...
  4. A

    Access Database Password protect how to

    Hi I have an access.adp project how can i password protect it I have looked for tutorials and it states encrypt via the File - Info tab but this option is not avaialble on .adp projects? is there an alternative thanks
  5. A

    open report vba filter

    Hi I have vba code DoCmd.OpenReport "MonthlyData2", acPreview, , " YEAR(CourseDate) = '" & Me.txtCourseDateMonth & "' " this works sucessfuly how can I add the following to the code so it filters month and year? '" MONTH(CourseDate) = '" & Me.txtCourseDateYear & "' "
  6. A

    passing parameter to stored procedure from a form to generate report

    Hi I have an access .adp project and have a stored procedure created in sql server, I wanted to know if its possible to have an access form that takes input and when a button is clicked this runs the stored procedure where the parameter value required is what the user has input into the form...
    • ayh1
    • Thread
    • Replies: 0
    • Forum: Forms
  7. A

    mail merge for a single record

    Hi I have an access .adp project which is linked to a sql server tables (2008 r2), I have a button on an access form which I click and successfully gets customer details based on a query. What I wanted to know is when I am viewing a specific record i.e. details for Patient Number X, when I click...
  8. A

    stored procedure and parameter pass via form to generate report

    Hi I have a stored procedure created in SQL SERVER 2008r2 I have a form in access adp project with combo boxes, when I click the submit button I want the values chosen to be the parameters and the stored procedure called to generate a report is this possible thanks
  9. A

    Access form to insert data in sql server table

    Hi does anyone know if theres any tutorials on how to create a form in access to insert/update/delete data from a table in sql server?
    • ayh1
    • Thread
    • Replies: 4
    • Forum: Forms
  10. A

    Report via stored procedure SQL server

    I have created a stored procedure parameter query and using access created a report that runs the procedure and creates a report based on a parameter entered: 1) I wanted to know if I can specify a default paramter so if I do not input it returns all records? 2) Can I create a stored...
  11. A

    Cascading combo box sql backend

    I have a cascading combo box that successuflyl returns data from sql server tables venue and date, when I save the record it saves the values but when I re open the record for a particular patient the combo box values are cleared and do not display patients appointment venue and date although it...
    • ayh1
    • Thread
    • Replies: 11
    • Forum: Forms
  12. A

    Auto increment field

    I have a table created in sql server linked to my adp project, I have a field course_id I have a form to create new courses when I click the button I get an error saying course_id is null value, how can I program in vba so that the value auto increments when I click new course button.
Back
Top Bottom