|
|
Determine data types from VBA
I want to determine the data types from VBA so I can appy the correct
formatting to them. I would do it manually, however the data can
change format as it imported from Excel. And I would rather not have
the users poking their noses around in the backend anyway!
TIA
Nick
|
|
0
|
|
|
|
Reply
|
 Nick
|
4/23/2007 3:59:29 PM |
|
On 23 Apr 2007 08:59:29 -0700, Nick 'The Database Guy'
<nickmcm@btinternet.com> wrote:
>I want to determine the data types from VBA
The datatypes of... what? Table fields? Variables? Query expressions?
John W. Vinson [MVP]
|
|
|
0
|
|
|
|
Reply
|
John
|
4/23/2007 5:13:48 PM
|
|
On 23 Apr, 17:13, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
wrote:
> On 23 Apr 2007 08:59:29 -0700, Nick 'The Database Guy'
>
> <nick...@btinternet.com> wrote:
> >I want to determine the data types from VBA
>
> The datatypes of... what? Table fields? Variables? Query expressions?
>
> John W. Vinson [MVP]
Sorry John, and anyone else who looked at my little problem. It was
the datatypes of the table fields that I was hoping to discover.
Nick
|
|
|
0
|
|
|
|
Reply
|
Nick
|
4/24/2007 7:59:08 AM
|
|
On 23 Apr, 17:13, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
wrote:
> On 23 Apr 2007 08:59:29 -0700, Nick 'The Database Guy'
>
> <nick...@btinternet.com> wrote:
> >I want to determine the data types from VBA
>
> The datatypes of... what? Table fields? Variables? Query expressions?
>
> John W. Vinson [MVP]
Tables field data types
|
|
|
0
|
|
|
|
Reply
|
Nick
|
4/24/2007 8:03:38 AM
|
|
On 24 Apr, 08:03, Nick 'The Database Guy' <nick...@btinternet.com>
wrote:
> On 23 Apr, 17:13, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
> wrote:
>
> > On 23 Apr 2007 08:59:29 -0700, Nick 'The Database Guy'
>
> > <nick...@btinternet.com> wrote:
> > >I want to determine the data types from VBA
>
> > The datatypes of... what? Table fields? Variables? Query expressions?
>
> > John W. Vinson [MVP]
>
> Tables field data types
When I have found them is there any way to change from a numeric types
in to a currency type
Again thanks
Nick
|
|
|
0
|
|
|
|
Reply
|
Nick
|
4/24/2007 9:15:47 AM
|
|
On 24 Apr 2007 02:15:47 -0700, Nick 'The Database Guy'
<nickmcm@btinternet.com> wrote:
>When I have found them is there any way to change from a numeric types
>in to a currency type
>
>Again thanks
>
>Nick
A Field has a Type property. See the VBA help for "Type Property (DAO)".
There are several ways to change a field type in a table, none of them
particularly simple unfortunately! A SQL DDL query such as
ALTER TABLE yourtable ALTER COLUMN numberfield Currency;
See the Access help for "ALTER TABLE".
John W. Vinson [MVP]
|
|
|
0
|
|
|
|
Reply
|
John
|
4/24/2007 4:39:52 PM
|
|
|
5 Replies
560 Views
(page loaded in 0.974 seconds)
Similiar Articles: Determine data types from VBA - microsoft.public.access ...I want to determine the data types from VBA so I can appy the correct formatting to them. I would do it manually, however the data can change format ... Check List in VBA - microsoft.public.accessCheck List in VBA Hello, I=92m looking for advice on the following: Let=92s say you wanted to check a list of values (same data type, same l... Check Duplicate with VBA - microsoft.public.access.formscoding ...Determine data types from VBA - microsoft.public.access ... Check ... Rows by VBA in Excel. Microsoft Visual Basic for Applications (VBA) is a user-friendly ... Check It Out How to scrape web page data in VBA - microsoft.public.excel ...Determine data types from VBA - microsoft.public.access ... Determine data types from VBA - microsoft.public.access ... ... Visual Basic for Applications (VBA) Forum ... Change Data Type using a Macro - microsoft.public.access ...Determine data types from VBA - microsoft.public.access ... Change Data Type using a Macro - microsoft.public.access ... Determine data types from VBA - microsoft.public ... using vba so search multiple Sheets - microsoft.public.excel ...i'm trying to search across multiple sheets based on data submitted via an input box. So essentially, you click the button, a box appears, you type ... getting the types of all the variables - microsoft.public.windows ...Determine data types from VBA - microsoft.public.access ... getting the types of all the variables - microsoft.public.windows ... Determine data types from VBA - microsoft ... Calculation from results of form fields in VBA - microsoft.public ...... use Dim statements to declare them > (otherwise VBA uses Variant data type, which ... Making form fields calculate automatically in your Visual Basic for Applications (VBA ... VBA-- Open a Form with filter accoding to LISTBOX multiple choices ...... If that doesn't work, open your table in deisgn view, and find what the Data Type of the ... I have tried the following VBA, but can't work:>>>> Dim varItem As Variant>> Dim ... Data Type Mismatch in Expression - can I force a query to read as ...Data Type Mismatch in Expression - can I force a query to read as ... Change Data Type using a Macro - microsoft ... Determine data types from VBA - microsoft.public ... VBA Tips & Tricks: Get Variable TypeTo know the data type of the variable: Function Get_Variable_Type(myVar) ... Yes, this is on VBA with excel, and it works fine with mine. (Though I am ... How to Access VBA Data Types | eHow.comKnowing how to determine the data type of a particular field in a table can make your database application more dynamic. Microsoft Office Access is a relational ... Determine data types from VBA - microsoft.public.access ...I want to determine the data types from VBA so I can appy the correct formatting to them. I would do it manually, however the data can change format ... Excel Developer Tip: Determining the Data Type of a CellDetermining the Data Type of a Cell. In some situations you may need to determine the type ... The CellType function (VBA code is listed below) accepts a range argument and ... Uses VBA's handy TypeName function to determine the data type of ...Uses VBA's handy TypeName function to determine the data type of the FormulaTest variable : TypeName « Data Type « VBA / Excel / Access / Word 7/26/2012 12:46:28 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
71 followers. 