Recent content by chrisgreen

Try downloading some freeware from www.pb-sys.com, then go to freeware and download MDBTask or MDB Repair tool. I have found the repairing tools very useful because they significantly reduce the size of Access Databases. Good luck

Just wanted your opinion on the future of DBMS's. At the moment I would argue that relational DBMS's are the state of the art. Do you think that object relational DBMS' will take over or do you think that vendors will simply provide add ons to their RDBMS', that will provide facilities like...

I am interested in the relational model and how it is used to produce relational database management systems. I am also interested in future developments of DBMS's. Does anyone know of any good web sites that I might be interested in? Thank you for your time.

I want to format data that I am puting into a text box. I can't remember or find what the appropriate syntax is. I think that it something like this. text1 = "Hello world"/n + "My name is chris" Please can you help me because it is really bugging me!

I have got a memo box in a form and I am outputing data from a table into it. How can I format the output. i.e. next paragraph.

How can I make a string variable accept a NULL value? Thanks for your time.

I can't remember and I can find help about the code used to format output. e.g. next paragraph, tab. I think that it is something like this /n or \n /p or \p etc can anyone help me?

I have some buttons with code within them. How can I call the code (sub) that is is the button from somewhere else. Thanks for your time.

I have a table with : ActivityNo, lineNo and comments ActivityNo and LineNo is the key. The comment is spead in the table accross the lineNo with the same activityNo. I want to produce a query that has the fields ActivityNo and comments. To do this I need to concatenate all the comments...

I have a table with : ActivityNo, lineNo and comments ActivityNo and LineNo is the key. The comment is spead in the table accross the lineNo with the same activityNo. I want to produce a query that has the fields ActivityNo and comments. To do this I need to concatinate all the comments...

How can I concatinate two fields into one using a query?

How can I do a query using the boolean Yes/No criteria. I have tried the following [activities]![completed] = -1 [activities]![completed] = No [activities]![completed] = False [activities]![completed] = "No" etc what is the correct format?

I have created my tables, views, sequences etc in SQL and I am now producing the forms in the forms builder. I have used the wizards to create the views and data sets. I can enter data into the system using the built in command commit_form ( is this right ). The data is being entered, however...

I need to find out detailed information about Access from experts. The kind of information that i need is as follows. What limitations does Access have? Critiques. What is Access used for in industry? Does anyone know of a web site or book that may be of help. Thanks for your time. Chris Green

How can I schedule a procedure in an access database?