Search results

Glad someone has seen this problem. Tried the code but get a compile error - expected variable and it points to Optional in the Public Function Replace segment ???? Thanks!

In an Access 97 DB, a form that contains a memo field is being used to allow a large body of text to be pasted in it from Word. The text is in Courier Font. When the text is pasted in, all quotation marks are pasted as solid bars. Tried Times New Roman and other fonts (TT) and same result. If...

Word Automation Continued Question Using the code referred to in the prior post. I had to change the Word template which was a table containing 5 columns because the last column's text would overflow the box when printing, and would not just flow into the next page, it would push other parts...

Graph question In this database, if I add a parameter in the meeting date field of the query to select dates in a period, then the attached graph starts asking for a parameter for each meeting date, and tries to give me a number of graphs, although the query itself shows the meeting date and...

Pat - the save portion now works appropriately. Can you or anyone else give a suggestion for the code that will check all the fields at the end (when the person clicks the check button, which they should do before printing), go thru each field to see that it is filled in and notify if it is...

dcx - There are cases when the user will have to go back and look up a piece of information, and I don't want to lock them into not being able to enter past that piece if they don't have it, only not allow them to print until the whole form is filled in, thus the check button which they hit...

Tried that, it takes the user there but still allows them to leave the field without entering anything, which is a problem. Also, if they do fill in the field, they have to reclick the check button for them to get the check completed, OK to print message. I want it to check each field (there...

I am using the code below, and need it to do two additional things - 1) Stop at each if block and not allow the user to go on until the missing piece of information is filled in, then go on to check the other areas. As is the user gets the messagebox, but as soon as they click OK and before...

Often I receive records in Excel format that departments want converted into an Access database. One problem I often have is when trying to normalize, i.e. create a demographics table with just one set of demographic information per person, I need to be able to get rid of all the duplicate info...

I am using the code below to automate the filling in and printing out of a Word template from Access 97. I have run into a problem whereby if any field is left blank, I get a type mismatch error. The minute the field is filled in with anything, the error is gone. I would like to insert some...

I am using the code below. I do not have any fields required at this time. If the user doesn't fill out a field, I get a type mismatch error. I would like to be able to say if CatID=13, then fill in the template with the text in OthTxt, but if OthTxt is null and CatID<>13, then ignore it and...

In the following code, I get a "type mismatch" error when the field in the database is blank and the Word Bookmark has nothing to pull from for a specific record. Is there some error handling code I can use to say if any specific field is blank in the database, go on to the next field without...

print multiple problem I added Neals code, but the dialog box opens on top of the print preview of the report, and if you hit close for the print dialog box, you can see the preview but get an error referring to closing the dialog box. This code is stDocName = "rptMeetingAttendance"...

I have solved the problem with the option groups by using the lookup table description field (a text field) in my query that the form using automation is based on. Doesn't check the box but does display the text associated with the box that was checked. Still would like to know a way to do the...

I have a Word template that opens in Access, populates, prints, and closes perfectly. I would like to know if there is a way to handle option groups for this process. On the form, I have an option group for "reason for selection" (checkbox, one only of course). In the table this is a number...

example Am attaching an example of my problem. For the first meeting, 3 out of 4 active members (at the time) attended = 75%. Next meeting 2 out of 2 active (at that time) attended = 100%. Active Member query only addresses active now, not at a particular date in time. How to account for...

Attendance percentage Using this DB is there a way to incorporate a percentage attending into the qMembersAttending and accompanying frmMembersAttending? My equivalent of tblMailingList has a field for inactive date (but I want the record to remain, just show inactive), so I would like to also...

filter on login I am looking for the same type of thing, is there something that will act as a login identifier (dialog box, form, ???) and when filled in filter all records except those related to this person (or service) so only the records they should be accessing they are allowed to see?

I have several section databases that have certain tables that link into tables in one main database. How can I get the section databases to 1) show only records pertaining to their section in edit mode or add mode? I have coded a filter on the OnOpen event, but they can remove the filter and...

Jon- I downloaded your file, but when I click on the Word button on your form, Word opens but the template does not load. Am I doing something wrong. I am using Access 97. Thanks!