=format([your_field],)
--- On Fri, 10/31/08, Mark Hallgath [EMAIL PROTECTED] wrote:
From: Mark Hallgath [EMAIL PROTECTED]
Subject: [ms_access] Convert mm/dd/ to only show
To: ms_access@yahoogroups.com
Date: Friday, October 31, 2008, 11:59 AM
I need to write a query in Access
Have you looked at the Northwind sample database that comes with Access ?
--- On Sat, 12/27/08, ram muthukumar kumar_s...@yahoo.co.in wrote:
From: ram muthukumar kumar_s...@yahoo.co.in
Subject: [ms_access] where are sample access programs available
To: ms_access@yahoogroups.com
Date: Saturday,
On newer version of Access, updating a linked excel table is not allowed. You
can read the data, but not write to it.
I normally open an instance of excel and loop through the record set, adding
records to the spreadsheet using the Excel object model. (Range,Cells, etc).
VBA was a wonderful
Hi Jan !
Did you just reply to your own thread ? ;)
Before you go any further, you may want to browse around on line and read up on
databse design, specifically normalization, keys and the like. (If you haven't
already)
I normally don't start creating tables, queries, or write code until I
Visual Basic 6.0 and ADO is how I've done it in the past. The MDB will contain
just the tables.
Many off the shelf commercial software programs use Access as a back end. UPS
World Ship is one of them.
As far as tutorials, I've always used the Getwen Lentz Access Programming
books.
--- On
Look into the on_current property, and the visible property.
Psuedo code to foolow:
Control_1 on_current
If me.value = 10 then
control_2.visible = true
End If
End sub
In the on open event of the form, set control_2s visible property to false,
also.
In the on click event of the add new