Search results for query: *

Thanks for each of your replies. PHV: I replaced the contents as you suggested and the end result was that in all the records of Query A, the year stated 1905 and Query B had four groups of 1905 since my data covered years 2002 through 2005. Golom: I replaced Query B with your suggestions and...

In the SQL below of my query A, qryIncident Master File, the field “[DOIYear]” is formatted as “yyyy” to give me the correct Year. I want another query B to sum the total number of incidents grouped by Year, [DOIYear]. I can’t get the grouped query to work properly; it will group the year and...

Yes Ken, I changed the Auto Center to Yes and left the Auto Resize at No on one of the Reports and it is now Centered when the button is pressed. For each of the 10 reports I individually made the changes. It works. I thought there would have been a code to cover all reports. ZmrAbdulla. I...

Thank you. I changed the Popup to No and Modal was set to No. It works fine. A question though, and I'm not sure if this should be a new thread, however it is related. When I press any of the Switchboard buttons for reports, the reports are displayed in front, however they are displayed at...

I have a Popup Switchboard and when I press the menu buttons for reports, the reports come in view, however the report displays in the background while the Switchboard remains in front. If I press other buttons on the Switchboard referring to other reports, those reports always display in the...

I was hoping someone may have replied. However, for the 1st issue, I did create a Command Button on my "frmList of Individuals", using the “macEmail Appt Letter” to Email just the 1 selected record. I used the [ApptID] as the Enter Parameter Value from the "qryList of Ind Appt Dates (Email)"...

The below coding was graciously provided by OnTheFly and PHV. As I open “frmList of Individuals” which has a subform “frmAppointments”, I press the cmdPrint Current Record, it prints the selected “rptAppointment Letter” using the [ApptID] field, then closes “frmList of Individuals”. This works...

Yes, OnTheFly, [ApptID#] was the name of the field being used. Per your suggestion, I delected all "#" symbols and Yes, the coding works just fine. Yes, PHV, before deleting the # symbols, I closed each occurrence with [ ] and that also worked. Thanks both of you for your professional responses.

Thanks for the reply. I created the “rptAppointment Letter”. The record source “qryList of Individuals w/Appointment Dates” has the [ApptID#]. I placed the coding below to the OnClick event of the Command Button of the “frmList of Individuals”. However, when I press the CmdButton, the...

I have the main “frmList of Individuals” which has a subform “frmAppointments” which consists of several scheduled appointments. The Primary Key in the “frmList of Individuals” is [ClientID#] and the two Primary Keys in “frmAppointments” are [ClientID#] and [ApptID#]. I have a Command Button...

In addition to the above, I looked at the design of the Northwind Samples database: Products by Category report, and see that they have only a CategoryName Footer, not a Report Footer.

Yes, thank you Remou and Trevil for your response. I followed your suggestions and was able to get my 3 fields into 3 sets of columns on my report. A question: Is there a way to limit the size of the Detail in how many records are displayed in each column, that is to have each set of columns...

I am looking for a way to display 2 fields of data that have multiple listings in “columns” in a report. Example: I want to send in a letter to my clients a listing of 320 destinations that come from 2 fields; [Destination] and [Category]. Normally the first 40 or so names appear on the first...

PH, thank you very much for your response. I can see that you are well above my knowledge of VBA and MS Access. I must say though I don’t use VBA, I’m learning though. However, I would like to ask where would I place this coding in my database? The field [Name] in the tblMFS Master Data List...

I have a field that lists the last name, first name, middle or middle initial with a period all in one cell, Examples Given: Lager, Curtis A. Lager, Curtis Adrian Lager, Sr, Curtis A. Lager Curtis Adrian, Sr. The staff is not consistent except for the last name. I want to create a query that...

Ken S. Thanks very much and I could definitely use this solution in one of my databases. Thanks, and have a Pleasant Day!

Kzutter Thank you for your response. Your MsgBox solution works great in the OnLoad Event of the Switchboard. I had previously created a PopUp form and wasn’t sure where to place it; I have now placed it in the OnLoad Event and that is what I was looking for. Ken S. I did go to the...

My database is opened via a password and then the Switchboard is in view. Prior to entering any of the menus and as the database opens, I would like to have a PopUp dialog box appear. This PopUp box will provide a warning statement, which has to be read, and then press the “close” button on...

Thank you Mike for your much "detailed" suggestions. I will go through this in detail to understand all the options and try to put it to work. Again thanks for your responsiveness.

Thank you for the initial response. I am not an experienced VBA code user. Is it possible to provide a sample of what the code behind the switchboard would be? Maybe there is already a sample db that has this coding; if possible, would you know of that link? Thanks very much.