Search results

Hi It seems really clear to you but I dont understand where I could put that info.. I'm kind of new in all of this I added the "is null" part because I read it on the net that it could help me remove the condition if that combobox is set to null (has no values). How could I use that : Like...

I have tried to add the extra brackets but it didn't work as for the purpose of the comboboxes, what I want it that it will search all the data listed in the select section that has a correspondence will all the comboxes that have a value. It can vary up to 5 comboboxes. As said before the PO...

Thanks for the try I would like to post part of my database but the buttons in the forum don't work ... anyone has an idea what I could do or where I could find information on that? Thanks

The problem with this is that I need it to give me the result if there is one, two or more comboboxes that have a value or if there is only one and if I use a left inner I have a result but don't have anything in the Discipline and the famille field any other suggestions? thanks

Hi I have a form where I have 6 comboboxes and a subform that will show the result for the query. The query is pretty simple : get all the records that have one or more of the comboboxes value. the values are in 2 tables so I used a INNER JOIN. I have the 6th comboboxes that works as a...

I can't seem to find the line that creates the error Here's the code that I'm using and guessing by the result the error should be there : Private Sub cmdCopy_Click() On Error GoTo Err_cmdCopy_Click Me.sfrEstimationResult.SetFocus...

Hi thanks for the extremely fast reply I hadeed your code but keep gettting a "application defined or object defined error". I fairly new in vba so I'd like if you could explain my mistake thanks P.S. I'm not sure I know how to use your code so I just called it with : me.frmSubform.Form.Copy

Hi I have a Form that as a Subform (populated by a query). The subform query uses the values of the form combo boxes. I have a command button in the form that is supposed to duplicate the record selected by the user (The duplication is there if the user wants to add almost the same item but...

thanks it worked well

how to control check box Hi Here is another question. I have two check boxes and I want to be able to control them. As for now, when a Area is not in the list I add it with this code. Private Sub cboArea_NotInList(NewData As String, Response As Integer) Dim strSQL As String Dim i...

Set the OnLostFocus code Hi I have a question that I have been looking around on internet but can't find anyting.... Is it possible to set the OnLostFocus event code as I can do with the rowsource. Let me explain : I have some vba that will run in the click event of a combobox. in that event...

Delete fixed thank you very much for your help... I fixed it by myself... I think it's because I wasn't really putting the focus on the subform. I'm currently working on gathering the information from the tables so I can populate the subform. When that is done I'll be able to work on the save...

Deleting problems Thanks for your help Sorry if I didn't say anything sooner but I was busy on an other thing. The previous and next button work and I'm trying to do the delete button but nothing happens when I click on the delete button. I used this to delete but no deletion is done. I...

Hi I'm not sure if I'm doing it right but here you have what I want to do: (To help you visualize my form I've added the image of it) I want to control the record control through a command in the form. I would have a Previous, next command and a Delete. I also want to put an edit so I can...

First draft of database relationnship Hi Here you have the first draft of my architecture. I'm just wondering if that is not more the way I want to see it at the end than the table architecture. I would be more than happy if one of you could take a look and give me a hint on how to continu...

Structural help Hi Concerning the same projet I'm wondering if I should base my architecture on what I'm going to have in the report or on the information that will need to fill in the report. For instance, in the report I'll have the items listed like that : item name, Dia, quantity...

Hello to all of you I'm reading lots of your post to try to find a hint of how I could structure my database. But can't quite find something that will allow me to start in a structured way. Let me first explain what is the goal of the database and what it will be doing : The database is to...