I have a database "Master Prog.AccDb" which sets a reference to another database "Menu.AccDb" - bit like the old Switchboard system....

Phil

01-18-2011 04:44 AM
Phil

Hi All, I am using UPDATE query from Excel to Access. I have 1000 rows with unique IDS ( same IDS in Access Database Table) I need to UPDATE for...

fi.or.jp.de

01-17-2011 06:53 PM
fi.or.jp.de

I'm looking for help in knowing the right questions to ask. Situation: Main Office accounting software data lives in a SQL Server database in...

Clif McIrvin

01-17-2011 10:39 AM
Clif McIrvin

I don't have a handle on A2010's web browser control. Obviously I'm missing something. 1) If I set the control source to http:/www.google.com it...

Salad

01-16-2011 05:19 PM
David-W-Fenton

Hi I have a access database which has been working for a number of years on a single computer. I have just put it on a network - 1 machine has fe/be...

David B

01-16-2011 05:07 PM
David-W-Fenton

HI All, I hope I explain this correctly............... I have a dual monitor workspace I open my Access XP application and it opens on my...

bobh

01-16-2011 04:19 PM
bobh

What are the things I need to watch for? I know about linked table subdata sheet properties and Sandboxing mode and making sure to run Jet 4.0 SP8...

Ryan

01-15-2011 12:23 PM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

When I use the scroll bar in the Navigation pane, the scroll refuses to stop at the selected item, but instead moves several lines away. I've seen...

Bob Darlington

01-15-2011 07:09 AM
Phil

Hello; We are using a Zebra TLP 2844 printer. The Access application executes the print job (user selects a button to run the print). Sometimes...

Tony_E

01-13-2011 09:56 PM
Arvin Meyer

Hello... I have a database where the customer name, address, ID, etc. is unique, however they can be related to several different tables. For...

Trish

01-13-2011 02:40 PM
Salad

Hi All, I have this group by query(sql code below) that I want to change so that it returns the Top 5 CountOfQuestion for each LOB, I've...

bobh

01-13-2011 10:31 AM
bobh

Once again, I turn to the masters for help that I thought I ought to know by now. I have tblAttendees and tblGuests. tblGuests has a field...

WhathaveIdone?

01-12-2011 08:27 AM
John Spencer

I hope I can word this so that you can understand. I am using Access 2007 and I have a simple query that returns the following results: User_ID ...

mpdsal

01-12-2011 07:42 AM
Bob Barrows

Got a screen where, AFIK, a control's .ForeColor is black. But it is rendering as grey. I've removed all the custom formatting, but grey...

(PeteCresswell)

01-12-2011 02:03 AM
Tony Toews

I am about to re-start a project originallly written in AK2 and now to be written in Access 2010. The original project was abandoned partrially...

Phil

01-11-2011 07:06 PM
Phil

I need to use the following query to fill a subform in Access and I want to to limit the records returned to the latest 'version_no'. It was all...

FireyColin

01-11-2011 09:47 AM
Bob Barrows

I am trying to get an event to work so that when a user hits a toggle button, there are 5 toggle buttons in a frame a unique value list is populated...

flebber

01-09-2011 11:18 AM
Marshall Barton

Access 2010. I'm trying to use command buttons as filled shapes (rectangles with rounded corners) on one of my screens, since the rectangle control...

Bob Darlington

01-09-2011 05:08 AM
Bob Darlington

Hi, I'm relatively new when using Access so bear with me. I have an Excel file with 4 spreadsheets, each with multiple...

Meaney

01-08-2011 05:38 AM
AB

if seems that this event is triggered when undo'ing the contents of a form, but before the data is undone simplified example, if I have txtA with a...

Roger

01-07-2011 06:35 PM
Roger

I've got a small access front end I've written that takes data out of our local SQL Server 2008 production database and stores it in some temporary...

Ryan

01-05-2011 01:18 PM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

Hi, In Access 2003, I want to make a form where I can pick a table in a combobox and list all of the fields (or perhaps just some) from it. I have...

PW

01-03-2011 10:05 PM
David-W-Fenton

I have a query which filters defects by a system code. The collation of defects by system is achieved by setting a system variable using a form so...

bezz

01-03-2011 04:29 PM
bezz

Have a client having problems with a fairly complex Access system which is split into front end and back end. Using access 2003/mdb format with...

Bob Alston

01-03-2011 07:25 AM
a a r o n _ k e m p f

Dear All, Is it possible to disable deleting records in a table or query ? Filip

Filips Benoit

01-03-2011 07:20 AM
a a r o n _ k e m p f

I'd try comp.databases.sql-server but it looks like a SPAM factory there... I added 3 new fields to a SQL table. I can edit data in SQL Server just...

ManningFan

01-03-2011 07:18 AM
a a r o n _ k e m p f

If you're like me (a long-time Access developer who doesn't do ADPs), you've basically ignored SQL92 Mode in Access. If you're unaware of its...

David-W-Fenton

01-03-2011 07:18 AM
a a r o n _ k e m p f

occasionally I get the error message Could not update; currently locked. ,DAO.QueryDef ,3218 strsql = "SELECT * FROM qryPurOpenList WHERE 1 = 2" Set...

Roger

01-03-2011 07:15 AM
a a r o n _ k e m p f

Hi All, I have been using the command below to open outlook 2003 (Version 11.8325.8329 SP3), attach a snapshot report, input the Mail address and...

Barry Edmund Wright

01-03-2011 07:12 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

Our application is an Access 2003 MDE (split database). They have Access 2007 installed on their PC. Any ideas? -paulw

PW

01-03-2011 07:10 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

wow.. why would anyone use mySQL with Access? SQL Server is _SOOOOOO_ much better.. and it integrates with Access-- it's much easier to use Access...

a a r o n . k e m p f @gmail.com [MCITP: DBA]

01-03-2011 07:06 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

periodically, the following fails when assigning qdf.sql, with "3167 Record is deleted." Dim qdf As DAO.QueryDef Set qdf =...

Roger

01-03-2011 07:05 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

On several of my software package installations, built using Access 03, the reports do not print in color, but end up being black and white. Any...

JohnP

01-03-2011 07:05 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

Hi All, I open a word document and preform a search and replace using VBA in MS Access everything works great. However, now I want to put a...

Barry Edmund Wright

01-03-2011 07:03 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

I've got a 2nd MDB with a table (tblPersonalInfo) and I'm trying to create a linked table strsql is the path to that mdb this works Set db =...

Roger

01-03-2011 07:02 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

I am still having trouble with the complicated SQL statement that I posted a few days ago. I need to add a further criterion which is the field...

FireyColin

01-03-2011 07:01 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

Using Access 2007 SP2. I am using ODBC linked tables and passthrough queries (dsn-less) connected to an SQL Server 2008 R2 Express database. When a...

agiamb

01-03-2011 07:00 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

I just use SQL Server Reporting Services subscriptions to send emails.. it's 100 times more powerful than Access.

a a r o n . k e m p f @gmail.com [MCITP: DBA]

01-03-2011 06:59 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

Hi Everyone, I am playing with a db design at the moment and an idea has occurred to me that I would like to ask for advice / ideas on. The db is...

The Frog

01-03-2011 06:56 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

Larry, that is sound advice indeed. Copyright and IP is a tricky area from what little I do understand. I met a lawyer once who specialised in only...

PW

01-03-2011 06:54 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

Hi, I have have an Access 2003 application with Sql Express as back end. After migrating the front end to Access 2007, users have a...

PatdeLux

01-03-2011 06:52 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

I have a potential need to use integer numbers up to 17 digits long. Access03 that I currently use can go up to 10 digits (32 bit restriction). I am...

JohnP

01-02-2011 04:51 PM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

I have a project where one of my reports is a terms and conditions statement that is three pages long. To make that report I'm using the maximum...

rbergman@bellsouth.net

12-31-2010 06:17 PM
Arvin Meyer

I have no idea if this is possibe. Suppose I have 2 separate front end databases called AFe.accdb and BFe, both with respective back end databases...

Phil

12-30-2010 03:07 PM
Tony Toews

Hi and Season greeting to All At home I use 2007, yet at work, they use 2003. I have a very functional app that I put together at home, yet! when...

NoodNutt

12-30-2010 05:06 AM
NoodNutt

Function ShowUserRosterMultipleUsers() 'Source: kb 198755. Dim cn As New ADODB.Connection 'Dim cn2 As New ADODB.Connection Dim rs As New...

elg

12-27-2010 05:44 PM
bsn

Dear All, In the form's header section I have an unbound combo box which format is like, @;"(Quick Find)" but combo box remain blank,my combo box...

Shakeel

12-27-2010 10:55 AM
Nance

Hi All, On AccessXP I was adding a graph object to an Access report and when I double-clicked on it to put it in 'edit' mode I got a pop-up which...

bobh

12-25-2010 12:22 PM
Tom van Stiphout

Hi, I have a subform that holds a treeview. Sometimes the user needs to hide the subform. Since it collapses to the left I replace that subform with...

christianlott1@yahoo.com

12-25-2010 12:20 PM
Tom van Stiphout

I want to provide a button to permit users to open a copy of Word or Excel from within my application. I'm using: Function OpenOfficeApp(vApp As...

Bob Darlington

12-22-2010 02:28 PM
James A. Fortune