Search results for query: *

I have 3 tables with the following relationships: TimeCards JobIDCodes PhaseIDCodes There is a one to many relationship between JobIDCodes & TimeCards There is a one to many relationship between JobIDCodes & PhaseIDCodes In the detail section of my report, I'm getting additional records...

I have a table called ImpJobID which has been records imported from an Excel spreadsheet. It contains two fields called JobID & Description. When the table is imported from Excel, one JobID can appear multiple times in the ImpJobID table. I would like to remove the duplicates using VBA &...

When I opened my database this morning, I noticed seven tables which were not there yesterday. They are: MsysAccessXML MsysACEs MsysIMEXCOLUMNS MsysIMEXSPECS MsysOBJECTS MsysQueries MsysRelationships What are these Tables? The icons are grayed out but appear to be part of the DB and I guess...

I have a unbound combo box on a Main form using a Select statement to populate the combo with employee numbers from the Employee table. The Main form does not have a Recordsource. I would like to have all the child records for the employee selected in the unbound combo appear in the Subform...

I have found the following code on a previous Tek-Tips thread provided by Rick39 & have incorporated it into the click event on my Save button located on my subform. Dim currctl As Integer, numctls As Integer Dim ctl As Control numctls = Screen.ActiveForm.Count For...

I have a combobox on th main form (TimeCards). I want to check if the field has been left blank before the user proceeds with anymore data entry. So on the Lost Focus event I have the following code: If Len(Forms!TimeCards!cboEmployee & "") = 0 Then MsgBox "You must...

I have been trying to use a date variable in a stored SQL statement but keep getting "Too few parameters Expected 1" errors. I get this error because the rst is emtpy but everything I have tried doesn't correct the problem. Here is the code I'm using: Dim db As Database Dim rst...