Search results

Hi all, Can someone show me how we can hide / unhide with a command button: all forms, reports and modules from a database? Thank you in advance.

Hi All, I Need a help with a qry. I have 2 tables and they are connected by nID. The table 2 is made by previous qry. The first table have 200 rows and the second have 50.000 rows. Each one have a column named DiffA with double numbers like: 2,02 – 7,89 – 15,01 etc… I Want from...

Hi All, I am using the following filter on my form to see some results from a sub form when I press a button. ====================================================================== If Me.chkGrand = -1 Then varWhere = varWhere & "[GrandSyn] = " & str(Me.GrandSyn) & " AND "...

Hi All, Need a help with a UPD qry. I Have 3 fields. The names are: ISSN1, ISSNX and ISSN3. I want an update qry to delete the 2 from the 3 fields and make them null. The rule 1 is to keep the smallest number from the 3 fields. So let’s say we have ISSN1= 1,25, ISSNX =2,26...

Hi all, I have a table in a database with exactly the same data (double or triple data) but with different ID. Example ID - NAME – SURNAME 100 – JOHN – SMITH 252 – JOHN – SMITH 326 – JOHN - SMITH Please need a help to delete the double data and keeping the data order by the newest...

The 2007 Microsoft Office Suite Service Pack 2 (SP2) is here: http://www.microsoft.com/downloads/details.aspx?FamilyID=b444bf18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en

Hi All, I need your help with a form. I want to highlight always the TOP number from the screen. I Want RED BACK COLOUR AND WHITE NUMBERS. Only one field at the screen, the BIGGEST Number. Can somebody help? I have also a very sample DB to help me solving this problem.

Hi all, Need you help creating update qry or code. Here is the problem. I Have a table with thousands soccer results. I Want to update the FinalPoint of the table. We have 3 FinalPoints in soccer. Win – Draw – Defeat. So if, Home team wins then the result is: 1...

Hi all, I am importing data from XL file and then I create 50 new tables. Each table automatically creates ID. I am using ACCESS 2007 and EXCEL 2007. For some reason I do not want the ID. My question is this: How can I AUTO - delete the ID from each table. I do not want to do it...

Hi all! I have a column which has the values like below: 0-80 10 -11 10- 11 1 - 12 The field is text. I need to split the values in to 2 part and put into two columns without "-", eg: 0 | 80 10 | 11 10 | 11 1 | 12 How can we do it? I am confused... Thank you in advance...

Hi all, I have a simple form with a client name and some notes. (The field is memo) I have also a button called “Case complete” I need your help. When I press the button “Case complete” then automatically have that statement in to the notes. The problem is how can I do this when I have...

Three Numbers dif Hi all, I need your help solving the following issue. I have enclosed db with one table. 1. I want to make a query to show me the following results. For column ctA for example: I want the query to show me the differences between the three columns. To have at list >=...

Hi all. I need your help with a simple qry. I Have 500 files ascending by the day. Let say for example today is Wednesday then I want the qry to open the files connecting to Wednesday. That’s all. Thank you in advance.

Hi All, I need some help. I Want to fill the NULLS from the PREVIOUS fields of my table. EXAMPLE: ID – My Field 1 - USA 2 - 3 - 4 - GERMANY 5 - 6 - ENGLAND 7 – etc I WANT THIS: ID – My Field 1 - USA 2 - USA 3 - USA 4 - GERMANY 5 - GERMANY 6 - ENGLAND 7 - ENGLAND Any suggestion...

Hi, Need some help with my table. I Want to calculate the results from my table with all the possible combinations and to put them to another table. For example: tbl1 ID | Num 1 | Num1 = 2,15 2 | Num2 = 3,69 3 | Num3 = 4,85 etc I Want this to the table tbl2...