Search results

Tim, Can you upload a sample of your report with a table?

Thanks Doc.

RG, I made several modifications based off your suggestions. I am still not getting the desired results with my form. Will you please take a look at the attached database. Thanks!:D

Thanks, I guess I need to play around more with queries.

Here is an example: =IF(COUNTIF(Holis,BB27)=1,"H",IF((DSUM(AllData,Data!$F$1,Matrix!B711:D712))=0," ",DSUM(AllData,Data!$F$1,Matrix!B711:D712)))

Is there a way to create certain math equations from Excel into Acces VBA??? If so, is there any links with examples... Any assitance with this is greatly appreciate. :D

Not to say I have tried everything, but I did attempt this. The only thing that I can think that may help is adding another field in my form that records the day, and filtering from this. To be 100% honest I was hoping someone could assist me with my prior post; I really want to be able to...

I have spoken to early :-(. My form does requery, but all of the records now show. I was hoping the subform would only show the records that I have entered today... Any thoughts?

Thanks a bunch!!

I am able to have it show the last record. How Can I get it to show all the records that I entered for the day?

RG, When I started building this form I thought that I could accomplish what I wanted by enabling or disabling the controls. You have brought up a interesting point. I think that I will rewrite all the statements to reflect the changes, based on the value selection. Thanks for the Database...

RG, I do agree with your analogy for me to start from the basics. I have attached a database please see post #3. Inside this database contains what I have written for my checkboxes. Would you mind taking a look to see if I am on the write path? Thanks

Okay, so I would use something like this in the subform VBA?... Private Sub Form_AfterUpdate() SubForm.Requery End Sub

Okay, So lets say I now have a module called modOnOff. Inside this module I will have created the following Public Function boxTurnOn() Dim Cntl As Control For Each Cntrl In Me.Section(acDetail).Controls Select Case Cntl.ControlType Case acComboBox Cntl.Value = Null End Select Next End...

This will take me some time to figure out how to write the logic for all the similar controls into a class. I understand what you mean, but I am not very good at writting classes or modules and calling them (the calling part is less challenging). I give it a try; do you have any idea in how many...

I have a subform inside a form that is linked to a single table. Everytime I enter a record, the subform isn't showing the recorded entered unless I navigate back to the record entered; even then it only shows one record. I would like the subform to show the records that has been entered. Can...

Try using in your table under the Number data type; then in the format use the drop down menu and click on Double, set the Decimal property from Auto to 0. Even though this is used for numbers with decimal values, it will prevent the roundup of the number.

I am kind of following. I will try to type out my understanding of your sugguestion. For example, Since I am using many controls of the same type, I can create a class that turns the controls on or off based on user selection...

RG, I am not sure if I understand. Are you saying that I need to create function or module?

I tried your suggestion and it works great. Thanks!