Search results for query: *

I have a table, ID Phonenums --- --------- 123 1231231234 123 1231231234 123 1231231234 123 1231231234 123 1231231234 both text fields. I need to update anouther table with the above data but I need the Phonenums in a single memo field in a single record. (Preferably...

I have an application that ftp's signature bmp's from a signature capture device. One problem that I am having is that the ftp process can take several moments depending on several factors. My idea is to hide or minimize the interface once the ftp process is iniated to allow the user to go back...

I have the following code... In testing my variable worked fine. But I only had one query. I find this works if I redefine the variable after each "go". Is there a way to define the vaiable for the whole script. I would probably call it a global variable. Thanks Uncle Mike --Get the...

Is it possible to do a parameter query in SQL Server like you can in Access, where a box will popup and prompt you for information to complete the query. And can I store that parameter to variable so I can use it in subsequent quaries. Thanks Uncle Mike

I have a some code that I need to put in a sub. It works fine in the body but when I move it to a sub I get "Not and object reference". Is there a way to pass the object inheritance to the a sub? Dim objDocument As Document If...

Currently have a button on my form that I launch to start my program in motion. Instead of pushing the button I just want it to automatically run the code but I can not find and onstartup form event. Can anyone advise me where to find it. VB.net 2003 Thanks Mike

I am trying to create a Access style Parameter Query were the query pops up a window and asks you what to search for. The online help says that this is an example. SELECT title_id FROM titleauthor WHERE (au_id = ?) But when I run it, it comes back with Incorrect syntax near '?'. Any...

I have three fields, Filename, Actnum, Branch In Filename field I have the names of a pdf files like 0000000001.pdf 0000000001_001.pdf 0000000002.pdf I need to seperate that name into the other 2 fields so that Actnum=0000000001 and Branch=001 and get rid of the .pdf If 001 does not exist...

I have a button on my screen. Once I press the button I want to return to the last cell I was in. I have tried Sheets("sheet1").Select Cells(myrow, mycol).Select Cells(myrow, mycol).Activate but when I push the button the button remains the focus? Any thoughts? Thanks Uncle Mike

I have a table with obscure field names. So I put their descriptions in a table. I want the control tip text to look up the field name in a table and have it display the description. I have DLookup("Desc", "Fieldlist", "FName = 'AMACCT'") but I cannot figure out how to reference the current...

We have a third party development environment that is written in .net 1.1. It allows us to recreate As400 sessions in a GUI envonment. So we don't have much access to the code. Anyway we are getting the following on some PC's but not all. What is the best way to proceed? I have read that the...

Is there a way to run a console program without opening a console window. The program is being call by anouther system and will ftp a file to the pc then open up the file in Adobe Arcobat. I would like to just call the program and then Acrobat just popup without letting the user know a program...

Anouther Newbie question. I need to capture a parameter passed to a program in a variable. Ex hello.exe 43454354 I am using VB.Net 2005 Express. Thanks Uncle Mike

Hey, Newbie question. I need some very basic ftp funcionality. I need to ftp a file to the server wait a few seconds and ftp back anouther file. I have looked a CFtpClient as an option and edtFTPnet. I found both to be confusing. Anybody have any suggestions or an example project. Any...

Need some help with the following code. It is a loop that reads and text input file and once it finds some strings it puts the line numbers into a table. How ever when it finishes it puts the end of line record number into the table but it puts it at the top of the table instead of the bottom...

I am new to .net. Just trying to make a line move across the screen. What is the best way to pause between moving the line segement. In the old days we just used a loop and counted to a large number. Like.... Dim x1, x2 As Integer Dim chg As Integer ' amount of change...

SQL Server 6.5. I accidentily managed to shrink my transaction log file from 117 mb to 68 mb. Anybody have any idea how to expand it back. Thanks Uncle Mike

I am trying to run an update on a table in 6.5. It is a large table with 250k records. update bla set field2=field1 It never finishes or gives an error. Eventually I stop the query and the transaction log is full. It is small business version of 6.5 which I just learned has a 1gb limit. I...

I need to Change the defaultvalue of a form field and save it so that the it will have the new default value the next time I open the form. I have done this before but can't find the code. Private Sub Form_Close() Debug.Print Text14.Value Dim answer If Text14.Value <> Text14.DefaultValue Then...

I was wondering if someone could tell me how to create a drop down list of the current tables in Access on an Access form. Thanks Uncle Mike