Recent content by Cat

I have a report with lots of calculations & formulas that I would like to reproduce in another database. Is there a way to print out the design view showing the formulas written out? Thanks for helping me out.

After printing some letters and envelopes,etc. I exited the datase using the button created by the programer. It was not different from the 100 other times that I have been in and out of the DB. When I went back in to check something I got the following error -" Error Accessing File. Network...

I can see that the code records an error but don't know what I have done wrong. Option Compare Database Private Sub Revenue_Button_Click() On Error GoTo Err_Revenue_Button_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "FRM Revenue Data Entry"...

It is the only button that I have created.

I have a form called "Revenue Form". I wanted to add a command button to my main form called "Add Revenue". I have a tried the Open form on the Command Button Wizard and also have tried creating a Macro to open the form. Either way I get an error message - " The expression On Click you...

That will put the date in automatically, but I only want date to go in if they enter a new revenue amount. They could just be looking at past entries. Is there a way to tell Access after I enter this dollar amount, put today's date in the date field?

In my Revenue datasheet form I want today's date to automatically fill in after the $$ amount is entered. What is the best way to do this? Thanks

Thanks. I would really appreciate the assistance. I think it must be the relationships but I am not seeing what I have done wrong. Even after Compacting and putting into zip format it is 39KB.

The file is to large to attache even after I zipped it. I'll keep working away at it. Thanks.

The Add More Records navigation button is greyed out. All it will let me do is view the existing records in the table.

The allow additions form property is set to allow additions. The record source would be more than one table, so would the best course be to go back and create a form using the records from each table need in the form? Thanks again.

I have built the necessary tables, created a query, and created a beautiful form from the query. The Form will display the existing records in the table but I don't have the option on the Form to add new records. What dumb thing have I done? Is it better to build the form directly from the...

Thanks Rich Now for the dumb question. Where is the best place to insert that expression?

I am building a DB for a group of users for fundraising. All the forms, queries and reports would be based on our Fiscal Year. Is there a way to set up the Fiscal Year dates first so that any forms, queries and reports, etc. "created" would automatically work with in the Fiscal dates? Thanks...

I have a table that list Area codes. EX: E1, E11, E12, E2 etc. When I put them in order E11, E12, etc. comes before E2, E3, etc. How can I format the table to insert a "0" so I get Area E01, E02, etc. - so the sort order will be correct? Thanks from a junior Access user.