Recent content by galantis

help anyone?

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.

thanks but emm, how do I enquote the WHERE clause to rst.open? rst.Open " SELECT [tblIntermidImport].[F3] FROM [tblCableSch] INNER JOIN [tblIntermidImport] ON [tblCableSch].[CableNo] = [tblIntermidImport].[F39] WHERE ((([tblIntermidImport].[F3]) Like " & """" & "*C*" & """" & "))", CurConn, , ...

Attached sample File Hi WyaneRyan, I have attached a sample of my database. My intention is to Append tblIntermidImport table into tblCableSch table, but if [tblIntemidImport].[F3] contains the letter 'C' (changes), I will need to find a match in tblCableSch using [F39] and replace it. If...

WayneRyan, Sql statment call works fine without WHERE clause. No, I am not connecting to SQL server, just connecting to plain Access. however, I need to select column F3 with anything that has the letter C. Copying and paste straight into Query QBE works find as well, so I am puzzled at the...

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

yes, Access automatically change from Like to Alike when I click on another row.

screen shots of QBE notice the keyboard cursor.

Uncle Gizmo, I ran the query in the Query Window/QBE. In the criteria row, I typed 'Like "work*" ', and it automatically change itself to Alike as soon as I clicked to another row. I also exported the table to another database which I build myself, and it does not change itself to ALike, so I...

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