hello, is it anyway possible to change the style of the system date with VBA code ? many thanks in advance

wv01

06-09-2006 03:02 PM
wv01

Hello! I'm sending E-mails to mailadresses in a table, using the code below. How can I send more than one attachment? Access can find the file to be...

Dirk Goossens

06-09-2006 11:01 AM
Dirk Goossens

I'm connecting to an access database and I would like the query to return results grouped on a particular column. When I try the following query, I...

Lorenzo Thurman

06-06-2006 12:08 PM
Lorenzo Thurman

I have a select query that groups records together, specifically baseball players and their home runs and at-bats. I want to create a query that...

Otie

06-06-2006 06:24 AM
Kevin

Hi, I am flying blind here. I am so stupid, I don't understand the manual.... I have basicly a name database used for a sporting event (archery) I...

hedding

06-03-2006 04:21 PM

How do I make a drop down menu that would let you choose Male or Female? Is this a querry, form, or what? Would love a step by step on how to...

hedding

06-03-2006 04:17 PM

How can I make a Combo Box in a form not display the same information over and over. In this Combo Box the Date is displayed on many different...

06-03-2006 04:03 PM

Hello all! I used the Command Button Wizard to put a button on my form which will email a report to my colleague. Just one prob: it will email all...

The Woo

05-16-2006 01:52 AM
The Woo

Hi everybody I have a table containing a list of E-mail adresses. Is it possible to send an E-mail (one by one) to all the adresses? Is it also...

Dirk Goossens

05-12-2006 03:03 AM
Dirk Goossens

I'd like to copy the date from a date field on my form, strip out the date formatting and plant the result in another field on the form. So, the...

The Woo

05-11-2006 01:40 PM
The Woo

Hi, I am completely new to crystal reports. So, I need basic information to start with. I have created a simple report using Crystal Report XI. Now...

SWEETIE

05-11-2006 03:39 AM
SWEETIE

I have a report with sub reports, one of the subreports have 12 text boxes that are 2" high and I want them all to grow if one goes to 3" high. If...

Edson Peacock

05-10-2006 10:30 PM
Edson Peacock

I am new to databases and thus to Access. I have a situation where I am trying to figure out how to key some tables I am working with. Consider...

Paul Hunter

05-08-2006 09:03 PM
Paul Hunter

I'm struggling with this, and I'm sure there's a way to do it. I would like to automate the back-up of an Access application to a writeable CD...

Mike Easter

04-30-2006 03:20 PM
Mike Easter

Is there a runtime program to allow you to run an access database (.mdb) on a computer without access installed. I am using access 2002. Thanks Perry

Perry Royse

04-25-2006 11:05 AM
leonz

Has anyone written the code to imort invoice transactions into Simply Accounting? Thanks in advance.

leonz

04-25-2006 11:01 AM
leonz

Migrate-Data is a pure java and an extremely powerful enterprise data migration tool aimed at small and medium sized databases. It has been developed...

pravumishra

04-23-2006 12:44 PM
pravumishra

Hi everyone, I have a form with a combo box on it. When you select a value (a PO#) from the combo box, the bound field is the indexID of the...

04-22-2006 04:55 PM
Ira Solomon

I have a form that is used for entering shipments of parts to suppliers. The data entered on the form is written to a table called tPartsSent. ...

04-19-2006 12:08 AM

Hi I need to generate a string of six random characters to act as the first password. Is there an example of how to do this...

John

04-16-2006 03:28 PM
John

Ok here is a real simple question for everyone, What are the pro's and con's of Access 97, 2000, & 2003. At work I use 2003, at home I use...

Ron

04-16-2006 12:47 PM
jim

Monty wrote:

Bob Alston

04-08-2006 09:29 PM
Bob Alston

Hello, Is it possible to retrieve the date when a record is created in an Access database table? And if so, how can I do that? Thanks in...

Jeroen Elias

03-27-2006 10:57 AM
Scott McDaniel

I sometimes get a pop-up box that reads "Overflow" and the module that is executing pauses. It doesn't get caught by my error trapping, and it seems...

SheldonMopes@KidNet.com

03-27-2006 10:55 AM
Scott McDaniel

I have a database with multiple tables. I want to query all tables that have a match for a specified field value. Each of the tables may have...

ChasW

03-27-2006 02:04 AM
ChasW

Can someone please help? At work we recieved some new program that is an MS Access application. While we were making some minor changes (because it...

Ron

03-24-2006 04:39 AM
Ron

Hi, I am having some trouble with recording a field on a form into my Table after formatting it to calculate several fields on the form. If i just...

TORQUE

03-10-2006 12:53 AM
TORQUE

I'm not sure if there is a difference in syntax for Access's SQL commands. I'm having trouble with what should be a very simple compound join...

_DS

02-22-2006 08:01 PM
_DS

Any recommendations for books that cover SQL programming for Access? I've already posted a question regarding Access's syntax for compound join...

_DS

02-21-2006 09:53 PM
Larry Linson

To my surprise and chagrin, newer versions of Access have disabled the functionality that lets users change the data in linked tables that point to a...

Jim S

02-18-2006 03:17 PM
Ken Snell

Hello. I have a listbox whose rowsource is set to a saved query (call it "qry_customer_list.") When I add customers to my database, I call...

Mark

02-17-2006 12:52 AM
Mark

My database has thousands of images created with Windows imaging from Windows 2000 & 98. My new computer is not able to access these files...

ggl

02-06-2006 07:45 PM
ggl

Hello, I have a user request to build a form in an Access database where the user can check off specific fields to pull in a query. For example,...

Jimbo

02-04-2006 09:59 PM
Jimbo

Estoy intentando hacer Access una consulta SQL tal como sigue: SELECT MAX(COUNT(*)) FROM ALUMNOS GROUP BY POBLACION; La idea es obtener la...

Ros@

02-03-2006 11:02 AM
Ros@

I have tried summing yes/no fields and always end up with negative numbers instead of positive numbers. What do you suggest? Susan

Susan

02-03-2006 05:42 AM
Del

I hope that someone can offer a little advice on this one - I've searched the groups but can't find an answer. I think that I'm doing something...

Mike Jakes

01-31-2006 09:00 PM
me321701@comcast.net

The biggest difference that I have encountered is in the Access versions themselves, especially in the event models. As for the SQL side, I've not...

me321701@comcast.net

01-31-2006 08:46 PM
me321701@comcast.net

Hello all. Here's one for you: I have a pop-up form designed to enter a new record in an underlying table. When I launch it on its own (no other...

The Woo

11-25-2005 02:46 AM
Frede W

Hello All, I am teaching myself Access and I need some help with SQL. I have a table, Employees; EmpID LastName FirstName 1 ...

Paul O'Donnell

11-22-2005 08:14 AM
Paul O'Donnell

Hi All, Hope Sombody could help me? I`ve created a form with 5 Feilds on, 4 Combo Boxs, everything works great data updates and deletes fine. The...

Wizard

11-22-2005 05:00 AM
The Woo

Well, maybe because I'm rather new in databaseland. But it just does not work. 1 Can I embed or enclose a word-document in a box and still...

peter lemmens

11-12-2005 06:52 AM
peter lemmens

Hi! I stored the file name and path of photos in a table with data from students and teachers. Is there a way to show the photos in a report or...

Dirk Goossens

11-10-2005 11:07 AM
Dirk Goossens

I'm trying to define a math problem in excel, so for example a 4 cell block where A1 contians nothing, B1 contains the number 2, A2 contains the...

DMolter

10-30-2005 07:12 AM
DMolter

Hello, I am very new to access and yet I have been asked to "develop" a small program with it that has several functionalities. I 'm going to...

Leen Wouters

10-29-2005 04:31 PM
Ira Solomon

have 2 tables a and b. table a has two fields name and date/ name is key table b has two fields name and address/ name is key the two tables are...

Judy

10-28-2005 10:38 PM
Ira Solomon

I am putting together a database for a local non-profit. I have programming experience and a little SQL knowledge from years ago. I have...

Robert Biales

10-28-2005 10:31 PM
Ira Solomon

Is there a good resource regarding how to use the expression builder in Access? Thanks Peter

Peter

10-15-2005 08:45 AM
Graeme Whelan

I have a form with two seperate date fields - From and To. I feed these values to a couple of queries. Trouble is one of the dates is being...

Richard John

10-08-2005 12:42 PM
woodglass

I need a database of all the words of a language, without any description or explanation of the words, simply a list of more words possible...

Federica Chiaro

09-29-2005 10:44 AM
Marc Weber

I'm looking for an editable list of all (or the most) of the italian words. could you help me? sunchiaretta (AT) yahoo (DOT) it

Federica Chiaro

09-29-2005 08:04 AM
Federica Chiaro