Search results

i would like to see controls on form having a different default name than the field names when created ... maybe using some kind of prefix such as cbo, txt etc

Happy Birthday Oldsoftboss

Happy Birthday pdx_man

If you are interested in applying a better user level security then check out this link, but make sure that you fully understand that pdf file before trying to implement as you might end up locking yourself out of your databases. Gooduck.

you're welcome :)

Hi, I haven't read all of the posts in this thread but the following are my wishlist (not sure if they have been implemented in 2007 version): - update the vba code when using the command button wizard - remove/hide certain features which are considered "bad practices" such as lookups at...

Hi duluter, I'm glad that it worked. In my opinion, ideally any form ought to be based on a query rather than on a table directly. There are several reasons for this, one of them being your scenario where you can use criteria in order to limit the number of records to be returned. If you try...

Hi and welcome to the Forums. If you use the search feature on this forums, there are several threads with excellent examples how to deal with images. I don't recommend using the OLE object thing, ideally you should use an image control on the form and make sure that you do link your pictures...

Hi Base your subform on a query and then in the client field of your query put the following in the criteria row: [Forms]![FormName]![cboClient] Replace FormName with the actual name of your Form.

if on the OnClick event you are adding this value via another form try searching this forum for OpenArgs

you're very welcome :)

you can try putting something on the AfterUpdate event of your combo such as the following: If Me.ComboName = "value here" Then Msgbox "message goes here" End If Replace ComboName with the name of your Combo Box.

I agree with you, but it was a suggestion so you don't build new objects (forms/reports) based on that table setup, because you will have a lot of maintenance to do in the future. As i said in my original post if you try searching the forum for calculated time you will certainly solve your...

Thx Banana ... very useful indeed.

Hi dufc and welcome to the forum. As regards the calculate time, search this forum for "calculate time" as there are several examples how to deal with sum which exceeds the 24 hours. Moreover, you shouldn't be storing the totaltime in your table, but that should be done at query level as it is...

thanks both for the replies, i think the best solution would be to have a table with just the idcard field. Thank You

Hi namliam, Thank you for your reply and suggestions. Right now i see the idea of simply distribute the database with the id field as the most viable option. Load the table into an array in code, then secure the code to not be accessible at all. I will try to research/read about this idea...

Hi, I have created a query from two tables which returns personal info such as firstname, surname, idcard etc. Due to data protection act i cannot distribute this information to third parties, however, i need a way where the third party can at least input the idcard number on a form and i...

Congrats Gary & (Rose) ... i'm getting married in about 2 months. :eek: ... shall i think twice? :D

i'm currently reading "Strangers Among The Dead" by George Bellairs which i borrowed from the library. It's rather an old book as it was published in 1966.