Search results for query: *

I'm sure the answer is here somewhere but I'm not sure how to search for it. I have a database of volunteers for a medical reserve corps in the county I work for. The "Person" table is the main table for the database and is organized: "PERSON TABLE" Person_ID (primary key) Last_Name...

I've looked through many of the Max date threads but don't really know SQL too well. I did something that I think works but I'm not sure this is the right way to do this. I have an address table with the fields ID#, Address, and Effective Date. The addresses are updated every month which is the...

I followed the instructions on Martin Green's website(http://www.fontstuff.com/access/acctut10.htm). I created a table with the following fields: Category, Product, Product Number, Publication Date, Supplier (from another table)Notes. The Categories are types of printed materials eg., brochures...

I need to say first that I don't really know anything about VBA. I know how to cut and paste. I used a tutorial at Martin Green's website on creating dynamic reports: http://www.fontstuff.com/access/acctut19.htm . I have several tables all linked to the main Person table with a foreign key. I...

I'm working on report. The fields and labels have borders. I can use ctrl and the arrow keys to try to move one right next to another but of course it's always either overlapping or there's some space between them. Is there anyway to tell access to just put one item right next to another without...

I'm doing a database for our county's Medical Reserve Corps. I have a query made up of 2 tables. The first table has person ID information and some other information. One field asks if the individual has a military obligation in the case of an emergency. A second table has a list of other...

I have split database. Some users may want to do queries on a copy. Is there a way to merge a back end and front end in order to create a query? I know they can copy the whole thing and relink the tables if necessary but I thought being able to merge it back into one entity might be simpler.

I've developed a database that will be used by 3 people primarily. One will be doing data entry and two will be querying and running reports. I plan to split the database and have all 3 users use the same front end. Is there a particular way the front end and back end should be backed up? I was...

It's probably convoluted but to do a datediff to determine age, I determine age by days then divide that by 365 and then truncate the number so there are no decimals. The truncated field turns out to be a text field even though the others that were used to determine it are both numbers. Is there...

I have a table with multiple entries for each person. There are multiples because each person may have been admitted multiple times to our agency. I have no control on how this data was set up so I'm stuck with this table. How do I do a query in which I say I want a unique record for each...

I created a form with several pages of tab controls. I created a subform which has four of it's own tabs. When I click in the tab where the "subtab" is, the tab furthest to the left is only half way visible. I click on another of the "subtabs" and everything moves over a bit to the right and the...

I have an Access form that's being filled in from a paper form. The paper form has changed in the last year so there are some common and some not common questions between the two. We're still entering both kinds into one table. I know there's probably a way to have certain questions appear...

Quite awhile ago I posted a question on how to get data on clients open within 2002. They may have been opened before 2002 and they may have been closed after 2002. I got a response, modified it and it seemed to be working ok. I have one query where it doesn't pull the right people. In the query...

Hi, I have a query with date paramters. When I run the query it asks for the beginning and end dates twice. It doesn't seem to affect the data but it seems odd. Any idea what this is? Thanks.

I'm doing a datediff where I'm using a persons birthday and the day they were closed to our services to determine age. However, if they haven't been closed in 2002 I want to use 12/31/2002 to substitute for CloseDate. I found this example: IIf(IsNull([DateOut]) = True, DateDiff("dd&quot...

Hi, I have been digging into HTML for about 3 weeks now. My friend who has done a few web pages said I must use HTML first and stay away from all that nice software, like dreamweaver, for a while. So here I am. I've struggled along and have made quite a bit of progress. I'm doing a web page for...

I hope I can explain this. I have a table with birthdays of clients. I created a form from this and then there's a subform,from another table, which includes the fields admission and discharge dates (one person can have multiple admissions). I discovered there is another database I can get...

I added a few new Yes/No fields to a subform and reset the tab order so they would be in the correct order. If I'm in one of the check boxes and click Tab, it tabs correctly but the subform jumps back to the top of the page. So it's tabbing ok, but I can't see that part of the form anymore...

Table 1 consists of basic client data and the Client ID is the primary key. Table 2 is entry and exit data per admission to the program by client. Each client can have multiple admissions to the agency. I want a datasheet subform with all the basic client data plus all admissions for that...

I'm working with database I didn't develop so I have some limitations with it. I have a query and a report that give enrollment and exit dates for our clients. I want to be alerted if the exit date that was entered is earlier than the enrollment date. I'd like it to appear in a color in the...