Search results

I am trying to automate the compilation of a rather large amount of data. More than one mdb file is to be involved but I would like everything to be controlled from only one of the database files. So I need to know how, if it is even possible, to make functions in other databases run. That is, I...

what's going on here this is crazy!

This might take some 'splainin' so be patient. (i use A2K) I had a report with a subreport. The subreport was to display many records for each record in the main report. I could never be sure how many records would print in the subreport until it was time to print the subreport (furthermore, if...

THis is highly related to one of the other posts in this section having to do with filter by forms, but the question is different and perhaps more specific. If this bothers anyone, sorry, but according to my judgement, it merited a new thread. Does anyone know anything about the...

I have a field on an entry form that I do not want being changed after the record is saved. Once this record is saved it writes some data to another table. If they delete the record that's ok because I have deletions set to be cascaded to the child table. I thought about adding a field to the...

I have a form where one of the textboxes should display a name. This textbox's data source is a field which, rather than a name, provides a unique ID# identifying that name in another table. It seems that if I want the textbox to look up the name I must make it into a combo box, but I want it to...

I was using Access's wizard to create a form based on two tables with a one to many relationship. I want the subform to be linked rather than exist on the parent form as a subform. The wizard provides this option. However, when I add some records to the linked form, the field that is the link to...

Can I have the OnOpen code of a report open up a form and then stay stuck at that point in the code until the form is closed? I wish to use the form to set a variable in the report's code or else somewhere on the report itself. And how do I do this?

I have many reports which are all highly similar. Each one displays numerous individual values. Each one of these values is processed through a function that tests to see if the value is greater than a preset limit. If so the function returns the initial value, if not then a special symbol is...

I need to take a number from a table and output it on a report according to a certain number of significant digits. For example, given three sig digs, 1.875 needs to output as 1.88 and 13.57 needs to output as 13.6. As you can see I can not simply set the number of decimal places. Sometimes I...