Search results for query: *

I need some help! I have 2 tables: Hotel_Coupon Player_ID RedeemDate Gaming_Details Player_ID GamingDate StartDateTime EndDateTime Actual Theo Type (Pit or Slot) Example of one player: Player_ID Type Actual Theo GamingDate StartTime EndTime 14841 SLOT...

I have a form with a subform in it. The subform is a continuous form. The subform has a combobox for the user to select a record and there is an Add button for them to add a record. There is also a Delete button to delete an existing record. The Add and Delete buttons are functioning...

I have the following tables: Teams TeamNum TeamYear ... Players MemNum TeamNum I have trying to get what I want all afternoon! I want to get the number of players by year. Players can play on more than one team per year and I want to count them only once. I've done a select query with...

I have created a database for a senior softball league. If we sign up a new player, I would know to check to see if they played in the past, but I'm going to be giving this database to someone else and they may not. So, I'm trying to put some checks and balances in it. When I add a new...

I have created a database for a senior softball league. I have a main form and subform which is working great to display players on team by year and season (e.g., 2008 Fall). The main form is based on a query. SELECT Members.MemNum, Members.LN, Members.FN, Members.Nickname...

I have inherited a database. One of the tables has a Memo field with what looks like a field within a field. Within the Memo field is text between <EXAMPLE1> and </EXAMPLE1>, and <EXAMPLE2> and </EXAMPLE2>. I've been asked to create a report and the I need * the text before <EXAMPLE1> to...

I am inheriting a database system. They have a separate database set up to store the bitmap images. They want it that way. My question is how do I know what the name of the bitmap is? All I see in the field is "Bitmap Image". Does it not store the filename when storing the bitmap in the...

Access 2002 Default File Format - Access 2000 I don't understand why this isn't working. I have a continuous form with the following code: Private Sub cmdUndo_Click() 'to go to the edited record Dim recordnum As Long recordnum = Me.CurrentRecord DoCmd.GoToRecord , , acGoTo...

I have a single form form based on a query with one table. It has a tab control with 5 pages -- no subforms. The form has an unbound combobox to look up records based on the same query. If the DriverTypeCD is 1 (Non-Professional) a control is made visible that is required for...

I have no idea how to start with this one. I have a subform where records could look similar to: Infraction Date Points 01/01/2000 3 06/01/2002 1 Somehow, I've got to calculate the points the driver has as of the current date. For instance, in the above example: On...

I have a main form with 3 subforms. I want to allow the users to use the MouseWheel to navigate the main form but I'm having troubles. Here's my code: Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long) If Count > 0 Then Call cmdPrevious_Click Else...

I have the following behind my form: Dim CurrentControlName As String Private Sub DateHired_Enter() If Len(Me.DateHired & vbNullString) = 0 Then Me.DateHired.SelStart = 0 End If 'remembers last control user was in while editing CurrentControlName = "DateHired" End Sub...

I have a main form with a subform. I have the following code on the main form: Private Sub Form_Error(DataErr As Integer, Response As Integer) ' MsgBox DataErr Select Case DataErr Case 2279 'InputMask violation InputMaskMsg Response = acDataErrContinue...

I am creating a database to track payroll information. Employees are assigned to a Home Dept but can work in other departments. I'm at the point where I'm trying to calculate overtime. I think I've got it figured out if they only work in 1 other department during a day. My problem is if they...

I am trying to create a csv file that will be imported into ADP PC/Payroll system. My first try created an error: strSaveFileName = "C:\ADP\PCPW\ADPDATA\" strSaveFileName = strSaveFileName & "EPI" & CoCode & BatchID & ".csv" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9...

I need to export data from a table to a CSV file. I have a form with a command button that runs the following: Dim strSaveFileName As String strSaveFileName = "C:\ADP\PCPW\ADPDATA\" strSaveFileName = strSaveFileName & "EPIJJV01.csv" DoCmd.TransferSpreadsheet acExport, , "tblADP"...

Here's my tables that I have a question about: tblEmployee EmpNo LastName FirstName MI DateHired tblDeptPay EmpNo DateEffective HomeDept ShiftCode HourlyPayRate I am creating a database to track payroll hours. Since an employee can change their Dept, ShiftCode, and HourlyPayRate, I...

I have a main form with a tab control with 2 pages. Each page has a subform (both continuous forms) on it. Both subforms have totals on them for Regular Hours and Overtime Hours. I have 2 textboxes for Grand Totals in the footer of the main form. As I go from record to record in the main...

When I delete the last record on a subform, it deletes the record but I get the following error: 2465 Access can't find the field "|" referred to in your expression. And if I delete the only record on a subform, it deletes the record but I get the following error: 2185 You can't reference a...

This database I'm working on is just kicking my butt! I'm not very good with complex queries. I beg for some help. Here are my tables: tblEmployee *EmpNo LastName FirstName MI DateHired tblDeptPay *EmpNo *DateEffective HomeDept ShiftCode HourlyPayRate tblHoursWorked *EmpNo...