This has to be simple but I can't find the answer. Access 2007 - when adding a tab control to a form it always defaults to a grey background. I can...

fiona.fenton@ntlworld.com

04-23-2009 05:36 PM
Salad

Hi, I'm new to Access and databases in general but am quite Excel literate - which I'm not sure is a help or hindrance with this. I need to convert...

rubiocollins@gmail.com

04-23-2009 04:23 PM
Phil Stanton

Currently I am working on a project that at one time required defaulting all relationship constraints in a sql-server database to "cascade delete". I...

lyle fairfield

04-23-2009 06:03 AM
lyle fairfield

I am using the SendObject method in Access2007 to email and internet- fax documents. I use the SaveAsPDF add-on to create a PDF attachment to send. I...

Lou O

04-22-2009 09:47 PM
Lou O

Hi, I don't understand why my form does not allow me to add new records (The asterisk icon (*) near the navigation buttons on my form). Thanks for...

zufie

04-22-2009 01:25 PM
Salad

I am trying to apply a filter to a subset of records via a macro. The macro calls the filter for current year records and previous year records...

Mike

04-22-2009 11:47 AM
Mike

Is it possible to publish a database table to Office Live and then link to it from Access 2007? I have found a tutorial...

Wayne

04-22-2009 01:06 AM
Tony Toews [MVP]

I am working on a project where I have specifications for a database table that are in Excel. I need to create this table in MS Access but there are...

saner.junk@gmail.com

04-21-2009 05:03 PM
Salad

Hi all, I made a very nice looking report for one of my clients, and he now asks me to put an arrow in the report header. I agree it would make...

HS Hartkamp

04-21-2009 01:16 PM
Larry Linson

I have a weird problem, I have a bunch of Back End mdb files that are set to replenish local tables from an Oracle source. On some of these files,...

lukethegooner

04-21-2009 08:28 AM
Builder

Hi everyone, I've developed a database for several users where I work. I have the full fledged version of access, however the users seem to only...

DeZZar

04-21-2009 08:26 AM
Builder

Hi all, I have an excel spreadsheet that is linked to an access query. The query returns daily revenue info (claim#, product, trade date...

jovi07@verizon.net

04-20-2009 11:19 PM
jovi07@verizon.net

Hello Accessarians, I've have had constant hell-slow performance in design view for a long time in Access 2007 with Vista x64. I'm talking about 5...

elias

04-20-2009 07:38 PM
Tony Toews [MVP]

Hi! I have created some MS Access applications (Forms) that use linked tables on a SQL server. The problem is that when I originally linked the...

Dave Moore

04-20-2009 04:12 PM
MGFoster

Is there any to run (but not display) a query when you make a change to a form? I've got a system now that is tracking backup jobs in our...

chickenfriedsteak

04-20-2009 10:45 AM
Salad

I've included a "where condition" in my report and it works !! What I'd like to know is that if the "where condition" is NOT satisfied, I've set the...

prakashwadhwani@gmail.com

04-20-2009 09:28 AM
Keith Wilby

Hi to everyone, I need to make a list of members / employers, so I would like that every employer has his own data which I can easily access....

Ozzie

04-20-2009 09:16 AM
Salad

I'm trying to generate an Age Analysis Report where the foll SQL statement will executed be in a loop for each customer. Can someone please correct...

prakashwadhwani@gmail.com

04-20-2009 08:07 AM
prakashwadhwani@gmail.com

But I'm checking here first to seek recommendations on commercial solutions & add-in's compatible with A97? Suggestions anyone?

MLH

04-20-2009 07:23 AM
MLH

I have a function that returns the date, X number of work days after a given date. 3 work days after 2/5/2009 would be 2/10/2009 The part of the...

paii, Ron

04-20-2009 07:12 AM
paii, Ron

Application.Modules do sometimes not know all modules. I am going to make a find utility that can be used programmatically to clean in code and...

Benny Andersen

04-19-2009 05:14 PM
Benny Andersen

I'd like to allow a user to select several non-contiguous rows in a datasheet form and then click a button to delete these records from a table, or...

freddy007

04-18-2009 10:04 PM
tina

I am losing my mind! I've been away from Access for several months and a friend just asked for some help. I can't get it! She wants to 1. Choose...

sara

04-18-2009 10:03 PM
saraqpost@yahoo.com

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: I think the biggest reasons is the lack of referential integrity. That just...

Don Leverton

04-18-2009 02:35 PM
Tony Toews [MVP]

Hi! I'm trying to create a form that allows the user to print a report based on an identifier that they enter. I created a form with a text box tied...

Dave Moore

04-17-2009 01:55 PM
Salad

Hello fellow Access 2003 users, is there a way to provide a date (for example, 1/2/09) and then via code, create the following...

nospam@nospam.nospam

04-17-2009 08:54 AM
nospam@nospam.nospam

hello, i am trying to create a sales report with month column headers... i can get the data to look right by viewing the datasheet as a pivot...

bipin

04-16-2009 05:00 PM
Phil Stanton

I adopted a ranking approach which I found here (http:// allenbrowne.com/ranking.html) However, I am doing rankings by product and by working week....

Astley Le Jasper

04-16-2009 01:06 PM
Salad

I have a ton of strings I am parsing out and the only problem I have is knowing whats a date and whats a special chr in a text field. ##/##/## is a...

sparks

04-16-2009 08:41 AM
sparks

Hi We have some some systems, which save a lot of detailed/temporary data to an access table (some ~10 tables in a file), and 3-4 tables are heavily...

jodleren

04-16-2009 02:13 AM
jodleren

I'm using information that I found in KB Article Q158938 to set the Y axis of charts with code based on stored values. The code I'm...

Wayne

04-15-2009 05:37 PM
Wayne

Am trying to use the following in declarations section of form module. Of course, it won't compile. What's the best way to set my constants inside...

MLH

04-15-2009 05:08 PM
Tony Toews [MVP]

On Apr 12, 9:38*am, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid> wrote: Don't know how you reached that conclusion David, but you...

Wayne

04-15-2009 05:07 PM
Tony Toews [MVP]

Hi, I'm having some trouble using images and their hyperlinks to open files. Any help would be really appreciated. I'm using Access 2003. I have...

franc sutherland

04-15-2009 04:55 PM
franc sutherland

Is there any way to have the same Water Mark on all reports? One solution may be to put the same background on each report, but, I would like to...

squeezebot

04-15-2009 02:36 AM
squeezebot

I haven't done text messaging on my cell phone. I'll see things on TV like "Send a text message to the show. Enter #12345 from your cell phone..."...

Salad

04-15-2009 12:29 AM
Tom van Stiphout

Hi, In advance: I'm using the Dutch version of Access 2003 so I'm not sure I'm using all the proper discriptions. Anyway... I have a variable which...

susan

04-14-2009 03:49 PM
MGFoster

Hi All, I'm upgrading from Access 2.0 to Access 2003. I'm unable to convert the workgroup security file System.mda (Access 2.0) to System.mdw...

Mourad

04-14-2009 12:17 PM
Mourad

Hello I have Microsoft Office 2000 Developer Edition. I mainly work with Access 2000 to create Access runtime solutions for distribution to many...

G Gerard

04-14-2009 10:04 AM
Tim Mills-Groninger

Hi, I use Access 2003 VBA. I cannot find the documentation relating to transactions in ADO. Is it identical to those in DAO? If not, where can we...

Marcel Nihon

04-14-2009 07:38 AM
lyle fairfield

Hi, I have been trying to Create a Data Entry Form From a Query as I need to feed values into two (2) respective tables. Is this possible? Any...

zufie

04-13-2009 02:26 PM
rkc

This is kind of hard to explain, but here goes... I've got an Access 2007 project front end with SQL 2005 backend. I've got a table that contains...

prime80

04-13-2009 10:51 AM
J Warner

6:05 PM 3/20/2009 Records are not saved after Paste Senario: Microsoft Access 2003, Windows XP SP3 Copying data from an Excel...

squeezebot

04-12-2009 01:29 AM
squeezebot

Windows XP SP3 / Access 2003 SP2 Using the API (this is my function referring to the API) ShowWindow Application.hWndAccessApp,...

squeezebot

04-12-2009 01:29 AM
squeezebot

Not sure if I'm just missing something relatively simple. Have a table as below which has it's primary key as ProvID, Location ID ProvID ...

veaux@aol.com

04-10-2009 09:09 PM
MGFoster

Using A2003, if I select Microsoft Access Help from the Help menu from the database window and type "Methods", I get a list of methods. However, when...

Salad

04-10-2009 02:37 PM
Salad

Hi, Just getting my feet wet with Access 2007 (Trial version) this weekend. I downloaded the Contacts Database, and noticed the "Map it" button,...

Don Leverton

04-10-2009 02:33 PM
Larry Linson

I want to build a string from results of a SQL SELECT statement. This string would be used for an IN clause in a subsequent SQL query. How do I...

troy_lee@comcast.net

04-10-2009 11:06 AM
MGFoster

Hi, I want to automatticly display all thr names of the queris in my db in a listbox on a form. Is this possible? Thanks, Susan

susan

04-10-2009 10:41 AM
MGFoster

There is code in the SECFAQ but it only works if the user is a member of the Admins group. That will not work for me. I need to check what group...

PW

04-09-2009 06:21 PM
PW