Search results for query: *

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...

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...

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...

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...

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...

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...

How can I hide a textbox with no value without leaving a space for the next line ie Record1 Tel: 9999999 Fax: 888888 Email: hello@yahoo.com Website: www.tek-tips.com Record2 Tel: 22222222 Website: www.tek-tips.com Record3 Tel: 3333333

I have a custom toolbar and one of the command buttons on the toolbar is to check the values of the controls in the form such as textbox, combo box, checkbox, listbox by calling a function. All the controls' value can be identified except the textbox. I tried to use a command button on the form...

I need help on how I can do this: Everytime there is a change on the table1 from database1, I need to insert the change in table1 from database2. Table1 has the following columns: DB_Name Table_Name Affected_Column Old_Value New_Value Date_Modified Modified_By So I will have a trigger on...

I have troubles importing XML to SQL. I tried using OpenXML but I get an error this error: "XML parsing error: Invalid at the top level of the document" What could probably cause the error? Here's the sample XML: -------------------- <?xml version="1.0" encoding="UTF-8"?> <?xml-stylesheet...

I can't figure out the problem with my code. Error on the SelectSingleNode and it is asking for an object :( Please help!!! The XML looks like this: <XMLDocument> <XMLHeader> <XMLTitle> Real-Time Streaming ON Market Data File</XMLTitle> <XMLDocVersion>1</XMLDocVersion> </XMLHeader>...

I need help on how to import xml data from the internet. I need to get the data every hour. Please help

Hello I need help how to store XML data from a website to my SQL server. I am planning to create a DTS package and schedule a task to execute the DTS package. But I am not quite sure how to achieve this task, ie how can I copy the XML files and parse the data. The URL contains several XML files...

Hello there I am finding a way how to import data in SQL in the simplest way. I thought about using a VB script or using DTS. Somehow I think it will be better if I just use Stored Procedure or Access database. Another problem I have is to format the data which is a .csv file. Sample Data...

Can you load the same form more than once at the same time? In short one form is avaliable many times at once.

I have a tab control with 5 pages. On the 2 pages, I use the same source (datasheet form) for the subforms. The subform will display the value depending on the record pick by the user using a filter. Only one tab will display the right values to the subform. What would be the problem?

Any thoughts why this happened? I have a stored procedure that works well in my development db but not in production copy of db. I noticed that the problem occurs when the stored procedure does not accept null value. The procedure goes like this: spmary_weekly_task '5/29/2003 11:59:00 PM'...

I would like to use the right click on a TreeView to call my pop-up menu that has a expand and colapse functions. I tried the code below in VB and it works but it doesn't in MS Access 2000: Code Private Sub tvwDB_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Long...

Can I use stored procedure as a record source for my report? And how can I do that?