Search results

I have a browse button to open up files with the following function on the click event. When I click it it gives me an error message saying - Object doesn't support this property or method. I did a debug and it gives me the error after the red line. Does anybody have any idea what I'm doing...

I have a ComboBox with a ValueList ("Employee1";"Employee2") and Button1 How do you disable Button1 only when Employee1 is selected from the ComboBox??

TxtRecordNumber: ControlSource = CurrentRecord TxtRecordCount: ControlSource = Count(*) Private Sub ButtonNextRecord_Click() On Error GoTo MyErrorControl If Me.CurrentRecord = Me.Count Then Me![ButtonLastRecord].Enabled = False Me![ButtonPreviousRecord].SetFocus...

I want to change FORM2 properties from when you click a button in FORM1 so you can't edit, delete, or change anything until you click the Edit button. What am I doing wrong? Private Sub ButtonCompany_Click() On Error GoTo MyErrorControl DoCmd.OpenForm "MyCompanyInfo"...

The user can't press tab until he types something into the textbox..how do I do this?? This is what i have.. Private Sub CompanyName_KeyPress(KeyAscii As Integer) On Error GoTo MyErrorControl If KeyCode = 9 and Me![CompanyName].Value = "" Then KeyCode = 0 msgbox "Please enter a...

When my program starts it makes you create an admin account to continue on. Once created, it takes you a form to create users. In this form i have a tab control called MyTabs and it has 3 tabs (tab1, tab2, tab3). Tab 1 is to create users. I want to disable tab 2 and 3 until at least one user...

How do I make sure two passwords are exactly the same?? I have two fields: MyPassword and MyPassword2. In order to create and save your password they have to match. But it's letting me save even tho MyPassword is Admin and Password2 is admin?? How do i make it case sensitive??

I am trying to set a record source to view only one record. For example: When a user logs in I want the form to only show that users record. I have the following on the log in form which is called UserAccess. DoCmd.Close acForm, "UserAccess", acSaveNo DoCmd.OpenForm...

On my switchboard form i have a listbox with various employees. When the user clicks his name on the listbox then hits the view my hours button a user access form pops up (basically a login screen). what i'm trying to do is, whatever name the user clicked on the listbox on the switchboard to...

What am I doing wrong or is there another way to go about this? I have control buttons instead of navigation buttons on my form to go to previous and next records. I did not use the wizard just VBA code. So what I am trying to now do is make the ButtonPreviousRecord disabled when its on last...

In my Employees table i have a Yes/No field named [Active]. I'm trying to make a ComboBox that allows you to select view Active, Inactive, or All employees. How do I do the All part,? Active: Me.RecordSource = "SELECT * FROM Employees WHERE [Active]= True" Inactive: Me.RecordSource =...

Private Sub MyZipCode_KeyPress (KeyAscii As Integer) If KeyAscii >= vbKeyA And KeyAscii <= vbKeyZ Then KeyAscii = 0 End If End Sub This only works for upper case letters. How can I make it case insensitive?? Thanks in advance.

This is my function: Function PunchInOrOut(sMyCallingForm As String, MyPunchInOrOut As String, MyUserCodeAs String, MyUsername As String, MyPunchDate As Date, MyPunchTime As Date, ForFutureUse1$, ForFutureUse2$, ForFutureUse3$) On Error GoTo MyErrorControl Dim DB As DAO.Database, MyPunchID...

I'm trying to build an unbound combo box that allows you to pick 3 options: Current Week, 1 Week Ago, 2 Weeks Ago. How do i calculate this? Say I have 3 months worth of records. When the user chooses 2 weeks ago - I want it to show 2 weeks ago from Now() and only that week.

I have a listbox and two buttons. ListEmployee, ButtonPunchIn, ButtonPunchOut. When the form loads all the employees show in the listbox. You have to select an employee so you can punch in. Once you select an employee and punch in, the ButtonPunchIn disables and the ButtonPunchOut Enables...

I have a Table (Employees) with the following fields: EmployeeID, EmployeeName, DateOfWork, TimeIn, TimeOut, and DayTotal. My form has a listbox (ListEmployees) and a ButtonPunchIn and a ButtonPunchOut. Everything is working. But what I want is to add to the ButtonPunchOut On click...

I have a form with a listEmployees (listbox), a ButtonPunchIn, and a ButtonPunchOut. When I select an employee from the listbox and click ButtonPunchIn the date and time saves in the EmployeesT. When I click ButtonClockOut I want it to update the selected employee in the list box. Can some...

Im creating a punch in punch out system. I have 3 tables: UsersT(Where the name of all the employees are), EmployeesT(Where the data from that day is stored, punch in and out time), TimeSheetT(Where all the data is and only the administrator can go inn and change). In the form i have a...

I have 2 tables: TimeSheet Table Employees Table The Employee Table is for when an employee clocks in and clocks out just for that day. The TimeSheet Table saves all the data (hours an employee worked) so when i make a report you can go back to whatever specific day you want to go back to...