Is it possible to enter the contents of the Parameter Value Box?

[MikeFord]

Does anyone know if it's possible to edit the contents of the "Enter Parameter Value" Box...for starters, I'd like to delete the phrase "Please Enter Parameter Value" as it means nothing to most users of Access; also, I'd like to format the text that I've entered in the query itself, i.e. make it bold, increase the size of it.

Incidentally, I did go down the route of linking my query to a form but this caused problems as I want more that one user to be able to view their particular parameter value at the same time.

Many thanks

 

[pbaldy]

I was going to suggest a form, and your second paragraph raises a second point. If you have multiple users, the application should be split into a front/back end, and each user should have their own copy of the front end. In that configuration, there would be no problems caused when people view their parameter value on a form at the same time.

 

[MikeFord]

Thanks for your quick resonse!

I'm afraid to say that this is the first time that I've heard that this is possible! Is it easy to explain how to do this...otherwise, I'm off to buy a book...

 

[pbaldy]

Searching this site should turn up numerous discussions, plus here a "how to":

http://allenbrowne.com/ser-01.html

 

[MikeFord]

Thanks Paul, saved me the cost of a book...deadlines a bit tight but I can give it go! Cheers

 

[pbaldy]

No problemo. If that wasn't enough info, there's this:

http://www.accessmvp.com/JConrad/accessjunkie/splitting.html

 

[MikeFord]

...am I correct in assuming then that there is no way to edit what appears in the Enter Parameter Value box then?

 

[pbaldy]

Correct. You have a little more control over message and input boxes, and the most control over forms.

 

[MikeFord]

Well, I've managed to split the database...I've created a new form and table in the front end which the user inputs there budget code in to pull out their numbers, etc...it all seems to be working OK, except...

It won't let me input data into a form, I'm not sure if this is related to the splitting or not but I've tried all the obvious fixes per help...any ideas?

When I input data into the other forms, the tables are not updating, is this related to the splitting again?

Cheers, if you can help.

 

[pbaldy]

In the front end, are the tables there, linked to the back end (they'd show with a little arrow next to them). Are the forms bound to those linked tables? If both are yes, then the data should go into the tables.

When you say it won't let you input data, what does it do? By the way, when you're just using the value for a query parameter, there's really no need to store it in a table. The query can get it right off the form.

 

[MikeFord]

Paul, thanks for your input on this...I'm just about there now.

I solved the problem with the form that didn't allow me to input data...I think this was because it had a query for a control source...anyway, the problem went away when I changed the query to a make table query and used this as a control source.

I'm still perplexed as to why my tables aren't being updated by the data input in the forms. How can can you check whether or not they are bound then? I know the control source of the form is showing the relevant table...surely this must mean thay are bound.

Also, I've got another form which seems to have identical properties that does populate it's table.

....urghh, so near yet so far...

 

[pbaldy]

If the form's record source is the table, and the name is the same as the linked table showing in the database window, the data should be going through. Can you post a sample?

 

[MikeFord]

Hi, I sussed it in the end...basically, I was using a DLookUp in one of the fields in the form...table didn't like it for some reason or other...well, I've hit the deadline and the front end is going out to the users now...thanks for all of your help on this!

 

[Villarreal68]

Hello MikeFord,

If you want to enhance your FE/BE setup take a look at this link:

http://www.granite.ab.ca/access/autofe.htm .

I know there are some similar utilities referenced here in this forum. But this is the link I found during the search.

ENjoy!

René