Recent content by Viper210

Well following your advice, I decided to create a query on a new form whose sole purpose is to limit my records to a specific date range. I found the following code to achieve this: Private Sub cmdPreview_Click()Dim strReport As String Dim strDateField As StringDim strWhere As StringDim...

I am a complete novice and need help determining how to build this date tracking report: I have created a form which tracks activities/status of my clients, and on this form, I have 30 unique date fields to keep track of when 30 activities must/will take place. What I am attempting to do is...

As I stated in the initial post I am very new to Access. Could you please provide more detail on how to: 1. Create a "Tab control" 2. Add pages to the tab control

In a nutshell, I have this humongous questionnaire that is nine pages on paper and will total about seven or eight sub forms in order to complete the questionnaire in Access. I would like to have command buttons on main form / sub form to take me to the next sub form (or previous one) and...

Thanks for the reply, added the extra comma and was able to print single record. Unfortunately, still can't get second button to work and now getting this error message when opening up the report "Client 3" listed in my code: "Microsoft Access can't find the macro 'DoCmd'. The macro (or its...

pbaldy: Was your replied code a typo, you instructed me to put the same code in thats already there.

Thanks both of you for the reply's. First of all, I did change the name from CmdPrint to cmdPrint2 when I built the second button under the "Other" tab where it says "Name". Is there something else in the command button properties that I need to change so access recognizes the two buttons as...

I found these procedures on how to create a command button to print just one record. Followed them religously, but the button still prints all the records. The steps Open your form in design view. Click the command button in the toolbox (Access 1 - 2003) or on the Controls group of the...

Apologies for my ignorance but where is the "Activate Property" of the report located?

Thank you for your reply, After doing some additional research yesterday, I came to the same conclusion about the on click properties and got it to work. Here is the much cleaner code that I am using that will show the single record in the report: Private Sub cmdPrint_Click() Dim...

I have a database, Form, and Report all named Intake3. I was successful in printing my report but Access prints all the records. I went to another Access site and found the following instructions that I attempted to modify to fit my database and command button: The following procedure prints...

I appreciate the response. What I meant to say is that I want to be able to have city and zip as lookups where I can then select them in my table or form. The problem is I don't know how to link the cityzip table to the County selection in the main table which is also a lookup. Any suggestions?

Thanks in advance to anyone who can help. The intent of my database is to collect collect as efficiently as possible information from a client and be able to autopopulate as much information as I can such as County, City, and zip code. So far, I have a table called intake which is the main...

Hello, I am a newbie who used access years ago and now attempting to get myself reaquainted how to set up what the rest of the community may consider the simplest things, so please be patient with my mundain question.