Search results for query: *

Hi I'm having an error in this string Depense2 = DLookup("Sum(Depense)", "[C:\Documents and Settings\schiasson\Bureau\bd2].[" & Me!lst3.Column(0) & "]", "Maitre= IdEngagementA AND IdEngagementA <> '01-000000-BU'") The error is being cause by this part "[C:\Documents and...

Hi I wanna insert that in my table strSQL4 = "INSERT INTO Date850([Date], [IdEngagementA], [Depense]) " & _ "VALUES ('X','" & lst2.Value & "','" & txt2.Value & "') ;" The first value, X, is suppose to be the date of the day. Is there a way to get the date on the computer and insert it...

Hi I would like that when for exemple I pick the first row in a listbox, the first row in a second listbox is also selected Thanks

How can I include a graph in an Access Form. The graph would be using a table in my databse for his data Thanks

Hi I'm doing this Total1 = DLookup("MontantActuel", "Table850", "IdEngagementA='" & lst1.Value & "' ") Total2 = DLookup("Sum(MontantActuel)", "Table850", "Maitre='" & lst1.Value & "' AND IdEngagementA <> '" & lst1.Value & "' ") The first line (Total1) return a Null (which is causing me...

Hi I just got a really weird problem and I really don't know what is going on Here's the code that cause the problem Private Sub lst1_AfterUpdate() Dim Total1, Total2 As Long If IsNull(DLookup("IdEngagementA", "Table850", "Maitre='" & lst1.Value & "' AND IdEngagementA <> '" &...

Hi I'm trying to do a If that would check the database to see if the record that the user wanna create already do so I can tell him Here's what I have If (DLookup("IdEngagementA", "Table850", "IdEngagementA = '" & txt1.Value & "'")) Then txt1.Value is what the user is gonna enter...

Hi I'm trying to do a If that would check the database to see if the record that the user wanna create already do so I can tell him Here's what I have If (DLookup("IdEngagementA", "Table850", "IdEngagementA = '" & txt1.Value & "'")) Then txt1.Value is what the user is gonna enter...

Hi it's not really a technical question. Between doing query on the fly directly in the VB code or doing them normally and linking them to form on control after, which one is the best? Btw I'm talking 'bout query that would be used only in 1 form and not query that will be use on almost...

Hi I have a normal form called CreateId. Normally I use the menu i made to call it. But I need to call it from another form called EnterFee if a special case occur. I would like CreateId to be called as a pop-up instead of taking all the screen.. is that possible.. without modifying...

Hi I have a control tab in which I put a subform which his a control tab too. The second control tab has 2 tabs and I put a subform in each of them. The first tab (subform1)allow the user to enter a new ID for a new project as well as a couple of information The second tab...

Hi I'm doing a query on the fly lst3.RowSource = "Select Sum(Table850.Depense) " & _ "FROM Table850 " & _ "WHERE Table850.Maitre = '" & lst1.Value & "' " & _ "AND Table850.IdEngagementA <> '" & lst1.Value & "' ;" I assumed that since for Format you put () Sum...

Hi Is it possible to put a SQLstring I did in my VB code directly in a textbox?

I have a listbox linking to a certain query. I would like it to refresh after I add some information in my databse without having to close the forms or something like that I tried something like that Private Sub Form_AfterInsert() Me.lst3.Requery End Sub but it doesn't work can someone...

Hi Here's a query string I did: strSQL = "SELECT Table850.Depense,Table850.Disponibilité " & _ "FROM Table850 WHERE Table850.Maitre = lst1.Column(0):" what I would like to do is to add all of the Depense I will get together and the same for the Disponibilité. I found a way but it...

I have two textbox They both have almost the same code as each other as well as the 2 table (Table807, Table850) they take their info from When I do the calcul, the first box does it without probem, the second one.. instead of add the number put it one to next other.. meaning it prally take it...

Hi strSQL1 = "UPDATE [" & Me!lst1.Column(0) & "] SET MontantActuel = txt1.Value WHERE IdEngagementA = lst1.Column(1)" it create an error about a no definition for lst1.Column (the last one) somebody know what it is?

is there a way to Update a table selected by the user Exemple : the user select from two listbox 2 ID. (lst1, lst2) Then he enter a number in a textbox (txt1). Then I do a calcul so to substract the number in txt1 from the money that was linked to lst1. I do the same for lst2 but I...

I'm doing this : SELECT [Table850].[IdEngagementA] as Engagement1, [Table850].[Description] as Description1 FROM Table850 WHERE ((([Table850].[IdEngagementA])="00-000000-00")) UNION SELECT [Table807].[IdEngagementA] as Engagement1, [Table807].[Description] as Description1 FROM Table807 WHERE...

I'm trying to create a listbox from a select that pick up information from 2 different table in the same database As it should do.. the listbox put those 2 information in 2 row. Because of that when the user select one the other is selected at the same time but that's not what I want. I want...