Search results

Awesome, done, works - Thank You !

I have a Customer Field and a Job# field as a key. The form has a dropdown for the Customer which is populated with a Query, The query pulls the Customer and the Job#. The form shows the Customer as 1 field (combo box) and the Job# as a separate input field (as text box). What I need to do...

How do I do this ?? (((O3-O2)*52) - ((P2-P3)*x) = 0)

Thanks to the 2 who responded. Do to the timing, I have already done a work around that included another field in the source table and just the SUM function which I know works well - w/o the source Excel having to be opened first.

I have Excel 2002. I have a spreadsheet which accesses data conditionally from a 2nd spreadsheet (not the same spreadsheet) and SUMS it. I have tried SUMIF which seems to have issues in the 2002 version, and I have also tried -SUM(IF((...)) which is not working either. Pretty stumped at this...

Access 2016 - I created a good chart, but the query it is based on requires a prompted for parameter - and I would like to have the "entered" query parameter appear as the LEGEND of the chart. However, it is not allowing me to use the query parameter field in the chart wizard.

This seems to explain: https://social.technet.microsoft.com/Forums/en-US/45ebe780-967e-4748-a146-9ec7a15626dc/unexpected-error-from-external-database-driver-1?forum=itmanager

The Excel 10.0 Obj. Lib. was missing, and I added it, but still fails.

Just realized that the transfer "from" spreadsheet (from Excel to Access) is not working either.

I have an Access Macro with the transferspreadsheet command to a special named workbook in an Excel Spreadsheet. The name of the workbook is the same name as the Access table being transferred. It just now began throwing throwing an "Unexpected error from External Database driver (1)". ANY...

Getting it to work, but looks like on the xp pc it wants this C:\Samples\kaline4_2.bmp in the table field.

The database in original pc is in c:\users\donc\documents (windows 10), in the copied to pc, it is in c:\documents and settings\donc\documents (XP). The pictures are in c:\samples on each pc.

I did and find/replace for the table field, but still not loading up the pic.? Nothing else in any of the coding has been replaced/changed.

I searched but can't find any clear answers. I tried to copy a database from one pc to another. This database uses .bmp pictures. In the table, I have the field, e.g., \\acer\samples\kaline201b.bmp. After moving to the 2nd netbook named pc, do I need to change that table field to...

I deleted all code, re-copied all the form code back in (I know some is superfluous). Then, like you suggested, I copied a part of the code under the Print event for the Group Header. I will check further in the morning, but seems like it works now. I am very grateful. I could not find a...

If you look, I did find/copy some code from somewhere a while back (it's in there, and works on the form, but the same code is failing on the report. I am not a code writer, I really don't understand it well. I am in no hurry. I appreciate all you can help with!

I've got a link to a picture stored on C drive and it works well with my single page form. On a report from the same query source, I would like the same picture to appear on each of the group header lines. If I hard code a logo in the picture property, the logo shows up. But, the individual...

=IF(SumByColor($A$6,F7:F502),MAX(F7:F502)) This does pick out the max. value in the column, but it is not the one(s) with the yellow background color.

I started a Macro/code to select certain columns and paste into new sheet. Then, I repeated the code with all of the same identifying columns selected and then the "next" different price column selected. However, I'm not sure how the 2nd Copy MUST add the 2nd selection range at the BOTTOM of...

I imported Excel to Access but lost all Conditional Formatting - so Access is not helpful now. In Excel, I have a baseball card collection entered, player by player, and each row has 10 possible column prices based on card conditions. In Excel, I have a yellow cell background highlight - one...