Search results

How can I change my code accordingly? Thanks

Sorry guys, I am back again. How can we put a control so that any invisible attachments (logos,signatures etc..) will not be saved down on the network. Basically VBA code that will distinguish between real and fake attachments. Many thanks.

Hi Guys I have written following piece of code to save down attachments into pdf format on a shared drive but this code saves down logos/signatures in the email to the shared drive as well. I want to put a control that will ignore any invisible attachments and only the real attachments get save...

In DB1, on the double click event of listbox opens up DB2 (Form1) so when the user populates all the controls and save the data then DB2 is closed (that means its events are no longer accessible). Just wondering how can we auto requery listbox at that stage. It is easy to put a 'Refresh' button...

Can anyone please help me in this ? It’s very urgent to resolve .

It doesn't work as when database 2 is closed then we need to update listbox in database 1 . [code] Private Sub lstAcceptedActivities_DblClick(Cancel As Integer) Dim strEngagePath As String Set rs = CurrentDb.OpenRecordset("SELECT * FROM tbl_Switchboard_System_Mas_SysName WHERE SystemID = 427")...

Hi guys, I have an access database 'DB1' and there is a listbox which shows all the activities . When double click event occurs on that listbox then another database 'DB2' with relevant form opens up and the users are supposed to complete the form . When the user completes the form and close it...

Just added single quotes in below statement and it worked :) Thanks CJ_London sSQL = sSQL & "format([MonthRef],'mmmm.yy')='" & [Forms]![frm_RMS_MinStand_UpdateAllocation]![cboMonthDue].column(1) & "' And "

yes its open

It doesn't give me any result (doesn't filter using MonthRef). MonthRef field in the table has Date/Time data type. cboMonthDue is a 2 column drop down box (1st column Date and second column is date in format mmmm,yy).

Hi Guys The below code to filter a listbox which works fine if we use supervisor filter and ActivityType filter but it doesn't work for MonthRef filter. MonthRef field has datatype 'Date/Time' Private Sub cmdSearch() Dim db As Database Dim rs As Recordset Dim bCriteriaEntered As Boolean Dim...

got it working :). changed to below: me.lstAllocation.column(6,i)

I need to retrieve Column(6) value from a listbox each time so how can this be changed ? Me.lstAllocation.Column(6)

the below statement retreives same allocation ID each time it tuns Set rs = CurrentDb.OpenRecordset("select * from tbl_RMS_MinStand_Mas_Allocation where AllocationID=" & Me.lstAllocation.Column(6) & "")

I have selected first 2 records in a listbox and when i run the code with debugger then it just loops through the first one 2 times.

Hi Guys The below code doesn't update all the selected items in the listbox . It just loop through the first item multiple items. Can anyone please figure out what's going wrong here ? Thanks With Me.lstAllocation For i = 0 To .ListCount - 1 If .Selected(i) Then...

I am looking for functions that will display random months (No repetition for same staff) in a quarter, Half year and annual. I hope anyone can help me with this. Thanks

Thanks MajP, How can we amend the following code so that there is no repitition of months? Public Sub AllocateQuarterlyActivities() 'Working Procedure Dim rs1 As Recordset Dim rs2 As Recordset Dim rs3 As Recordset Dim Dt As Date Dim i As Integer Dim dtmStaffRef As String Set rs1 =...

That's great MajP. Many Thanks. Sometimes it gives the same month for various activities to be completed by the same person. Can we avoid that?

Thanks MajP, it works great. How can i amend the code so that it will pick random month in half year and also randon month in a year? Many Thanks