Search results for query: *

Hi Anyone knows how I can run SQL queries in a batch..i.e. running strSQL one after another. For example, SELECT * FROM TABLE1 and then after that run SELECT * FROM TABLE2? Thanks in advance. mflower

Hi, anyone knows how I can check for common fields in two recordsets? If rst1.ID = rst2.ID Then MsgBox "" Else MsgBox "There are no matches" End If Why won't this code work?

Hi, anyone knows the code to open MS Word 97 in Excel 97, but platform is Windows 2000? The piece of code currently used works on Excel 97, Word 97 with platform Windows 98: Dim objWord As Word.Application Set objWord = New Word.Application Is there another way of writing code to open Word...

Hi, I get this error message "Network packet layer: Internal Net Library Error: Net lib protocol driver call to connect two endpoints failed" while trying to connect to the SQL server. What can be done to fix this? Please help.

I've created a user and password, but now Oracle requests for "Create session..." needed before I can use this user/password to login. Why? and how to fix this?

Hi! Anyone knows how to code this if statement: If date.Value >= "#01/01/00#" Then label1.Visible = True Else label1.Visible = False End If Somehow the label1.Visible is always true, so I suspect that if I want to find a date greater than 01/01/00, for example if the date is...

This is a question for a Excel document. Would anyone know how to find a specific value in column A and when found, enter that value in another column B? For example, A1's value is 1,2,3,4 and I would like B1's value to find any 1 and put in a value of 1 and 0 if no value of 1 is found. Problem...

Anyone knows where I can get more information about nested If statements? The problem I have with mine is it stops at the first If statement and does not proceed to the next.

Anyone knows how to turn on the combo box wizard?

Thanks for all the help on combo boxes from relevant threads. HOwever, my problem is the second combo box brings up the value relevant to the second combo box, but I want the value to appear in the text box without clicking and bringing the value up again. Is that possible? It's like making the...

Does anyone know if I have two tables, table A and table B and I want label X to show (visible on form) if the ID on table A.ID = table B.ID Thanks.

Anyone knows how to limit the print out to 2 pages only? As in once preview, print out 2 pages only? And not only 2 pages only but printout back to back so only 1 page with two sides printed? Help!!

I think this could be a silly question as it would seem so easy to most programmers..but what's the code for saving a particular field in Table 1 to Table 2. For instance, I want to save FirstName from Table A to FirstName in TableB. Thanks.

Anyone knows how I can save a value in a text box into one of the columns in the combo box. Example, I'll search for a record, and the record appears in the form, but when I type in a value in textbox A, and click a button, that value is saved in the combo box. I do not want the value to be...

Anyone knows why when I sort the order of the report by the field First Name, some of the first names will not show? For example, I've got two Karens and in the report, it will only show one Karen and not the other, have I forgotten to make changes in the properties? I've sorted and grouped the...

Anyone knows the procedure I can write based on this logic: I have two forms: Form1 and Form2. And two types of members: A and B. If member = A, then Form1.show, if member = B, then Form2.show.. I have problem in declaring the variables and writing the full code...please help..thanks:)

Anyone knows the code to using two combo boxes, when you select the first combo box value, it brings up a related value in the second combo box? As in, second combo box has a record which relates to the first combo box. Thanks in advance.

Anyone knows the code to limit a report to 2 pages and to be printed double-sided without doing it manually in print setup? Thanks in advance.

Anyone knows the code for two combo boxes, cmbA and cmbB, whereby when I select a record from cmbA, it contains a related record in cmbB, therefore, when I select a record from cmbA, that related record will show in cmbB.. Thanks in advance.

Anyone knows where I can limit the preview of reports to 2 pages? Writing code? Thanks.