First  |  Prev |  Next  |  Last
Pages: 1 2 3 4 5 6 7 8 9 10 11 12
Access 2010 misbehaving
Hi all. I run A2010 on a separate PC which has Windows (XP) automatic updates switched on. A couple of days ago I had a telephone call (number witheld) from a guy with an Indian accent saying he was from Microsoft and enquiring whether my PC was playing up. Now, I don't respond to this kind of call (for obvoiu... 13 Aug 2010 05:57
unable to put an option group on a subform without crash
I have 1 subform in an access 2003 database that any time I put a option group on it and hit save the database crashes. Any other type of control is not a problem. Check box, toggle button .....etc I have even put about 10 different types of controls on the form tied to variables and still it works fine.But not an... 12 Aug 2010 20:16
highlight current record in continious form
Hi All, I know there are so many questions on this issue but mine is just a little different. What I am trying to establish is the following: The user clicks Alt-Q which opens a form with a listbox with years on it. When he chooses a year the form closes and in my continious form it jumps to the first record ... 12 Aug 2010 10:21
Many-to-many question
I have some tables, trying to create a normalized many to many situation. I the the following tables: tblStates (US States, that is) tblProducts ProdStates (to link the two tables together) The tblStates and tblProducts tables have a many to many relationship. What is the best way to create a from to be able to s... 11 Aug 2010 11:26
Report Design question
Hi again everyone, I am hoping that there might be an easy way to achieve this before I go and create bucket loads of queries. I have a need to produce a report with five sets of data, side by side. They are effectively lists based around a single field. I have previously generated a query that has a column for ... 13 Aug 2010 19:02
Combo Box not working in Access 2007
I am using a combo box that has a control source of a text field of size 50. I also am using a value list with "val1", "Val2", "val3" values for example. Anyhow in access 2007 when I click on the value of the combo box nothing happens. In 2003 what I click on becomes the value of the combo box, anotherwords I'm ... 11 Aug 2010 12:31
Publishing a block of code for all to use
Hi Everyone again, I mentioned a while ago that I was happy to publish a block of code I wrote to allow the production of powerpoint slides from a report. I have the code working nicely and I would like to share it, but I am not sure how to 'publish' the code and pay attributes to those whose code and work guide... 10 Aug 2010 05:49
Creating an artificial rownum value in a query
Hi Everyone, I have a scenario where I will need a rownum value for a query. I have attempted to make this by doing a self join type query based on the 'original' querydef and counting the records. I am getting results that dont make any sense and I am not sure why. My 'base' query is made up from data that sp... 10 Aug 2010 12:26
Multiple Counts In Select Query
I have several tables which have imported data for a back end datafile, these can be simplified as: Syscode NumOfD 101 34647 101 43567 101 12354 102 12345 103 4356 104 49907 104 21455 104 54678 193 34567 209 54789 209 222... 9 Aug 2010 16:47
Capture field of certain records to display in code as comma separated text
Hello, I was wondering what the most efficient way of capturing check box values from those records in a form which are checked so that I can use the values in code. I have a form with 5 controls, 1 is a checkbox. The user will check the records he wants chosen and then click a CommandButton. In the commandButt... 9 Aug 2010 10:05
First  |  Prev |  Next  |  Last
Pages: 1 2 3 4 5 6 7 8 9 10 11 12