Recent content by tbaguio

Has anyone tried to reverse engineer an Access database with security on it? I have Visio 2003, and have attempted to create the Access DB data source several times, but it doesn't allow me to do so. Thoughts? Theresa "Sleep is the best meditation." - Dalai Lama

I have a combobox on a MS Word userform called cboCustName which I want populated by a SQL database. I've already successfully created the connection and have populated the combobox with the correct data. My next problem is this: How do I pull more than one value into the combobox? I want...

Hi, I appreciate the comments. I have SQL Server 2000 and a trial copy of Visio Pro 2002. Since I'm a newbie at this, what are the steps needed to export my currently existing SQL Server diagram to a email-able file format? Thanks! "Sleep is the best meditation." - Dalai Lama

Is there a way to export SQL Server diagrams to email to clients? I'm more used to Access databases, so not having the "Save Relationships Report" feature is odd for me. Thanks! "Sleep is the best meditation." - Dalai Lama

Yup. Clicked on it. Clicked on it several times after my initial frustration. Still no "stickiness". It goes back to the default after some time has elapsed even if I make the change while in the DB exclusively. "Sleep is the best meditation." - Dalai Lama

Actually, I've tried doing that. Unfortunately, that setting does not stay set. For example, I would set it at 20000 max records. Later on in the same day I would look at the setting again, and it had reverted to 10000. Anyone else have this problem? "Sleep is the best...

I am running an Access 2000 ADP pointing to a MS SQL 2000 database. One of my forms is pulling a recordset that is in the 15000+ records range. Under options for my ADP I have set the "default max records" to both 20000 and unlimited, but for some reason, none of these settings...

Thanks very much for your reply. Your assistance was greatly appreciated. That did the trick! More proof that the posters on Tek Tips know their stuff! "Sleep is the best meditation." - Dalai Lama

Hello, I have 1 table that looks like this Table XItem { TransactID TransactStatus nVarchar TransactStatusId Int This is all done in a MS SQL 2000 backend What I want to do is when a user updates either TransactStatus or TransactStatusID I would like the field to update the the other...

Hi, I'm having the same problem. Did you by any chance get this resolved? We have tried using this method with our SQL backend: me.uniquetable = "dbo.tblTableName" Unfortunately putting the table name in the string does not enable the code to recognize the object owner. I'm...

Wow, you have all convinced me... C# it is. I guess I am sold on the marketability of learning C#. I never really thought of it that way. I was more stuck on keeping to what was familiar, but I figure I have to expand my programming realm anyway. Thanks again! "Sleep is the best...

Thanks RiverGuy and Craig for your responses. I think I'll continue on and leverage my existing experience with VB and learn VB.NET. As for C#, I will delve into it slowly by trying an introductory book in the meantime. I really want to learn C# based on what everyone is saying, but as Craig...

Hi, I'm a self-taught VB6 novice programmer and was thinking of going back to basics. I am planning to take an introductory programming course but am torn between which language to use: C#.NET or VB.NET I'm currently using Access 97 VBA at work, but want to get into more data-oriented...

Thanks Ben. It's always helpful to have shorter ways of doing things! Theresa "Sleep is the best meditation." - Dalai Lama

Came across two nifty functions that enable you to find out the name and path of the currently open database for people using Access 97. Thought it would be of use. I mostly use it in the footers of my reports combined with the CurrentObjectName function to help me figure out which report came...