Search results

Hi, Using the code found here: http://www.mvps.org/access/tables/tbl0009.htm I have put the function to relink my tables into the OnOpen event of my Startup form. The function relinks fine, however, if the back end tables are missing, ms Access reports it's usual error: "Could not find the...

Have you tried pressing CTRL + TAB?

I have setup all my form validation in the BeforeUpdate event. I know that Access will auto save the current record when you scroll to the next record, which works fine with my BeforeUpdate validation code. However, some users users just like pressing the "Save" button, becuase it makes them...

Thankyou Craig. I might try some of those alternatives. I don't blame Stephen Leban for not supporting the Calendar. When you create something so useful, and you do it for free, to then offer support for free aswell, I'm sure can be quite taxing on your time. I think that is the great thing...

Hi all, I don't know if anyone has come accross this before. I've been using Steve Lebans Calendar control (available here: http://www.lebans.com/monthcalendar.htm ) for several database application I've built. I only noticed recently, that after I've selected a date range, by highlighting...

TODAY I LEARNT A VERY IMPORTANT LESSON. The reason why I was having the problems mentioned above is because I did NOT realise that - Subform [EVENTS] load BEFORE the Main Form [EVENTS]. Once I placed the code that was in the OnLoad Event of my Main Form, into the OnLoad Event of my...

Hi Bob, In attempting to post a stripped down version of the database I discovered the problem. I have two categories of reports I'm using, Category 1, Category 2. Each Category has some different field names. So I used VB code on the AfterUpdate event of my combo box and on the OnLoad...

I made the change, but I'm still experiencing the same behaviour as before. The total calculates correctly after changing the recordsource query through my combo box, but doesn't display the correct total when the main form first loads. I should also mention, I'm using a piece of code (which...

Hi All, I have a subform which has a field in the footer to calculate the sum of a field =Sum([SaleAmount]). On the main form, I have a textbox that references the subform's [SaleAmount], Main form control =[Forms]![MainForm].[MainForm_subfrm].[Form]![SaleAmount] I have a combo box which looks...

In reference to my comment above, I realise now, a better way to do it is to requery the lookup combo box on the AfterUpdate Event, rather than OnCurrent. Althought I don't notice slow performance with my application now, if my number of customers was to increase into 10's of 1000's, it would...

I think you are dealing with more complicated reports than I. I have a Main form that allows a user to Select a Report from my list of reports (stored in a combo box that I have been dynamically generating based on a naming convention that I use for my db query objects). Once the user...

RoyVidar, I like your idea. If I do it the way I setup, I have to make sure each query / report has a Description in the database properties windows. If not, my code returns an error when the combo box is populated. However, if I put my names in a table, I could still lookup the query names...

Works like a charm! Thanks!

Hi people, I'm using the following code to generate a list of the reports I want for a combo box: For Each accObjectQry In CurrentData.AllQueries Me.cboSelectReport.AddItem accObjectQry.name Next This grabs the queries for the reports I want to generate on my form through the combo...

Perhaps using: DoCmd.OpenForm Me.cbOpenForm.Column(3) Will do the trick. It worked fine for me!

Tim, I thought about what you said here, and using the suggestion by boblarson to work with the OnCurrent event, I used the combo box wizard to lookup my customers and GoTo customer on click from the list from the combo box. But I wanted more than just to clear the value in the combo field...

Thankyou kindly Tim! It was a simple matter of the record source property. I did not realise I already had my subform setup to work correctly, without needed to So restoring the main form's record source property to just the Customer's table was all that was needed. Thanks for the tip on...

* Bump To New Posts*

Hi guys, I've been experimenting with Tab Control forms in Access 2003. I've setup 3 tabs on my form with a Tab Control. The first 2 tabs, Customer Info 1, Customer Info 2, reference the same table. The last tab, Payments, has a subform that displays all the payments the customer has...

I have been slowly moving my SQL code to a VB string. So far, it hasn't been a straight process, and I had to read a lot of other forum examples to understand the correct syntax... and still I'm not getting the same query results for some queries. llkhoutx, what would you suggest instead? I...