Search results

Ya k it's because [from Microsoft] This includes Microsoft Access database engine errors, but not run-time errors in Visual Basic or errors from ADO. I just don't understand why some people give this as an example and everyone seems to say it works while it doesnt.. uh uh.

Hi folks! I have a question about the Form_Error sub... I need to do some error handling and this sub just doesnt work.... It never ever pass inside even when some errors are thrown... Anyone has a clue why? :banghead: Private Sub Form_Error(DataErr As Integer, Response As Integer)...

As CJ said, you have to call it this way: me.mySubForm.Requery

Nah, as stated by vbaInet, it's pretty hard to do what you want. You could try to make sub longer than my arms and it still would not fit perfectly what you want. You can try, but you'll waste lot of time for poor results. :S EDIT: You can still take a look here, someone was trying to do it...

Hi Not sure this is what you want to do but: That change the width...

Oh well I never intended to use another source of data than my Access Database. I'm very sad but...:( sprdsht.ActiveWindow.ViewableRange = "A1:B5" sprdsht.Names.Add "ARangeName", "A1:B5" MsgBox sprdsht.ActiveSheet.UsedRange.Columns.Count The Names.Add does work... but for the UsedRange...

Earlier this morning, tried to dig out a bit of listview. Major problem of this control is that only the first column is selectable. Also, it seems you can make it "editable" but I didn't manage to make it work (and I'm not going to waste my time on it since only first column can be worked on by...

Same here ahahaha! I'm more oop than anything else! VBA makes me cry! :P I've read on the forum of iGrid that it does not do the job of a datasource. So no, I guess if you edit the datas, it wont do anything unless you make an update on "AfterCommitEdit" event. And truely sad because if I...

Long search of 2 minutes: no it can't be bound to a datasource. :( But you can add a sub: Private Sub iGrid0_AfterCommitEdit(ByVal lRow As Long, ByVal lCol As Long) And force an update of the edited data every time a data is changed. Else, works only with recordset. Well still, it's faster...

I didn't look in dept about listview because I thought it was read only. Can a user actually write on it like a datagrid? Spreadsheet you can use it for more than just viewing excel files. You can work it the same way as you would do in Excel vba: write/read cells, let user input (or not) or...

Have you an On_load sub on the form frmAddKeys to get the parameter and load the data? EDIT: could be OnOpen maybe better for you. Retrieve arguments you've passed this way and then tell him to load the data else it wont do anything! :) someVarOrField = Me.OpenArgs

Hi again, I found we can set the viewable range in the options of the spreadsheet control. That is very nice but... can we do it using VBA? I can't find a damn method for this. All I'm trying to do is change the range dynamicly based on my needs. Then this is my "more advice than question"...

Ahhh. I tried creating a new object but didnt got the ref the good way. It worked. Oh god I can't believe took me so long to figure out such a simple thing. Hard come back into Access 2013. I barely remember that Access 2003 I've did 7-8 years ago! Woop. Many thanks buddy. Have a great day :D

Hi folks, Having some troubles with ActiveX controls. I tried with many of them as the "Spreadsheet" or the "Listview".. I add them to a form, go into VBA on a "form_load()" sub and try to use them. Problem is when I type their name and then use the "." to get their properties, I don't have...