Search results

The highlighted line refers to the textbox 'RingNumber' containing a parsed string from the temporary table the form is based on. Does this count as unbound?

Yep, thanks, that is the issue.. What I am getting at is the fact that I can refer the value of an unbound textbox in the current record with 'Forms!frmtbltmpDrillRecon!RingNumber' but how do i change the value of an unbound textbox in the current record?

Hi, The following code refers to a continuous form based on a temporary table. In order to simulate grouping I set a textbox to value 1 and have conditional formatting give it a black background in order to draw a line every time part of a string in another field changes. The highlighted line...

It is actually a slightly amateur version of a commercially available database. Unfortunately the pro' database will not link to the CAD software that we use. I have used the comercially available db (it is very good) and chatted with the person who wrote some of it (he denies he wrote the...

Attached is an example of a report I would ultimately like to produce. The intermediate step is somewhat simpler. The option for an IT professional might be to store minimal graphics data in the database, with the majority of graphics data remaining only in our CAD software, with additional...

Hi, So I have data in a temporary table which represents lines of a drawing. I need to turn this data into a picture. I think I have two options; first option is to use the print event in an access report to turn my data into lines and circles on an access report; second option is to link to...

Did that comment add anything constructive JB? I think not

Thank you Galaxiom. You have hit the nail on the head. Once more a very simple solution. I am now a little less ignorant

JB - you suggest the additional inverted commas and yet I have used the same structure without the additional inverted commas previously. The only difference being this query has an additional left join. namliam - I create a table because I don't think additional records can be added to data...

same (ish) problem, different day Hi again, an annoyingly similar problem to my original post. I hope yous will help me again! I receive a error message to the effect that I have a syntax error (missing operator) in the 'WHERE' clause. I have tried to set out the query in the approved style...

So a piece of CAD software (Vulcan) links utilises an ODBC link to the database. From what I can make out the CAD software runs a Query stored in the db then filters the results of that query. I suppose this will continue to work so long as the ODBC link looks at the front end. At some point...

What happens when I want to add a new table? does it automatically end up in the back end? If I find that I need to change the design of an existing table what hoops will I have to jump through?

Hi, I am vaguely aware that temporary tables do not have the best reputation. I have recently started using temporary tables and I have found that I can make the db far more user friendly using temporary tables than without. I would like to use a whole lot more but I want to know if I am...

At what stage should a database be split? The database I am writing will continue to develop whilst being used. Will splitting the database impose any limitations on what I can change? anyone care to post a list of pros and cons?

I am familiar with the concept of parent and child records, forms and sub forms based on different tables. What I have been playing with is having a parent form from a query and the sub form from either a query or a table. I have basically succeeded in what I want to achieve using forms and...

or maybe the main form based on a query and the subform based on a table?

Can I base main forms and subforms on two different queries?

Thanks for your response, Most of the parent records will have one only child record. Some parent records will have multiple child records and some none. For speed of data entry I don't want to have to used the mouse to move from one parent record to the next and into child records...

Hi, My db has multiple linked tables. As time passes and work on a project continues data needs to be added to a separate table that is linked to the first table to be populated. ie, Initial design data is entered first, when drilling is complete more data is added to a linked table, when...

It is a list of possible names that can be selected for entry to another table