Search results

Thanks so much RossWindows, I'll give this a try.

Thanks Mr. B. Guess you're right, can't have my cake and eat it too. Was hoping there was some VBA code that would change the "Limit to List" = "Yes". I did what you suggested and changed "Limit to List" = "No". However, then the "On Not In List" Event code won't execute, and the User is...

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...

Hi Adam, The main form that opens with various option buttons is named: [frmMainMenu] Then, the main form that contains the subforms is named [frmStaffTransactions] Connected to this [frmStaffTransactions] is a tabbed view, with several forms such as [frmCreditCardStatements], each having at...

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...

Thank you! The code ran OK (no error message) when I clicked the command button to update Oracle. But I don't think the Query update actually ran -- it did not update the Oracle field on the subform or in the table. And, when executing the query, I should have gotten the usual message about...

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...

RESOLVED - I've found a way to change minutes to a percentage of an hour, in order to calculate total hours worked. Field is named [HrsWorked] which provides values in hours/minutes such as 2.15, 2.30, or 2.45 etc. To convert the minutes to percentages of an hour (and get 2.25, 2.50, 2.75...

After further thought -- and re-reading previous answers/suggestions to timesheet questions in the Forums . . . How do I convert a number (double) field that contains the hrs.min, Example: convert 2.45 (having worked from 09:00 am to 11:45 am) to 2.75 I need to convert the 45 minutes to a...

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...

My PC died and the dept Tech Specialist gave me a new one with Access 2007. I've discussed with him the issue I'm having with the .mde file. For the time being, I'm developing on my laptop which has Access 2003. To reiterate -- whatever I develop in a split Access 2007 database (with...

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...

Good grief! How dumb of me. Thanks Bob.

Guess I spoke too soon . . . my databases won't open past the first button click on the Main Menu. I've changed the Trust Settings (see attached screenshot) but no longer see the Message Bar with the Options button. Any suggestions?

Thanks Bob. I've done that but am looking for a way to permanently over-ride Users having to do this. I checked online and read about going into the Trust Center Settings and disabling all macros. This worked fine. Not sure how this will work on a split database and .mde file. Appreciate...

I got the same error message when I tried to recreate an .mde file after writing lengthy code in a Module. Bob Larsen is right on - I had an error in my recent code somewhere although it compiled OK. I fixed the code and then recreated the .mde OK.

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...

THANKS to you all! I was incorrectly putting several lines of code in a sub routine -- Private Sub Report_Open(Cancel As Integer) but I now put this in the actual control source field in DESIGN view!! =UCase([YourField]) Works great! 331

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...