Search results for query: *

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

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

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