Recent content by smitty27629

The form and it's calculated fields are being stored in a table (Totalstab) for later viewing. I created another form that displays Totalstab's data and recalculates the needed fields but when I scroll from record to record the calculated fields do not update. So I figured that I would just...

Does anyone have any info? Please.

I wrote an insert query that enters all fields on a form into a table. The form has some fields that are populated by a query and some that are calculations of the other fields. All of the fields that are populated from the query enter fine, but the ones that are calculations are blank. I read...

I have a form that contains fields that are populated by a query and it has a few fields that require user input. What I'd like to do is have a Save button that when clicked will save all the fields on the form as a record in another table. This form would be used multiple times for each month...

Does anyone have any suggestions for the quarter format in the query in post #9? I'm not very good with VBA obviously, so I don't know the available attributes for the DatePart and Format functions. Maybe I need to do something different in order to get the Quarterly query to work. I just don't...

RV, Your a lifesaver Mate. I owe you a pint or two. I took the quarterly queries out of my macro to test the monthly queries with the info you gave me and it works great. One other question, How do I do the same thing for the quarterly queries? Again, the combo box will have January...

Does anyone have any info at all? Please. Thanks.

SJ McAbney, Where was this posted before? I may be able to get info from it. RV, I changed one of my queries to use the DatePart in the criteria field of my query but I'm not getting any results. No errors, no data, nothing. In the table that I'm querying, the [shipdate] field is 01/17/04...

Des, I'm not sure I understand what you mean by a lot of picking and choosing. Currently, the user is having to type in 4 dates. For example they want to see the Monthly and Quarterly report for January. When they click on the button to create the report, they are presented with a form that has...

From the switch board, the user clicks on the Create Monthly/Quarterly report. This opens a form where they enter the begining month, ending month, begining quarter, and ending quarter. After they type that in they click continue which initializes a macro that runs several queries based on the...

Wayne, Sorry it has taken so long to respond. It worked wonderfully. Thank you very much. Everyone, can you recommend a good book, website, etc. For VBA in Access. Most everything I find in searchess is for Excel. Thank you all.

I have a scenario like the following: field1 field2 field3 field4 field5 field5's control source is: =[field1]/[field3] The problem is that, it is possible that both field1 and field3 can be 0. I would like to set field5 to 0 if field1 or field3 are not >0. I just cannot figure out the...