Recent content by OldManRiver

Examples All, So after following all the links and much more research I was either directed to or found 5 examples of how I should do this, which are in the attached file. File0 ==> Is one with Bitmap Image and works, but cannot apply to my program as somehow this one gets a value for the...

D, Well I am feeding my form with a status table so let me take a run at it, but I still have the problem that when I select a status in one row, all rows set to that status and thus to that color. Here is the VBA I have so far: Sub TKT_FColor() Dim ColorSTR, FieldVal, ValueSTR If...

D, Yes and I replied, but I see the system somehow did not get my reply posted. I saw no code in your example and I do everything 100% in vba, so your example does not help me. Give me an example with vba code please. OMR

Conditional Formatting - Not the Answer All, I appreciate the inputs on condition formatting, but it is limited to just 3 values, where I have 9. What I need is for the functionality of conditional formatting in vba so I can fill in the row, setting the color as it sets, then change the...

All, Attempting something I have not tried before. Have the form shown. Need to accomplish the following on the subform: Change color, row by row, for different status values, Change value, row by row, from either drop-down or pop-up. I actually only need to change/manage color and value...

B, I had already done this and it kept telling me it was my DEV machine locking the file. When I turned off the DEV machine was still getting the same answer; so obviously it is something else. I may have to schedule a server re-start, over a week-end with the Sys-Admin. Thanks! OMR

All, I posted my thread about the DB locking up: http://www.access-programmers.co.uk/forums/showthread.php?t=180381 This has now left me with a hanging open session in the BE file, which says it is my DEV machine, but soft and hard reboots have not cleared it. I need to run weekly...

Temp Solution All, I kept going back through my backups until I found where I no longer lock up and found it was when we implemented a splash login screen that things went south. I disabled this for now, but have done this many times without this result, so now my question is why? Any...

All, I have a FE/BE design in production. Last week the FE blew up on one of MS, memory collision errors. Since then all my forms on the FE are coming up in either POPup or Modal mode. It is causing all the users to hang and not be able to run the processing. I was able to clear this...

All, I have DB designed with FE & BE and need a script to force users off the BE for maintainance with "Compact & Repair" as default maint. I know there is a script out there, but forgot the URL. URLs please!! Thanks! OMR

Partial Fix All, Found part of my problem. I'm trying to use the routine in VBA for both Access and Excel. They do not handle the same. Access loves the "Dim objPrinter as Printer" but Excel hates it. Need a way to make a routine that satisfies both. OMR

What ?? All, The HOWTOs all say this code should work: Sub SetPrinter(DevName) Dim objPrinter ' Dim objPrinter as Printer ' Set Application.Printer = objXL.Application.Printers(0) Set objPrinter = objXL.Application.Printer ' For Each objPrinter In...

All, Does anyone have a link to a good example of how to call a printer in VBA? Thanks! OMR

Excel Export - Working All, Got it working but not using the "TransferDatabase" which I want to master. Here is the working code:Option Compare Database Public TargetForm As Form, SourceForm As Form Sub Run_Mtn(MyDays) ' Run the Temp Marting Query for last 15 days Dim dbs As...

All, Where I am at with my code. Went to the temp output table, as I know that and code is:Sub Run_Mtn(MyDays) ' Run the Temp Marting Query for last 15 days Dim dbs As DAO.Database, DatVal, DatWrt Dim DayVal, FMTval, SQLstm, WHRstr Set dbs = CurrentDb DatWrt = Format(Now...