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

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...

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

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

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...