Search results

I have written the following code to add monthly activities for the staff whole roleID is 37. Not sure how can we do it for quarterly activities ? In the below code FrequencyRef=3 means "Monthly". Public Sub AllocateMonthlyActivities() Dim rs1 As Recordset Dim rs2 As Recordset Dim rs3 As...

Hi Guys I have created a form with following controls: Type (Drop down box) : The options are "Audit","Review","Meeting" Number (Textbox) : how many (Count) Frequency (Drop down box) : The options are "Monthly","Quarterly","Yearly" Now my question is suppose If there are 2 audits need to...

Yes its resolved , I changed the following line as below :) .Attachments.Add """" & rs.Fields(0) &""""

Gasman, I tried Eval function and now it gives me runtime error '2482' RMS cannot find the name 'L' you entered in the expression. With oMail .To = "RMSSupport@boi.com" .Body = "See below the requestor comments " & vbNewLine & Me.txtComments .Subject =...

The filepath column stores both Filepath and FileName . But the code gives me a runtime error '3251' 'Operation is not supported for this type of object ' in the below highlighted line: Private Sub email() Dim qdf As DAO.QueryDef Dim prm As DAO.Parameter Dim strEmail As String Dim strMsg As...

I wrote down the following code but I am getting run time error 'Cannot create file , Right click the folder you want to create file in ....." . I just want to attach files to outlook but not sure whats going wrong. Dim qdf As DAO.QueryDef Dim prm As DAO.Parameter Dim strEmail As String Dim...

I have tried but can't figure it out. Any help would be much appreciated. Thanks

Hi Guys I have a 2 column listbox which stores file path and File name of a file. I want to write VBA code so that when save button is clicked then an email gets sent to e.g Test@gmail.com with an attachment of the files stored in the listbpox. So the listbox first column stores Filepath and...

Thanks Ridders , it worked. I am having another issue that there are some duplicate records present for staff members with different unique Ids in the table. So I want to add something in the below query so that it shows maximum Date_completed records only and not the duplication. Can this be...

RAG is an expression. I am writing the following query but want to filter by RAG rating 3. I tried to put criteria 3 under RAG and it didn't work: SELECT qry_Model_AnnualTest.StaffName, qry_Model_AnnualTest.AnnualTest...

Hi Guys I am writing the following query and it gives me above error message at RAG. Any help will be much appreciated. SELECT qry_Model_AnnualTest.StaffName, qry_Model_AnnualTest.AnnualTest, qry_Model_AnnualTest.Date_Completed, IIf([RAG]=1,"Red",IIf([RAG]=2,"Amber","Green")) AS Priority...

Mine is a continuous form as the end users want to see all the assessment questions at the same time . How this can be done using continuous form?

Hi Guys I have a question regarding sub forms. I have a subform which displays a list of assessment questions and next to each question there is grading (option buttons). At the moment I have put 3 options buttons so the users can choose grading in (Yes,No,N/A). This works fine so far. But...

This is m exact code but it gives me the same error message : BACKUP DATABASE Test_Aman TO DISK='\\Corpfiler1\Data\Access Databases\Group Manufacturing\Test_Aman.BAK' WITH MEDIAPASSWORD='C0mplexP@ssW0rd' GO

Hi RX, I can't find the link to Data security in sql server . Can you please send me the powerpoint presentation?

Hi Guys I am using the following script to create encrypted database backups in SQL Server but I am getting an error message "Msg 3032, Level 16, State 2, Line 1 One or more of the options (mediapassword) are not supported for this statement. Review the documentation for supported options."...

Hi Guys What are user groups in sql server? why do we need to create them? Can we create by ourselves or this needs to be done by helpdesk. (not developers). Does it relate to database security ? Can anyone please explain? Thanks

Hi Guys I don't want to display a proper message box but just on the mouse hover event I want to display a text and it will hide automatically when no mouse hover on that label. Any help will be much appreciated. Thanks

Thats great Ridders. It works perfectly :)

Galaxiom , where do I need to make this change??