Search results

(I'm not sure if this belongs in the macro or query forum) I have a macro that opens 15 queries and ends with opening a report. The final query asks the user to type in beginning date, then an end date. Now when there's a data mismatch (i.e., he spells feburary), the macro halts. No harm no...

Thank you, Plog, that thought crossed my mind several times over the past few months. I'm afraid that ship has sailed. I have too many other queries and forms attached to that table. It would take me a year rewrite it..

I am an amateur programmer and use Access to keep track of my medical practice. I frequently have to send patients out for tests and the data is stored for each test in the patient’s record. What I would like to do is create a query that selects all patient tests done each month, and then...

That did it! Thanks so much

Thanks Mihail, But when I do force new page in the detail section of the report, it gives me a new page for every record (every patient). I would like all the patients from one referral source on the same page so it can be printed and faxed. I'll give you an idea of what I'd like to see...

Hello Friends, I am a Dr. an amateur DB programmer and would like help on the following situation. I have a DB with all my patients and (among other things) all their referral source. I would like to print a status report of all my patients, grouped by the referral source, and fax them to...

I would like to add 2 command buttons to an existing form: 1. Create a onenote notebook with a name based on the primary key of the active record 2. Open an existing onenote notebook based on the primary key of the active record. Any suggestions? (Be gentle, you're dealing with an amateur)...

Thanks Plog. Let me clarify a bit. This portion of the database is not to track visits MADE, rather visits ANTICIPATED (It prints a Monday morning report). The number of anticipated visits are calculated on autoexec and the number of 3's, 4's and 5's are calculated using the count function in...

I run a physical therapy office and patients come in for treatment either 3, 4 or 5 times per week. My database is used to track these freqencies (among other things). I have 3 queries which count how many patients come in 5, 4 and 3 times/week. In my main table I have fields called "how...

I have a macro which opens a query and prints a report based on that query. It's executed by a command button and it works fine. Problem: The macro periodically runs without calling it. I inserted a message box as the first command to alert me and remember what I did immediately prior...

OK nevermind. I found the problem. (I was using the name of the field in the table instead of the name of the text box. For some strange reason, I didn't name it DOB). Thanks for your help and insight JHB! /Pat

OK. I didn't want to get bogged down in the message box issue, so I tried another method. I created a test update query to update [Print Template].[last name] to "DOB is null" if [Forms]![Edit patient]![DOB] is null So the problem is that the update query sees the DOB field as null. Now I...

Here it is, cut and pasted. Private Sub Command172_Click() MsgBox ([Forms]![Edit Patient]![DOB]) End Sub

Thanks. Removing the other table stopped the query from updating that table (go figure). I changed the command button to run the VBA code you provided, but it returned the following message: Run-time error '438': Object doesn't support this property or method. I'm testing this on a...

Genius....I put in a dummy record to start and it updates. There is one problem and one strange phenomenon, however. The problem is that the DOB field does not update. The strange phenomenon is that the warning tells me that I am about to update 140 rows (the number of records in the main...

<More to the story> The command button will launch a macro which will run the query, then execute the mail merge code. I don't want an append query because I only want one record at a time in the table. I did try several WHERE statements. i.e., WHERE Forms![Edit Patient].[Last Name] is...

Yes. There is code to execute a mail merge from the newly updated table (a table with one record). But that comes after the update query. Some background info, if it helps: I used some code which runs mail merge from Access, the problem was that it merges the whole table and I only want one...

I am trying to use an update query to copy 4 fields from the current record on a form to a different table. A command button will execute the query, as well as other commands, via a macro. "Edit Patient" is the form which the user uses to navigate the main table "Print Template" is the table...

I am using Access (2000, don't laugh) to allow my staff to quickly enter data into a PDF form. I've inserted the PDF file as an object, I can line up the fields to fit the representative boxes on the form. My Problem. The inserted file does not match the size (8.5 X 11) of the original...