I have a main form "Main" and a sub form "Sub" - the subform contains a list of relevant documents that I might want to associate with a record in...

MPS

04-27-2009 11:49 AM
paii, Ron

Is there a way to programatically determine if a database that is linked to Sharepoint is online or offline? I know that the status bar gives this...

Wayne

04-27-2009 03:19 AM
Wayne

Hello All, I searched for this here and the web - still in the dark....I may be asking the wrong questions I need to lock an access database after X...

flymo

04-26-2009 08:36 PM
flymo

I have created a basic table which has a tblID (Primary Key), Name (text) & Price (currency). I need the specific Price field to be linked with the...

John

04-26-2009 02:14 PM
John

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> wrote: I think I've noticed Jet TMP files in the temp folder but I sure could be...

Yitzak

04-26-2009 01:41 AM
Tony Toews [MVP]

Here's a weird request I just got. I need to program Access to create text files in a specific folder and put on extensions that are like . 000, the...

musicloverlch

04-26-2009 01:21 AM
CDMAPoster@FortuneJames.com

Hi all I once wrote about my problem "Could not update; currently...

jodleren

04-26-2009 12:34 AM
CDMAPoster@FortuneJames.com

Nowadays, many reporting tools claim that they are Excel-like, and they support Excel-like report design after improvements. Then, what is a real...

gaby

04-25-2009 02:10 PM
Larry Linson

Hi, I'm in the UK and at an early stage in learning the basics of database construction. I've been looking at some relational 'Contact' example files...

jaynebartram@googlemail.com

04-25-2009 02:51 AM
jaynebartram@googlemail.com

If I do an export from an A2007 database and save the export, it then becomes available under the "Saved Exports" button on the "External Data" tab...

Wayne

04-25-2009 01:47 AM
Wayne

Perfect! You have saved my life. Thanks! On Apr 24, 3:30*pm, fredg <fgutk... (AT) example (DOT) invalid> wrote:

musicloverlch

04-24-2009 04:49 PM
MGFoster

I need to use the ampersand in a title on my report, but it sees it as an operator even tho it's a label and not a data field. How do I make the &...

Rosy

04-24-2009 12:40 PM
Rosy

I have charts within forms selected by months and years i.e. April 2008 to September 2008 etc 6 monthly and 12 monthly charts. My boss would like a...

Elaine

04-24-2009 10:51 AM
Salad

I have a calculated field in a query - Rate: / If the fees are zero and the hours are zero I get an Error in that field. How can I have it return a...

Rosy

04-24-2009 07:59 AM
paii, Ron

I just imported a bunch of excel forms into an access database. The problem came when I hit txt fields in the middle of numeric data. Is there a way...

sparks

04-24-2009 03:41 AM
Mr.Frog.to.you@googlemail.com

I'm getting an error which I cannot explain. I'd be grateful if someone else would look at it and help me figure out what is going on. In a...

existential.philosophy@gmail.com

04-24-2009 12:07 AM
Salad

Hi, Is it possible to bring up the color picker using code in Access 2003 and return the RGB or color value? I'd like the user to be able to choose...

PW

04-23-2009 07:46 PM
PW

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 06: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 05: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 07: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 10: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 02: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 12:47 PM
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 02: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 06: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 02: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 09: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 09: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-21-2009 12:19 AM
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 08: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 05: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 11: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 10: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 10: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 09: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 08: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 08: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 06: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 11: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 11: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 03: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 02: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 09: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 06: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 02: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 09: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 03: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 06: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 06: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 06:07 PM
Tony Toews [MVP]