Search results

Gemma-The-Husky That Solved The Problem Thank You!

Hello DCrake I Changed the Private to Dim as you suggested Now I get a Type Mismatch Error. I've Pasted the Code back to clarify where. Dim rstEmployees As ADODB.Recordset Dim cnn As ADODB.Connection Private Sub Form_Open(Cancel As Integer) Dim intReturn As Integer Dim str As String...

Hello I have the following code to populate an unbound form. I keep getting the Error Message (Invalid Outside Procedure). Does anybody know why Option Compare Database Private rstEmployees As ADODB.Recordset Private cnn As ADODB.Connection Private Sub Form_Open(Cancel As Integer)...

Hello, I have a project in which I need to populate an already designed Excel form. I use an access database to store the data. I have created a query that assembles the needed data. I filter this data down by using a (StartDate,EndDate, and Project ID) Parameter. To make this easier to filter...

Hello, I'm trying to create a macro takes data from an access database record-set and fill out a form using this data. I get the record-set into excel alright I'm not sure about how to go about transferring the data over. I've enclosed the excel spreadsheet which has 2 sheets on for...

I Did Figure this out. I had an extra ( " ) in front of the second parameter (NumberWins, in this case)

Does anyone know if you can use 2 Parameters in a Dmin Function. For Example: Public Function ClosestToTiebreakerPoints(WeekNum As Integer, MostWins As Integer) As Double ClosestToTiebreakerPoints = DMin("TieBreakerPoints", "WeeklyCountWins", ("Week =" & WeekNum & ")And("NumberWins =" &...

Thanks JanR and JDraw I 'm thankful for both of tips you gave me. I do struggle with writing Longer SQL statements and you both have given me great tips for dealing with them. hascons

I'm having a problem with the proper syntax for a query Statement and I'm getting An Error 3075 Syntax Error. Sql2 = "SELECT WeeklyPicks.GameID, WeeklyPicks.Week, WeeklyPicks.Username, WeeklyPicks.Pick," & _ "qryCalculateScores.Winner, WeeklyPicks.TieBreakerPoints" & _...

Works Perfect Thanks Paul

I was wondering if it is possible to reference a textbox name property with a variable. I have a form that has 16 textboxes (txtHome-1 - txtHome-16) I was hoping to be able to loop through them and fill each textbox with different Data without having to specifically set all txtBoxes...

I was wondering if it is possible to open a treeview control expanded to a certain child node. I use a form(Form1) with a treeview control to make a selection which populates a subform (On the same form as the Treeview control) which is bound to a record from an access table. Some fields of...

Thanks jdraw this solved the problem

Can any one tell me the proper syntax for the Statement below: strSQL = "SELECT * FROM [Work Type SubCategory] WHERE [Work Type Category ID]= strCategoryID" strSQL is Text Work Type SubCategory is a Table Work Type Category ID is field in above table strCategory is Long ( this gets passed...

Hello, I am having problems getting a third level with a treeview control on a form. I can get 2 levels but I seam to be missing something. I've attached a sample access database with just 1 form and a couple of tables and queries. I'm hoping to be able to take the selected 3rd level node and...

Holger, Thanks for your help This does solve the error problem, However it only performs this task once. My worksheet has several months of daily data and i would like This sub to perform this task for every day (that has Data ). I'm never really used this find method but from what i've read it...

Hello, I have an excel list with (column A Blank) (Column B Date) (Column C Time) (Column D Activity) I'm trying to use the find method to copy the activity to column F At a time that is selected on another worksheet. Here is the Code: Sub Test1() Dim t As Date Dim r As Range Dim lr As Long...

Hello, I'm trying to update(create a Change Order) based on a table of Extra work items( Extra Log) for different projects. I use a form bound to (Extra Log) to easily enter items as needed. I Also use a check box to allow only those items that are checked.To print a change order on this table...