Search results

hello, I have a module that I would like to parse the original date of birth in the format of dd/mm/yyyy (i.e., 01/05/2007) to the format of yyyymmdd(i.e., 20070501) using SQL statement copy them into another table at the same time, may I know how could this be accomplished programmatically? Thanks!

Hello, I have a table that has some fields and now i would like to append a table to it, mapping the same field and add in the field of the second table that the first one does not have, and leave the field blank for all data in the first field. may I know how can I possibly do this? thanks a lot!

interesting, i must have messed up something in the tables then, thx anyways.

SQL View says: SELECT * INTO AppendAllFields FROM [some table]; But the design view is blank

they are both strings with the name of the table, so i assume the answer is yes, i did not define the structure of the AppendAllFields initially so I assume it would inherite the structure of sometable as well :) Thanks!

Hello, I was trying to create a chunk of code like follows: sql = "SELECT * INTO AppendAllFields FROM [some table];" Set qry = db.CreateQueryDef(qryName, sql) DoCmd.OpenQuery (qryName) where qryname is alr. defined. When I wronf it, it kept giving me the error on the DoCmd line saying that...

Never mind, I found it: http://office.microsoft.com/en-us/access/HA010547271033.aspx

Hello, Say I have a dynamically generated string (e.g., "Wah! What a big fish!") that I want keep all but the last character(i.e. changes to "Wah! What a big fish"), may I know how can I do that in VBA? Thanks! Anyi

But how can I exclude those 10 fields first? Is there something in VBA that says append table for all but these 10 fields? Thanks a lot!

Hello, Say for example I have two huge tables I want to append together, out of the 200 fields, 190 of them have exactly the same name and will be mapped to exactly the same place, but the rest 10 do not have the same name although they do have a corresponding mapping to the target table (say...

How can I set the warning off? What is the VBA statement to do so without freezing the screen? thanks! Anyi

Hello, I wrote a module that would require certain modification and creation of tables, however, when I run the module, it kept asking me whether I would like to run the appending query, and considering it is about 40 tables created, it is really annoying that I have to press OK every time, and...

But what if i could only allow one characters instead of multiple character? What would be the wildcard then? thanks!

Say I have a field that contains data like: abba abc ccdd And I would like to inlude, say, just a single b if the word starts with a and ends with c (i.e., abc or abdc are both OK), and any number of bs if the word starts with a and ends with a(i.e., like abbbbbbbbbbbbbbba or abbbbbbdda) and so...

Hello, I understand that in an SQL string, you could either use [fieldName] or fieldName to search for an field in select statement, may I know what are the difference between the 2? Thanks! Anyi

yes they do, thanks

I am not allowed to change anything on the source table...by company policy...:) So how can I do that without using VBA? Thanks!

Hello, I have around 40 tables right now on hand and I would like to combine them into one big table (a table, not table formed by query) and I am wondering is there a easy way of getting it done without me physically copying and pasting all 40 tables? Thanks! regards, Anyi

Mmm...parsing...that does not sounds good, is there anyway I could simply extract the first four digits in YYYYMMDD without using VBA and then convert the four digits to year? Thanks!

But is Access capable of recognizing, say in a string named 20070514, the 2007 is the year instead of 0514? Thanks!