microsoft.public.access | Forum profile

  Sorry, but this newsgroup is for questions about Access, the database product that's part of Office Professional. Your question would be best reposted to a more appropriate newsgroup.

  On Sun, 29 Nov 2009 00:35:51 +0000, Mickey <tccmb@me.com> wrote: >Hi, >I have inherited an Access database that needs quite a few changes to >forms. Can I make the changes on a copy of the form and then simply >move the new form into the database once my changes have been made? I >have tested this and it seems fine but I'd appreciate any advice as to >whether this is okay...

  Correction: That should have been: SELECT MAX(YourTable.Date) As Date, Num, SUM(YourTable.Amount) As Amount, SUM(YourTable.Amount2) As Amount2, MAX(YourTable.Receipt) As Receipt, GROUP BY Num HAVING SUM(YourTable.Amount) <> 0 OR SUM(YourTable.Amount2) <> 0; Ken Sheridan Stafford, England

  On Wed, 25 Nov 2009 15:55:06 -0800, "Paul" <BegoneSpam@forever.com> wrote: For performance reasons Access locks records a page at a time, not a record at a time. A page typically contains several records. Multi-user conflicts are a fact of life with any development tool. So you try to gracefully handle them. Perhaps in your error handler you can go to sleep for a second or so and try again? -Tom....

  That also works. I just could not recall the name of the built-in format. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County David W. Fenton wrote: > John Spencer <spencer@chpdm.edu> wrote in > news:O#EkV6ebKHA.2184@TK2MSFTNGP04.phx.gbl: > >> Or as an alternative: >> Field: SomeFieldTF:...

  How is the data stored in your database? Table and field names with datatype? Post some sample data records.

  dusty68 <dusty68@discussions.microsoft.com> wrote: >My office 97 Access Program begins automatically and it just began to happen. > >Is there someway to make this from happening? It is very frustrating when >your logging into the computer and all of a sudden access 97 starts to run .. Check your Start >> All Programs >> Startup menu item. Tony

  Tom van Stiphout <tom7744.no.spam@cox.net> wrote in news:7vvrg51s40tbd736r2qnbuv77aic9n7r4g@4ax.com: > For performance reasons Access locks records a page at a time, not > a record at a time. A page typically contains several records. Well, except when it doesn't. If you created your database in A2000 or later, it should automatically use record-level locking. Now, it could be that it's very...

  CW - You can try the GotFocus event of the first control (in tab order) on your form.

  I did a quick google on VB object converters and I see the product that I think you are talking about. While I have never used this Access to VB tool, I would guess it's not as easy as advertised to take a complete Access application and switch it to a VB or VB.NET application. Reporting for one in VB or VB.net usually works with a different product other than Access. Your back-end access database can probably stay the same,...