Search results for query: *

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, 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!

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

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

Hello, Is it possible to use .Passwordchar property or password characters with Inputbox? TIA! Porsche

Hello, Does anyone here have a list of integer values I can enter for the backcolor property of an object in Excel VBA? TIA! Porsche

Hello, I am trying to incorporate a security feature in one of our MS Excel tools at work which requires me to get the computer names of users. I know this is already available in MS Access, though I only found the Application.Username property in Excel. Is there a way to get the computer name/...

Hello all, I'm trying to get the listbox columnwidths property to work though the syntax that MS Excel VBA Help provides does not work. Here's part of the code: Private Sub BO_Selection_Form_Initialize() With Me With .BO_Listbox .ColumnCount = 3 .ColumnWidths 36;20;200...

Hello All, I'm trying to make MS Access get focus on timer and I've used AppActivate and Getobjects but they don't work. Actually, AppActivate works but how do I make it pop up to notify the users about something? Any help would be appreciated.

Hello all, I'm currently working on a functionality for one of the MS Access databases that we're building. This feature will auto-assign each flagged case to a person in a table, kinda like dealing cards. Here's my code: Sub AssignCounter() 'Macro written by Marvin de Pano 'Macro written on...

Hello, One of the databases we use is currently corrupted. Unfortunately, I'm not able to repair it because there's a virtual/residual link that exists from the last time it was used. Is there a way to remove this link without asking everyone in the department to log off their Windows? I've...

Hello all, Is it possible to hide your form through a button while at the same time keeping the timerinterval property of the form running? If I do a Me.Visible = False through a commandbutton, the timerinterval prematurely ends and goes to the next series of procedures. Thanks in advance.

Hello all, I'm trying to use the Edit method in Access to change an item of a recordset into something else. Here's the code that I have: Sub Update2() Dim dbsOPSTool As Database Dim Logoff As Recordset Dim LOS As String Dim NewLOS As String NewLOS = 2 Set dbsOPSTool =...

Hello all, I'm trying to return user/computer names in a messagebox using the Openschema method. Unfortunately, when I try to make them pop up in a msgbox, I can only make 1 of them appear. How do I make all of the computernames from the recordsets come out in 1 messagebox. TIA!

First of all, I'm sorry if this sounds stupid as I've just started programming in Access. Anyway, as the subject goes, how do I compare textbox values to table records? Do I have get the table rows and store them in an array first? If so, how do you compare the textbox value to any of the items...