Search results

HI all I would like to be able to put the value "" in each field in my subform when I try to delete the record in the form...My form's source is a table and the subform has another table... Thanks in advance Myriam

Thank you Pat for the reply, but the problem is not there...I copy the same form but that works in my old db..and when I put it in the db that I use right now, it does the same thing...but it was working in the other database. Any other idea? Myriam

HI all Does it have a way to take off and replace the blank line that It have in the subform when it doesn't have any record in it? Because the blank line in my subform is not there anymore when I open my form. Does it have a way to make it appear again? Thanks in advance Myriam

HI all Does it have a way to take off and replace the blank line that It have in the subform when it doesn't have any record in it? Because the blank line in my subform is not there anymore when I open my form. Does it have a way to make it appear again? Thanks in advance Myriam

I have A report that have 5 fields. When the five fields have the same value..they make a group..But when one value of the 5 field is not the same, it change the group. Everything is okay for that. In one of these field it have 4 possibilities. And I would like to display it in the order...

I want that the user enter a value that already exist..and it have to exist...if it doesn't exist..I want to put a message for the user that he/she has to enter a valid value...But the message of access always appear after mine...and I would like to take it off.. Thanks in advance Myriam

HI all I would like to display a message and remove the access one...How can I do that? My code is like this Private Sub Combo77_NotInList(NewData As String, Response As Integer) docmd.beep msgbox "you have to enter a valid number" End Sub What should I add to take off the access message...

HI My field is a packet number and the user have to enter 5numbers with 1 letter..(ex: 11111a). I would like to be able to check if the user enter a "x" for the letter, whatever the number is... Could somebody give me some code? thanks in advance Myriam

thanks I guess that It's what I need but now, I need a detail..what's the event on format? Because my access is in french. Could you tell me when is it? is it when the report opening? THankX Myriam

Hi all I would like to put a blank where all value is = 0..is it possible? I read that yes, but It can cause some problem. How could I be able to don't have this problem? Thankx in advance Myriam

Hi there What i would like to do is to print a report when I choose the caracteristics in combo box. My database is about packet wood. I want to print a report that I can choose the lenght, the color, the kind of the wood (ex:mapple) and more..How could I do that? Thanks in advance. Myriam

the only thing that I want is to display another field in the subform when the packet_number already exist. I want to take this field in the table (the same then the packet_number) and display it in the subform. I don't know what to add in my code to do it. the packet_number is a text(5nubmers...

There is my code. The only thing that I would like to do is to display a field jointed to the same table of the packet_number. Everything is on a subform and I use Access2000. This field that I want to display is not the only one in the table but it's the only one that I want to display in my...

Hello I have a form with a subform in it. In my subform I have 2 fields (packet_number(text bos) and PMP) which are linked. What I want it when the user enter a packetnumber. I would like that the program check in my table if the packet already exist. (it have to) and if yes. I would like that...

Ok My problems might seem quite easy but I begin to learn access by myself. I use Access2000. My problems (because I got 2) are: I have a form with a subform (2 different tables). In my subform I have 2 fields: "packet_number" and "PMP" (that is linked with the packet_number) . What I want...

ok there is my code. I put it on a form to do a search with a button "search". The code is on click_event. So at the line with a * it give me an error with the compatibility of type. thanks to look at it. The field "no_conn" is numeric. I tried this same code in another form and the field is...