Recent content by fanfan2

Thanks for your comments. Actually I just want to find all the errors and display, I wouldn't correct those as someone else will have to go through the errors base on the original files - there's no "pattern" or "rule" to correct them. I agree I should make triggers to catch errors at the data...

Sorry I didn't get it... In my case in order to find the errors I have to use a loop to go through the recordset ( can't do it with a simple select statement). But this way I can only find errors one by one, which is a pain. I wonder how I could display all the errors at once. thanks...

I have the following: Do While Not recordSetx.EOF if <condition> then msgbox ("error" & error) end if recordsetx.movenext loop This displays the error messages in hundreds of small message box windows one after another, I have over 1000 errors, is there a way that the error...

thanks so much, problem solved:)

I have the following code: Private Sub Command6_Click() Dim curDatabase As Object Dim rstSheet As Object Dim hIDN As String Set curDatabase = CurrentDb Set rstSheet = curDatabase.OpenRecordset("tblSheet") rstSheet.Movefirst Set hIDN =...

it works now! thanks very much.

Yes I did save the code window, and it was "event procedure". I'm using version 2010. So how can I make sure it's trusted location? It is on my local machine. Thanks.

I have a basic question: I have a button in a form, right click on it --> property --> event -->on click, then on the VBA window, I had: Private Sub Command7_Click() MsgBox ("test") End Sub then I saved everything and went back to the form, click on the button, nothing happened. Did I miss...

I'm so confused about scatter chart in access. It is very easy to create in excel, but in access things look very different. I have a query that includes x and y columns, I'd like to create a scatter chart on a form that use x column as x axis and use y column as y axis. I'm using access...

I tried this but don't know where the saved file is...how can the user choose the path where to save the file? thanks.

I exported the db with the TransferSpreadsheet method, seems like I have to specify the file path when writing the code. Is there a way that the user can be prompt to choose the file path where to save the file? thanks very much.

I use access 2007 on windows xp. In access have over a 100 linked tables to SQL Server. I want to run a micro to download selected tables into local machine, either to the same access file or a different access file. any help will be appreciated.

Sorry the table didn't show clearly in my previous posting, now file is attached. Thanks.

I have the following table, I would like to group by ID and if there are consecutively same code, group by them, then pick the minimum valueA and maximun valueB within the group. I couldn't make it work, because if I group by ID and then group by code, then it picks all the same codes within the...

I found the calendar contol. Now I want to be able to click on the calendar then opens a query with the date as the criteria. On the calendar control property, I set the event "on update" to the query name, then in the query criteria I put "[form]![frmName]![CalendarControl].[value]. But it...