Search results

Hi, I am still confuse after reading threads on producing running sum on queries. help! This query is to produce a time line graph of Progress Tasks with 3 main categories - New, Completed and Outstanding. So I got months on the x-axis and count on the Y-axis. sample data. say we look back...

Hi, I just upgraded my access database to SQL server backend. I have manually redefine primary keys and indexes in SQL server that matches the table structure in Acess. Now I am having problems with the primary key been autoincremented instantly. In one of forms I link the primary key - ID...

Hi, I am having problems importing data from Excel file. what i am trying to do is to cycle through the individual sheet in the worksheets. I insert the name of each sheet into the MS Acess table to identify which sheet it belong to. It looks like it is cycling through the sheet but it is...

Hi I am wondering if there is a way to unfilter stage by stage. For example you apply 3 filters using the Filter by selection button on the toorbar and instead of unfiltering all 3 filters all at once, I want to remove filter one by one back to the beginning. thanks. Galantis.

Hi, I need help with my select statment. I can't seem to select any rows when using wildcards embeded in ADOX statement. Can someboyd help me? Set rst = New ADODB.Recordset rst.CursorType = adOpenDynamic rst.LockType = adLockOptimistic rst.Open " SELECT UCase([F3]) AS Cap...

Hi, I have a problem to solve, Table1:InitialMeasurement No Quantity 1 12 2 34 3 45 Table2:FinalMeasurement No Quantity 1 45 3 77 4 67 Table3:CombinedMeasurement Index Initial Final 1 12 45 2 34 0 3 45 77 4 0 67 how can I join table1 and table2 to table3? Many thanks...

Hi, I was given a Access database to test. and I trying to find out why my query will swap 'Like' statement to 'ALike'? e.g SELECT DOCUMENT.TITLE FROM DOCUMENT WHERE (((DOCUMENT.TITLE) Like "work*")); will automatically updates itself to SELECT DOCUMENT.TITLE FROM DOCUMENT WHERE...

Hi, I have a form which I can't seem to filter by form. When I click on "Filter by Form", the only combo option I get is "Is Null" or "Is Not Null", it does not give the full list in the table to choose. Can anyone tell me what's wrong with my form? The form also has a sub-form....does it...

Hi, help! I have problem to solve. I have a table which gives Module, Site CC, Description,ContractHrs,Quantity PR06,5110000,1" XS CS,0,0 PR06,5110001,1" SCH 160 CS,0,0 PR06,5110002,1" XXS CS,0,0 PR06,5110003,1.5" XS CS,0,0 PR06,5110004,1.5" SCH1 60 CS,0,0 PR06,5110005,1.5" XXS CS,0,0...

Hi, Sometime when I delete a record on a form using the wizard delete button and I move between records, #Deleted record shows up in the fields. Can anyone help me in getting rid of it? or why is it ocurring? Also, I am getting error "2455 : You entered an expression that has an invalid...

hi, I have posted this up in the Forms section but received no reply so I'm going to try it here. I am trying to work out which Tab is current been viewed/opened. My button does differrent thing depending if Tab 1 or Tab 2 etc is current been viewed. thanks. My idea so far (which doesn't...

Hi, Sometime when I delete a record on a form using the wizard delete button and I move between records, #Deleted record shows up. Can anyone help me in getting rid of it? or why is it ocurring? Also, I am getting error "2455 : You entered an expression that has an invalid reference to the...

hi, I am trying to work out which Tab is current been viewed/opened. My button does differrent thing depending if Tab 1 or Tab 2 etc is current been viewed. thanks. My idea so far (which doesn't work is): The first statement is also true. Private Sub cmdPrintModule_Click() Dim tbtab...

I am having trouble return the result when I code the SQL statement in VBA, but if I copy and paste the SQL straight to Query design it return the correct return. Using ADODB, it gives me "S0" but Query Design gives me "01" My table is SiteCC 1921001 19210S0 and I want to return "01"...

Hi, My SQL is not really good, I have a table with Name AC01 AC02 AC03 ACS0 ACS1 I would like contruct a SQL such that it returns the highest number excluding the S*. I thinking along the line of Max(Right(Name,2)) and using Not Like "S*" and maybe using a subquery? any help will be...

Hi, I have a problem, and I am not sure what's the best way. My query using Sum, and GroupBy that produce a result of Name, Quantity, Price, Type AC32, 755.95,13698, LM AC32, 320.89, 1736,EA but I would like it such that, Name, Quantity(LM), SumOf LM+EA, AC32, 755.95, 15434, Is that...

Hi, I am wondering if anyone has worked on a reporting form which allows the user to save it as a custome report form for future re-use? For example, the user has selected certain criteria for printing from the reporting form and would like to save this setting for future re-use. So they do...

Hi, I have a parent window which upon clicking on a button will pop-up a child window containing a listbox. The listbox recordsource is a subset of the parent window. I want the user to select a record from the listbox which will load the selected record onto the parent window. How does one...

Hi, I am a newbie to SQL and MS access, and from I can tell, it's a simple join question. Can anyone please help me with this question? Table1: Name, Type, CurrentWeight,CurrentAmount AC31,Air Coolers,141.606, 299,721.44 AC32, Air Coolers, 338.494, 52,117.57 AC34, Air Coolers,90.238, ,765.439...