Search results for query: *

Thanks LS, Actually, what i like to do is to access this MDE file from other programming tool, like ASP.NET, to retrieve the local table values. Yes, you are right, shouldn't be in this VBA Forum. But... zqi

Hi, We have Access 2000 .mde file installed on user's machine. There is a local table, tblTABLE, in each of these mde files. Is that possible for me to access this tblTABLE from outside and grab/export the record (only one) values? Thanks in advance.

Hi, All, I need a kind solution to put the SQL Server Port number (2434, not default 1433) in my coding: Set dbCurrent = CurrentDb For i = 0 To dbCurrent.TableDefs.Count - 1 Set tmptable = dbCurrent.TableDefs(i) If tmptable.Connect <> "" Then tmptable.Connect =...

thanks Rich and VB. I finally create a Local table with a Yes/No field to store the datasheet data, and manually process after user finishes. Zhong

Hi, All, I have a frmMain, on which has a tab control with one subform on each tabpage. The frmMain has the standard navigation button to browse the records. The Subform is in datasheet view of the child records of main form. The question is that if the user getfocus on the subform, and then...

Hi, What i am trying to do is allow users to process multiple records in a subform at one time. Is that possible to highlight(select) any multiple records in a subform? if so, how can i retrieve one by one. I try dim the subform as a control ctlfrmSub, but ctlfrmSub.itemselected doesn't...

I like to create a report (rptParent) with grid lines to separate their components (from sub reports), like the following format: subRptA-ID| subRptB-ID| subRptC-ID| subRptD_ID| subRptE-ID ----------------------------------------------------------- subRptA-DI| subRptB-DI| subRptC-DI|...

Hi, I am working on a regular form, and try to prevent the user's wheel mouse from scrolling the records. Any suggestion or comments on this? BTW, i try to do search on this forum today, it seems not working. Any clue about that? Thanks in advance, Zhong

Thanks Rick. I use Access 2000, and did accomplish the job via Conditional Formatting, although some check boxes' backcolor can't be changed on the datasheet view. I appreciate your information. Zhong Qi

Hi, all, I am experiencing a trouble in changing the color (backcolor) of each row in a datasheet subform. Here is what i want to achieve: I have a subform w/datesheet view on the main form. This subform is editable directly from the table records. The main form has no recordsource, but some...