Search results

I would like to format text in a text field in a Report. For example. This is a test of my formatting needs. I understand that MS Rich Textbox doesn't work on reports. I tested them and could not get a bound RichText box control to preview or print. Is there any way to embed printer...

I'm trying to create a SQL Server Table (SQL Server 2000) from MSAccess. Here's my Code: mySQL = "CREATE TABLE tbl_Test_ & "(Code varchar(255), " _ & PartNumb_1 varchar(50)," _ & Price_1 money , " _ & MSRP_1 money, " _ & Avail_1 varchar(5) ) "...

I have written the following code to create a table in a SQL Server 2000 Database. mySQL = "CREATE TABLE tbl_PriceAndAvail_" & strDistCode _ & "(Code varchar(255) NOT NULL, " _ & "PartNumb_1 varchar(50) NOT NULL," _ & "Price_1 money NOT NULL) " Set cmd =...

I'm trying to create a connection string to access SQL Server 2000 stored procs from MS Access 2003. I created a connection string using a UDL and attempted to execute a stored proc. When the stored proc executes, I get the following error. This connection cannot be used to perform this...

I've been an MS Access Developer for 10 years. Recently Access 2000 + I have found the databases are less stable. I routinely get unexplained error messages occurring in code blocks that have worked for years. Both I and my clients get kicked out of databases by Access and have to open it...

We like to hang functions on a Button_Click event. We would also like to use a function with the MouseDown event, but we have not been able how to use the Shift parameter in the function, e.g. =MyFunction("Test", shift) Is there any way to get access to the Shift parameter when using a...

I have developed a coding utility in MS Access that stores code snippets. I added <insert tags> that allow you to change fields and variables automatically. I also added Stored Procedure capability that converts Stored Procedures in SQL to VBScript. It’s really amazing. What used to take me...

I have had to rebuild my system. Now that I have all software loaded, I would like to reset all my options. Where are MS Access 2000 custom settings, like toolbars kept? Thanks for your help ;)

Usually when this happens here, there is a syntax error in your database. Have you compiled all to see if there is an error?

I'm developing an Acess 2002 database for a client that will be used as the backend for a web site. Client wants to be able to enter text descriptions that will appear in web site. They need some minimal HTML Formatting (Bold, Underline, Italicize). I have created a neat function that adds...

Thanks for all the advise. I discovered the solution shortly after I posted the question. Data is not changed or updated under a program action so those events wouldn't work. I simply set the focus on the close button. This committed the entry to the field and voila I could get access to the...

Do you have one copy of the front end database that everyone users or does every user have their own front end database?

I'm pasting a string from the Clipboard into an unbound form. I can see the string in the field, but the field is not dirtied by pasting the string into the field, so in code, the value of the field is null. What's the best way to dirty the field. :o Thanks

Yes. When you add a function in a Global Module, it should automatically be created as a Public Function. The first line should read Public Function

Try creating a public function in a global module. You can then use the function in your query. Please note that the function will run slower than your current approach, but it will allow you to do the more sophisticated formatting you want and it is more supportable. After you have created...

Of Course, you're using MS Access. If the form is corrupt, here are some things to try. 1) First do a repair & compact. Often (but not always) this will resolve corruptions. 2) Decompile the Database. Most of the time, this will resolve corruptions. Go to the command prompt (Start | Run...

Combo Boxes used for filters should not be bound. You may have a bound Combo Box on your form to enter an order's Country, but you should not use it for filtering. Either change your combo box so it is not bound, or create a second combo box that is unbound to be used for filtering. You...

You might check MS Access options on her system. Check Tools | Options | Edit Find. Make sure the confirm Document deletions is checked.

You might also check the default record locking (Tools | Options | Advanced). Make sure it is not set to All Records

There are several things you should try researching. 1) Is the Combo Box a bound control. If you are using it to filter records it should be an unbound control. If it is bound, the value is controlled by the value in the current record. 2) Do you have any code on the Before Update or After...