Search results for query: *

Given the above...this is obviously being used in a multi-user environment, and sounds as if a single copy of the database, residing on the server, is being accessed by all users. If this is the case, it may well be the problem! Having multiple users sharing a single, non-split database...

[ol 1] How are you attempting to do this backup? Why in the world would you backup the Front End, but not backup the Back End? Isn't your data important? A corrupted Form can be recovered or recreated...but corrupted data? [/ol] Hope this helps! There's always more than one way to skin a...

This is a problem that started with Access 2003, I believe, and is felt to be triggered by non-attached Labels on the Pages of a Tabbed Control. In addition to appearing when cycling through Records, it can be seen by merely hovering over Labels with the mouse. Allen Browne has a short...

Sorry...misunderstood your question! Don't think you can do away with the current/selected Record being hi-lighted, in Datasheet View. To be honest, can't imagine why you'd want to! But everybody has different needs! As is often the case, when wanting something that looks like a Datasheet, but...

Don't know your version, but in v2007 you go to Options - Datasheet and set the Alternate Back Color to 'No Color.' The caveat, here, is that you have to do this before creating the Datasheet View Form! Doing it doesn't change the appearance of previously created forms. Hope this helps...

In, in fact, you have already done so, multiple times, after been given the same advice before! Are the Fields SrvChrgSize and SrvChrgAmt in a single Table? If so, base your Combobox on that Table and include both Fields. You can do that by simply using the COmbobox Wizard. Hope this helps...

Actually, unlike many previous ActiveX DatePickers and Form-based calendars, Access does consider the Control to be physically populated when done using the native DatePicker, meaning that all of the Control's associated events, such as the BeforeUpdate event, AfterUpdate event, etc, will fire...

Actually Forms are refreshed automatically...at least through 2007. In that version, you can find it under Options - Advanced and then down under the Advanced Section. It defaults to 60 seconds but can be set to 0 (zero). Hope this helps! There's always more than one way to skin a cat! All...

txtXLst One would expect a Control whose name is prefaced with txt to be a Textbox...but the XLst part sounds like a Listbox...which is it? Hope this helps! There's always more than one way to skin a cat! All posts/responses based on Access 2003/2007

Some form of corruption would be my guess! I did notice something that I'm sure is unrelated to the problem, but you need to be made aware of, as it could cause other problems down the line. When you do something like this Dim i, ix, j, k, L, m, n, p, q, r As Currency I suspect that you think...

Probably would be a good idea to post the OnCurrent code, so we can see what it does! Problems that can be resolved by stopping execution, part of the way through, then continuing execution, generally have something to do with timing, but without knowing what the code is doing it's hard to say...

First question, I guess, is are you trying to do this by manually selecting the Records to hi-lite...or doing this based on some condition? Hope this helps! There's always more than one way to skin a cat! All posts/responses based on Access 2003/2007

The obvious thing is that in the working code your field is txtfromdate and in the errant code the field is txtdatefrom Hope this helps! There's always more than one way to skin a cat! All posts/responses based on Access 2003/2007

First question...does the Form open in Read-Only mode, or can you actually add a New Record? Second question...is the Form's AllowAdditions Property set to Yes? If it is not Read-Only and the AllowAdditions Property is set to Yes, then Private Sub Quantity_AfterUpdate() DoCmd.GoToRecord...

Having multiple users sharing a single, non-split database, sitting on a network drive, is the sure way to repeated episodes of corruption, speed and timing issues (timing coming to mind from your description) as well as all manner of odd things happening! Multiple users simply have to work off...

Is this Database split into a front end/back end configuration, with each user having a copy of the front end (with everything except Tables in it) and the back end (with Tables) on a shared drive? Hope this helps! There's always more than one way to skin a cat! All posts/responses based on...

UserForms are intended to be used primarily with Excel, and to a lesser extent, with Word, I believe, which begs the question...why do you insist on using them with Access, instead of using standard Access Forms? This is not the first problem you've posted because of mixing the two. Hope...

Glad we could help! Good luck with your project! Hope this helps! There's always more than one way to skin a cat! All posts/responses based on Access 2003/2007

You can't use If Me.cboEmployeeName.Value = Null Then The correct VBA code for this kind of thing would be If IsNull(Me.cboEmployeeName) Then or, if there a possibility of a Zero-Length String (unlikely, I would think, in a Combobox, then If Nz(Me.cboEmployeeName, "") = "" Then Hope this...

Glad we could help! Hope this helps! There's always more than one way to skin a cat! All posts/responses based on Access 2003/2007