Search results

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

Where can I find the access2007 build-in calendar? Thanks.

Perfect - thanks so much.

I saved a report to another report name. When I open the new report in the design view, it shows the new name on the title (the window tab), but if I open it in the report view or the layout view, it still shows the old name, what was wrong and how could I solve this? Thanks in advance.

Thanks a lot. Sorry I'm not skillful at this. Do you mean a list box on the form? On the query, if I have other criterias could they be used together with the parameters? Another thing is, on the report aside from the part that was associated with that query, there are other text boxes that come...

Thanks, that's an excellent idea. But the user just wanted to select or enter the month, rather than enter the time range ( from, to ).