Search results

I have seen lots of laptops and desktops that were set up by en- users, not IT people, have the default account name, owner. Since not all my client use Active directory, I store both the OS user name and the OS Computer name. I use the same system lib (advapi32.dll) API and have never had...

It is possible to get only SQL Server database hosting. If you must have complete control of the Windows OS and the SQL server installation, then you would need a VM. This is also the most expensive way. Converting your Access front end to work with a remote SQL server is possible, but will...

I use ChilKat Software's libraries for all things email related. I use it to open an IMAP folder to read and process emails.

Tim, The first thing I would check is the Combobox's property for the Default value. Make sure it is not set to something. If there is no default value set, next I would check the Form's On current event to see is it is getting set to a value.

OK. Since you want to use the shortcut (right-click) menu, I would create a custom shortcut menu with an option for "Less Color". Less color option would call a function to set a TemnpVars: [COIDE] TempVars!LessColor = True[/CODE] When the report prints the On format events will "fire" again...

From the PDF: You are getting very close. Try changing the following: & " WHERE (((tblStatus.Status) = 'Open' Or (tbl((tblAffM.LeaderID) = me.cboValdAnL))" _ to a data substitute into the SQL using one of the following: If tblAffM.LeaderID is a numeric data tyoe & " WHERE...

Great point about how slow the conditional formatting can be.

To save colored ink or toner, I go to the printer properties and pick Grayscale. If possible, I also select "print quality" as "draft" which uses even less ink or toner.

If you drag a field from the field list to the report, Acess will attempt to name the control the same name as the file name. If you add the control first, then set the control source, you will need to also set eh control name. I would verify the control name property is correct if you are...

Still in the On Format event since this is a report.

Me. refer to control onthe report. If control name or field name has a space then you must use the [ and ]. You can always use the [ and ], even when thre are no spaces in the name. For the Me.9Control Name Here] to work, the must be a control on the report with that name TIP: You can add...

I like your thinking. (y) Great use of the Rich Text feature I have created a custom message box using Rich Text with great results. I like your idea to use it Rich Text to format text on a form when conditional formatting is just not enough. I have Access application with many features...

EDITED by HiTechCoach: add additioanl explinations Correct, but the problem is the lines before these with only CODE1 tested. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Select Case [CODE1] = "AS" ' >>>>> CASE 1 [SPLIT1] = 0.514 * [Fee] Case [CODE1]...

I agree. Exporting the attachment is the only way I could get it to work in a Web Browser Control (WBC) Why? Great question ... and the reason ... Web Browsers only show files from the hard drive. Every web page is cached (downloaded) to the local computer's hard drive. The files are then...

Try this: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) ' Initialize tot eh defaults Me.[SPLIT1] = Me.[Fee] Me.[SPLIT2] = Null ' check for exceptions Select Case Me.[CODE1] = "AS" Me.[SPLIT1] = 0.514 * Me.[Fee] IF Me.[CODE2] = "AF"...

Based on your code, I assumeed the unbound controls are the [SPLIT1] and [SPLIT2]

I lust looked at the Select Case statement and there may be an issue. Only 1 case is wil be selected. Case [CODE1] = "AS" And [CODE2] = "AF" [SPLIT2] = 0.486 * [Fee] Case [CODE1] = "AL" And [CODE2] = "AF" [SPLIT2] = 0.381 * [Fee] WIll never be true since the...

For reports, I use the Report's section On Format where the control is located to set unbound controls and other things. It works similar to a Form's On Load event and On Current events. Try moving your code there. I would be very surprised if it does not work because I do it all the time. It...

The way I get around the limits of the standard combo box is to use a form with the view set to Continuous Forms. This allows the use of alternate row colors and conditional formatting. I use a button with an arrow pointing up (reverse of the combo box arrow) I call this a pop-up, or...

If the query is a record source for a form or report, I find it better to do the ordering/sorting at the form and report level where you can use the alias name for ordering/sorting. In your case, doing the ordering at the report/form level will probably prevent the function from running twice.