General

From a Form subtract issue from bound QtyOnHand in a new record
I want to make a simple current record transaction and update one field in the main database for a unique item. The transaction would be to add an issue record to an issue table and change the inventory table QtyOnHand field based on the issue. Update queries are generally for multiple records, I've tried usi... 19 Mar 2010 14:23

Issues after 2K7 Conversion
Hello, We have just converted an Access 97 db to Access 2007 and now no one can open the db in either 97 (.mdb) or 2007 (.accdb) Unfirntunately we do not have any Access guru to trouble shoot this. Any ideas on where to find help. One thing I did notice is that when the 97 db was first opened in 2007 the Da... 19 Mar 2010 16:40

Access crashes when importing dbf file
I'm using Access 2003 and when I try to import a dbf file, Access crashes on me. I've already tried repairs and uninstall/reinstall of Office but that hasn't resolved the issue. I also am up to date on all service packs and updates. Not sure what to try next. ... 22 Mar 2010 16:52

Filter using query
Hi all If I have a query which contains a list of ItineraryID's (primarykey) can I use this to filter a forms recordset? Thanks... Sue ... 19 Mar 2010 15:32

Running Total
Hi, I am trying to use a Running Total query but have come unstuck in two places, the following works however I would like the running total to start in April not January and go to March the following year, also how can I stipulate that it only shows records where the field [Status] is equal to "Won". SE... 21 Mar 2010 17:22

Multiple listbox questions
I have a sales/cost/profitability report that with lots of help from posters here I have managed to create a form to filter it by several criteria and its all working well, I'm just tweaking it some now and have a few questions: First I have 2 listboxes 1 for customers (we currently have 346 listed), 1 for lot... 19 Mar 2010 13:13

Table ALIAS of INNER JOINs ?!?!
argh! had a typo. forget about it... ... 19 Mar 2010 12:01

on last enter start new blank form
is there a way to have a new blank form start after entering last input of information? Thanks in advance for the help! ... 30 Mar 2010 09:26

YES/NO FIELD IN COMBOBOX
tblCustomer custid PK autonumber custname text custcode text custacct yes/no used in frminvoice as combobox using all 4 fields (custid hidden) example data in combobox A D Plumbers | AD0001 | -1 Smith, Andrew | SM0001 | 0 column(3) either shows -1 for true or 0 for fal... 20 Mar 2010 08:31

Assigning permissions
In Access 2003 I have just set up User Level Security. I am now assigning the permissions. In the User and Group Permissions window, I selected the Group "Users" and the Object Type "Forms". I checked some of the boxes as desired and assumed this would apply to ALL forms. However I now see that it applied only t... 19 Mar 2010 13:13