Search results

I have a series of dates and I want to convert the dates to months so that it would show how old in months the dates are. ie 05/05/2002 would be 24 months 05/05/2000 would be 48 months etc etc Thanks

I just want to exclude characters from a string. The string may change from job to job. Thanks

There will be loads of stuff to exclude is there a way I can use the IN("a","b","x") format for doing it.

Im trying to check for characters in a string but seem to be having problems I have the following but VBA doesnt like it. If Mid(Name, x, 1) not in("a","b") Then Your help is appreciated

Thanks for that it helped a lot. Another question for you. How can I create a table using ADO and add fields to it.

Can anyone help with some simple issues Im used to using dao dim db as database dim rs as recordset set db = currentdb set rs as db.openrecordset("dfsfdfsdf") etc How do i do this in ADO

How do I do this using ADO and not DAO? Many Thanks

Create a Table using VB How can i create a table using nothing but code. Thanx

done that doesnt make any difference

Is there a way to turn off the annoying beep that access does whenever it confirms anything. It beeps when changing tables and finishing queries and also in find and replace Im sure there was something that could be changed in the registry but I cant remember what.

By chance I changed the code to Set qrydef = DBase.CreateQueryDef("", "INSERT INTO Results SELECT directors.[Business URN] FROM Directors GROUP BY directors.[Business URN] ) " and it worked. thanks again.

I'm using the code below For x = 1 To 10 DBase.Execute "ALTER TABLE Results ADD COLUMN TEST(x) TEXT;" Next x Keep getting syntax errors. Any ideas?

I have a list of ids in the directors table. I want to create the results table that has the same ids but keeps them unique ie no duplicates. The directors table will have duplicate id's

Have the code belowPublic Sub MultiDirectors() Dim DBase As Database Dim rsSet As Recordset Dim rsResults As Recordset Dim qrydef As New QueryDef Set DBase = CurrentDb Set rsSet = DBase.OpenRecordset("directors") Set rsResults = DBase.OpenRecordset("results") Set qrydef =...

How can I create extra fields in an existing table using code?

I've created a form which lets a user change there own password in the database. When it runs I get an error, I think the error relates to the users not having ADMIN rights to the database. I've tried : DBEngine(0).Users(txtUserName).Groups.Append ("supervisor") but I get a compile error...

Is there a way that from a postcode field I can just extract the letters only from the first part of the postcode? ie bb11 = bb a12 = a etcetc I need to be able to do this from a query.

no should be ok thanks

no should be ok thanks

ahhh no that'll be the problem then..