Search results

thanks for your help. However, Open event (or Load event) doesn't work, still show the error message without going to that event. Any other suggestion? Thanks.

Hi: My Access (A.mdb) application has linked tables which are located in another Access(B.mdb). If the location of the B.mdb is not correct, the application (A.mdb) will pop up an error msg: "Datebase Startup: Could not find file: "C\Users\correctPath\B.mdb", error Number: 3024. Can I trap...

Hi: I am trying to get a value when my report is open. (The report has a valid Record Source, and opens with valid data) For example: Private Sub Report_Open(Cancel As Integer) Dim sName As String sName = Me.CustomerName End Sub Why the Me.CustomerName is empty? Is it too early to...

Hi: Pat, thanks for your suggestion. The Select query looks like this: SELECT a.MB_RECNUM, Sum(...) AS ProblemPoints, Sum(...) AS DatePoints FROM b INNER JOIN a ON b.MAINTENANCE_ID = a.MAINT_ID GROUP BY a.MB_RECNUM; Can you give me some ideas how to make a changes so the Sum() value...

Hi: I am not sure if the update query let me using the data from another select query. WATERPIPE is a table, and qrySrcTable is a SELECT query. UPDATE WATERPIPE INNER JOIN qrySrcTable ON WATERPIPE.RECNUM = qrySrcTable.MB_RECNUM SET WATERPIPE.[Break Type Points] = qrySrcTable...

No, I have unchecked the "Dockable" of my Immediate Window, I can move the Immediate window around screen, but can't see the "Watch Window".

Hi: I think I adjusted " Watch Window " couple of days ago, now I couldn't bring that window up again. I tried: View -> Watch Window, but all I notice is: the whole "Microsoft Visual Basic" Window flickering but no "Watch Window" pops up. Any suggestion? Thanks James

Hi: I have a sql database as back end. I will install my MS Access .mdb application (front end) to each user's pc (about 5 users with 5 PCs). I am going to add a small local temp table in .mdb, say: tblTemp_Local, each user will have his/her own local table, it won't cause any conflict, am I...

sorry, I thought I figured out, but in fact not yet, any suggestion?

Hi: I have an Append query, the data are from a SELECT: So it looks like this: INSERT INTO tblA (colA1,colA2...) SELECT (qryMySelect.colB1, qryMySelect.colB2...) FROM (qryMySelect) qryMySelect is a query that get data from other 2 tables (tblX, tblY), if the qryMySelect runs a Inner Join...

Hi: From some links, I find RTF2 is better. So I downloaded from here http://www.lebans.com/richtext.htm, and installed it, restart my pc, in the Toolbox of Access form, you can find the RTF2 in the list. It works. Jt

Hi: I have a rich TextBox control, it shows on my form with the content, but it doesn't show in my report. I am pretty sure the control source is correct, because you can select from the "Properties =>Data =>control source". Can you let me know how to fix it? Thanks JT

Thanks PAUL

Thank you very much for you quick response. If I have an Access database, myAccess.mdb, now I link this .mdb to the sql server, so in the sql server can see the myAccess.mdb tables.... Can I do this: in myAccess.mdb, I will treat its tables as if they are located in sql server, I create a...

Hi: I am confused by the concept of "using Linked server for data access". (This is the article I am looking at, I don't know what is exactly trying to accomplish: http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/ ) My questions...

Woo, this is really helpful, thanks a lot. JT

Thanks, that works! The ".ListCount" is what I am looking for. Jt

Hi: I am trying to understand: CursorLocation Parameter 1. adUseServer 2. adUseClient 3. adUseNone (this is obsolete) From a book: "A cursor is a memory structure, somewhat similar to an array, Recordsets make use of cursors, and several different kinds of cursors are available in ADO" my...

Hi: I have a subform, and I have a recordset which contains data in it, now I want to populate the recordset data into subform, how can I do it, I have tried: Me.subformDetails.Form.RecordSource = rst or: Me.subformDetails.From.recordSet = rst All do not work. Thanks in advance. JT

Hi: thanks for your help. comboBox.rowsource doesn't work for me, may be because I set the comboBox Row Source Type = Value List. All I want to do is: delete the data in comboBox list, since the data is populated by using addItem method, so it won't delete any thing in the table. (the are not...