Search results

Maybe not the right forum to ask in but I am curious if there is a simple solution to deploying a single database that my application will access. My VB.NET application simply uses a System.Data.SqlClient to connect to an instance I have locally. I want to send my mdf file and let the user...

I am building a site in which users will be uploading "photo's" to my a web host. Is there anyway I can scan these files for virus's before I download them? The website is going to be an ecommerce site in which I will have users uploading images that the client will work on. The client has...

What is a good (REALLY CHEAP) software for creating small flash files. Somthing to make small little banners and intro's using still's and some music...

If My.Computer.Network.IsAvailable Then If My.Computer.Network.Ping("www.MySite.com") Then Debug.WriteLine("Site Available") My.Computer.Network.DownloadFile(ADDRESS, MyFileName) End If End If

OS = XP pro SP2 200GB IDE HD with 134GB free (NTFS) 200GB USB2.0 with 54GB Free (NTFS) Virtual Memory = 1gb (Let Windows Manage) Trying to copy files from a external USB drive to the Hard drive. I have done this a million times and now it decides to foul up. When trying to copy files from...

What is wrong with this... Dim conn As New ADODB.Connection With conn .Provider = ("Driver={Microsoft Text Driver (*.txt;*.csv)};DBQ=" & fName) .Open() End With

Well ran into a ? - Form.Printer.Orientation - works in Office 2003 but not in 2000 Dim vFM as New Form Set vFM = New [MyForm] vFM.RecordSource = SelectSQL vFM.Visible = True DoCmd.Maximize vFM.Printer.Orientation = acPRORLandscape ',<<Is this available in...

Hello all and thanks in advance for any suggestions. My current project seems to be bloating itself rather fast. How do I implement this code to the current DB? Note that this opens a DB exclusively so I am sure it has to be ran while the DB is closed???? Public Function...

Hello all, Having some troubles updating some records. I need to run some code that will erase a portion of the record. fieldA (Text) Value might equal "400.401 my text" I have another table that contains all the codes like 400 401 500 504 324 i need to delete any portion that matches any...

History - I wrote the app in Access 2K and it sent email through Outlook97 We upgraded to Office 2003 I have a custome app in Access that utilizes the ability to send email through Outllook. It worked with Access2K and Outlook97 - it works in Access2K3 but Outlook gives a warning for every...

Is there a way I can grab the systems Temporary Internet Files directory and through it into a string type variable? Dim F as string F = GetTempPath ' This gets the temp folder - I need temporary internet files folder

Hello all, 1st off, thanks for anytime that you spend replying to the post. I have a database that I connect to using VB6.0 for the front end. We have 21 different offices and most of them are connected at least through the WAN. My problem occurs with the offices that are connected with VPN...

Hello all, Does anyone know where I can find some info on (Or is it possible to) create an excel workbook with specific worksheets? DoCmd.RunSQL ("SELECT GPS_Antennas.* INTO tmptable FROM GPS_Antennas WHERE Assigned_Location = " & Chr(34) & office & Chr(34)) DoCmd.TransferSpreadsheet acExport...

Hello All, I just posted this under tables on accident - I then realized that this was not a tables question so Sorry about the double post! I am trying to figure out how to start MS Paint with code and have it open a picture that is defined by a variable name.. Private Sub Text1_Change()...

Hello All, I am trying to figure out how to start MS Paint with code and have it open a picture that is defined by a variable name.. Private Sub Text1_Change() FNAME = "G:\SV\Survey\KUTTRUS\sagis\ms11\source\valve\" FNAME = FNAME & Text1.Text & ".JPG" End Sub Private Sub Command1_Click()...

Does anyone know how to import a *.dbf IV file into access - I keep getting errors that it can't find the file that I am picking! Thanks, Jerry

Is there a way to clear a form completely of data when a Command button has finished . 1.) Users log in to the form 2.) Users input data into text boxes 3.) Users click a command button to validate there text 4.) User Click a command button to Submit (Insert) there data 5.) How do I do 2 thru 4...

I have designed a form to automatically put photos in a table. The problem is that the db is getting huge after just a few pictures---- There will be about 621 photos total... here is my code..... ohhh yeah. I am linking them (Not embedding) please help. Private Sub Command8_Click() Dim I...

This database is for a GPS Observation Session table. What I am trying to get is the Observation span. (Length of time set on a particular point..... What I have is a start and a stop time. Stop subtract start = span.... That works perfect untill days that the span went through Midnight...

Does anyone know where to get a "FREE" pdf printer drive? One that actually works... I want to write my access reports to pdf. Thanks, Jerry