Search results

Hey, all... I'm having some difficulty with a subquery. I'm using a subquery to find a previous record's value. It works, with a few exceptions. Here's what I have: SELECT tblEventLogFile_Clean.Date, tblEventLogFile_Clean.Time, (SELECT TOP 1 previousRecord.Time FROM tblEventLogFile_Clean as...

Thanks, Bob - I'll look for it... Racer -- Initially, it's okay for me to connect to Oracle with an ODBC connection; however a true Oracle connection is ideal. I've found ODBC to be generic and clunky. Thanks to both of you. Andrew

Welp. Not to my knowledge. I've installed OraHome81 and have been able to connect to the server with it... Is the driver something I would find with my copy of Oracle, or with my copy of Crystal Reports?

Hey all... So, I'm firing up Crystal Reports 11 for the first time.... I need to connect to an Oracle Server, however the option does not exist in the "Standard Report Creation Wizard" under "Create New Connection," nor does it exist in the "Database Expert" under "Create New Connection."...

Most excellent! Thanks! I really ought to get myself a book.

What is the proper way to pass an integer? I have this function and sub: Public Function testpassing(number3 As Integer) testpassing = number3 + 20 End Function Public Sub test() Dim test2 As Integer test2 = 189704 msgbox(testpassing (test2)) End Sub ...But I get an overflow...

NM...I muddled it out. It took a lot of swearing, but it's here. Public Sub UnhideSheet() Dim xlsApp As Object Dim xlsBook As Object Dim xlsSheet As Object Dim fileName As String fileName = fileName 'location and file of the XLS file you wish to change Set xlsApp =...

Hi all! Is there any way to unhide an Excel sheet from an Access mdb? I can do it in Excel, unhiding a workbook's own sheets, but I have no clue where to begin if I'm attempting it from a different file. ~Andrew

Edit 5:00 PM is not 3.71 it is .71 the 3 is a date, maybe that's a clue. A clue indeed. That solved the case. Those cells with a date included (but not shown, due to formatting) seem to work fine. Those cells with just the time have problems. Thanks! I've got it now. ~Andrew

I'm having a bit of problem with a spreadsheet. I'm using VBA to setup a sheet. One of the columns is annoying me. Column B is "Start Time" and Column C is "End time" Column Z (We just skipped a bit) is the number of hours between the start and end time; the total hours worked. So, cell Z4...

By embedded vs reference, do you mean the difference between an image hosted and referred to by HTML on a website and an image hosted by one server and referred to by HTML in by another site? If you open this link in IE, copy the image, paste it into Word, you see an image. I don't. I see that...

Is there a setting that determines reference vs picture??? I have never seen/heard of such a thing. I just copied the Google logo out of IE7 into MS Word 2003, with not trouble. CTRL + C and CTRL + V. No Paste Special.

Hey all, I have a user who's getting strange text in her MS Word documents. When she copies an image from IE and pastes it into a new Word doc. the picture does not appear. Instead, a code of sorts appears instead: { Define the page structure. INCLUDE PICTURE...

Noel..err--- The solution's right above your first post. >.>

I just implemented the code that Fuga provided above in a loop, which downloads a very large number of seperate files from the Internet. Does anyone know why the code might halt after a certain number of loops? After a bit, it just stops. I don't get an error, but I still have to kill the...

Sorry... They're handles. Yours is DaneRanch. Do a search of the page (CTRL F) for their names. In short, what you're attempting is difficult. mission2java_78 and Autoeng suggested these two links (and then fought ever which was better ;)) to software suites that can do this...

Your combo box is saving an assigned value, rather than the actual text representation, in the record. It saves space, and makes for a cleaner, more stable database. Change the "bound column" in the properties of the combo box, if you want to prevent this from happening.

http://www.access-programmers.co.uk/forums/showthread.php?t=43919&highlight=resize+screen Check out the comments by mission2java_78 and Autoeng. ~Andrew

I've used the beta version - Pretty slick, I'll say... There are some things that I thought would have been nice to include that were not, though. No matter - I won't actually be using the real copy for many moons to come.

Excuse my ignorance, but I don't know what you mean. Perhaps I'm overlooking it in the help feature? I knew that you can transfer objects from one database to another using that VBA code, however I cannot find how one might use it to transfer an import/export specification. ~Andrew