Search results

Well, 'Huh', the form contains the fields where the 5 play & pick numbers are entered that are saved in a table. However, why does that matter when what I was asking for was guidance from you experts who know how to write code that will compare one set of five numbers with another set of five...

Looking for some suggestions to enable me to write some code, for when a control button on a form is pressed, that will match, for example, 5 numbers that I pick with 5 winning numbers that the lottery draws AND save how many of the numbers match. (I know how Excel is an easy way to do this...

Hello JHB, The revisions & additions that you provided performed the 'magic' that I've been trying to achieve, daily, for the past 14 weeks. You can read my excuse(s) in my response to Gasman. Thank for doing that and teaching me a bit more of the VBA code writing fundamentals. I appreciate...

Hello Gasman, I did step through the program, numerous times, during the development of my attempts to achieve the goal that I described as my 'need'. My problem is that I don't understand the meanings of the much of the computer lingo in some of error messages that Access displays, even when I...

I asked for help about 2 weeks ago, received some help,but no solution to my problem. So, I trying another approach. I have a control on a 'L_Name' customer's form, in an Access 2007 DB, that copies a template Excel file (ie., SOM.xlsx), renames it to 'L_Name SOM.xlsx) and fills it with...

Saw that before, but didn't read it thoroughly. Now, it makes sense. Thanks a lot for doing what you do and did. ;) I didn't see any scales; so I wrote this post instead. After logging in the scales appeared and I picked them.

I have seen the following 'set' statement in an example of VBA code: 'Open in the read-only mode Set src = Workbooks.Open("strFolder_PathNew ", True, True) I was unable to find any explanation of the significance of the two 'True, True' ending the statement. I would like to know what all four...

I should have said this in my initial description: I have a control on a customer's form, in an Access 2007 DB, that copies a template Excel file and fills it with customer name, address, etc. While it is open, I want to copy a cell "M59"s value from one xlsx file and paste it into cell"E14"...

Adding "dstn", as shown below, didn't work, either. dstn.Worksheets("Sheet1").Range("M59").Value = srce.Worksheets("Sheet1").Range("E14").Value BTW & for what it's worth, I am able to manually entered a value in the "E14" cell of the destination xlsx file that was created, initially, which...

The code that I didn't show creates the ". . . . .\L_Name SOM.xlsx" file and keeps it open. Other than that, it's not related to what I'm trying to do with the code that I did include with my submission. I tried numerous macros that were available on the 'net, as I stated, and adjusted...

I have a control on a customer's form that copies a template xlsx file and fills it with customer name, address, etc. While it is open, I want to copy a cell's value from one xlsx file and paste it into a cell on the open xlsx file that I just created. After trying various suggestions seen on...

DB is proprietary property and I not permitted to share it. When I omit the two 'Me' statements from the sub, all works just fine, If I rename the objects in the associated table and use those names in the sub or reposition them in the sub, the error is encountered. Iitially, I tried using...

My code to carry some fields of a form to a new form and clear selected fields. It works, except for one combobox field & one text box (Me.Driver & Me.Material), whereas the other combo, text & date fields do work.) I've tried doing everything for a month before giving up and asking you...

Yes, I know. I thought I deleted the post, so I could post my code in a more normal format. I tried using 'Null' for the two statements that work, but that didn't solve the problem. The error message was: "Update or CancelUpdate without AddNew or Edit".

My code to carry some fields of a form to a new form and clear selected fields. It works, except for one combobox field & one text box (Me.Driver & Me.Material), whereas the other combo, text & date fields do work.) I've tried doing everything for a month before giving up and asking you experts...

Re: Code to use start & end date entries and cbo selected item to open the related re My code work ok, except for when I enter a start date & leave the end date blank. However, I'll work on that problem. I don't know if I have a 'double entry' problem, like you pointed out. With respect to...

Re: Code to use start & end date entries and cbo selected item to open the related re You shamed me into doing it right. Here is the code that does what you suggested. Hopefully, it will help somebody else, who needs to do what I needed to do. Again, Thanks for the help and prodding...

Re: Code to use start & end date entries and cbo selected item to open the related re I solved my problem by writing 16 queries to do the sorting, using the cbo item selected as the query's criteria for each of my items, and by using the individual queries as the record source for the reports...

Re: Code to use start & end date entries and cbo selected item to open the related re Yes, I have 16 different reports that match the combobox item selections. Filtering is done within individual reports. The problem is that, for the example code, only the start & end dates are filtered and...

Code to use start & end date entries and cbo selected item to open the related report I have a form with a startdate & enddate fields and a cboExpense_Selector. Need to fill start & end date fields & pick an expense item from the cbo and open a report that desplays the expense for that item for...