Search results

how to change Access default error messages with custom messages? Like, if I enter some data in a sub form where the parent form is empty new record, default error message says that 'You must enter a value in the 'column name' field'. I want to disable this default message and display my own...

I know about False thing, but I was confused about converting Macro to VBA. Here I just called Macro from VBA after passing the NewRecord condition. It solved my problem, though initially i didn't get the idea. Thank you.

Thanks Paul, Me.NewRecord is a good idea but I don't know how to make rest of the code work in VBA. I only know how to use Macro's for now. I tried to use Convert From Macro's to Visual Basic, but something seems wrong and i see many 'Error$' messages in the code. I've written a Macro to run on...

I've a requirement where I need Before and After Update triggers to be fired when an existing record is updated, but not when a new record is inserted. My understanding is that for insert operations we've Insert triggers. Then why Update triggers are firing after Insert operation?? How to make...

You people are always helpful. Thank you )

I was only looking for the answer where such relationships as in last attachment are possible in a database, WHEN THE SITUATION ARISES. 'Stopher' understood when I'm looking for and I found the answer in first half of his advice. You've also answered, so i've got my answer. I'm at the moment...

Thanks for clearing up things on relationship diagram. Based on what is advised here, i've created a relationship diagram. This is first time i'm using multiple paths, does it look eligible?? I mean it isn't is providing any redundant information, or any other reason for it not being...

I tried hard to understand myself but I think I really need kindof help understanding the entity-relationship concept. I've been advised in one of the post earlier that there should be only one path to each table in ER process flow diagram and if there are more than one paths then design is not...

Thanks Bob, it sorted both my problems. I was under impression that we can not use SELECT against queries. I was looking to run the SELECT DISTINCT query for the RowSource value based on the value selected from another combo box. The size of the query was getting longer because of...

hi, My SQL query is longer than the maximum limit allowed by the Combo Box Row Source value. I also cannot use DISTINCT in my query when using as a Row Source for the Combo Box. Could someone advice how to get around these limits please?? Khurram

Thank you JHB, for pointing out my mistake... I thought tables will be fine to refer because anyways the pointer is on the current record set!! It works perfect now. Just a request, please remove the pasted image from your post. Access file was ok, but this is way too open. Thanks in advance )...

Thanks, but it is still not working. I'm confused why it is still not reading from form on focus. if I enter values manually, it gives the correct result, attaching screenshot. This is record # 29 in attached database above, but when I try to read from form it simple doesn't work and show all...

I couldn't find the filter, where is it please in the file?!

Thanks Galaxiom, if by current you mean the record which is currently open on my screen, then I'm trying to read from the current record but it is not working. I should be able to use the value in controls of the current record as per my information about Access so far, but it is not happening...

I sent an screenshot of a form, obviously it'll not work ) Ok, i'm attaching the Access file here. Nothing secret, so I can share the file. you'll see in form named as 'frmEmployee', there's a button with 'Update Query' icon. I just put it temporary to run the query. it is running...

Attaching file. Trying to select from the master form, one on top. Thanks.

I meant to say, I can read the values from Form Controls only for the new record while I'm entering data. But once I fill-in all the fields and save the record, after that I can't read it from Form Controls anymore. I need this for comparison with other tables/records. for e.g. Access can use...

In Access 2010, Under what conditions can we read values from forms please?? I'm trying to write query in which i want to find and update records based on saved record, but seems like Access is not reading values. I've opened the form and add a button to run a query, so the form is for sure in...

I mean entering a new record via forms. Ya, it worked. Thanks for help )

Thank you. One last thing please. What if I need to hide control on a new user form, like search box etc.? I've done it like this. Is this an ok way? If Me.NewRecord Then Me.cbxSearch_Label.Visible = False Me.cbxSearch.Visible = False Else...