Search results

I have recently been told of an error with one of my databases. The error number is 2926. The description is "Because of your security settings and current security policy, this control is disabled. To modify your policy and enable the database, use the Message Bar". On investigation, my copy of...

Hi All I'm looking for a bit of guidance. I am trying to set up some template emails using text someone has entered in a form with a variable indicated with a key word in brackets aka. [ChangeID] or [ChangeDate]. The field on the form is formatted as Rich Text so I am getting http code. (No...

Hi All I wonder if anyone can shed light on my problem. I am generating an Excel file from VBA on my database. One of the requirements is to see the table results in a pivot table format. OK I thought - just use the pivot table automatically generated using VBA. My problem is this code works the...

Hi All After spending the day looking for solutions i think i need to ask for help. I have a form that has its recordset generated from SQL. All fine, this form is the available selections to automatically populate another from ( One is generated by the engineer the other by the production...

Hi All. I have a query that I have created dynamically using VBA The VBA being: strSQL = "TRANSFORM nz(Sum([Duration]),0) AS SumOfDuration " & _ "SELECT " & strGroup & " AS F " & _ "FROM (SELECT tblDowntime.Reference, tblDowntime.Stopped, tblDowntime.DowntimeStartDate...

Hi All, I have created a chart using the form PivotChart view. I have done this initially using VBA, but i have also tried just using a query and puting two text boxes in the form. The data is a summary of some other data in the database. (Number of faults, between 2 dates, for any selected...

Hi All This is driving my crazy! I know I could do this another way but I would like to solve this. The code below works the first time. (It is to see if a duplicate barcode entry is entered for an order, the data is on a sub form) However, If I try to enter a second deplicate entry i get an...

Hi All, I have been looking at this problem for a couple of days and I have run out of hair to pull out! I have created a report that has two groups Customer and Product i.e. The group header 1 is for customer and group header 2 is for product type The detail looks at the QA problem with...

I am having problems with the following code: Private Sub Form_Load() Dim graphOb As Object Dim rsCount, i, j As Integer Dim mySQL As String Dim db As Database Dim rs As DAO.Recordset Dim myData, arrA, arrB, arrC, arrD As Variant Dim ns As Object Set db...

Hi, I wonder if anyone can help with my little problem. :confused: I have a recursive method that has worked until i started getting Error 3048 - Cannot open anymore databases. I tried to rework the code to use docmd.runSQL but then i have a stack error. I have commented out this code. I think...