Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I replace some text in as string with some other text string?
You can use this function that will actually replace the characters within a specified string with some other characters. This is MUCH better than using the MID statement because it doesn't care about the length of the string you are replacing. You can also use it to remove a group of... -
Access VBA automation for replacing text
Here's something that might help. You can use this function that will actually replace the characters within a specified string with some other characters. This is MUCH better than using the MID statement because it doesn't care about the length of the string you are replacing or replacing...- overClok6
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Reproduce table structure?
I'm about to do this very thing in a project. Use the TransferDatabase method of the DoCmd object, setting the structureonly parameter to True. That will copy the entire structure of your source table into a new table you specify, even in a different database if you wish.- overClok6
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Need to look at modules, forms, tabels etc..
If you forget to hold down the SHIFT key, you may also try pressing the F11 key after you have brought up the Access database to expose the database window. From there you can access the Tables, Queries, Forms, Reports and Modules. If there is no database security implemented on the database...- overClok6
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
