Search results

Hello everyone, I have a combo box that is "Limited to List". When the User enters an item not on the list, a message asks "Do you want to add this to the list?" If the User Clicks "Yes", the item it added to the list and the field will contain the new item. If the User Clicks "No", a...

Hello All, RE: Filter subform(s) after Main Form opens/loads WHAT I'D LIKE TO DO: When the main form is initially opened, each of the subforms will be blank forms, yet the User will have the ability to scroll through to previously submitted data on the subform(s). WHAT I'VE TRIED: Have...

Hi all, 2 buttons on the Main Menu each open the same Customer screen with same tabs and forms/subforms. Button 1 filters to 400+ New and Continuing Customers, button 2 filters to All 6000+ Customers including potential ones. When the Customer screen opens, the same combo box appears which...

I'm trying to update an Oracle number that appears on a form (that's open) to a field on an underlying subform and subsequent table. I'm able to accurately update Oracle numbers for ALL employee records, but I only want to have it apply to this employee's subform (and subsequent table) that is...

Hi All, I've spent the better part of 2 weeks developing a Timesheet form for employees and students to enter their own hours worked. The code has the Timesheet calculate time worked each day in Hours:Minutes. PROBLEM: I need to sum this for each pay period, and it is not summing...

Hi All, Background Info: I developed our main department's Access 2003 split database which is on a server for 15+ Users. I've now been given Access 2007 for development -- Users still have 2003. There are also 2 other smaller databases that are not split (.mdb). Problem: In the split...

Hi All, I've been developing in Access 2002-2003, and now have Access 2007. I can open a 2002-3 .mdb database OK, but when I click on the Main Menu buttons, nothing happens -- they do not work. So I cannot access any of the existing Menus and Forms. In fact, none of the previously existing...

Could someone provide me with the exact VBA code to use to change lower case to upper case for specific fields when printing REPORT labels -- sample field names: [LastName] [PermStreetAddress] [PermCityStateZip] I've tried many variations of UCase([LastName]) and I get the error message that...