Search results

Poppa Smurf, In My first example I Dim the rstEmployees in the Global variable Section (The Very Top), I always do this when i run several different subs or functions that will use the Variable. I do this With Either DAO or ADO. In This situation I got this working using DAO recordset. For...

Update: I Created this same procedure using a DAO Recordset and it works fine. Does anyone know why this won't work with ADO. Below is the module I used with DAO .(This Works) Private Sub ClearcboEmployee() 'This sub will be used on the btnSave sub Procedure Dim rstEmployees As DAO.Recordset...

The net 2.0 I found a class Module that i was able to incorporate into my project. It does help but I do agree that much of what i've done seems to done easier with DAO. I was experimenting with splitting my database and thought that ADO was required to communicate between the 2 databases...

Jal Thanks for your response. I changed this procedure to DAO and it works fine.

Mstef, I was able to figure this out using a DAO procedure to add the records. Thanks for your response

Hello, I have an estimating database. Which generally gets data from 4 different Tables. I Have a form with a Bound main form and 3 Bound subforms to get this data This has been working well. There are times that I need to create an Identical Estimate for different customers. I now manually...

Bob, cnn is a global variable used to establish a connection on every form in my Project. I Get the connection through a class Module, on the form Open event. It remains open through the life of the form and all objects and recordset are closed and set to nothing on a Form Close Event.

Hi Bob [BidWorkTypeCategoryID] is a number Field. I'm populating a TreeControl with the recordset. I can use a designed query and this seems to work fine. I just like to create a SQL Staement in code if I only need the query for 1 specific purpose. I Cheat and build a query in the designer...

Hello, I'm getting an Error ( Error in From Clause ) with the following Statement: strSQL = "SELECT * FROM [Bid Work Type SubCategory] WHERE [BidWorkTypeCategoryID]= " & strCategoryID Set rsN1 = New ADODB.Recordset rsN1.CursorType = adOpenKeyset rsN1.LockType =...

jal, This sub is called from a cmdSave Sub, Right after the records are saved to the underlying table, I clear the form and then call this procedure to try and reset the cboEmployee ComboBox.

VbaInet, I'm Using ADO recordset, ADO does not require the Edit statement before updating. The code above does set the selected employee field (EmployeeTemporaryInactive) to true.I can manually check to verify this. If I close the Time Card form and then reopen the Employee is removed from...

VbaInet, Here is the sql statement SELECT [Employees Extended].EmployeeID, [Employees Extended].[Employee Name], [Employees Extended].EmployeeRateClassID, [Employees Extended].EmployeeDateTerminated, [Employees Extended].EmployeeTemporaryInactive FROM [Employees Extended] WHERE ((([Employees...

VBAInet, Yes the True/False field is a Yes/No Datatype

Poppa Smurf, The ComboBox recordsource is a query and currently the (EmployeeTemporaryInactive) Field is set to false to filter out just active employees. One more item, An Active employee in my table is one in which there is a Field (DateFinished) is Null. So my query checks that both...

Hello, I have an unbound Employee Time Card form that Inserts many records at once. I use a combobox to display the active employees. I'm trying to create a macro that would set a true / False field to true (in Employees table) after this employees records have been added. Once the employee...

Hello, Just Wanted To give an update. I did figure this out. The Line: rstSuppliers.Find strCriteria, 1, adSearchForward Should have Been: rstSuppliers.Find strCriteria, 0, adSearchForward The 1 was causing the record to skip the first record.

Thanks Guus2005 for your response, However I had tried that after I posted here, I did figure the AfterUpdate wpould be more appropiate. This however did not solve the problem. I 've added a BOF check before running the search but this also does not seem to solve the problem. I've reposted the...

Hello, I have a form that uses a combobox filter. it works for all the records except the first record. When I select the first record I get an error message..(Either BOF or EOF is True. I would assume that it would be true as the record selected is the very First One. I have played around with...

Hello, I'm experimenting with splitting my access database and possibly using Vb.net or other as a front end. I have begun updating my forms to unbound forms and populating,adding,deleting etc.. with them using ADO. This has gone well and all forms are working properly. My question is that I...

Hello, I've created an unbound form to for experimental purposes. I have navigation buttons to move to first,last,next,previous. I get an error message if I'm at the last record and hit the move next command button. I've been experimenting with EOF and BOF if statements But I keep getting the...