I have an unbound form that displays all the days of the year as a calendar. It has 12 rows of text boxes with either 29,30 or 31 in each row. Text...

Jim Devenish

11-12-2007 05:38 PM
OldPro

Hello all, I have an annoyance that is common to all of the Access 2003 applications I manage. All of the applications are split front end/ back...

Bruce

11-12-2007 03:52 PM
Jim Devenish

Hi All, I have a requirement where I have to read the data in a text file.This has several rows and columns.I want to transpose data from...

Roy

11-12-2007 03:12 PM
Roy

Hi All, I'm using A2K and need to print a specific pre-printed form. I know that once I have that report on a particular computer screen I can...

Ron

11-12-2007 01:44 PM
lyle

Sometimes before clicking "Post" I copy my message, open Word and paste. Word is excellent, and can suggest synonyms and translations. But it takes a...

lyle

11-12-2007 12:48 PM
rumkus@hotmail.com

i have only owner name and pid of a access database. can i create .mdw file and open database using that. if i can please tell me tha way. please,...

gihan chamara

11-12-2007 10:39 AM
Keith Wilby

Thanks a lot Stuart for your message. I could read the data from text file, the problem was appearing when I had unicode characters (languages other...

Chris

11-12-2007 05:57 AM
Chris

We have window for login/password and then error "Process is stopped by database core Microsoft Jet, another user changing data at the same time".

MLH

11-11-2007 07:59 AM
MLH

I'm moving Access2000/2003 apps into Access2007 running on XPpro Dells. I've found where to lower the macro security and with a tweak to references...

Rick

11-10-2007 11:09 PM
Rick Brandt

Well for most it is a method of playing the game and working out how to make money by developing skills that can earn good amounts of Runescape money...

koerggkpww0023@gmail.com

11-10-2007 09:36 PM
koerggkpww0023@gmail.com

Hi Everyone, I have a table which has many fields in it but I need to pull some specific info via a query and I don't know if it's possible. I want...

scott

11-10-2007 06:56 PM
Smartin

Hi All, I've got a client/transaction type of database where tblClient is linked to tblTransactions via ClientID. The client table contains all...

Ron

11-10-2007 05:16 PM
Smartin

Is it the rule that any table that you want to use via ODBC must be a UNIQUE record? And if you want any speed associated with the table it should...

Salad

11-10-2007 04:26 PM
Chuck Grimsby

Hello, Hope everyone is well :-) Any help would be very much appreciated......what I want to do is use the IE 6/7 object model from within VBA (MS...

Get started with Google Groups

11-10-2007 03:52 PM
Get started with Google Groups

The table wizard does not give you an option to select a Big Integer field type when creating a table with the wizard. Can it be done another...

MLH

11-10-2007 11:08 AM
MLH

When looping through all controls on a form in code, is it possible to determine what section a control belongs to? I want to skip controls in...

Phil Reynolds

11-10-2007 10:17 AM
Stuart McCall

Set rstTemp = .OpenRecordset(dbOpenSnapshot) Execution of the above line gives me a "Too few parameters" error. The line is preceeded by another...

MLH

11-10-2007 09:58 AM
Bob Quintal

I have a form that has its own custom menu bar in Access 2000. I'd like to make a copy of the menu bar and use it with another form. How can I do...

Neil

11-10-2007 07:20 AM
Neil

Hi Using access 2007 in MDE All tabbed forms opened as maxmised with no restore or minimised buton. A lot of my forms look really ugly if maximised....

Alfred

11-10-2007 06:06 AM
Anthos

Hi I'm using automation with winword to search and replace text in a word document. The word document is a letter with text such as...

google@webedi.co.uk

11-10-2007 05:10 AM
Bob Quintal

Hiya folks, I'm trying to put together a database for student involvement in school sport activities. I'm not exactly what you'd call "proficent" in...

David Fairbrother

11-10-2007 03:39 AM
David Fairbrother

is there a way to group records in forms in 2003 version ie. i have number of records with date and would like to see it in this way on a form sep...

nina

11-10-2007 02:29 AM
JHB

I just got a heads up about these guys. I think this will really interest you so I thought I would share it with you! Here is what they have to...

rbyrsumvkatqdmdia3up@gmail.com

11-09-2007 10:43 PM
rbyrsumvkatqdmdia3up@gmail.com

it is easy to go to the database window to double click on a table and open it. it is also possible to import or link tables of a secured database...

fredloh@gmail.com

11-09-2007 06:24 PM
Kitform

Hi, I tried to post the following in the Access Team Blog (twice) but didn't see it posted. I don't know if it was because it is long or because the...

gdpz@walla.co.il

11-09-2007 06:02 PM
gdpz@walla.co.il

This is driving me nuts. Can anyone help? I have a program which searches for and analyses Access databases across a corporate network. At one point...

Michael Scott

11-09-2007 04:22 PM
heifler via AccessMonster.com

Hi In Access 2007 (the MDE) The taskbar displays Powered by Microsoft Access. How can I remove it Thanks Alfred

Alfred

11-09-2007 03:32 PM
ARC

Problem Description: I have a large form called Reports Menu that lists several reports that can be viewed or printed. Printing works fine. When I...

David Grist

11-09-2007 02:59 PM
David Grist

Hi, Is there a way to have a union query (2 tables) in an other query then join a third table having the ability to edit records in the...

cashotte

11-09-2007 01:51 PM
Technolust

Hi, I have a database that contains a table with an administration area and a number associated with the "count" of a certain characteristic of that...

KevinC

11-09-2007 12:48 PM
Jana

I have table Workstations with fields WorkstationID (autonum PK) and WorkstationName (text). I also have table ProductOperation with WorkstationID...

tbrogdon@gmail.com

11-09-2007 12:40 PM
tbrogdon@gmail.com

Hi all, how can I execute a large amount of DDL Queries on Access 2000? I've a DDl/SQL Script file which defines a data structure with CREATE TABLE,...

Ale

11-09-2007 10:13 AM
lyle

I'm trying to automate an Excel spreadsheet from Access. I've established a link and loaded data from a recordset onto a worksheet in Excel. I now...

oliver james

11-09-2007 05:17 AM
oliver james

Why do I get this error when I run this code from a report's open event? strSQL = "Select * from qsrptCaveat" If Forms!fdlgPrint!chkInclude = False...

Keith Wilby

11-09-2007 03:56 AM
Keith Wilby

I have created an append query that pulls information from one database, and will append the selected information into a new table. The fields are...

Barb.Richards@gmail.com

11-08-2007 11:34 PM
Barb.Richards@gmail.com

Hi, i'am using an ac2K progrom which sends automaticle emails with an attachment. Since last week , a error occurs with number 2293. Our mail...

pat

11-08-2007 11:23 PM
Salad

Why does my combo box list the ID value rather than the Name? I have tblWorkstation w/ WorkstationID (PK - autonumber) WorkstationName I have...

tbrogdon@gmail.com

11-08-2007 11:01 PM
tbrogdon@gmail.com

Hi, I was wondering if anyone can help. I am stuck and how exhausted all avenues. I have downloaded Allen Brownes sample of the FindAsUType utility....

Jo Nolan

11-08-2007 08:48 PM
Allen Browne

I have a access 2003 database table with a Yes/No field called Flag. When the user is in the database, they check the field in order to flag that...

LFM

11-08-2007 07:41 PM
LFM

In a newly converted database (ACCDB from A97 MDB) I'm seeing the following behavior. In the query design grid (of existing or of newly created...

Gary

11-08-2007 04:50 PM
Gary

Hi All, I'm looking for help with what the Transact SQL code is for this Access Update query sql code. I've been doing Access for some time and all...

bobh

11-08-2007 04:21 PM
bobh

This is driving me nuts. Can anyone help? I have a program which searches for and analyses Access databases across a corporate network. At one point...

Michael Scott

11-08-2007 03:44 PM
Michael Scott

I created an aging query using the partition function my query works but it is showing all Zeros. I would like to remove all zeros and only get...

sergia.dupoux@gmail.com

11-08-2007 03:25 PM
Larry Linson

Is it possible to actually launch an Excel document embedded within Access? I want it to open up in Excel, not in an Access form. It's a very large...

wilsoch@iwon.com

11-08-2007 03:06 PM
wilsoch@iwon.com

Hello I am looking to buy a contact management program in Access that is similar to ACT! so I can customize it for my company. has anybody hear seen...

kasparov11

11-08-2007 03:00 PM
kasparov11

Hello, I have a pop-up form that is used to enter data on a form that is already open. My difficulty is that any of several forms might call this...

Dave

11-08-2007 02:46 PM
Ron2006

I have a table that I had split into 2 tables (for various reasons). The problem is, I've seen a few instances of customers databases where it's...

ARC

11-08-2007 02:17 PM
ARC

I have a SQL 2005 box serving up data to an Access application. One of the users prefers to go into the table to enter certain repetitive data. The...

TS

11-08-2007 02:13 PM
TS

We have a TON of access databases on our servers. after 10 yrs a person went in and wiped about 50 files in one. ALL hell broke loose. A few...

sparks

11-08-2007 12:55 PM
sparks

Hi is it posible to check if another database is open? i have several datasbase the first is a dbase where the local data is maintained on closing...

kevcar40

11-08-2007 12:10 PM
lyle fairfield