Recent content by Shawny

I have a report showing how many projects were done in a particular year, for each state in the US. Query organization: The only way I was able to figure this out was to make a separate count query of project numbers for each state, then combine all those querys into one query that the report is...

HI, I have a report that has an OLE object which is a map. When I publish to Word, the map does not go to Word. Could there be another way for me to do what I want to do? I have a map drawing - I put field controls on top of it. I want to get the map and data in the controls into Power Point.

Gosh folks, I'm not understanding your questions. I guess I really don't know what is going on here. If I need a start date, maybe last year? 200401 the user can type in any code. 200403 or 200502 or022401. I just want to separate the number into 2 different sections.

Thanks for the reply. The data is a code for a university for year and term. Because of particulars in this database, that is how the data must be entered. It's up to me to separate the 2 sections. I don't understand the question what would determine how the data will be displayed. Sometimes I...

Example of data in my text box: 200501 The data is text, not number. I want to be able to reformat this data to show either the first 4 numbers, or the last 2 numbers. It's important for me to use the format property in the form design view. I tried @@@@spacespace It does not work.

Thanks. I have entered my question under VBA.

I am designing a database to balance my checkbook. How do I put in schedualed transactions? I know how to add the new record. I don't know how to tell Access when to do it, and to not do it more than once a month.

Hi, I am making a database to balance my checkbook that enters schedualed transactions. I want to type in a starting date, and then run code to add a new record every 30 days after the date. I know how to write a macro to add the new record. I do not know how to tell Access to run the code...

You people are wonderful. thanks

I have a text box on a report, based on a text box on a form where the user types in the data to show on the report. The data is a 6 digit number. Example: 200403 I would like the report to show only the first 4 digits of the 6 digit number. I have been trying different formats with no success...

Could anyone share with me the code to prevent the 'Action Failed' box from showing when a macro fails?

How do I stop the Action Failed dialog box from appearing if a macro fails?

I have a cmd button on a form to delete the record: Private Sub Command121_Click() On Error GoTo Err_Command121_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 Exit_Command121_Click: Exit Sub Err_Command121_Click...

Peopletbl is the 'one' table and breedtbl is the 'many' table. I have a form peoplefrm with a Breed subform on it for the many breeds. I want to search for People records (and open the people form) with a particular breed as the criteria. The only way I have been able to make this work is if I...

I would like to stop the automatic box that comes up when data is entered that is not in the list in a combo box , and the 'limit to list' property is set to yes. I want to put a macro on the 'not in list' property to do some things that I want the user to do. The auto not in list box is in the...