Search results

Hi, I have a small question here, hope someone can solve that I use expression on the query field, but after I run it, the field change its format from number to text, can anyone tell me how to reformat on the query criteria to change the text to integer format? Thanks

Hi all, I got a urgent situation here, Please help me out, Thanks! I have two tables, Table A: Year Type Count 1992 Walk 82 1992 Bike 43 1992 Vechicle 298 1992 Ship 3 1992 flight 3478 1993 Walk 47 1993 Bike 13 1993 Vechicle 638 1993 Ship 24 1993 flight 3111 1994 Walk 0 1994 Bike 8 1994 Vechicle...

Hi all, I have a report which based on a crosstab query, and I add a grouping by using the group&sort button on the design toolbar. The grouping is on one of my crosstab query row head. Now I want to export report to excel with each grouping as an individual worksheet in one excel file, which...

Hi dear all, can anyone gove me little help? I have two forms, one is for selection and the other one is fo display the result example of the display report form right now shows: year Area1 1993 Vehicle 5 1993 Train 6 1994 Vehicle 1 .... the Area and transport type are all passed from the...

Hi dear all, I have a query like below Cnt Type Time 1 TypeA 20/01 1 TypeB 23/01 4 TypeE 23/01 3 TypeC 14/02 24 TypeA 25/02 564 TypeD 12/03 116 TypeE 24/03 0 TypeB 15/04 27 TypeD 25/04 And I have a multiple listbox on my form to select type If the selection from the...

Hey guys! I almost raise my white flag with my project, I am a so bad programmer....... My code gives me bugs all the time and I hardly can fix it... Can any of you genius have a look and give me some advise or fix for me...PLEASE...THANKS..... Private Sub Zone_slc_AfterUpdate() Dim db As...

Hi All, I am very stupid on VBA coding:banghead: My problem is that I have a query which count the number of target field in my table,(if the value in the column represent once, the count is 1; if the value repeat 3 times, the count value is 3), then I want to develop a case select or anything...

Hi, I am working on write Sql in VBA and I want to save this query into a array table. Since I will change my Sql later,so the array size can not be defined now. I haven't done any code with array before, can anyone give me some example or hints on how to do that? Thanks!

Hi Dear all, I have Query A and Query B, and I want to insert a new column to A from the exist column in B, here is my code: "INSERT INTO A (col_3) VALUES (SELECT col_3 FROM B " & _ "WHERE A.id = B.id ;" Please provide me the correct way to do that, thanks

Hi All, I am working on my query criteria on VBA now but I keep getting the snytex error from my query SQL, can anyone check it for me? Thanks! strSQL = "SELECT weeks.Year, week_catch.Week, Species.Species, Species.SpeciesRef, week_catch.Catch, Area.Zone, Area.AreaCode, Area.TotalArea...

Hi all, I have a multi select list box called "Spc_Slc" and want to pass the selected value as criteria to the field called "Species" in my query. My form is called Catch_Selection, so after I built my list box with the RowSource from my original table SpeciesTB, I created a query with all the...

Hi all, just quick question this is my sql on VBA code Sql1 ="Select [SmallArea] From [AreaQuery1] WHERE [SmallArea]="NA";" I try to find any record in SmallArea that contain "NA", it give me the compile error of "expected: end of statement" Can anyone fix it for me? Thanks!

Hi dear all, I have a optional group with 3 buttons and one list box. my query has 4 fields: A1, A2, A3, A4. I want to know if that possible to show A1&A2 in the list box after click the optional group button1, and then if I click optinal button2, field A2&A3 will shows in my list box, and so...

Hi dear all, I have a Query now, and then I want to make the user to select the level of the data they want in my query, but if any data in the selection level is not available (which represent by "NA"), I want to write sone VBA code to push the selection to a higher level which do not contains...