Search results

Thank you! Could you please give me an example applied for this one: textSQL = "DELETE * FROM tbl_temp WHERE userName='" & wUser & "'"

Hi dear all, I have this complex query and all is working fine. Public Sub refreshTemp(wUser As String, wTeam As String, wMonth As Integer, wYear As Integer, wInactive As Boolean) Dim textSQL As String Dim db As DAO.Database, rst As DAO.Recordset, Qdf As DAO.QueryDef Dim wInit As Double...

I think that it is actually Next instead of Loop.. I tried it, but still have the same problem, it stops on 14 :(

Hi dear All, Thank you for advices, but that is not the issue :) I am using reserved words just in the forum to simplify. Here is my code and it is working, it loops trough the assigned teams to each user. i = CLng(TempVars!lboCount) Do Until i = -1 OpSQL = " SELECT...

Hello Dear All, I have a multi-user database where each user has its own perimeter (Team). I am tryin to run a select statement that runs on several times based on the teams assigned for the user. Here is the select statement: OpSQL = " SELECT tbl_temp.type, sum(tbl_temp.value) FROM...

Thank youuu ! You are my savior :)

Thank you Arnelgp, I think that this code copies just one record, I would like to do as the first code I had (Copy all rows when ID=MyID). Is it technically possible?

Hi Dear All, I have this code that copies a table content on the same table changing ID (Thanks to Arnelgp who helped me with this). Set rs = db.OpenRecordset("tbl_Vals", dbOpenDynaset) lngCounter = 1 With rs...

Hello The_Doc_Man, Thank you for your response, I resolved it and my solution was the same as yours. The Type field is just an exemple for the forum, thank you for the advice :):)

Hi All, I have two tables: table 1 and table 2. I have the same set of data in each one. As a data I have team, type, month, year and averageValue I'd like to know how do I run an sql update query that can update Table 1 with Table 2's averageValue using team, type, month & year as a...

Not the main ID of the table but another related ID.

Thank you Arnelgp, you are a hero ! I have one more question if you don't mind. I'd like to copy just the data where ID = [comboboxID] Thank you again and have a great day :)

Hi arnelgp, thank you so much. I didn't try it yet, but does it update the id too (new IDs with no duplicates)? Because I didn't get the syntax.. Thank you again !!

Hi dear all, I am working on a project using Access 2007 and I'm looking for a method (If that exists) that allow to do a bulk copy of records on the same table (>200 records). Another issue, the IDs are not AutoNumber and should be updated too when doing the copy to avoid duplicates. Thanks...

I solved it! For those who may experience the problem: Split the database and put the front-end in the user's local folder & the back-end in the network folder => Gained up to 70% of the processing time :)

Hi Ranman, thank you for your response. I finally found the source of the problem: The programm is located in a network folder. But I can't solve the problem :( I am forced to place it in this folder .. If there is a solution that could speed up the program just a little bit I am a taker...

Hi all, I'm having an issue with my Access project. When I close a form it takes pretty much time to execute the command (up to 50 secs). When I close and reopen Access it works perfectly.. but when opened more than 30mins then I have the problem again. I have no problem with my code which I...

Or you can just use the MouseUP & MouseDown events where you include the height & width of the images. Here is a sample: Private Sub yourImageName_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) Me.yourImageName.Height = 500 Me.yourImageName.Width = 500 End Sub...

Thanks guys, Arnelgp's solution worked perfectly :)

Hi All, I am trying to center the content of my listbox. I did the tour of all forums, but found nothing helpful.. I want to center the columns individually (because there is some of them that i wouldn't them to be centered). The problem is that Microsoft didn't make it native to center a...