Recent content by Pedro Magueija

done Thanks... I added: response = acDataErrContinue ...and the message is now gone... thanks again for the link...

Hellozz ppl!!! How can I disable the error message that appears after we entered a not in list value? I´ve read articles on this and tried the following code: Private Sub cod_cli_NotInList(NewData As String, Response As Integer) DoCmd.SetWarnings False MsgBox "Por favor insira...

Ok! I WAS using the autonumber field for identification purpose (i´m just a rookie) but I realized that another field was probably better and with your explanation seems obvious that it is the best option. Thanks...

Hi ppl... I did a search on this forum for a confirm procedure before saving a record and found this article. Tested it and works just fine... but I have a form that has a auto-number field. This field keeps going on even if I answer no in the msgbox... is there any way to stop this from happening?

First thanks for taking the time to help me Pat..... I´ve been trying to learn how to use Access Security and I´ve defined permission only to me (the admin) but.... I´ve created an account for users of my db... problem is that the SHIFT key still works to open the db window and queries and...

How can I disable any edition to the database? I want to block every other user who tries to copy or change anything in the database. The only reason I want to do this is because although I´m still a beginner I thing that my work is being used/changed without my permission. I really need to do...

Thanks, worked out perfect.....

Is there a function that returns the value "01-01-CurrentYear"?? I need this value because I want my query to return all records between the begining of the year and current date. I already did this but I had to insert <Between #01-01-2004# And Date()> in the criteria of the query. What I want...

Hi.... I have a toolbar containing a print button, but I only want the button to be active when a certain form is opened. Is it possible? 1 more thing, can I make the very same button print a specific report depending on the currently active form (since this button is on a constantly present on...

table form Kabir_Hussein -> Yes... but I´ve already done that, just that the record that appears in the "table like form" (the one I want to remove) appears even when you have empty tables... example: I´ve just created a new table, then I created a "table form", the table is empty... but when...

table form First of all: thanks Wayne Ryan...but... what I want to do is to remove the record that appears with a "*" when you create a table like form. For example: even if you have empty tables there´s still a record in the form... that´s what I want to remove... I do want them to add records...

Is there any way to hide the record that is always shown in a a "table like form"?? Could anyone help me with my other thread?? Many thanks...

How can I make a combo box work as the navigational buttons?? I would like the combo box to list all records from a table and from there the subform would show the correspondent records from another table...