Search results for query: *

Hi Rubbernilly, I love it it works nicely, I don'y know why we alway try complex thing when it is so simple. thanks, Froggy

Hi everyone, Here is my problem. I have created a database to store information on raw material stored in a ware house. Each class of raw material have a given expire date, and some of my user are messing up this vital information when a new raw is introduced. Have a starting form with...

Thanks it works like a charm. I'll use this function for many other application thanks again froggy.

Hi everyone. I'm a newby in VBA and I have been trying to do something for sometime without any success. I have 5 command buttons on my “main” form. All on them open the same “page” form only the subforms change depending on the command button clicked. On the “page” form the users manually...

Thanks misscrf, I've tried something based on the code you gave me which looked like that: Private combo1_AfterUpdate Me.MySubFormObject.Form.RecordSource = Me.Combo1 Me.MySubFormObject.Form.Requery End Sub but it is not working and the all link between Query/main Form and Subform...

I'm just working on that at the moment. look at this link it worked for me. http://www.lebans.com/mousewheelonoff.htm steph

Hi, I have a common form with only one subform box on it. I have 3 possible forms for this subform space. I would like to know if it is possible to open a given form in my subform depending on the information enter in my main form. E.g: if I select "car" in a combo box from my main form...

mguidry5, I'm using VBA for simple event, so I know how it works. However I'm still learning the art of creating a more complex application. that's why I need a bite of help with your solution. Thanks, Steph.

Thanks for the auick reply, - SuicidED -, I have tryied your solution, it is working but not like I want. Sorry I was not clear enough in my request. I would like this compulsory event to be triggered when the user is trying to print or close the form. - mguidry5 - sorry but I have started...

Hi, I hope that someone can help me with this one. I have a form that people fill up to enter information on suppliers; two text boxes must be filled up with information, supplier name and phone number How can I introduce such obligation? I want to make it a bite smart, with pop up window...

Hi Guys, Thanks for the help,sorry for the delay a was travelling all week anyway the code works like a charm. Thanks again Steph

Hi, Hope that someone can help me. I currently have a list box with a Table/Query linked with “easy search” application based on SLQ programme, which is working nicely at the moment. Table/Query SELECT DISTINCT [Globaltlb].[ID] AS ID, [Globaltlb].[Product] AS Product WHERE...

Many thanks for the thread, I ahve used the microsoft method, it works like a charm. Thanks again, Steph

Thanks Guys for the tips, Look at them this morning and come back to you later on. Steph

Hi Everyone, I have launched my database on Access 2000 a week ago, and someone noticed something unexpected. My database was developed to enter new materials on site. Everyone can have access to it and a “new record “ variable was used to avoid everyone to modify previous data’s, with...

Thanks exactly what I was trying to do. steph

Hi, I'm trying to run an SLQ with two conditions in a table form. The first condition is a normal txtSearchString application, but I would like to only display some of the d ata. the (simplified) code I'm currently using is the following: txtSearchString = Me!TxtX.Text strSQL = "SELECT...

Thanks Sim, Works exactly the way I wanted. Gave you a start for the help. thanks again, Steph.

I’m using access 2000, here is the prob I’ve got. I’m trying to create a field where a date will be automatically entered. My colleagues need to review the data every five years to check if not out dated. I’m using a =date() expression to set the date, and I’d like to create a field where 5...

Sorry to be a pain, can you explaina bite more in detail what I need to do. Thanks, Stephane