Search results

Is is possible to combine two unrelated reports into one master report? If so, what is the best way to do it? rbrule

Hello, I have a form with two subforms. The subforms are created from two queries. When I search the main form, Access shuts down after two searches, with no error message. It did the same thing when the subforms were based on tables. Does anyone know why this happens, and what the fix is?

I have a crosstab query that shows the average product errors for each product each month of the year. Some products are not produced in certain months which leave null fields. The months with data show percentages of errors from 0.00% to 100.00%. I would like to have a summary column that shows...

Hello, I am trying to set up conditional formatting for a text box in a subform. the subform is in datasheet view the fieldname is [status]. I have entered the following code in the after_update property. I am looking for the background and text to change color under several different...

When setting up macros, what causes an Automation error?

Can someone tell me the correct macro condition, item, and expression to populate field # 1 with a word if field # 2 is null and populate field #1 with a different word is field # 2 is not null?

Is there a way to insert a calendar on a form from which a user can select a Month year and day similar to using the calendar on Outlook or Lotus Notes to set up or view appointments or meetings?

I have a table that contains two fields "status" and Date". I have set the status field to the default value "available". I would like the value of the status field to change to "not available" automatically when the date field is filled in. I believe I need a SetValue macro, but I have not been...

Hello, I have a query that I did not create, but I am now responsible for. My problem is that when I type a date into the criteria field to call up records I get no records. I know the records are there, because they come up when I take the date out of the criteria field, and open all records. I...

Hello, I would like to put the first date shown in my query in my report header as well as the last date. For example the Header would read Report covering 1/5/06 to 4/17/06, and would automatically update depending on the first and last dates in the query. I used =First([date]) and =Last([...

Is there a way to format the day of the month as an ordinal number? For example instead of formatting the day as January 1, I would like to format the day as the 1st, 2nd, 3rd etc. day of the month. I need to do this in order to match the format of a contract that we want to use as a mail merge.

Is it possible to include a bound OLE object in Access in a mail merge using a Word document? If so, can someone tell me the procedure? When I include the OLE object as a merge field, and complete the merge, only a code shows, not the document it is linked to.

I would like to set a column in my spread sheet to change color 30 days prior to the date in the cell. I used the formula =value(A1)<= Today() + 30. It seemed to work for one cell, but I couldn't get it to work for the rest of the cells in the column. The procedure that I used was to highlight...

I have an excel sheet in which I wish to use conditional formatting . I would like to change a cell red 30 days prior to the date entered in the cell. I would like to use conditional formatting for all the cells in the column. Can someone give me the correct formula?

I have an excel sheet in which I wish to use conditional formatting . I would like to change a cell red 30 days prior to the date entered in the cell. I would like to use conditional formatting for all the cells in the column. Can someone give me the correct formula?

I recently created a database and installed buttons to properly close the database to avoid coruption of files etc. However I could not find a way to eliminate the X button in the upper right corner of access. Today my dbase crashed, I presume because someone did not use the buttons I installed...

I recently created a database to be posted on a network. In order to eliminate users prying into the mechanics of the database, I unclicked some menus on start up. The database is also password protected. I did such a good job that now I can't get into the database window myself. I used shift...

Hello, I have a new database with two tables, one of which is a linked table. I want to link the two using a one to many relationship from one table to the other. I have a primary key field in the main table which is an autonumber, and a foriegn key field in the second table which is a number...

Hello, I am in the process of converting data from an excel sheet into Access 2000. I know the import procedure, however some of the fields in the Excel sheet have multiple data. Is there a way to sort out this problem, short of cutting and pasting or re-entering the data? For example one...

Hello, I have a delete query in my database which I would like to run from a command button on a switchboard. When I use the command button wizard, it does not show delete queries in the menu of available queries. If I create a command button manually I will need VBA code for the event...