Recent content by emcc
-
E
Queries, Reports and Forms, oh my!
I have a form (for prospects) based on a table. The table, for the most part, will be populated from our website. But, there will be times information will have to be manually input. What I would like to have is a list of prospects pop up and then be able to choose from the list and have the... -
E
Comment Box Funny Error Msg & Text Box Problems
I have two problems on my form.... I have a comment box that when I either try to enter text into it or leave it blank that gives this error message: "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data" I checked the properties of... -
E
Date updated on input form
Pat: Thanks for your response. I do have a dumb question though! When I add the column, in my case to a query, I'm not sure what I'm supposed to put in the column. And, how do I associate what I'm changing in the Form's properties to the text box where this date will live? Sorry, I'm new to... -
E
Date updated on input form
I have an input form for prospects and can't seem to figure this out. I would like to have a date field that is automatically updated, that shows the date the form was last updated so when a user opens a form they will see that date. Thanks! -
E
Creating a column total
Rich and SomeGuy- Thank you both for your help on this. It was actually Rich's solution that worked! Access, it seems, is a bit quirky that way but now that I know how it thinks I should be able to avoid these kind of problems in the future. emcc -
E
Creating a column total
Rich and SomeGuy- Thank you both for your help on this. It was actually Rich's solution that worked! Access, it seems, is a bit quirky that way but now that I know how it thinks I should be able to avoid these kind of problems in the future. emcc -
E
Creating a column total
I'm still working on my report...now I've moved on to column totals. For the columns that refer to a table the totals come off with no problem. The one column that is a "derived" total is another story. When I use the expression =sum([Outstanding])a message box pops up asking for a parameter... -
E
Writing expressions for a report
Pat - Thank you, thank you, thank you...that was the problem. You have no idea how long I have struggled with this or how many people I have asked about this! I am so glad I found this site!!! -
E
Writing expressions for a report
I have all of my expressions in Text Boxes... -
E
Writing expressions for a report
I'm a fairly new Access user (self-taught)and have created a report where, in one field I would like to have Access look at one date field and compare it to another and make a decision on what it finds. Specifically, I'm trying to say: if InvoiceDate is Null, print the QuoteDate, otherwise...