777bonzai
Last Activity: Nov 4 '15, 07:30 PM
Joined: Jan 11 '12
Location:
-
I was able to figure it out. Thanks everyone! -
Rabbit. Thanks for your response. Basically, for example, if user enter Date1 as 01/05/2011 and Date2 as 01/02/2011, Date3 should be auto populated as a date of 01/04/2011
thanks
777bonzai.Leave a comment:
-
Autofill Field Date3 Based on Fields Date1 and Date2
Hi,
hope someone could help.
On a form, I have three date fields Date1, Date2 and Date3 and format of all three fields is shortdate. I want field Date3 to be auto-poluate by this formula (Date1 - Date2) +1 after user enter Date1 and Date2. I built this VAB code on the AfterEvent of Date2 field.
...Code:Private Sub Date2_AfterUpdate() If Not IsNull(Me![Date2]) And IsDate(Me![Date2]) And Not IsNull(Me![Date1]) And IsDate(Me![Date1])
-
Hi Rabbit,
thanks, I'll try that.
BonzaiLeave a comment:
-
Hi Rabbit,
Thanks for your response. I am not storing the data. I just need the data to present that way for another purpose. Any help would be greatly appreciated.
thank you,
bonzai.Leave a comment:
-
Eliminate Duplicates
How do I transform multiple records into one unique record base on Account? For example my table have 5 records:
Account Name Code
99999 John Doe 111
99999 John Doe 112
99999 John Doe 113
99999 John Doe 114
99999 John Doe 115
I would like to make the table below
Account Name Code1 Code2 Code3 Code4 Code5
99999... -
NeoPa, thanks for trying.
BonzaiLeave a comment:
-
yes, I could export a query instead of a table; however, my goal is to export the data to xml with a hierarchical structure as follow:
...Code:<customer> <customerID>99999</customerID> <Order> <OrderID>99999000</OrderID> <OrderDesc>99999000Desc</OrderDesc> </Order> <Detail> <DetailID>9999000111</DetailID>Leave a comment:
-
Hi NeoPa,
I've made corrections to the code. the code is under the OnClick event from a command button names Command4
...Code:Private Sub Command4_Click() Dim objOtherTbls As AdditionalData Set objOtherTbls = Application.CreateAdditionalData 'Identify the tables to export objOtherTbls.Add "Order" objOtherTbls.Add "Detail" 'Here is where the export
Leave a comment:
-
export tables to xml
I have an access db with 3 tables: Customer, Order, Detail. These three tables are linked via a field calls customerID. I would like to export these three tables to xml but I do not want to export the field "customerID " from the table Order and table Detail.
...Code:Sub ExportCustomerOrderData() Dim objOrder As AdditionalData Dim objDetail As AdditionalData Set objOrder = Application.CreateAdditionalData -
basically, how can I convert a flat file xml into a hierarchical xml.
thanks,
bonzaiLeave a comment:
-
Export data from access to xml
I have an access db and the db has two tables "parent" and "parent_cas e". I would like to export data from these two tables into xml. I did the export and unchecked opition "include primary key or index" in the schema tab, but somehow the primary id is repeated in the patient_case part, how can I get rid of this? In addition, with the xml data file, instead of saying "dataroot" at the top, I would like to rename...
No activity results to display
Leave a comment: