Help

Date Partition Function
I have a circumstance where I need to calculate counts based on user set start times, end times, and intervals. It looks like the partition function (http://office.microsoft.com/en-us/access/ HA012288921033.aspx) would do exactly that but it requires whole numbers not dates. SO...... 1) Is there a partition fun... 13 Apr 2010 18:27

Lock File Issue - 2007
On Mar 6, 12:40 am, John von Colditz <johnv...(a)earthlink.net> wrote: Strange issue with lock files. Database is split front end with multiple back ends. When users log out of the database, the following situation occurs. User(s) log out If One User In Database Then     Lock File Gone in < 1 Sec Els... 13 Apr 2010 00:45

Form Open Event crashes Access 2007 after close/compact
On Mar 9, 1:57 am, emanning <emann...(a)kumc.edu> wrote: I recently upgraded a 2003 mdb to a 2007 accdb.  There is one form in this accdb that causes 2007 to crash after it closes and compacts. (the standard "M O A has encountered a problem and needs to close...." message with an option to restart Access)  Af... 13 Apr 2010 00:45

Printing Checks from Access
On Mar 14, 2:13 am, Karl <karl3...(a)gmail.com> wrote: On Mar 13, 9:58 am, Karl <karl3...(a)gmail.com> wrote: I need to print checks from an Access 2000 database (can be updated if needed). If someone is doing this, can you share information on how you handle the fonts (check text versus the micr fonts... 13 Apr 2010 00:45

VBA - rst.Open cmd goes to error handling
I have some code that works properly in one database that I have pulled into another database, but it does not work in the other database. I am not experienced enough to resolve the issue. I have a feeling that it has to do with references, but I am at a loss at how to fix it. I did make the references match in... 12 Apr 2010 14:45

Image Display Problem !
I'm using the foll code to display images from a folder on a form. Each time I try to scroll to the "next" record a small window flashes past saying: "Importing C:\Al-Maha-Membership\Snaps\FILENAME.jpg" 1) Why does this appear even though I've specified: Application.Echo False 2) If I wait for some time (... 15 Apr 2010 20:20

go to a particular record in a form
Hi I have a help desk database that is populated by a user form in ms access 2003. The form has a text box that users can identify if the current request is similar to another request - for example request 1302 has a text box callled tbrRelatedTopic that a user might type value 1234 (for relatonship to requrest 1... 10 Apr 2010 01:34

'Time Picker'
I already have a 'date picker'' in my app (mscomct2.ocx) which I have the users select calendar dates for various date input purposes. Has any seen/used/know of such a thing as a 'Time Picker' in which the users can select military time rather than type that time into the input box? Thanks...Earl Anderson ... 10 Apr 2010 01:34

Append Query error with apostrophe
I have an append query that works fine unless one of the records includes an apostrophe. INSERT INTO [tbInvItems] ( ItemAbb, ItemName, AVIDNO ) SELECT DISTINCT [tbInventory].AVName, [tbInventory].AVDescription, [tbInventory].AVID FROM [tbInventory], [tbInvItems] WHERE ((([tbInventory].AVID)=Forms!frmInventoryEn... 9 Apr 2010 14:29

2010: Essential Diffs?
Sounds like Access 2010 is something of a different animal from preceding versions. Could anybody generalize the big issues? -- PeteCresswell ... 14 May 2010 22:39