Search results for query: *

Thanks Lonnie. I'll need to run a OpenQuery first but will need to get it changed each time. Then run the strSQL. Run OpenQuery (change the filter) in the Module Then run strSQL Run OpenQuery (change the filter again) in the Module Then run strSQL Will this work? Thanks.

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

Thanks cmmrfds. Please tell me how to select the recordsets? I cant' seem to define the table in the form itself, keeps coming up with error for the table. Please help.

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

Thanks all:) If statements it will be then.

Hi, I've changed it to a Select Case statement: Select Case ([Sent]) And ([Recvd]) 'document sent, not returned Case Not IsNull([Sent]) And IsNull([Recvd]) Me!imgDocNotReturned.Visible = True Me!imgDocReturned.Visible = False 'document sent, document returned Case Not...

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 the reply Jonathan. Here's more notes: Table A has ID and Name Table B has ID and Name LabelC is the label to show if "truetext" Table B is a linked table from another database I need explanation from scratch actually, which controls to drop on the form, writing the code...

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

You're correct, it's the ID that ties both the tables together. However, do u mean show Table B in the form as well? Then write a sub that checks whether the ID for Table A and Table B match? If they match, label shows "TrueText", if no match, then label shows "FalseText&quot...

Thanks for that Jonathan. However, only Table A is on the form, Table B is not. Therefore, I must write a module that references Table B? Am I right? Where would you suggest I find more information on modules? Or more on VBA for that matter...thanks. mflower

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.

Thanks Aivars & JoeMiller! However, my problem is still not solved. I would like the printout to be double sided on 1 sheet of paper. docmd.Printout does not specify that:( Or is printing out double sided not possible unless done on the printer setup?

Hi Aqif I actually didn't write in this part of your recommended code: Private Sub CmbA_Click() Dim strmsg As String strmsg = List1 'MsgBox (strmsg) DoCmd.requery "CmbB" End Sub Reason being that I actually created more than 1 combo box to reference another combo box, therefore dont...