Search results

I found a solution. It may not be the best, but will work for this purpose. In the SUB form AfterUpdate event. Private Sub Form_AfterUpdate() 'call a function that calculate the new Grand total DisplayGrandTotal 'or requery the subform, if you use another subform to display the...

Hi guys, I've pulling my hair on this issue for a day now. I have a subform that can be filter using date ranges. When a date ranges is select, I get a subtotal on the subform; however, I want to keep a running Grand Total on the main form regardless if the subform is filtered by the date...

Yes, it is an ADP file. I also notice the the options under Office Button => Server => Link Tables is disabled. EZfriend.

I have an adp that was created in Access 2003, but now we are in 2007 version. When I open the adp file (connecting to SQL server), I can't seem to edit the report, queries, or adding more reports to the project. Everything appears to be locked. Have anyone seen this before? Thanks. EZfriend.

You can write a quick code to return all of the query definition into a text file or something and then from there, you can tell which tables/linked tables are used in the query. More information: http://articles.techrepublic.com.com/5100-10878_11-5047664.html

Perhap, you can run a macro to look at the value in each row of that column and then compare it to the previous value, excluding the first variable part.

Hopefully the function below will do the trick for you. As always, you will need to test it well and consider situation where two users to to add the record at the same time. Private Function GetNextNumber() As String Dim rs As Recordset Dim sSQL As String sSQL = ""...

Attached is a sample database to do what you need to do. It may not be the best solution, but it is one of the solutions. Peace out. EZ

You need the cbo.Requery to refresh the new data. See below. Private Sub CboEmployees_AfterUpdate() Me.TxtNI = Me.CboEmployees.Column(2) Me.TxtBand = Me.CboEmployees.Column(3) Me.TxtPensionRate = Me.CboEmployees.Column(4) Me.TxtPCT = Me.CboEmployees.Column(5)...

I am assuming that your sub-form uses a different query to pull the data. If that's the case, you can programmatically modify the query for you subform so that the correct information are being retrieved, Once that's done, just refresh/reload your subform.

Create a text box where you can enter the folder path then follow the instruction on http://www.blueclaw-db.com/listbox-directory.htm to fill a list box with all your text files. Once the listbox is filled with files, create a button to perform the import function above by looping through the...

Yes, you probably need a space after the WHERE clause; otherwise, your query would be something like WHERE## without the space between the word WHERE and your [Tbl_Section_1]![UniqueID] "UPDATE Tbl_Section_1 SET Tbl_Section_1.ProgUsed = " & Me.Lb_Programmes.ItemData(varItm) & _ " WHERE " &...

Are you looking for a directory searching? or just checking to see if a file/folder exists? If you are looking for a directory searching, I do have code that can loop through directories/files. If just check for file/folder existance, use the DIR$ function.

Try convert your DB to 2002-2003 format and see if that help.

This is what I use for export some records to an excel file. Hope this help. 'FORM - frmExportToExcel Private Sub cmdExport_Click() Dim r As Long ' row number Dim rStart As Long Dim rEnd As Long Dim objXls As Excel.Workbook Dim sFileName As String sFileName =...

filter the new form with what's in your list or change the form's control source (sql) so that it filters to just those in your list.

Did you add the ADO reference to your project?

You have 69 records because your query "qryRecordings" returns 69 rows. Really, your Record Source for the form "Recordings" should just be the table "Recordings" This will give you your 4 concerts (records). Linking the Master & Child ID for the subform is correct. Note: look at your form...

Look at the VBA for the attached db. It will give you the necessary code to accomplish what you need (See green text comments in the db). You will need to implement your current code to the database to get what you need. Please note that the database uses the ListView control to accomplished...

Sample database attached.