Search results for query: *

I have the following line in a module in access 2010. It was originally written in access 2003. DoCmd.OutputTo acQuery, "qryOutputForGIS", "MicrosoftExcelBiff8(*.xls)", sPath, False, "", 0 But now, instead of outputting the query, it deletes the destination file. Any ideas? Daniel Dillon O...

I need to find and rename all .JPG files to .jpg in a folder with subfolders. How would I go about this? Daniel Dillon O o . (<--- brain shrinking at rate shown.)

I have created nav buttons on a bound form. I would like to disable the "next" button when on the last record. How do I know when that is true? Daniel Dillon O o . (<--- brain shrinking at rate shown.)

doesn't matter for now. don't have 2007. Daniel Dillon O o . (<--- brain shrinking at rate shown.)

MajP: so does that allow the behavior I was after? Daniel Dillon O o . (<--- brain shrinking at rate shown.)

Lovely, got it working and added a Prev. button that is disabled at top of list. Had to create intRemainder for that, in case last bunch became not multiple of 20 for some reason. Thank you very much. Now to get the renaming thing working. Should be okay. I can work with text and basic fso a...

I'll give it a go. So I can fit 20 images on the form, so should I change... i = i + 1 ...to... i = i + 1 If i = 21 Then Exit Sub Daniel Dillon O o . (<--- brain shrinking at rate shown.)

MajP Thanks for giving me hope. Can this unbound form be a this unbound form would be a non-linked subform. How do I "load" images into it? Do I use the image control or an unbound ole control? Access 2007 not an option. Using 2003. Daniel Dillon O o . (<--- brain shrinking at rate shown.)

Thanks Duane. So I would have to identify the jpgs by looking at the image. Is there then no way to display the images in a continuous list for me to make selections from? Daniel Dillon O o . (<--- brain shrinking at rate shown.)

I have to rename a couple thousand pics, so I created a form for this. In it there is a subform in continuous view that displays the names of the image files (from a table). I also want to show a thumbnail of each. So far, I get the same pic in all records and it changes when selecting another...

SWEET. I will have to start using "With..." in my code. Daniel Dillon O o . (<--- brain shrinking at rate shown.)

Got it! Replace 2 instances of .EOF with .BOF. Daniel Dillon O o . (<--- brain shrinking at rate shown.)

Thanks lameid. Me.Bookmark = rs.Bookmark screamed at me. I repeated it as before and it was fine. Thanks PHV. "I get run-time error 3021: No current record." at the top of the column. Daniel Dillon O o . (<--- brain shrinking at rate shown.)

Okay. I'm getting there. I just need to be able to land this thing when it gets to the top/bottom of the column. See the red bits...That is what I would like it to do, somehow. Private Sub Text50_KeyDown(KeyCode As Integer, Shift As Integer) Dim rs As Object Select Case KeyCode...

Recordsetclone and bookmark are somewhat foreign to me, although I have seen them and sometimes read what they do, their use to slip through the seive that is my brain. Could you give me a tip what to search for, maybe a method or something? Daniel Dillon O o . (<--- brain shrinking at...

I have a data entry form with a subform bound to a (temporary) table. Default Tab and Enter behavior moves focus one field to the right. Default Shift-Tab moves focus one to the left. The code below is my attempt to force those defaults to move up and down one record in same column instead...

the data will be imported from a csv file into a new table. The time format is... 18:12:28. I am looking for... 18.2 Daniel Dillon O o . (<--- brain shrinking at rate shown.)

THanks. Is it possible by formatting code, rather than running a procedure? Dateformat or sumpthink? Daniel Dillon O o . (<--- brain shrinking at rate shown.)

I have a short time field in a table. Is it possible to display 10:30 AM as 10.5 and 10:30 PM as 22.5? Daniel Dillon O o . (<--- brain shrinking at rate shown.)

Well that makes sense. But it is not obvious. I was looking for a 1 to 1 trade. You know... ASP to PHP SQL Server to MySQL Access to ????. Now, I get the picture that Access can remain my front end, but that I must simply learn ADO and a new flavor of SQL/datatypes and a few peculiarities...