Recent content by Bear

I've created a db where 7 individuals enter their data in 7 forms. This data is then combined to form one report, but these individuals wish to edit this information once brought together. I thought an easy solution would be to publish this report to MS Word. However I ran into a problem, I...

Here's the situation, I've set up one form as a search form where you type in a ID# and click on the search button which starts the macro. The macro is set up to open form, maximize and then set value. The plan is to have it insert the ID# into the appropriate field on the other form if the...

I added new fields to an existing form and when I positioned them in the form the labels disappear when I preview the form but the text field is visible. I have the label outlined and that is visible but the text within the label is hidden. Any suggestions?

I am currently running a query to open a form. This query uses a HIN #(primary key) to find the clients record but if the client is new it defaults to a blank form for data entry. What I want to occur when this happens is the HIN field fills in with the number that was used in the query. I have...

Presently I am using a query on a health number to bring up the clients record. If the client hasn't been entered into the database before, it defaults to a blank form. What I want is to have the health number fill in the appropriate field on the form to reduce double entry. Any suggestions...

Thanks, that was simple, being new to access I sometimes miss the easiest answer.

I was wondering if it is possible to add a new feild to an existing report because I don't feel like reformating the style an existing report. Or is it possible to create a new report and copy the layout(header/footer) from the existing report. Any help would be appreciated.

Thanks, I can't believe I over looked that.

I have created a combo box from an existing table. The problem that I am having is when choose an option from the box and continue on to the next form/record the option I selected is not saved so when I return to it appears blank again. I appreciate any ideas anyone may have.

Thanks Travis for the help your help has pointed me in the right direction and has given me a few new ideas.

Being a rookie at Access, I imagine the answer is simple. I am developing a waiting list using a SIN number as a primary key. What I'm hoping to accomplish is when I enter in the SIN number the form fills with their previous information unless they are a new client. Any ideas would be helpful.