Recent content by Porsche996GT2

Thanks PHV. Did not think of that (/me is scratching his head.)

Hello, I just would like to know how I can delete Machine Data Sources created in Access by mistake. I'm thinking there should be a file kinda like tnsnames.ora in oracle that has a list of linked connections but I'm not sure if this is the case with Access. Any help would be appreciated. Thanks!

Hello All, I tried this code and it works ok: (declarations) Option Explicit Dim mlngCounter As Long Function ResetCounter() mlngCounter = 0 End Function Function GetNextCounter(pvar As Variant) As Long mlngCounter = mlngCounter + 1 GetNextCounter = mlngCounter End Function In the...

Hello abaldwin and dRahme, I'm just trying to do it on a query. I automated the creation of these queries on a loop and each time it gets created, it runs with a different criteria and gets deleted. I basically want a numbering on each of the query results, as the numbering will be used in a...

Hello All, Is there a way to create some kind of an autonumber for queries? I automated a query to run several criteria and I would like to have the records numbered each time the query is run. Any help will be greatly appreciated. Thanks!

Hello Ken, Thanks for your help. I was able to make it work by creating a nother query based on that query. It's probably inefficient but it works now! Thanks, Porsche

Hello Ken, Thanks for your reply. I pretty much just copied the SQL statement from the SQL view of my query, thus the continues line before the FROM statement. I think this is the line that's causing the error: Format(Format([anniversarymonth],""00"") & ""/01/"" &...

..with my SQL statement? I'm doing this in VBA and am having problems with the punctuations: SQL = "SELECT qry2006RenewalsFlagged.PID, qry2006RenewalsFlagged.CID, qry2006RenewalsFlagged.SetID, qry2006RenewalsFlagged.[Group Name], Format(Format([anniversarymonth],""00"") & ""/01/"" &...

Hello Everyone, I'm working one of our databases at work right now and for some reason, even without the autoexec macro in my database, it automatically opens one of the forms when started. Where do I look next to stop the form from opening? Thanks, Porsche

Hello, I keep getting the error on the subject line whenever I try to transfer my query results to an existing Excel spreadsheet. This wasn't a problem before but now it's coming up everytime I execute it. I read on some messageboard that it might be caused by updates to Office XP, and I...

Great! Now that works... is there a reason why I have to add false now to the close method?

Hi Geoff, I'm not sure why it's not working, but my close button sets the saved property of the workbook to true before closing it, there's no other code in between them: With ThisWorkbook .Saved = True .Close End With This is what I have in my module. It works fine as long as I don't...

Hello, I tried the Saved property of a workbook in Excel XP to exit without getting the prompt to save it. But for some reason, it does not work, although it worked perfectly when I used Excel 97. Is there a reference that I have to add to make it work? TIA!

Hello all, We recently upgraded our MS Office version from 97 to XP(2002) at work. After the upgrade, some of us started experiencing issues with MS Excel. Some of the tools/programs we use (originally created/programmed in 97)just started crashing randomly while saving, closing, and sometimes...

Geoff, sorry about that.. I was referring to MS Excel. I've been doing some research on it but it seems I already hit a dead end. Thanks for the reply though.