Search results

O.K. So, I did some further checking and I've narrowed the problem down a bit. First I would like to say that it would be easier to just put the Recordsource in the form (it works if I do that) , but at this point I'm wondering why it is doing what it's doing and how to fix it, just as a matter...

Hi Cronk In Fact, I have the names of all the forms, menus, and submenus in a table. The way I have set it up this line of code is the only one I have to customize for a new form. If I didn't do it this way then each time I wanted to add a new form, I would have have to copy the template...

Thanks I'm being dragged away for dinner. I'll get to it A.S.A.P.

Hi IslaDogs It's a database that is designed to be easy to add to. The way I've set it one can simply go to an input screen, and by entering text, add choices to menus, data entry forms, edit data forms etc. That's why that is all in a separate table. As mentioned in the reply to PBaldy...

HI PBaldy You're obviously not the only one who's confused. I used Title() because I have a function that returns the value of strTitle so that I can use it in a query. My brain seems stuck on using it! Putting strTitle in it's place yields, as it should, the same results. How do I attach...

Hi I had this working but seem to have done something, which I can't figure out, that has changed that. I'm trying to set up a database that will be easy to add forms to. To do this I have set up a table with all the form names, the title to appear in the header, and the record source. The...

MickJav That's the wierd thing about it. I am setting strTitle. In fact the code for all the forms is exactly the same as it's each form is a copy of a template. Sometimes the line: calls the function and sometimes it does not

OnOpen was a mistake the call to the function is in OnLoad.

Using Me.Title = strTitle works! I got sidetracked because I'm also using Title() in a query and just sort of got stuck on it. However, I'm still curious as to why sometimes the line Me.Title = Title does not get called and sometime it does. Thanks to all of you who helped and...

Hi GasMan In the other thread I was trying to ensure that I was writing the function correctly and that was resolved. Me.Title=Title does work, but like I said sometimes the function does not get called, that's my problem. As for using Me.Title = strTitle .......Duh! I somehow didn't...

Hi MickJav I'm a self-taught in access person so I'm having trouble following your answer due to the fact that I don't get a lot of the jargon. I have a separate standard module where I declare the variable and the function. So, below Option Explicit I have the line: Public strTitle as...

I have a function call that does not execute in some instances. The function and the variable defining it are on a standard module: Public strTitle as String _____________________________________________________________ Public Function Title() Title = strTitle End Function In the onload...

O.K. I get it. Like I said I'm self taught so I don't always get subtle stuff like that. Thanks a lot for the reply, really appreciated.

Hi and thanks for the reply. Where you have "criteria string here" I want to put the variable strTitle and that doesn't work because access automatically surrounds the variable name (strTitle) with quotes, and I get this: SELECT MenuItems.title, MenuItems.InMenu FROM MenuItems WHERE...

Hi I taught myself access a few years ago so I'm not only rusty but don't really understand what I'm doing. I mostly blunder along until I figure out how to do something. Also, I'm very poor at getting a question across, so I'm going to break this one up and start really simple. I am trying...

Hi I have been working with Access for a while but I only use it for my own personal projects so I'm very much an amateur. I use an access database to keep track of purchases and sales of items. The nature of the business is such that I only buy one item at a time. By that I mean that while...