Search results

I am glad that I was able to help you. I'm not able to help you with your next adventure in Access. I am less knowledgeable than you. Maybe post your requirement in a fresh thread to get the attention of the "knowledgeable Ones", the MVPers. Good Luck:

If you pick "OK", in my sub-routine, you will create a directory named "L_Name" that is the name on my "Customer's" table. Next, an Excel file (Bidder.xlsx) with Customer's name, address & telephone number. etc automatically copied into the corresponding cells per the code in the rest of the...

I'm no where any kind of programmer, but with a solution to my request for help, I used this code: Private Sub MakeBidder_Click() Dim appExcel As Excel.Application Dim lngLastDataRow As Long Dim Folder_Path As String Dim strFolder_PathNew As String 'Create path for...

sneuberg's code worked perfectly. Now, I don't have to dream about trying to solve my problem. Once again, this forum came to my rescue. Thanks for being here. Punice

Hit another wall...researched the World, but didn't find what I could get to work. I have an Excel 2007 spreadsheet with cells 'D4', 'I2' & 'N4', set as type 'text'. I have a table with fields named: 'Area', 'Cust_No' & 'L_Name'. I want to read the excel data into the table when I push a...

Yes, I did try that...didn't work. I only need to roundup, because the number that needs to be rounded up will always be lower than "13.60" before the rounding portion of the sub-routine is required. Oops! I did not try what you suggested, initially. When I did, I got a compile error...

In Access 2007, I dug myself into a 'coding hole'. I have this: Me.[SUTA_Total] = DSum("([SUTA_Tax])", "tblWages") which calculates a value of "13.5989" when certain conditions are met from executing the code prior to this statement in a sub-routine. I need to know, exactly, what code to use...

OK, I took Markk's advice and created two directories, one at a time. Of course, it worked. Thanks to all for your help getting past this 'onion skin'. Now, I wonder what the next 'wall' will be. Never-the-less, I'm learning a lot trying on my own and seeking help from you experts when I...

Actually, you can make a directory and a sub-directory in Access 2007. The following code does it within the same db that won't do it, now. It creates a folder named 'R11Bidder14' and a sub-folder containing the customer's last name (ie., LName) obtained from a text box field on the same for as...

MkDir still doesn't create this folder "12_R11_TY-18" & a sub-folder "Marketing". I changed the cbox to a text box. Still get 'error 75'. I apologize for being so ignorant and not understand why it doesn't do what I wish it would. I've done a MkDir op previously in this same db, copied that...

TU MarkK. Now, this crops up: "Bad File Name or Number" at the red line: Private Sub cboBizYear_Click() Dim strFolder_Path As String Dim BizYear As String Dim strWhere As String 'Captures the user selected 'BizYear' strWhere = "[BizYear] =" & Chr(34) & Me.[cboBizYear]...

I have a cbox (cboBizYear) bound to 'BizYear' on an Access 2007 form. I want the value selected (eg., 'nn_R11_TY-yy) to be used to be the name of the folder to be created, with 'Marketing' as a sub-folder. Here is my code: Private Sub cboBizYear_Click() Dim strFolder_Path As String Dim BizYear...

Ok. Thanks for all the responses. I wondered why it didn't work in Access 2007. I'll have to find another way to be able to insert missing numbers into a query that that converts a date field formatted as 'mm/dd/yyyy' to a 'm' formatted jobber to complete a 1 thru 12 sequence for exporting to...

Saw this sql & want to use it. Problem: what does the '#' mean/do preceding the 'a' & 'b'? That's all. TIA SELECT a.i FROM #a AS a WHERE a.i NOT IN (SELECT b.j FROM #b AS b) OR a.i IS NULL;

Thanks for your help, still... (1) The php opened to jibberish using Notebook++ & EditRocket. (2) Confused a bit. which hunks of the code go where? I copied the 'module' code to a module & assigned the other to a control with the proper name and to an on-click event. Reversed that and it...

Re my initial posting and the following information: Query name is: "PnLqryJob_Revenue_ByMthName" xlsx file path is: "C:\9_R11_TY-15\Marketing\Jan-15PnL\Jan-15PnL.xlsx" Excel file name is: "Jan-15PnL.xlsx" This is the code that I thought would do what I wanted. If not, what code will...

Given these, is the syntax correct and should it do what I want? Query name is: "PnLqryJob_Revenue_ByMthName" xlsx file path is: "C:\9_R11_TY-15\Marketing\Jan-15PnL\Jan-15PnL.xlsx" Excel file name is: "Jan-15PnL.xlsx" DoCmd.OutputTo acOutputQuery, "PnLqryJob_Revenue_ByMthName"...

Need help on exporting data from a query containing my monthly revenue to the revenue range of cells in an existing excel spreadsheet, for example. Been experimenting for 3 weeks with no luck. So, once again, I'm asking for the expert help that I always get here. It's obvious that I don't know...

I'm going to do what you suggested, just to gain additional experience 'thinking & doing'. This 80 year old brain needs all the exercise that it can get. Thanks again for you much appreciated help...Punice:D

Markk, I followed your example and was able to create the query that I needed. I'll format the report to display the info as I wanted. Thanks for your caring to help this old geezer.:) SELECT tblMaterial.J_ID, tblMaterial.M_ID, tblJobs.L_Name, tblMaterial.E_Date...