Search results

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

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

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

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

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

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

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

Hi all, I am using Access 2007 and I'd like to disable right clicks on forms through a VBA code (not from the Access menue or other). If someone could help, I'll be grateful even after the incarnation of my little soul. Thanks in advance :)

Dear all :) I am using Access 2007. I am building a form, almost finished, but the last part sucks. I did a SELECT statement to bring a value based on several criterias but when I run it, it demands A PARAMETER VALUE. Here is the SELECT Statement : totprecsql = "SELECT...

Hi folks, I built this code to open a form based on 4 criterias but I have a problem in this line : DoCmd.OpenForm "frm_initiativesDetails", , , cond, cond1, cond2, cond3 When I do just one condition (cond for example) it works the message error is, I think it's a syntax error .. Full code ...

Hi all, I'm trying to use a WHERE condition that holds two conditions I succeeded to execute the first condition (teamName) but when I add the second one it doesn't work. What I want to do is to add this condition to the same code : [rsel_frm_viewInitiatives].monthActual='" &...

Hello all, I'm trying to open a form (frm_viewActuals) that contains a listbox (lbo_actuals) base on a two comboboxes (cbo_teamName & cbo_period) values in another form called (frm_filterActuals). What i'd like to do is to update the listbox in frm_viewActuals after clicking "Apply" button in...