Search results

Thanks a million!!!!!!! It works!!!

regular expressions Hi, .. it still bugs.. Actually, I tried everything you wrote and looked in the help but I still have no idea when the Access comes into "no responding" fase when I run the sub procedure. If you have any other idea on how to solve this problem.. Anyway, thanks a lot for...

Hi, Thanks really a lot for all help. You helped me a real step further in understanding. I think I'm very near the final answer, but for some reason or another, when I run the sub procedure, Access bugs and is not responding each time (so that I have to close the program down without seeing...

Hi! I made a form in which the user of the form needs to enter the name of a table and its datasource. Once he has written this, I want to run a macro that inserts that table into Access For that macro their is no problem: PathSource = "D:\Leen" NameInput = "railway_line_pune.dbf"...

Thanks! It works!! Incredible how you can loose your time ;)

Hi, Can somebody help... I'm trying to put via an automatic way a field to a table that autonumbers. When I use a select-query: ALTER TABLE tablename ADD COLUMN Id Autonumber, Access doesn't recognizes the type "Autonumber". Even in VBA when I use the .createfield method, I can't set the...

Hi, Thanks again! Actually, I'm just "new in the world of programming" so I tried as you said to make a late binding and it works!!! Actually, your second option, to use the addfromfile.method, I don't understand: I searched using Google desktop the vbscript.dll file but it is not apparently...

Hi, Thanks for the tips. In Access 1997 I could'nt set the references. But now, after installing Access 2000, I vinked both the reference "Microsoft VBScript Regular Expressions 1.0 and 5.5" and it worked. However, In my company, everybody still works still with Access 1997 because of the...

Hi, I'm working with regular expressions in VBScript and I'd like to implement them in VBA in a module. However, in the helpfile from VBScript I found: VBScript Features not in Visual Basic for Applications : among others the function "RegExp" (the use of Regular expressions). However, on the...

Reply 2 methods Thanks, *using the first method mentioned: you can put 0 as a default value in a Table, but that doesn't make all empty values in a table 0 (it does for new rows your addig but not for existing rows). Correct me if I'm wrong. *using the second method using updatquerys goes...

Hi, I have a table with several (many) fields and for each field I have some empty values (cells). For now, I made an update-query for each field, for example: IIf(IsNull([Man1Type]),"0",[Man1Type]). This works, however, as there are many fields I was searching for an automatic code (using...

I do still want to find a solution to add a column with datatype "AutoNumber" without having to go in designview (so via macro/...) In the help i found the following: --- Sub CreateAutoIncrColumn() Dim cnn As New ADODB.Connection Dim cat As New ADOX.Catalog Dim tbl As New ADOX.Table...

My goal is to automate a process via Macros, without that the user of the database has to touch the design view etc. I have one table met 1 field = Road_id, but know, I'd like to add a second field (ex. auto_id) and have this one in autonumber, for example: road_id & auto_id 5 &...

Thanks a lot for your help! The Alter Table method works (I wanted to automise the process, so changing manually is not an option).

still don't understand the change data-type Hi, I'm having the same problem: I want to convert the data type of a field in a table using a macro/query/.. but I don't understand your solution explained on this forum: I want to change the datatype of the field named "Manid5" in the table...

I'd like to create a table using the folowing subprocedure: ----- Sub CreateTable() Dim dbs As Database, tbl As TableDef, fld As Field Set dbs = CurrentDb Set tbl = dbs.CreateTableDef("Test") Set fld = tbl.CreateField("test1", dbText) tbl.Fields.Append fld dbs.TableDefs.Append tbl...