Search results

OK, I've started to discover that Access functions work a little differnetly to what I'm used to doing. What I'm doing is setting variables based on user options, and then running the script. So what I want to do is 1: test for the selection 2: set variables 3: run the script So... If...

Help. It's gone down and won't come back up. I've tried importing from another db, and using the compact/repair tools but to no avail. Do I have to ask IT Suport for last nights backup?

I use VBA a fair bit but I've never had the need to use functions, I have however, used them quite alot in ASP so I'm not unacustomed to them. My question is, is the proper procedure to create them as modules, and them call them from the code? Is the syntax to call a module mobuleName()? Cheers

Does anyone have any experience with international codes and regional codes and numbers. I'm building a sqlserver db and just need to know the maximun length of the fields. cheers

There's loads of different paramater settings for them your best bet is to check the help files. hth

'On the fly' the code would something like: FirstNumber = InString(Postcode,#) FieldToPopulate = Left(Postcode,(FirstNumber-1))

this works for me Dim db As Database Dim strSQL As String Dim RST2 As Recordset Set db = CurrentDb() strSQL = "SELECT * FROM Stopcode" Set RST2 = db.OpenRecordset(strSQL, dbOpenDynaset, dbConsistent, dbOptimistic) Good luck

Correct me if I'm wrong......... Error trapping is processes that the developer put in place to handle errors. Sounds really obvious when you put it like that. Basically, you test the system as a really stupid user, put the wrong data types in fields, enter values that 'outside' of the range...

If the .bat file creates a locking file (like access does when you open a db) you could use the FileSystemObject command to to check for the existance of the file and while it exists loop the macro to check for it. This could create a lot of problems though, not least locking your computers...

Thanks Pat I came across that in the help files. Unfortunatly, I need to create the list on an ASP page, so unless I pull the names out from a SQL statement, or create the list in a query it's no good. information.schema doesn't work either. cheers

You need to add (I can't remeber which) Set dbs = Currentdb() or just dbs = Currentdb() as long as it's the db your using that you want to connect to.....

I want to create a list in a query from the Table column headings, does anyone know how I would go about this, obviously I want the list to be created automaitcally and update itself when I add new columns. thanks

Sorted it, created a Pass Through Query and called that from the VBA.

I have an Access front end for my SQL Server db. I need to execute a stored procedure in SQL Server from Access or exectute the SQL from access to the SQL Server. Does anyone know how I'd go about this. I sort of half know what I'm doing, I've done a fare bit of ASP and VBA, but I can't find...

Wizards. :rolleyes: Pat the all knowing..........:p Cheers

??????? Don't really know????? I got to option 21 and it told me I could only have 20. I'm using A2K.

I'd prefere to use the OptionGroup, just because I think it would be more suitable, but I may have to.

Sorry not very clear!!! It's an Option Group on a form, trouble is it will only let me add 20 options to the group, and guess what, I've got 25. Any ideas?

Does anyone know of a way to get round it.

I opted for 'Storeing it in a Table' option. Hey it works :D