Search results

Ok, I have a DB containing data (name and address) about a client's parents, psychiatrist, and school. When it comes time for the client to have a review meeting, I want to be able to generate a form letter to all these parties, but I'm not sure how to do that with my current DB configuration...

I want a text box on my report to return the sum of persons who are between ages x and y. The code works perfectly if I want to return persons below or above a certain age, but does not want to return persons within an age range. Here is the code that is not working...

I am currently running a report that outputs a list of clients at various locations. What I would like to do is have the report jumpt to a new page each time a nrew location comes up. Is there any way to do this, where would I place the page break?

SELECT tblClient.FullName, tblService.Funding_Source, tblService.Service_Name, tblService.Auth_Date, tblService.Auth_Units, Sum(tblServiceLog.Service_Units) AS SumOfService_Units, [Auth_Units]-[SumOfService_Units] AS [Remaining Units] FROM (tblClient INNER JOIN tblService ON tblClient.SSN =...

Ok I have a table of clients, and each client will have 2 employees of differing types assigned to them. I had hoped to combine all employees into one table, assign them differnet titles in the employee table by way of combo box and then have the appropriate fields in the client table only show...

Alright, I did a search for this and came up blank, but I'm sure its been asked a million times, sorry for the inconvenience:D Is it possible to make a subform a popup form? I have a client table --1--to-many--> service table and want the service form to popup out of the client form. But I...

Ok I have a series of tables structured like this: --->=1 to many Service Managers----->Clients-------> Service Received-----> Service Log However, each client can also have a Case Manager. Usually I'd just make another table for them and create another 1-to-many for that field, but heres the...

An easy question: When I create dbs, I usually have to create single field tables that contain data that will never be duplicated, such as race, gender, etc. In the past I have just made the single "gender" or "race" field the primary key rather than assigned autonumber PKs to all the data. Is...

I am importing some data from an excel spreadsheet into tables and attempting to set the relationships so that I can run reports on it. As you can see, each unit can contain a number of case managers, no sweat. However, it sems as though I need to create a many to many relationship between my...

I am looking to open a form in a subform control, but in "Add" mode. Here is my code to date: Case conCmdOpenFormAdd With Me.chiSwitch .SourceObject = rs![Argument] .Visible = True End With How do I let the subform control know that I want...

In setting up my DB I was thinking it might be convienient to open my data entry forms within the switchboard interface, i.e. you click Enter Client Data and frmClientData opens up in the switchboard form. I know there has to be a way to specify which control the form shows up in, but I am...

I am looking to develop a form that shows records in a report based upon criteria defined in said form. So far I have had success in filtering city names, state, and whether or not the client is a medicaid recipient. Unfortunately, my knowledge does not include how to search a range, such as...

I want my users to be able to search the db through a popup form and then generate reports based on their input. Can someone post a bit of sample VBA that demonstrates a form field populating SQL statements? I'm not sure if this is even the correct procedure. Any help is appreciated.

I am attempting to have an action query populate the "Age" field of my demographics table. I want my input form to run the action query after the DOB field has been updated as to populate that field as the form is being completed. However, I continue to get "Compile Error: Argument Not Optional"...

Ok, I made a query that returns a Case Manager, their associated cases, and 3 dates that relate to each of these cases. So its: Case Manager-----Case Name----Date1-----Date2-----Date3 I only want records to appear that have a value in at least 1 of the 3 date fields. If they have no data in...

Ok, I have a query that returns a case manager, their clients, and a date attributed to each client. Ex: Case Manager Client Order Date James Bond Pussy Galore 01/05/2005 Oliver Cromwell Janet Roundhead...

I am attempting to calculate a due date via an expression that calculates 90 days from a specific field. However, if that specific field is empty, I want it to calculate off another date. I believe I have written the expression properly, but it doesn not function correctly. Here is my...

I am creating a switchboard to access a few data entry forms and to preview reports before printing. It seems that whenever I add a button to preview a certain form(the 4th button on the form, all others work fine), Access goes crazy. I get several errors, including: "You have entered an...

I checked the sample DB section, but could not find what I am looking for: a anonymous customer satisfaction database. Just a shell I can build upon. Does anyone here have anything similar I might be able to use?

Hey guys I'm developing a DB to input satisfaction surveys and compute satisfaction levels expressed as a percentage. I am setting up the DB with 1 record=1 satisfaction survey. The record would contain the fields:Survey Quarter and questions 1,2,3, etc. The responses to the questions are in...