Recent content by GigglyGirl

yeah but here you are adding column.. The thing is I am trying to just change fields' properties of an existing table because it contains recods already. Thanks for you fast feedback Omega

Hi, I am trying to figure out how to change properties of fields of existing tables. Is it possible to change properties through Access VBA? Thank you

Hey I got it.. Thank you anyway. But I have another question how you change fields properties in VBA??

Well with data. And just to remind that Table2 could be anything.

Hi, I need help. I am trying to figure out how to join two tables which they have totally different fields and make a new table out of it. For example Table1(with Records): PeopleID, tblPeoPedigree, Person, Father, Mother, Gender Table2(empty this field could change): ATA25E07, ATA29C07...

Well actually I figure out.. Thank you any ways Here is the answer Public Function CreateFieldX() Dim db As DAO.Database Dim rsMarkers As DAO.Recordset Dim tdfNew As TableDef ' Dim dbText As Object 'NOT NEEDED Dim fldNewField As DAO.Field Set db = CurrentDb()...

Well Actually I was trying something else.. such as using DAO But just cannot figure out what is wrong that doesn;t create a new table assign. Public Function CreateFieldX() Dim db As DAO.Database Dim rsMarkers As DAO.Recordset Dim tdfNew As TableDef Dim dbText As Object Set db = CurrentDb()...

yupe that is right

Hi, I am trying to figure out how to convert records or rows to fields. For example if I have a table with certain records field1 ------ A B C D and I want them to be my fields in a new table, that would look something like this A B C D How can I do that in VBA by...

Hi MicheaelRed, Yeah I saw your code and I just wondering is that in the level of forms?? Because I don't want anyform. The thing is I just want to record the changes from tables.. Is that possible. Like example. Table name Field Name Change made date XXX Number 55 to 44...

Hi, I need help to find out if there is a way to keep track of changes in an Access table. For example a history file that records the changes made and the date either in text file or any other file format. I will appreciate your answer. Thank you

Hi GDGarth, Yes please if you could show me how to do it with one file I will appreciate that. But how I can send you a file?? There is an email well I can send you Garth?

That is a great example.. Thank you for your help. You must be a really good programmer. Thank you

Thanks GDGarth it really give me an idea how to start. But one quetion.. How that code will look like?? How do I wirte that code that can puts the fields in the proper order?? How I can replace all the [vbcrlf] =[Enter] to commas?? I am kind of re-learning all that thing since I didn't use it...

Hi, I need help with importing sequential text files that look like this: Marker: 042xe3 Project: CEPH Date: Thursday, May 02, 1996 Frequencies: 1) 170 - 0.019 2) 169 - 0.315 3) 168 - 0.167 4) 167 - 0.500 Het: 0.623 PIC: 0.573 Individuals Used: 27 of 133 1331-01: 167 167...