Search results

Me.Number = Me.cboSearchID Me.cboSearchID = Null rs.movenext <<<<Add This Exit Do <<<take this out Loop

Sweet Thanks for that. That will come in really handy in the future. I was trying to keep away from Automation as it seems to be my nightmare when installing on other machines. What I figured to work was just stick with: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, tbl1...

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

Final resolution Dim strAppName As String strAppName = "C:\WINNT\System32\mspaint.exe " & Chr(34) & FNAME & Chr(34) Call Shell(strAppName, vbMaximizedFocus) Thanks for all your help.......

Getting Closer Little Closer just can't get the file to open - Paint does though! FNAME = Shell("c:\winnt\System32\mspaint.exe", 1) ' Run Paint.

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

Sorry for Delays OK- It is a potential on going process - I think though now I have worked around it by staying away from access- I figured out a way to do all the database manipulation outside of access and actually just eliminated access for this particalar project... ESRI Arcview uses DBF...

Excel I went through excel in the beginning and started running into problems. If I had a field called "FEDIRS1" and it was null the whole table through - Excel would drop the field completely. This wouldn't be such a big deal its just I have like 70+ fields!

Hmmmm You might be on the right track. The DBF is coming from an Arcview Shapefile which does use IV, Excel opens it fine but maybe since Access is so much more powerfull it is getting confused with the versioning or something like that - Ohh Well, I guess I will just stay away from...

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

You can set the timer interval property to however long you want the form to be displayed! Then as a timer event procedure place some code to open and close whatever forms I have an Autoexec macro that calls up a form called "SplashScreen". When Splashcreen loads its timer interval is set...

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

Is this for a GPS/GIS application? Are they going to be used in the field //// If so you might want to consider your real estate being a little larger so that you can see it on the small screens......

thats awesome!!!! 2nd part) How do I check to see if the file exist? I dont want the field to be filled in unless there is a picture available........ I dont want to use a common dialog to pic the file because I already know what the file names are.... I am basically trying to use this to...

What sort of touch screen are you using???? All of ours have either handwriting recognition or onscreen keyboards.

Can you convert that to 97 (PLEASE) Sorry Jerry

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

If you are using the report wizard you can add grouping so that your main records are only displayed once.... If that doesn't work post again and we'll go from there...