Search results

Thanks for the quick response. It it possible with Access 2010? Regards, Ben

Hi all, I still couldn't find a solution. I don't use any form. Just wanna color a column of a table using a condition. I got a table Test in my Access Database. How can I color column x red, when x < 0 and green when x > 0 . Is this possible? Thanks.

Hi all, I wrote down the following code: Public Sub TEST_Daily_ExportTables() Dim tdf As DAO.TableDef For Each tdf In CurrentDb.TableDefs If tdf.RecordCount > 0 Then DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, _...

Hello Mile-O, actually these are tables in my database.

Hi, there are three file belonging to a unit BP, QT or TEF. I want to export them together as REPORT_BP, REPORT_QT or REPORT_TEF. when I select an export file name and then export all these tables it will create tabs wihtin my selected export file name. But I want to let the user select a folder...

Hi all, I'm getting desperate here. I want to export files these files BP_SUMMARY,BP_fix,BP_var, QT_SUMMARY,QT_fix,QT_var, TEF_SUMMARY,TEF_fix,TEF_var. At first I want to select an export location and then I want to create files like REPORT_BP,REPORT_QT, REPORT_TEF REPORT_BP shall include...

Is it also possible in ACCESS 2007??? Regards, Ben

Hi Paul, I'm not sure what you mean with continuous form. I create a report in a Access database using a button in a form called BP. The report name is TEST. I just want to add a conditional formatting at the end, so that the USER can identify the issue records more easily. Kind regards, Ben

Hi all, how can I add a conditional formatting in ACCESS VBA? Let's say I got a table TEST with a column x. Is it possible to say color line green if x < 5 , color line red 6<x<10 and color line yellow if x > 11? Thanks in advance. Regards, Ben

Hi ino_mart, it is defined as double.

How can I change the format in VBA? The source table is created new each time I start the program. Regards, Ben

Hi all, I got a simple problem here. How can I change a number column in a three digit percent one? Tried the following, however it just deletes the content of the column: Public Sub TEST() Dim a11 As Double Dim year As Integer DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE DEPT_FILES SET...

Hi all, thanks for your help. I found this solution in the web: Sub TEST() Dim tdf As DAO.TableDef Dim fld As DAO.Field Dim rs As DAO.Recordset Dim i As Integer Set rs = CurrentDb.OpenRecordset("Quantity_022014") Do Until rs.EOF = True rs.Edit...

The column names depend on the reporting months, e.g. 012014. Furthermore some columns can be added dynamically depending on the selection of the user. Is there a way to loop through all columns and replace all blank fields of column with 0 ? Regards, Ben

Thanks for the hint, the problem is that I got variable column names. I need to tell the column names each by each in an UPDATE query, am I wrong? Regards, Ben

Hi all, I try to go throgh all columns and replace all blank fields with 0. Somehow this doesn't work: Sub TEST() Dim str As String Dim rs As DAO.Recordset Dim fld As DAO.Field str = "Select * from Quantity_022014" Set rs = CurrentDb.OpenRecordset(str) For Each fld In rs.Fields On...

Hi Cronk, yes I read the responses and divided the statement assigning the dlookup to x. x = DLookup("TNS_in_EUR", "TNS", "Division = 'COMMON' ) It tells me invalid use o Null How can this happen, is there a problem in Access with small numbers?

Hi all, I want to sum up specific records in a table called TNS. All records with Division = Common should be summed up to the records with Division = AK. TNS contaıns columns Division, 012013,022013...,122013 I tried following without success: Public Sub TEST22() Dim strSQL As String...

Hi all, can somebody please help me? Something is wrong with this dlookup in : strSQL = "Update TNS Set TNS_in_TRY = " & _ " Nz([TNS_in_TRY],0) + " & Str(a) & " * Dlookup([TNS_in_TRY],TNS,Division = 'COMMON' AND Product_Class = 'Scrap_Sales' AND Reporting_Month = '" & t & "') " &...

Is there some kind of container where I can put all columns I want to, then I could map the columns of table B with the available columns of that container ? Regards, Ben