Search results for query: *

Having a DLOOKUP issue where it constantly returns a null value. I have the following code on my form and the first part does work: Private Sub cboApptVehicleYMM_AfterUpdate() Me.txtVehicleMakeModel = Trim(Mid([ApptVehicleYMM], 6)) ' This Works Me.txtSvcPriceCode =...

I have used an example of Access 200 database examples to write the code for doing a total on the subform, then having it show on the main form. I had it working until I opened it with Access 2010. Now the Sum([ItemTotal]) causes a #Error in the text box in the footer. This also happened to...

I have a database which works great in 2000-2003 but when I take it to work and use 2010 it has a problem using the Find - Starts with filter provided. I have the form open and that box to find a record open by code. When a few letters are enter and I go to search it notes it cannot because...

I have a report which I call from a button with the following code: Private Sub btnPrintReceipt_Click() On Error GoTo Err_btnPrintReceipt_Click Dim stDocName As String Dim StrCriterion As String stDocName = "Payment Receipt" StrCriterion = "[ReceiptNo]=" &...

I am trying to have a SQL query update a table with the record count from another table which meets the criteria of between two dates from a popup date form. The date part works in other similiar coding where I am pulling individual records by an ID field. This is differnt in that I need the...

I have a basic In/Out form which on some workstations the user(s) will minimize it from their desktop all day. I have located the front-end in it's own folder on the c: drive of the workstation. Is there a way to have the form refresh when it selected from their tool bar? The complete...

When I open a database in Access 2003 RUNTIME it displays a dialog box that is a Security Warning. I know how tosolve this issue using Access but I can't figure out how to do it using the runtime. The application is status board for In/Out and only has one form, a continous form with only three...

I am setting up an initial login screen which will have NO security function other than make someone relaize they shouldn't be trying to get into this particular database. All I want is to ask for the Username and then the Password and if both are supplied correctly it will open the main...

I hve placed the following code on the OnClick button on a form. The SQL statement is to append the training records for a particular training session based on the employee name having a checkbox marked. When I tried the query it worked fine EXCEPT I had to manually type in the training session...

I need to refix the autonumber feild with the first three characters from the Last Name field in the same table. Obviously it needs to change the autonumber AFTER the Last Name is entered into the record, not when the record opens. Any ideas would be appreciated.

I am trying to write a DSum ststement to track days off for employees. I have the following: DSum("[VSCount]","tblVacSickEmp","[VSEmpID]="& [Me].[EmplID] My second criteria is to be >=[Me].[AnnivesaryDate] but I am having a problem adding it to the above. Suggestions? Thanks, Fireman1143

I am trying to do a time calculation in Access where I have: [ScheduledTime] in hh:mm AM/PM format [Duration] in hours in numeric fixed 2 decimal format My third field is to be calculated where the [ScheduledTime] and [Duration] are added to get a [EndTime] in hh:mm AM/PM format...

I have a report with four (4) fields: DeptType (test), AssignDate (Date), DispatchNumber (Number) and Closed (Bit). All fields are contained in another application and are linked to the Access application. The query does generate the correct information and the Closed field is used as the main...

I have been using Access 2000 to work on a small, simple project. A co-worker uses Access 2003 and has worked on the same project I have. Now when we tried to open the database we get a Microsoft Visual Basic "Error accessing network. Network connection may have been lost" message. I also...

I am trying to open a form ("frmpopupTaskDescript") with two (2) criteria. The first criteria works fine alone and the popup works as designed. My problem is how to specify an additional criteria (which is a number). I keep getting a type mismatch no matter how I set the quotes etc. I have...

In my application I would like to have an email sent to two supervisors alerting them that a NEW Service Request has been entered. I have the email part working correctly but can not figure where to place the Event. Everywhere I place it it gets sent BEFORE the record is saved and some of the...

Good day! I have an application in which I use a button to send the user form the list of Contracts to the one they selected with the button. The DetailButton code is below. This same coding works in all sections EXCEPT for the Contracts ( I also have Licenses, Software, Systems, Peripherals...

Part of my applicaton has a table in which I would like to have the one field - fldCompleted - filled in with a date when a form attached to another table has the Completed Date filled in. The form has two hidden fields which can be used for matching the table with the fldCompleted. I have...

Part of my applicaton has a table in which I would like to have the one field - fldCompleted - filled in with a date when a form attached to another table has the Completed Date filled in. The form has two hidden fields which can be used for matching the table with the fldCompleted. I have...

I have a report with an unbound field set to the following source- ="This current contract - "&[ContractName]&" - was started on "& [StartDate] &"." All works well except I would like the date displayed in a different format then it is. I also have another...