Anchoring a form to the top of the form when moving from page to p Hi there In my database, I have a main form and a subforms which consists of a tab control. When I navigate from page to page, my position on the page varies. Is there anyway to anchor it so that the form remains at the top instead of jumping all around the place? Thank you in advance. ... 6 Mar 2010 11:52
Free Entertainment! Hey I would like to announce that I have a site for free entertainment as in I host free entertainment. It get's updated about every week! http://redcars101.co.nr ... 6 Mar 2010 10:45
multiple column lookup My multiple lookup column displays 97203 15 12 when I want it to display 97203 C025 Portland The data for the lookup column is stored in another table in these columns primary key (autonumber) value 1 value 2 Thanks! I have tried everything I can think up----twice. ... 6 Mar 2010 14:05
Vista Security and Access 2007 I have Windows Vista Home Premium 64-bit running on my HP Pavilion dv-1183cl Notebook PC. I also am using MS 2007 Office. I have been looking for a Membership Database to keep track of a Shriners Club. In doing so, I have down-loaded MANY Access Databases. Each and everyone, when I install them have a "Table" ... 5 Mar 2010 19:38
Macro Setting I am setting up a macro and in it the is a "make a table" query that would require the user to click on "yes". Is there a way that popups don't appear and yes is the default? ... 5 Mar 2010 17:22
Linked Tables Twice? Hi all Currently we have an access 2000 backend database with front ends on access 2003 and 2007. I am looking at creating a database which references some of the tables in the original backend. Rather than risk disturbing this database I was considering creating another backend database with the original ta... 8 Mar 2010 05:20
Still confused on relationship queries and similating a vlooku Jerry, you made my day. I don't know why I couldn't put the puzzle pieces together. I was close but couldn't get past the idea of using a query for some reason. Thank you very much for your help. "Jerry Whittle" wrote: You can't put in the city names into your Main table (short of a lookup field whic... 4 Mar 2010 16:58
Search My Report Help I made a report from a table that is a list of files with their hyperlink, a description column, etc. I want to make a report that has a search button at the top, and can be searched by All columns or the few columns I have. I have tried to search for answers and am new to Access. Can someone give me a good ... 5 Mar 2010 11:42
DAO Recordset Issue The overall objective is to sort a recordset by clicking a command button at the top of the column. The following code is my coding effort and I can't even get past the basics. The strSQL creates the correct recordset (30 records) when I plug it into the SQL query window but it returns 30 identical copies of the f... 5 Mar 2010 09:26
Still confused on relationship queries and similating a vlookup Normally I would just dump this into excel, but the file that I am dealing with has over 1.5 million rows so excel can't stomach it. Here is what I have done. I have one table (MAIN) that is my main table. It contains all the raw data. I need to convert a city code to a city name. I have another table (CIT... 4 Mar 2010 14:41 |