Search results

The following steps can all be done programatically. I would suggest learning how to do all of them and then include them, in succesion, in a Sub Procedure somewhere. 1. Export the table to a remote (temporary) database Use an sql append query (remote location) 2. Compact/Repair the remote...

A form is not a Recordset.. Recordsets are either queries or tables. If you want to use your form's recordset try this... Set rst = Forms!YourFormName.Form.RecordsetClone Instead of this.. Set rst = db.OpenRecordset("YourTableQueryName", vbOpenDynaSet)

pm

Is there any specific issue that you are having?

Dim db As DAO.Database, rst As DAO.Recordset, recNum As Integer Set db = CurrentDb Set rst = db.OpenRecordset("YourTableQueryName", vbOpenDynaSet) rst.MoveLast rst.MoveFirst 'Populate the recordset recNum = rst.RecordCount 'count the Records MsgBox recNum

Is everything peachy??

Rick, I changed the RecordSource to Have the criteria DeptNumber = Forms!MainForm!DeptNumber. And then it was necessary to Requery the Form in the event that DeptNumber had been updated.

Rick.. tblDEPTHEAD and tblEMPLOYEE are now obsolete. You had a bunch of employees in tblEMPLOYEE that were not associated with any DepartmentNumber in tblDEPTHEAD, consequently you lost a lot of data. Now you're down to something like 475 total employees instead of 900+. The important thing...

That seems to be a common theme. I think I may have found a way around it. Is this method crazy?? 1. Create tempDB 2. Export DataTables ONLY to tempDB 3. Compact tempDB 4. Execute a WZZIP Shell to Zip tempDB 5. Email tempDB.Zip from Remote Location to Local Location I've managed to automate...

No Problemo Mi Amigo.. As long as you are willing to learn you can always improve. Go to design view of your form. Select the form object. In the properties window, go to the data tab and select the record source option. Click the elipsus (...) It will ask you if you want to make a query of...

Rick.. What have you done to the beautiful structure we had begun to create?? It breaks my heart to see you structuring it the way you have chosen. I see you have totally extinguished the primary key from each table. Not to mention you added a bazillion comment fields when this could have easily...

If you are going to just use one table, then you really will want to switch over to Excel. But... If you really want to make Access work for you, study up on Normalization. This is the method of expelling duplicate data from your tables. Check out the latter half of this report. If you just...

Don't I have to connect to this remote server or something? I will assume that just because I use the server named \\Blah... that doesn't mean that I am going to get into server \\Blah.. Keep in mind that \\Blah is in a completely different state, on a completely different network, at a...

Assuming you have the piece of equipment stored somewhere on your form.. Dim db As DAO.Database, rst As DAO.Recordset, equipID as Integer 'first, get the Primary Key of the record you are looking for curEquip = DLookup("[equipID]", "tblEquip", "[EquipPiece] = '" & _...

Cool!! That looks good.

Will VBA continue to loop through code as the Shell runs, or does it see that the Shell is completed and then continue to run. I call the following Shell (it copies the active .mdb into a temp file) Call Shell("""" & batPath & """ """ & projPath & """ """ & copyPath & """", 3) And then I take...

You need to Normalize your table structure. --tblProjet-- ProjectID (Primary Key: Autonumber) ProjectName (Text Field Displaying Project Name) --tblTest-- TestID (Primary Key: Autonumber) ProjectID (Foreign Key From tblProject: Number) TestName (Text Field Displaying Test Name)...

Why do you want to enter duplicate data?

Put the code in the After Update <Event Procedure> of your dateReq TextBox

If Me.dayReq = Date() Then Me.chkBoxName = -1 'Set Check Box To True End If