Search results for query: *

It is working now. I just have to put space between the variable and the & sign. I thought it will pick up the reserved symbol and variable. Thanks for your help PHV!

I tried this code using 2 double qoutes as suggested by PHV but I still get an error in the formula line. Compile error: Expected: end of statement Sub ValidateData() Dim i As Integer Dim intRowCount As Integer Dim strFileNAme As String intRowCount = Application.Inputbox("Please enter the...

How do I concatenate a variable within the formula string? I am getting errors.... ActiveSheet.Cells(i, 1).Formula =...

This is a correct formula but needed to be translated into to a VBA code as there will be more or less 4000+ cells to be populated...

I have several worksheets to compare and the result of the comparison will be in master worksheet. To check for the right worksheet to use the column Q must not be blank or null. I have this code but there seems to be error on the quotes Sub ValidateData() Dim i As Integer Dim intRowCount As...

It works.....thank you so much!

Hello I need help to write a macro to be able to automate linking of 2 worksheets. There will be master worksheet (file) with different sheets where each sheet is link to different files. Each cell in column A per sheet is linked. Example: File A with Sheet Entry Master File with Sheet Staff1...

Ok Thanks!

Hello I need help to write a macro to be able to automate linking of 2 worksheets. There will be master worksheet (file) with different sheets where each sheet is link to different files. Each cell in column A per sheet is linked. Example: File A with Sheet Entry Master File with Sheet Staff1...

I have a report that has a parameter for report type: Summary, Detail, Executive. Depending on the user input for the report type. Some AcFrame (all the controls in the content) in the group will be hidden. I am currently using this code in the acFrame: Function ShowWhenViewing( ) As Boolean...

We are using DHTML. I just changed it to ActiveX viewer and the problem still exists :(

This is BOE XI R2. The users don't really need to schedule the report. They would like to print it whenever they want. But the print preview is different from the printer's print-out even if I print it in pdf. But if we do an export option to pdf, the format is kept. The weird part is that it...

Need help!!! I created a report in Crystal Report XI with multiple columns from different subreport. The preview and print out are both the same. But in BusinessObjects XI infoview the print out is not the same as the preview. The format of the fonts is only correct on the first column but the...

There are 2 options on displaying the data. Alphabetical or by Department. If alphabetical names there are no problems but if the option is by Department, the group get mix up.

I acutally created a view and use the view of the table instead: SELECT phone_list.Department, department.department_name, phone_list.Subdepartment, subdepartment.subdepartment_name, phone_list.Last_Name, phone_list.First_Name, phone_list.Job_Title, phone_list.Phone_No_1, phone_list.Phone_No_2...

Please help me group the data from the table. The data should look like this: Department1 SubDept1 Name1 Name2 Name3 SubDept2 Name4 Name5 Department2 Name6 Name7 There is always Department and members under it. But sometimes there are no subdepartments. but it is not grouping properly. The...

Is there a way to fix the problem above?

Hello this code works fine except that on the next page the first value is adjusted to the format of the previous page: Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) If FormatCount > 1 Then Exit Sub If Me.Page Mod 2 = 1 Then...

yeah but not too expert

Concatenate will not work because I used bold formatting on the label. How do I match up the textbox. It will still leave a space.