Search Result

Hi
i am trying to convert mmddyyyy to yyyymmdd

the dates are stored in a text file

i thought of find and replace buy there are some errors

can any one give some idea


regards

I have a form created in VB.net. It is used to get some information form a user. The form is not bound to any data source.

A combobox on this form is used to enter a cost. I want the value entered by the user to be displayed using currency format. I have used the Format String Dialog that opens from the ellipses button on the FormatString property of the combobox and selected Currency. This put C2 into the FormatString property....

I have a database with one Table called marriages.

marriages Table Contains the following Field:

Field Name = Date of Marriage

Data Type = Text

--------------------------------------------------

The table contains over 9000 records. With records such as the following in the Date of Marriage Column:

1847/11/28

1917/02/04

1920/08/02...

hi i have a number lets just say 123456 and i want it to be separated like 12,34,56 rather than 123,456.

ideally i would like each group of 2 to be in a separate cell and if i put say 123 in it would automatically update the next cell by 1 and the current cell by 23.

however if this is not possible then i would like just one cell with the comers separating every 2 digits!

Thanks in advance!
Ollie...

Hi Everyone,

I've read the Insight article regarding this topic (Courtesy of MMcCarthy); however I suspect there might be an easier way than the mentioned extensive VBA coding.

My situation has spanned several posts now (first post), and I am still as of yet to post my promised summary code / database structure (sorry! Undergoing a revamp currently), and I now find myself in the situation of writing multiple, repetitive...

Hi,

I have a combobox named[listDateSelect] which allows users to filter records from my PrepareQuery table/query. The field[listDateSelect] has:

What I need is to format the [PrepareDate] with YYYY-MM

...

Hi guys,

I am writing a code which shows timeformat but in the output it combines both 12-hr and 24-hr format. Is there any solution to this problem? Can anyone tell what is going wrong?

Hi all,

First of all I will try to explain what I want to achieve.

In my Access database I will export some queries to serveral worksheets within the same workbook.
However I want the different worksheets immediately in a table format.

This is the solution I have at the moment:

With regard to the export I use:
...

Does anyone know where I can get more information about the DSM12/14+ format that is used by sites like autotrader,edmu nds etc for importing stock automatically?

I can't seem to find anything about it on the web other than references.

Thanks in advance

Mystified

Hello everyone,

I've read some logfiles to import their data into a statistics (excel) file. Now I ran into trouble that within excel the cell's format is "number" but it is still displayed as string/text, causing my diagramm is not updated until I apply "convert to number" to all concerning cells, though all cells are formatted as number under cell format properties.

1.) when do I use the number...

Hello All,

I am developing a project in which i have to feed the data in the form of CSV. But the data that I am getting is in XML format.

I need help as to how we convert an XML file into CSV.

Please reply asap!

Hello All,

I have a field on a form that is formatted as a general date and would like to be able to run a query that returns items that have end dates that end in a specific year.

I have a combobox that has years entered as values (not linked to a table) (2010, 2011,etc...)

However when I simply set the end date column criteria to match the combobox selection, nothing is returned. I'm assuming this is because...

Greetings!

NE2: [un] & ([Expiration]"mmm") & [st] & [op] & ([Expiration]"yyyy")

That's what I have in a query column. I need it to look like this:

SPXAUG775C2009

The SPX is [un]
The 775 is [st]
The C is [op]

I had commas after the [Expiration] both times just before I put the format I wanted it in, but there was a syntax error....

Hello,

I need to create conditional formatting of a text box in the detail section of a report. The formatting is based on multiple parameters that are stored in a query. For example, pretend that [Census3] = 50%, [Yellow] = 80%, and [Green] = 90%. I will check [PercentCensus] in the report against [Census3] (from the query, but currently stored in a text box on the report via a Dlookup - textbox name is still [Census3]). If [PercentCensus]...

Me again!

I am not sure how to phrase this, "but", I have to create a field that produces data in a specific format from other fields of data.

Creating the table and the query was the easy part...now taking the data that reside in that table, adding in a new field that takes the info from the other fields and makes it look a special way in that new field.

I'm not sure where to put the code in...