Search results

Hello, I am using Datasheet view when displaying my data. The data are displayed in a "x,y" matrix wherein data can be directly edited in the Datasheet. Anything inputted in a certain cell is directly updated to DB. I want to open the Form, input data but WILL NOT COMMIT then close the Form...

Hello, Once again, I need some advices from the Access Gurus here. I have a list of data. Please refer to sample below: I need to edit from x1y1-to-x3y4 cells. (yellow cells) It's like editing multiple cells in one view. Editing the items will be faster when done this way. What is the...

i stumbled on this 7yrs-and-counting post... shacket is right to check the VB Help on UBound and LBound... since i already checked the VB Help, oh well, will post the UBound here... ====================================================== UBound(arrayname[, dimension]) The UBound function syntax...

it took me some time to figure it out... the catch here is "only the first line has a name" making the rest(blank) a PrimaryKey as well... thus, having 2 or more primary keys...yey! :) a post made almost 3 yrs ago is a post still brand new... :D this really helped me a lot! thanks Pat...

nevermind...i thought it will take me long time to figure it out... :D sharing my knowledge: With oXL .Workbooks.Open (sXclFilePath) .Workbooks(sXclFilePath).RunAutoMacros (xlAutoOpen) .Application.Run ("ErrorCheck") .Workbooks.Close End With :cool:

Hello once again... I made a function in Excel. The function does some error checking within the Excel file. To be easy for me, I want my code in MS Access to simply call the function in Excel. I check this MS Support site: http://support.microsoft.com/kb/198571 I tried calling my function...

Thanks for the reply jzwp22. The data type is already "Number". But still, it isn't working. I think the listview can't recognize if it's numeric or alpha. Even if it could, seems like the sort function of listview is for alpha only. I prefer to use the control's function to have a fast...

Hello, I am currently using Listview control. The sorting feature of the control is useful. <ListviewCtrlName>.Sorted = True <ListviewCtrlName>.SortKey = <FieldToSort> <ListviewCtrlName>.SortOrder = <SortOrder> It sorts well with Text type but is weird when sorting Number Type. :( Ex...

Hello, There's a freeze pane function in datasheet but for horizontal scroll only. How about for the vertical scroll? I need to implement this to be able to view the total data of each column by scrolling up and down but maintaining the view of the total data. Calling all the Access gurus...

Works like charm! Thank you, LPurvis! :)

Hello LPurvis, I am now using the Datasheet. I can edit data which are unlocked columns and cannot edit to those which are locked. But the user can add new row data in the bottom part. How to disable this? Hope you could still help me on this.

Hello LPurvis, I think I now know what you mean. I tried playing some of the properties of the Datasheet. I enabled Locked to one of the columns and in deed they are uneditable. Currently, it is just difficult for the user to determine which one is editable and which is not. Guess I have to...

oic...you mean I'm going to have many Datasheets? Editable columns will have their own datasheet while uneditable columns have different datasheet. Going to lock the datasheets which are uneditable. Is this what I should do? If there is a better way to do it, how?

Haven't tried using it as a Subform but I seem to know the display. It is the same as the display of the database. But in the Datasheet, all cells are editable. I want specific columns (only) to be editable. The rest are uneditable. Is it possible for Datasheet? If not, is there any way to...

Thanks for your reply, LPurvis. Seems like the listview control cannot do the job. I researched the other day and stumbled to what you said. About DataGrid or FlexGrid. I tried checking in my MS Access 2003 and got none of those. There is nothing in my References. How can I get these...

Hello, I am back and got a new question. I have various data to be displayed in a table. I think a listview will do. I want to edit the value of a certain cell (column,row). The process is done by clicking the cell first then edit. Is this possible? :confused: I searched the net but...

hehehe... i noticed something... AprileC is super... She's always online. Is she really like that? Or is she a bot? (You may disregard these un-technical questions)

yes, it worked well. already got it last month...hehehe! anyway, thanks for your reply. i didn't replied to this thread anymore coz nobody's noticing it already. But thanks for giving time to find the solution. :)

Re: SOLVED: How to set un-editable column in Listview? I now know why setting the properties of ListView control in VB Editor doesn't work. It is because the ListView has its own "Property" setting. :eek: The pre-defined Property Setting link is the "Properties". But the ListView's link is...

SOLVED: How to set un-editable column in Listview? I finally got it! :) I added this setting: lstvwXclList.LabelEdit = lvwManual Changing this property in VB Editor seems to be buggy. No matter what value I set, it always reverts to its original value. (weird) I also tried implementing...