Search results

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)?

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

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?

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.

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

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

I am trying to decide how I should set up the relationships between the following entities: - SPECIALIST - CASE LOAD - AREA. A SPECIALIST is an employee that is responsible for a CASELOAD. Each CASELOAD can belong to only one SPECIALIST at a time, but CASELOADS can be shifted from one...

I am trying to decide how I should set up the relationships between the following entities: - SPECIALIST - CASE LOAD - AREA. A SPECIALIST is an employee that is responsible for a CASELOAD. Each CASELOAD can belong to only one SPECIALIST at a time, but CASELOADS can be shifted from one...

Does anybody have a good strategy/method for creating a way to be able to search for a specific, existing record on a form so that the user can edit it (i.e., rather than having to scroll through a thousand records). All ideas would be appreciated. Thanks! -CoddFish

Does anybody know how to implement nested subforms? I am clueless... Please let me know if you know of a source that explains this, or if you can explain it to me so that I can actually create the thing. Thanks. - CoddFish

A PROVIDER can have one-to-many NEGATIVE LICENSING EVENTS. Each NEGATIVE LICENSING EVENT has negative action(s) filed as: - Denial - Suspension - Injunction - Revocation - Probation and/or - Fine. These negative actions are not mutually exclusive in that each NEGATIVE LICENSING...

I have a form with a subform. The subform is the typical format with each record displayed horizonatally in a grid. I would like to be able to double-click on a single record to open another form that will display just that record for viewing, and for add/edit/delete. Each record contains two...

I have a form that contains a combo-box where the user selects an AreaID (the bound PK for tblArea). This primary key is associated with records that contain three other columns of data: County, ZipCode, and FacilityType. There are two text boxes on the same form that I would like to...

I want to create a form where all controls are initially hidden except for a single combo box. I would like to make the other controls visible only after the combo box has been populated. How can I do this? thanks.