I don't have A2010 yet. In Access we might have an app that presents a record and we want to generate at document from it. With mailmerge we can do...

Salad

07-21-2010 12:00 PM
Salad

I have a split 2003 app. When the BE is in use by one or more of the users' FE, I can't manually open the BE.mdb. When I doubleclick, nothing...

Lars Brownies

07-21-2010 11:38 AM
paii, Ron

Hi everyone, I have a subreport that needs to stay a specific size and I'm using it to display a single field that (County Name) that can have 1 or...

DeanL

07-21-2010 11:11 AM
DeanL

I am working on another verion of the last database I was trying to help with. It is access 2007 I look at the list of tables/forms/queries on the...

sparks

07-21-2010 10:17 AM
sparks

Hi Everyone, I have a seemingly strange situation where one query runs perfectly, and a copy of the query with an altered 'where' type condition...

The Frog

07-21-2010 07:14 AM
Bob Barrows

I would like to format a field to contain seven characters. For instance 37593 would be 0037593. Is there an easy way to do this through the format...

Terry Carroll

07-20-2010 11:40 PM
Marshall Barton

I am converting a Access97 front end to Acess2010, the back end is Access97. I get the following error when attempting to add a record to one of...

paii, Ron

07-20-2010 01:50 PM
paii, Ron

I have an update query which updates fields in two tables. The query is fired from an input form but when the command button is activated the query...

Steve_s

07-20-2010 01:19 PM
Steve_s

I don't have A2010, just asking a question. Let's say you hae a table; CustID, Customer, City, State, Zip and an input for do display or enter data....

Salad

07-20-2010 12:53 PM
David W. Fenton

I have a form that lists several records in a row. I want to be able to click a checkmark and autopopulate specific fields with preset data based on...

Erik

07-20-2010 08:12 AM
John Spencer

Dear Access experts, I have no experience writing ADO or DAO code but I am going to start soon. After reading up on ADO and DAO, it seems both can...

klar

07-19-2010 09:06 PM
klar

I am using Access 2003 and want to have a query return results based on the value a text box in a hidden form. Depending on the value in the text box...

Vet Tech

07-19-2010 04:33 PM
Vet Tech

Thanks in advance, expert advisers!!! I have a query that I run a report from which returns all records that have a 'Renew by Date' in the last 365...

Robert Jacobs

07-19-2010 04:28 PM
Marshall Barton

Hi folks, thought I'd throw one more post on the heap of complicated form/subform event woes here at CDMA. My setup is this: I have an unbound form...

downwitch

07-19-2010 02:44 PM
Marshall Barton

I have created a scope of work report which uses 4 sub reports to display reference numbers for defects, change requests etc. in multiple...

divventknaa

07-19-2010 01:27 PM
divventknaa

First off, thank you any experts who have the answer to my final question! I'm almost done with this thing! My database holds all of our assets,...

Robert Jacobs

07-19-2010 10:10 AM
Robert Jacobs

I have been developing in Access for many years and I am now looking to formalise the support I offer my clients. The problem is that the phone never...

Paul H

07-19-2010 03:10 AM
Paul H

I have created a scope of work report which uses 4 sub reports to display reference numbers for defects, change requests etc. in multiple...

divventknaa

07-18-2010 07:53 PM
Salad

There are more complicated ways to address this problem, but compacting the data file worked for my 2007. I was getting it on an update query. (Note...

pemigh

07-17-2010 07:57 PM
Arvin Meyer

I am running a sort of plan on a page which covers several elements, Defects, Config Chane Requests etc. which will have an associated query with...

divventknaa

07-17-2010 03:12 PM
Marshall Barton

I'm trying to do something I normally don't do, and that's allow the addition of records in a continuous form. The form is bound to the join table...

David W. Fenton

07-17-2010 03:08 PM
David W. Fenton

I cannot output a table in Access 2003 or Access 2007 as a step in a macro in a comma seperated file format. The option is not there. I converted...

Matt Perfetti

07-16-2010 06:46 PM
Access Developer

I have an Access database that stores product data that I use to publish a print catalog and run a website. Everything currently works okay where I...

Steve P.

07-16-2010 11:40 AM
Steve P.

Karl <karl3200 (AT) gmail (DOT) com> wrote in news:47b29e08-0dae-4900-8936-f3c7c84cade7 (AT) w12g2000yqj (DOT) googlegroups.co m: With a website?...

JeffP

07-15-2010 07:09 PM
David W. Fenton

I have an application in Access 2003 which opens MS Word document files using Automation. I now need to be able to open those docs as read-only for...

Dave G @ K2

07-15-2010 04:38 PM
Mark Andrews

I have a totals query that is giving me incorrect results. The query is SELECT ForeignID, Last(StatusID) AS LastStatus, Last(StartTime)...

Salad

07-15-2010 08:50 AM
John Spencer

I have an unbound field on a continuous form that i would like to use the "right click" filter features on. for some reason the fields that are...

fishqqq@hotmail.com

07-15-2010 08:41 AM
fishqqq@hotmail.com

I am using a disconnected ADO recordset that I bind to my form in Access using VBA. I am able to edit existing records, but deleting them is causing...

billy_tech

07-14-2010 03:30 AM
billy_tech

I have a table with an address field. The data in this field for example is 1234 Main St.; 1234 Main Street. I want the data to be consistent,...

Kissi Asiedu

07-13-2010 02:44 PM
Bob Alston

I have a mde database file developed for a client. This was originally set up and run in Access 2003. Everything worked fine. Recently this client...

clk

07-13-2010 02:04 PM
clk

I'm not sure if anyone has a definitive answer on this, but thought I would ask. If I establish a centrally located workgroup file on a network...

Vincent

07-13-2010 04:05 AM
The Frog

I have problem with one of my A2003 databases. I'm getting strange behaviour when I type in a module. For example if I type 'dim x as string' this...

Dave G @ K2

07-12-2010 02:40 PM
David W. Fenton

We have an Access 2003 database that handles Contacts and Events for the organization. This is used by everyone in the organization - across all...

Vet Tech

07-12-2010 12:56 PM
Vet Tech

I have 2 computers, both windows 7 & both Access2010. On the slower machine the code below works and creates an AccDe correctly, but it doesn't work...

Phil

07-11-2010 04:42 PM
Phil

Thanks for replying again, Salad. I accept what you are saying. Using your suggestion, what would I do if the customer had 3 outstanding invoices...

BobbyDazzler

07-09-2010 10:21 PM
Salad

Again we have an access 2007 database and they want me to convert it to 2003. Like before the person put in everything neet and cool she could...

sparks

07-09-2010 08:03 PM
sparks

How do I get past this problem, where I want to place a variable where it's expecting the exact name: strTable = "Query1" Set rs =...

christianlott1@yahoo.com

07-09-2010 07:18 PM
David W. Fenton

I've got an Access 2007 table with a field called Zip which is a text field. Some zips were entered like "67203" and others like "67203-2752". Is...

emanning

07-09-2010 07:12 PM
David W. Fenton

Here's the story: I had an mdb (2003) with permissions setup (security1.mdw). I needed to make changes and since the original was bloated, I created...

christianlott1@yahoo.com

07-09-2010 02:20 PM
christianlott1@yahoo.com

So simple, yet so puzzling. Searches have turned up nothing useful, so I hope someone here can provide some insights. This SQL statement: cJEnq =...

Neil Gould

07-09-2010 01:33 PM
Neil Gould

Hi, I'm working w/ data like this: parent: 1061001 child: 810 parent: 1061002 parent: 1067303 child: 809 parent: 1068201

christianlott1@yahoo.com

07-09-2010 12:07 PM
christianlott1@yahoo.com

I've just taken over a klunky but functional application for a new client. They are running Access 2000. It's a BE-FE system, no security features,...

freddy007

07-08-2010 05:02 PM
freddy007

I’m trying to make a conditional macro that will check a table to make sure there isn’t already a record with the same ID and Entry #. If there is a...

Craig

07-08-2010 02:46 PM
Salad

I would like to do a search feature similar to what Google has done. When the user types in the initial letters of a keyword, Google...

klar

07-08-2010 06:06 AM
klar

Hi All I'm running into a problem I've not encountered before and was wondering if anyone else has. In a split Database after running a standard...

Jon Lewis

07-08-2010 05:04 AM
Jon Lewis

I’m creating a query that is going to go through and look for various impossible data entries. What I would like to do is use an IIF statement and...

Craig

07-07-2010 10:21 AM
Salad

Hi all I have, over the past few years, been developing a datase for a client in MS Access. The time is now approaching, however, when we will...

Andrew

07-07-2010 10:12 AM
Andrew

Hi, I have a form with a text box and a subform. Main form is unbound. SubForm is displaying records from a query. I would like to the user to be...

Dragon

07-07-2010 10:03 AM
Salad

I created a form, added a combobox to it and want the combobox to be populated by values from two different tables. For the rowsource property of...

g

07-06-2010 05:49 PM
David W. Fenton

For source code browsing of software written in C, java, C++, there are convenient and free source code browsing tools like source navigator. This...

Lay

07-06-2010 03:48 PM
Tony Toews