Search results

It works! Jon, Thanks! Somebody gave me the exact same suggestions in another forum. Both suggestions work! Thanks for the reply -- this was driving me CRAZY :eek: -CoddFish

Any other suggestions? Wayne, Thanks for the reply. I tried your suggestion (I agree that it seems like a problem with data type), but it didn't work. The following query (using [Begin date:] = 1/1/2005 and [End date:] = 6/1/2005) results in zero rows of data... SELECT tblSpecialist.User...

I have created a query where I use the DateAdd function to calculate a date. I have named this calculated field NextVisitDue. The problem is that I'd like to be able to put an input parameter on NextVisitDue so that I can retrieve records within a date range. For some reason, when I do this...

I've searched and searched and searched, but cannot figure out how to get Replication Manager going with Access 2003! However, when you look in the Access 2003 Help file, it states clearly that the only way to implement indirect synchronization is by using Replication Manager! Does anybody...

Does anybody know how to implement Internet synchronization without Microsoft Office XP Developer (the only version of Office that comes packaged with MS Replication Manager)?

Tom, Does this work with a Design Master in a replicated database? Thanks. -CoddFish

I have developed a replicable database. I have run into a situation where I need to make some scary changes to the design master that involves changing a particular relationship that will have a cascading effect on a number of database objects. As such, I would like to be able to make a copy...

Thanks namliam for the suggesstion. Thanks Mile-O-Phile for the link. Thanks pono1 for the knowledge. -CoddFish

Do unto others... Tim, You might consider taking your own advice. -CoddFish

Who's the one with the evil imagination? :eek: WOW! I didn't mean to put up any red flags or piss anybody off! I hadn't even considered (nor do I fully understand) what you have suggested my intentions might be. My intention is to utilize a user's login password to query a table...

I know you can get the current user by using the CurrentUser() method. Is there a way to get the current user's password in VBA?

Thanks Paul! That's awesome -- thanks Paul! You just made my life much easier!

I am wondering if there is something like a global or session variable within Access that can be updated upon login (that is, the user-level login provided by MS Access' Workgroup Administrator). This way, I will be able to more precisely control various user features based upon who is logged in.

Thank you very much!

Catch-22: Allow Full Menus - HELP!!! I was playing with the Startup options in my database (Tools menu) when I decided to deactivate (uncheck) the Allow Full Menus option (at least I think this is what I unchecked). I just wanted to see what would happen. To my horror, doing this has removed...

Thanks! Thanks for the reply Jack! I'll let you know how it goes... -CoddFish

My objective is to have an easy way for a user to get to the record that they need to edit/delete (on a form) quickly, without having to sroll through every record to get there. I want the user to have a way of selecting (or typing in) data in a combo box from the available records in a...

And, a somewhat ironic title (subject) for the thread, no?

So, you are then suggesting the following: SPECIALIST - one-to-many - CASELOAD CASELOAD - one-to-many - AREA Am I correct in this assumption?

Noted.