Search results

I currently have a form (firstform) that contains a button. If I click the button it opens another form (secondform - as a sepated window) that displays data. I use VB (DoCmd.OpenForm "secondform") to open the second form. This works fine. Now I am trying to insert the secondform into the...

I wondered if anyone could help me out with this: I am trying to implement the code provided by ajettrumpet here: http://www.access-programmers.co.uk/forums/showthread.php?t=171396 My issue is with step 5, I have placed the different code into 'On Open' and 'On Close', but when I run the...

I am trying to find some form of VBA code that will automatically select an appropriate (default) item in a list box. I can't use the 'default value' property as whats displayed in the list box is different depending upon other selected fields on the form. Could somebody please help? I'm...

I have a crosstab query that has been working fine from 02-08 to 12-08 (mm-yy) where the dates have been in ascending numerical order. Now we are in 01-09, the query looks like this: 01-09 02-08 03-08...to... 12-08 What I need is this (in date order with 01-09 appearing at the end)...

For instance: Front page of the Independent Online: 1) 'Darling is running out of options' - are we really surprised? Don't we all already know that changing interest rates is really the tail wagging the dog! And who really cares about any of this.... 2) 'Soho - Why sex trade...

I am able to create list / combo boxes in a form where the fields displayed in the box (for the users to select) will depend on (1) what has been entered in other fields on the form and (2) results from other queries/look up tables. I'm happy with all of this. Where I'm stuck is that I am now...

In my main table (in the back end), I have about 11 thousand records (with 19 columns) and when I first created the table I left most of the field sizes at the default value (255). However I have now reduced many of them, some to just 5, but the file size after running the compact and repair...

Surprising I've been unable to find any info on this. I am writing a user manual for my database and I'd like to 'copy' various forms and stuff to the clipboard, and then paste them into Word. The trouble is, when I use ALT-Print Screen, it copies the whole Access display (everything I can...

Hi, I was wondering if anyone might know if such a database would work over 2 sites. Specs are roughly as follows: 1) Database located on network in Harlow, Essex, that our Scotland site has access to. 1) No more than about 5 users on at any one time. 2) Main table will have 600 rows of data...

Hi, I would like to create a query in which I recall data from 2 tables in completely separate databases. Firstly, we have my database that manages the 'test status' of various units in manufacturing, all of which have unique serial numbers that go through different test stages. Every time the...

Hi, I have a Form that is filled in by various people. Once filled in, they hit a submit button that stores all the contents of the form to a table....fine. I have some fields on the form that I would like hidden from view, such as Windows Login ID, date etc that must be saved to the table...

Hi, I am having some difficuly trying to find the easiest way of producing charts from my data in Access. Initially, I created pivotcharts in Access, only to find that getting these into reports was a little tricky, and I found the charts behave slightly differently to Excel (need exactly the...

Microsoft application note 286335 (List of reserved words in Access....) gives a list of reserved words that we should avoid. Does anyone know for certain if these reserved words are case sensitive? ;)

I have created a crosstab query that displays data by month, using SLQ statement 'Expr1: Format([Date],"mm-yy")". 'Date' is a field in my table that is formatted as dd-mm-yyyy that is entered for each record. My problem is that I can't figure out how to restrict the query to display data for...