Search results

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

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

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

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

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: I added some data into a comboBox: Do Until rst.EOF Me.cmboProduct.AddItem rst!ProductName rst.MoveNext Loop How can I delete them by using VBA code? (I need refresh the list items). Thanks JT

Hi: I can add data to a combobox if there is only one colum in the combobox, now I am trying to add data to a two colums combobox using VBA code, but I keep getting this error: Run-time error "6015', can't add this item, the index is too large, here is the code: Me.cmboCategory.ColumnCount...

I have no experience using MS Access to interface with MySQL. I have a tiny MySQL database that might need to have Access connect with it over the internet and grab data/update etc. Is this practical and what does it take to do it? My project is not time sensitive but I'd like to see what...

Hi: Haven't use MS Access for a while. I just create a query called qryAppendDate, how can I call in my vba code. Something like: docmd.runquery ???? ( I created the query by using "Create query by using wizard"). Thanks JT

Hi: Previouis developer didn't put comments on below Sum function, so I want to understand this totally before I do any modification, here is the code: Sum(IIf(DateDiff("d",[Date Entered],[MaxOfDate Entered])>15,1,0)) AS [More than 15 Days] My questions are: 1. The "Sum" is adding all the...

Hi: I have a listbox, and a recordset (DAO.Recordset). If I clike a button, and go through the code line by line, the listbox can show the result: when hit the line: Set Me.listBoxResult.Recordset = rs However, if I don't go through the code line by line, just click the button, it just won't...

Hi; I have created query: qryNumProudcts. It works fine. Now I want to call this query, what is the syntax for this, by the way, since the query will return a number, how can I get this value, also, do I need create action query? Thank you very much, JT

hi; I have a recordset which contains some data, now the recordset is there, I want to add those data into a empty table. I can use "while loop" to grap the data from recordset row by row and add to the table, until .EOF is true. I am think if it is possible that I can copy the recordset and...

Hi: I have a query, I will add a extral coloum expression like: % of Boys: ([numOfBoys]*[numOfTotal])/100 Now I want to show the result like this: % of Boys: 30% 40% ... I want add the sign of " %" hehind the number. How can I do this? Thanks JT

Hi: I am trying to insert a Excel Sheet into my MS Access 2003 form, I find this link to tell how to do it: http://msdn.microsoft.com/en-us/library/aa190078(office.10).aspx But after I add the Excel sheet small icon to my toolbox Window, it grey out, I can't select it. Would you please let...