Answer Questions

• JaysonC can we do this in vba

  I developed a small windows appln in vb.net 2005 which uses MS-Access2003 as backend I want to give my own protection to this MS-Access file when i try open the access file, it should display my own Enter password dialog box for password I also want to mainain the user credentials in this access file Can we do this in VBA Hi, You shouldn't need to use VBA. If you load your database and select To ...Show All

• Peter Z Source Object as a query

  Hi i have a form that contains 2 text box's and a subform what i really want to do is to run a query and not have an input box popup i would like the dates entered into the 2 text box's to be used in the query of the subform and display a table that shows all records that are between date 1 and date 2. SQL code: PARAMETERS [First] Text ( 255 ), [Second] Text ( 255 ); SELECT Equipment.* FROM Equipment WHERE (((Equipment.[Date Installed])>[Firs ...Show All

• BSOD2600 lost buddy

  Started by timm at 05-17-2005 1:06 PM. Topic has 0 replies. Yesterday, 1:06 PM timm Joined on 03-24-2005 Posts 2 lost buddy  I once had a buddy.  He was very helpful, but then he left. So I applied for a new one two months ago, but never heard from him. Looking at the buddy site, I don't see a way to just reapply for a new one (other than filling out the form from scratch).  ...Show All

• Donkay Important MS Partner Question

  I'm giving serious thought to joining the Microsoft Empower ISV program, but I want to know for sure what version of MSDN and other software I'll get once MSDN Universal goes away.  The Empower ISV website has been recently revamped, but it STILL lists MSDN Universal as the version partners receive.  Since MSDN Universal is no more in about a month, what does that mean for active/new partners Please ...Show All

• FaulstiR Access report using VBA

  Hey All! I have a problem. I am creating a screen that includes persons first_name, last_name, phone_number (this is a fields in access) Now I have created a command button and I want that when user clicks on the command button the information in those fields would go to excel page. Sincerely, Boris Good answer! Maybe you can help me for a further more complex question: How can I parametrize Docmd.TransferSpreadsheet ...Show All

• neilprivate Problem with MS Updates on New Dell

  I have a brand new Dell XPS Fully Loaded and Upgraded, but there is one MS security update that will never load. I have Windows XP Media Center Edition 2005. I also have PC-Cillan Micro Trends Antivirus/Firewall Internet Security Protection. Below is the update that I am not able to get as it fails every time. Security Update for Microsoft .NET Framework, Version 1.1 Service Pack 1 (KB886903) Failed to install The other issue I have: ...Show All

• aprilmadams office2003 chart object(Spreadsheet1, ChartSpace1)and VBScript

  Hi Friends, I have a VBScript codes works in windows 2000 professional and office 2000.After migrated into office 2003. It does not work and got an error message " borrower does not support activeX" however. Does any person whcih new CLSID in office 2003 match these 2 clsid in office 2000 CLSID:0002E500-0000-0000-C000-000000000046 and CLSID:0002E510-0000-0000-C000-000000000046 After installed office 2003, I could not find above clsid/object(obj ...Show All

• chris12345 MS Access VBA - Controlling Textbox in Forms

  Hi, have a question here on controlling the appearance of a textbox in a form. Currently, I have a form which is has its recordsource linked to a table with 5 records. Each of these records have the Field -> "Cost" The form, when loaded, will display all 5 records in a "Continuous Forms View". The "Cost" Field is displayed as a textbox. How do I, using VBA, control the appearance of the text boxes For example, i ...Show All

• edmund83 Standard Difference Function

  I have a set of values 40 45 50 55 60 in my Excel spreadsheet. Is there any function that will find the difference between the adjacent rows (5 here). I would be happy to know if the function could be used in VB6 Thanks Shasur ...Show All

• Jaime de la Mancha Acces1 1.0 converted to Acces 2003 but the old medical program does not run.

  We have in our Hospital an old program written with Access 1.0. For more than 12 years it was OK but the size of the data base reached 1 GB since we are scanning images for each patient, and then the program collapsed. We were able to convert the old 1.0 databae to Access 2003 format, but the program does not recognizes the convered data. We don't have the program codes and the young lady that wrote the program for us 12 years ago, have had tw ...Show All

• elsonidoq MS Access key problem

  I'm doing a little work for a lawyer that has an Access VBA system to handle billing and printing of some legal documents. I am not an Access VBA expert; I'm a C++ expert who has picked up a few Access skills. When his secretary adds a new client, she has to pick a record key, which they call MGMT_CODE. It is a four-character text field. Most of the existing MGMT_CODEs start with 0 and consist of four numbers. Some of them start with 9, though, ...Show All

• myheadhurts VBA Excel Module opening Access DB with Recordset

  Here is the code: Dim cConn As ADODB.Connection Dim rs As ADODB.Recordset Dim sSql As String sSql = "SELECT Table1.Field1,Table1.Field2, Table1.Field3 FROM Table1 WHERE Table1.Field4 = Yes" Set cConn = New ADODB.Connection Set rs = New ADODB.Recordset cConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='\\path\files\folder\database.mdb'" Set rs = New ADODB.Recordset rs.Open sSql, cConn I get the same error on ...Show All

• Ken McGhee Web services reference not displayed

  Hi, I have installed Microsoft Soap Toolkit Version 3.0 and Microsoft excel 2003 in my system. My machine is a part of domain and I am logged in as domain user and this user has local Administrator access to the machine. Now my problem is I am not able to see the "Web Service reference" on the excel VBA macro editor under "Tools" menu. Could anybody please help me know the root cause for this problem. Thanks Sanja ...Show All

• Kely Can you guys help me fixing the error?

  I'm currently working for engineering company and it is my first time using visual basic woth Excel application. My job is to find the error and fix it, but i just dont know how. I have tried few things but it seems not working. Can you guys help it would be greatly appreciated. Thanks. The program contains macros and is a excel application. Here's the error message I get: Run-time error '1004': Select method of Worksheet class faile ...Show All

• Maigo Suppress Linked View Unique Record Popup

  Hi there im linking a view on an ms sql server to my access database using VBA using DoCmd.TransferDatabase acLink, etc.etc. How ever, I can NOT get the `Select Unique record Identifier` pop up to stop coming up when the link is being made. I dont care about needing a unique identifier, its a read only record source. The only way ive found is using sendkeys command to cancel the popup - however this can not be relied on, if it happens when the u ...Show All