Search results for query: *

I have been using the .dll for a while now with great success. The question hopefully someone has an idea on is that I want to use the .attachment to send a linked document. For obvious reasons I do not want to embed the document as my database will get out of control. Does anyone have...

NM It was an ID10T error, I wasn't using the other table's field name, it works, I thought I was doing something wrong with the syntax. I had what you posted to begin with, but didn't have the correct field name, DOH! Thanks for your help and quick reply!

Thanks for the fast reply, I tried that and it returns successfull even when the state is not in that table, any Ideas?

I am trying to use the Dlookup function to validate whether or not the information typed in a text box is in a table. For example, I want to know if a specific State is in a Table. I have looked at the FAQ, but I can not seem to get this to work. Basically what I want to do for test purposes is...

I have used it in our old host system and it waited for the cursor to be at a specific spot on the screen before it continued to the next line of code. But it obviously doesn't seem to work as described above. I am fairly certain that the function needs to be rewritten, it may be incorrect as...

I use SetCursor like this: Public Function SetCursor(ByVal lRow As Long, _ ByVal lCol As Long) As Boolean stemp = moExtra.Screen.MoveTo(lRow, lCol) End Function SetCursor works great! but when I use the following WaitForCursor as follows: Public Function...

here is a link to the attachate site: http://supportweb.attachmate.com/ The code, is Basic so it might be similar to what you are using. For example we used to use a program called Reflections, http://www.wrq.com/ and the programs look visually identical, but the programming is slightly...

I think I found them in the Attachmate help files. I have not used ProcommPlus, so am not familiar on how you would use the functions with that software, hopefully someone else can shed some light.... Sorry :( But if you need additional code on what I have just let me know, and I can post.

I can't tell you how thankfull I am, I did however get a chance to actually get it to work they way you stated, Again, thanks for all your help!!!

WOW! It works! your suggestion on registering it was the part I was missing! I hard coded it in access and it now sends the email, but the problem is being able to set the txtBox email address to pass the value into the code. I tried to setfocus, that didn't work. Maybe by dimming the txtbox as...

I have been searching google/newsgroups and other searches and found this really cool VB code: "http://www.freevbcode.com/ShowCode.Asp?ID=109" basically it can be made into an exe and you can send "spoofed" emails with attachments. Now the problem I am having is trying to figure out how to use...

I am not sure why it works this way but here is the code: Private Sub Command5_Click() 'Do the copy Me.Text3.SetFocus Me.Text3.SelStart = 0 Me.Text3.SelLength = Len(Me.Text3) DoCmd.RunCommand acCmdCopy End Sub Here is where I found the answer...

I am using 97 and I am getting an error when I try the runcommand: 2046 the command of action 'copy isn't available now' I just want it to copy the text in the text box, and also be able to check if the textbox is empty... any help is much appreciated!

My purpose is to just keep the string in memory so that when the form opens the text is just copied as if I had copied the text using ctrl+c or using the copy button.

My apologies, the code is in the form current event, when the focus is on a new form I have this bit of code: Private Sub Form_current() Dim strCopiedClaim As String strClaim_Processor = GetWindowsUserName Me.dtmTodays_Date = Date DoCmd.RunCommand acCmdSaveRecord strCopiedClaim...

I tried that and I get a runtime error '91' object variable or with block variable not set. That is where I keep getting stuck, your help is very appreciated :)

I need to copy the text in a text box when I am in a form, I have tried different ways but I can not seem to get it right, I have tried dim strClaim as string, and then strClaim = ClaimNum which is the name on the form from a query of a table. If anyone can help it would be much appreciated :)

Yes I re-wrote the function so that I could put it in a class file, and use it with several different sessions, we have at times needed up to 16 different session windows open, and using that function in a class file just seems to make more sense to me, I just wasn't sure how to do it...

Ok, so I answered My own question: in a class file put this: Public Function WaitForText(ByVal sText As String) As Boolean sTemp = moExtra.Screen.WaitForString(sText) End Function then in your form put this: .WaitForText "text I am waiting to appear on screen

I don't claim to be any sort of expert or guru, and this is my first time posting, so thank you all in advance, I have found this forum to be a helpful :) My question is this: how do I use the WaitForString function in a class file? I have to assume it is close to the waitfor cursor which I...