Search results

Re: "Expense Table" approach. I will resort to modifying the form with the sub-forms that I use to enter 'Revenue', 'Matl_Cost, Sales Tax & Del_Fee', 'Labor' and the disposal 'Fee' plus the date & other data that I enter in them, as you indirectly suggested. However, I'll wait to see if a...

Researched & tried numerous approaches to solve the problem that I'm giving the experts to do for me, once again. I have a tbl_Job_Basics that I and need a query that merges it with data from these the [named fields] in these four tables; 'tblRevenue for the "Revenue" amount', 'tblMaterial...

Brian, In my final attempt to get the code to produce what I wanted, I changed 'ON (tblLOADS.L_ID = q_Latest_Pudates.L_ID' to 'ON (tblLOADS.BROKER = q_Max_Pudates.BROKER)'. Thanks for spotting my omission. Punice

Found this Re: Query on Latest Dates from pbaldy and modified it to fit my application: Here is the query sqls that provided my what I wanted. SELECT tblLOADS.BROKER, Max(tblLOADS.Pudate) AS MaxOfPudate FROM tblLOADS GROUP BY tblLOADS.L_ID; SELECT tblLOADS.BROKER, tblLOADS.MATERIAL...

Let's say that I have a table (tblLOADS) with BROKER, Pudate, MATERIAL & DRIVER information and I want that information from the last entry for each BROKER. Based on a forum response from 'bpalsy' (I think), I need to create two queries: one that gets the most recent entry for each...

The "L_ID" is the 'Load identification number' that is automatically created when a new load is entered on the 'Loads' form, where the control is located that runs the following sql. Here is my sql: SELECT tblLOADS.L_ID, tblLOADS.BROKER, Max(tblLOADS.Pudate) AS MaxOfPudate...

I tried converted some of Mr. Browne's sql to apply to my applications, but what I tried did not work. Still showed all records for the BROKER, Pudate, Material & Driver. Still looking for the correct solution to my problem.

Giving up after a zillion tries. I have a table (tblLOADS) containing: BROKER, PUDATE, MATERIAL & DRIVER. I am able to create this query: SELECT tblLOADS.L_ID, tblLOADS.BROKER, Max(tblLOADS.Pudate) AS MaxOfPudate, tblLOADS.Material, tblLOADS.Driver FROM tblLOADS GROUP BY tblLOADS.L_ID...

Thank you Spikepl for discovering the omissions in my initial post. Thank you Pbaldy for solving my problem. I removed the 'text' as you suggested. When I added the SR to On-Current, I had to keep the SR in the combobox as well. Now, the colors are retained when I exit & reenter a form...

Using Access 2007. I have a form (Broker), with a combobox (cboClassifier), that I use to select 1 of 4 phrases, display the selected phrase and color the field with a color that I've assigned to each phrase. Next, I have a report that contains all of the Broker names, addresses, etc. based on...

(Access 2007) I have a combobox (Classifier) that displays the selected phrase from the list and colors the Classifier field appropriately when I use this sub-routine, 'On-Change'. (On-Current didn't work for me.) 1. The colorization is not retained, when the form is closed & reopened, only...

Initially, I didn't understand what your first response actually meant. Per your second one, I did and applied it successfully. So simple...it's nice to see that there still are people on this planet who can think and do. tnx much & stay well!

I guess I didn't state my request for help clearly enough. (1) Which field do I associate the event procedure 'On-Click' with:?; (2) Are the 'Dim' s required?; (3) Are the Case statement's correctly written for the ranges?; (4) and, are the expressions correct what I'm trying to do? In other...

I have a 2007 form with two controls: 'Wages' where I enter an amount; and 'FedWH' which I want to be calculated & appear in that field when I enter a 'wage' amount. This is the VBA that uses the Fed Tax values for wages between the applicable wage ranges: Dim Wages As Currency Dim FedWH As...

Re: Copy & rename a excel file to a sub-folder with a name entered in a forms control I'm discouraged that none of the 103 persons who looked at my request for assistance with my vba problem (for the past 2 months plus) are not able to 'fix' it. Am I not phrasing my request clearly?

Re: Copy & rename a excel file to a sub-folder with a name entered in a forms control With my code, I can create a directory with the name (eg., Jones) that I enter into a window on a form (eg., "C:\R11Roofing13\Jones"). The name of the window on the form, where 'Jones' is entered is...

I am still trying to copy an Excel file from a parent folder to a sub-folder, that this code creates, and name the copied file with the name used to name the sub-folder, using the name entered in a control field (named 'TheDirName) of an Access 2007 form. Here is my VBA, which names the copied...

OK JHB, the sample code worked fine. It fooled me by saving the directory and xls file it created (and opened with my added data) in the 'user' folder. I didn't expect that. Now, that I am able to make a directory, I am attempting to get my code that I presented, initially, to work using what...

Re: vba to mkdir, copy xls file to it & xfr form field contents to cells of xls file Refs were marked as suggested; code seems to compile error free; last row is 'N67'. Another problem: Debug doesn't work (ie, F8, etc), with/without 'allow special keys' picked. #$%@# Here is my revised...

:banghead:I submitted this problem to the 'Forms' forum and received several responses. None of those suggestions worked. So, I'm appealing to the VBA code experts for assistance. By clicking on a Access 2007 form's control (mkmybidder), I want the on-click vba code to: 1. Create a new folder...