Search results

I need to be able to count the number of spaces in each record. Any ideas. Cheers

You can use this if EXISTS (select * from INFORMATION_SCHEMA.tables where table_name = 'Table8') for SQL server but not for access. Is there a way in VBA perhaps I could use. Thanks

This will open explorer Call Shell("c:\windows\explorer.exe\", vbNormalFocus) but I need to direct it to a specific file path. any ideas.......? thanks

OK, this is what I've got It would work fine if the file was comma delimited, but it's tab. It's not recognising tab as a delimiter, so it's concatenates all the column names and looks for a column in the db called "fistnameSecondnameAddress1....." Can you specify the type of delimiter...

Can it be done?

Does anyone have any experience of this. Is it advisable or should I look for another solution.

I have a hybrid SQL Server/Access db. The table sit on the SQL Server but I use Access as a front end. I been developing the database while it's been in use, so I have a copy of the database which I work on and the original that someone else updates data with. I've been makeing changes to the...

I use a rectangle to hide text boxes whena certain condition is true (lazy I know) but it doesn't hide one of the boxes, now it just so happens that the one it doesn't hide is the PK. Coincedence? Is there a way I can send it to the back?

I have a query with product code and name (who ordered) this is grouped so that multiple orders by the same person are simply added. I have a text field in the orders table for "Special Requirments" when the query is grouped then any special requirments are treated as a *new* group. So...

i have a db that imports excel files, due to [my] poor design of the spreadsheets some of the records will be imported with missing data, but the data will be on the line just above it. when all the spreadshhets come back I'm expecting about 50 odd, I'd rather have a way of updating it in...

I'm trying to run a delete query from a button, but when I use the wizard to create the event, it doesn't show me the delete querys as an option, just the select queries. It's not a problem I can just script it, but I was wandering whether anyone else had come across this, is it a bug, or is it...

Does anyone know how I can?

Does anyone know why, or how I get them. I tried to reinstall them but to no avail.

Access won't let me ... Dim db As database Saying user defined type not defined. But it will let me... Dim rs As Recordset But won't let me... Set rs = db.openrecordset Presumably the last one is directly related to the the first. DOes anyone know why this is happening, and more...

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

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

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...

Does anyone know of a way to get round it.