I figured that people like Albert Kallal were the beta testers of Office 2010 but it appears there's going to be a "public beta" whatever that is. ...

Salad

11-16-2009 12:06 PM
Salad

The method of producing light.{NOOR} NO MATTER ANY RELIGION - ALLAH(GOD) IS FOR EVERY ONE. In prehistoric times stones would be rubbed together to...

fahad sarfaraz

11-15-2009 05:12 AM
fahad sarfaraz

I am using the following line to export a select query to excel DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "qryJobSpareExport",...

paii, Ron

11-14-2009 08:41 PM
Tony Toews [MVP]

"James A. Fortune" <CDMAPoster (AT) FortuneJames (DOT) com> wrote: I wouldn't call Albert an extol troll. I've met Albert a number of times. Yes,...

Bob Alston

11-14-2009 04:10 PM
Tony Toews [MVP]

Hi all I'm importing a txt-file to an SQL-server db via Access (linked files). I therefore use ado, with of course the addnew method of a recordset...

Daedalus

11-13-2009 02:43 AM
The Frog

I have an autonumber field to generate a REF. I need to copy my table because of problem but when I do this I loose my auto-number ref, how can I...

Paul

11-13-2009 02:22 AM
hbinc

Hi, I’m using access 2007. I would like to use one of my reports as the body of an outlook 2007 email message. I’m able to export the report as an...

Dummy

11-12-2009 11:46 PM
Tom van Stiphout

I have this pretty big dataset and output 70+ csvs to a charting program twice a year ... be lovely to loop through the dataset to output my text...

Jeff

11-12-2009 06:25 PM
Chuck Grimsby

Something to amuse you regarding Office 2010...Office 2010: The Movie http://www.youtube.com/watch?v=VUawhjxLS2I

Salad

11-11-2009 08:58 PM
Salad

I have tried several things but am not able to blank out the rowsource of a sub-form when the form closes. Please help. Its urgent.

Arlette

11-11-2009 04:02 PM
Tony Toews [MVP]

Hi All, I am finally (finally!) changing the habits of a lifetime and no longer concentrating on building Access FEs that connect to a SQL Server...

auntiejack56

11-11-2009 02:54 PM
auntiejack56

Thanks for any help on this. I have about 150 tables with the same datatypes and field names. I would like to, on a regular basis, create (or...

lackeysc

11-11-2009 09:31 AM
Salad

I am trying to construct invoice numbers in the series D0000001/ D0000002 etc etc. I ma importing records to a temporary table and then poulating...

gorsoft@hotmail.com

11-11-2009 09:28 AM
Salad

Hi, I have a database which has been in use for 2 years. Now all of a sudden when one particular user enter a date into a field all information...

Paul

11-11-2009 08:16 AM
paii, Ron

Why do hidden controls on a form display themselves in datasheet view?

Mat

11-11-2009 03:09 AM
hbinc

Is it possible, In a datasheet view subform, to change the backgound color based on the value in a particular field? For example if the field is...

AgentX@apocalypse.com

11-10-2009 09:21 PM
Mat

Is there a way for access to continuously monitor Outlook (sending/ receiving) and store email data in database?

shanq

11-10-2009 12:01 PM
shanq

Dear reader, In the Startup form you have the possibility to Browse to an application Icon. In case you runs the program always on the same...

Simon

11-10-2009 01:59 AM
Allen Browne

Dear reader, In the Startup form of Access I see in the combobox of Shortcut Menu Bar a list of menu bar names. This names are not familiar to...

Simon

11-09-2009 11:01 PM
Simon

Please help. I have a program that automatically runs each morning to pick up the latest fund information files from various companies. They all work...

musicloverlch

11-09-2009 03:35 PM
Salad

Clients with Access 2003 can't use my database because macros are blocked. At a colleagues recommendation, I went into Tools, Macros, Security, and...

Tomahawk Lady

11-09-2009 02:27 PM
Tony Toews [MVP]

Kiers <kieran (AT) leasemanager (DOT) co.uk> wrote: Cr*p. Hmm, now what would be nice then if he put it onto an Open Source site. Tony -- Tony...

Kiers

11-08-2009 12:04 PM
Kiers

I'm wondering if it behaves any differently than it did on Vista.

Don

11-08-2009 11:29 AM
Don

I get this error Server was unable to process request. ---> The type initializer for 'DSHS.SNF.Model.Message.UserMessageFactory' threw an exception....

Bob Alston

11-08-2009 12:47 AM
James A. Fortune

If you are looking for data to be secured from people with malicious intent then you could always introduce a cryptographic function to encrypt the...

The Frog

11-06-2009 01:59 PM
David W. Fenton

Hi all I have seen code (from Lyle, who always makes me feel sooo inadequate!) for sending emails via OE (MAPI stuff). I am under the impression...

jbguernsey

11-06-2009 11:06 AM
jbguernsey

Well i did as you said (i used PersonID as the primary key in Employees Table) but when i run the Persons Query (with criteria to give me only the...

Mistirios

11-06-2009 05:23 AM
Mistirios

Hi all, I team up with a GIS guy a lot, and we've built a good workflow around (me) generating crosstab queries/view from Access DBs for him to...

Jeff

11-05-2009 02:00 PM
Jeff

Hi I have a form/subform set up, with a button to add a new record. I want the button to add the new record to the main form but not add any data to...

paul

11-05-2009 11:20 AM
paul

Hi Everyone, I've written a basic function to return TRUE or FALSE depending on whether related records exist in another table. This works well...

elias

11-04-2009 08:22 PM
Chuck Grimsby

In order for my application to work, the Microsoft DAO 3.6 Object Library needs to be third on the list of references. Can anyone tell me why it...

pemigh

11-04-2009 08:15 PM
Chuck Grimsby

Hi All, Has anyone ever tried to have the data on a report center itself on print preview? The secretaries here are having a fit because a...

musicloverlch

11-04-2009 04:28 PM
Salad

"paii, Ron" <none (AT) no (DOT) com> wrote in news:hcrtt1$ej8$1 (AT) news (DOT) eternal-september.org: To me, Citrix is one of those FUD...

septimus

11-04-2009 02:52 PM
David W. Fenton

I linked a speadsheet in an app and opened it and noticed I had some #Num! cells. I guess that called to my attention that there were number and...

Salad

11-04-2009 12:37 PM
Salad

Any suggestion on the following would be greatly appreciated: I was working on a database in MS Access and I have encountered an issue I need your...

Mohabi

11-03-2009 07:17 AM
paii, Ron

I know this group is for helping in use of the access but hoping to find some help on installing '97. Recently purchased laptop w\ XP Home. Have...

doncee

11-02-2009 04:17 PM
doncee

I'm linking Access to Outlook, the system automatically generated a link table called "inbox" which I can't modify anything inside, seems like a...

shanq

11-02-2009 01:50 PM
shanq

I have an Access 2003 Form with a listbox on it. The row source is a Table/Query. The query sorts the records according a Date/Time field in the...

RCGUA

11-02-2009 11:03 AM
RCGUA

I have a form which has 2 dropdowns that the user needs to select. One is on Year and the other "Active or not". The 2nd dropdown has 3 options -...

Arlette

11-02-2009 10:46 AM
Salad

I have a search screen in MS Access 2003, with a unbound text box to put in the parameter to search. I need to have all the text boxes in the...

Arlette

11-02-2009 05:42 AM
Arlette

I am using Access 2007 and am puzzled by the form and report design tab. No matter what I do the gridlines group remains greyed out (disabled) Has...

Lou O

10-31-2009 11:42 PM
James A. Fortune

Hi Everyone, I am trying to find out if anyone has had any issues with Access applications / Jet databases on 64bit Windows platforms. I am...

The Frog

10-31-2009 10:54 PM
Tony Toews [MVP]

"David W. Fenton" <XXXusenet (AT) dfenton (DOT) com.invalid> writes: Knock yourself out. -- Randy Yates % "Watching all the...

Randy Yates

10-31-2009 06:32 PM
Randy Yates

Usually a subform's recordsource grabs ALL records it needs and then the filter established by the Link Master/Child fields is applied. However, the...

Randy Yates

10-30-2009 02:36 PM
David W. Fenton

I am trying to email a personal invoice to our members. I can generate a PDF file of the invoice OK for each person and I can email them something as...

Phil Stanton

10-30-2009 01:04 PM
Phil Stanton

Using A2003. I'm using the coding below to look up AmountReceived for a certain date: strExpr = "AmountReceived" strDomain =...

emanning

10-30-2009 09:13 AM
emanning

I have a Color picker to lookup color numbers to be kept in fields - I give access to the Color Picker via a button, whn the user has selected a...

Malcolm Hind

10-30-2009 09:04 AM
Steve

I have a form listing Part Number and Part Desciption. PartNo is a small field and description is a wide field. So I wanted my heading to look...

Salad

10-28-2009 07:14 PM
Salad

Hi all, I want to dump some data in XLS without the table header information. Information on the docmd.TransferSpreadsheet Action is telling me...

Mat

10-28-2009 04:21 AM
Mat

I am trying to create an SQL statement in code to insert a record with 30 fields into another table with the same properties. The problem is that...

Lou O

10-27-2009 07:43 PM
Lou O