General

Calculate % in one query : "Count some" divided by "Count All"
Hi I have a table of 5 columns whereby field values are either positive, negative or level. I've constructed a query whereby the results are then converted to either "P" for positive, "N" for negative or "L" for level. What I want to be able to do is count all of the "P"'s in say column one and then divide t... 10 Jul 2008 13:25

Form not opening as created
I have a form created from a table - it was created as a columnar type, however when I open it from a command button on another form it opens as datasheet. This causes a problem in that the command button that is on this form is not visible and therefore as I have hidden the close button and the min/max opti... 9 Jul 2008 02:26

Copy design in report
I have 10 groups, for example A,B,C,D,E,F,G,H,I,J. Also i have 10 quires to show each groups. I have made a report from quire A. My question is that is there any way to copy the same format in the report A to all other reports. ... 8 Jul 2008 08:59

Access records reverting to earlier data
We keep our mailing lists on Access. As far as I know the database was created using Access 2000, which was upgraded to 2003 after I came into post and we're now using 2007. Sometimes addresses will revert to earlier addresses. This was a problem for the previous admin worker as well so I've started trying to ... 11 Jul 2008 21:16

Cannot hold the screen image
I need some help with my processes. Here is an example of code I am using. Application.Echo False, "" DoCmd.SetWarnings False DoCmd.Hourglass True DoCmd.Close acForm, "frmNEWEMPLOYEE" ' qryCONTACTSFAMILYSAME DoCmd.OpenQuery "qryCONTACTSFAMILYSAME", acViewNormal, ... 8 Jul 2008 16:11

DEPACCO
Día luminosoGANA DINERO CON DEPACCO: -100Euros alregistrarte -10Euros por e-mail recibido y leido -5Euros por click -Dos niveles de referidos ¡¡¡ REGISTRATE YA EN!!!: www.depacco.com/pages/index.php?refid:agamenon ... 8 Jul 2008 08:59

How to convert All Caps to just Initial Caps?
-- The Padre ... 8 Jul 2008 08:59

Hide Database record display
Hello, This might be easy. I have a VBA form which has multiple recods. On the bottom left corner, there is display with 5 keys and a text box. It shows that i have 10 records out of 20 and I could cycle through them. How do I hide this display? I forgot what it is called. ... 8 Jul 2008 08:59

Recursive lookup in a table
Hi. Is it possible to create a field in a table that lookups to a different field in the same table? for example I have an Employees table with fields: ID Name Boss_ID and as you can imagine Boss is also an employee and Boss_ID is related to ID. Can I do that in MS Access? Another example: Contracts ta... 10 Jul 2008 14:27

Using string variable
Hi, I have a code like below: Private Sub Combo0_BeforeUpdate(Cancel As Integer) Dim A As String A = Combo0.Value Combo2.RowSourceType = "TABLE/QUERY" Combo2.RowSource = "SELECT" & A & "FROM TABLE1" --> not working End Sub Combo0 is showing field name list of table1. "A" is getting c... 8 Jul 2008 08:59