Search results for query: *

combo and Andrzejek, I gotta tell ya, I'm an old fart now and I don't code near as much as I did years ago. And I've never coded in Excel before but I'm a little embarrassed to realize how simple the solution is. I don't know why I couldn't see it myself. I tried everything I could think of...

combo: I'LL BE DANGED! HAHA! I failed to see the "Format" you put in the string. When I copy/pasted the line IT WORKED. Thank you sooooo much! Dan Rogotzke

combo: ERROR. This is what I get: Andrzejek: Data missing. This is what I get: Dan Rogotzke

I have a command button where I input a well name in an input box. It returns the record in a msgbox. How do I get the date to display as a short date instead of a number. This is the code I'm using: Sub LOOKUP() On Error GoTo MyErrorHandler: Dim PRIMARY_WELLCOMP_SHORT_NAME As String...

combo, Here is the format of the code that works: PLEASE REMEMBER, in the first example it works with the 108 emails I have coded in. In the second example it pulls the 108 emails from a table... it DOES NOT work. DoCmd.OutputTo acOutputReport, "rptReport", acFormatPDF, "c:\data\rptReport.pdf"...

stronngm, I don't get an error message. The emails just don't get to Outlook and get sent. combo, before I went to the table with my email addresses I had them hard coded in the .To = line. I had them stated in 10 different lines so that the lines of code weren't too long to deal with and the...

I have an Access 2013 database program that emails a report to 108 email addresses in the company via code in a module. I have been manually editing the .send = in the code to remove or add email addresses, but now I want to put the email addresses in a table and gather them for the .send = code...

Wayne--while I was sitting here I decided to double check…no triple check…quadruply check my data for any anomalies. Using the month of January, any two consecutive weeks of data would filter but not three or four consecutive weeks. Since I was concerned with one column in particular, the...

OMG! I just figured it out. Access table column header filters only allow you to filter up to 1,000 different record choices (names in this instance). If there are more than 1,000 (maybe it is 999) different choices (names in this instance) in that column it won't allow the filter option. Thank...

Maybe it's just an anomaly with Microsoft or a recent fluke in the network. It all worked fine for him until about a week or two ago. Dan Rogotzke Daniel_Rogotzke@oxy.com

They use Access 2007. No fields are memo or look up. Some are numeric and some are text. Problem lies with a couple of text fields as well as a couple of numeric. Like I said, makes no sense to me. With any span of consecutive dates within the month all the fields will filter but not with all...

I'm sorry guys, I don't want to sound rash but this has nothing to do with the query. It gets the data to the table just fine. The problem is with the table and the column header filtering that my supervisor likes to use. Again, the problem is that if the table is populated with one week of data...

This just populates a table. One of my supervisors looks at the data by opening the table and uses the column headers in the table to filter the data for his viewing purposes. He’s the one that brought this problem to my attention. He’s been doing it this way since I built this reporting front...

Yes, I checked all the data for Null values and Empty fields. There are none. FYI, the filters I am talking about are in the column headers of the table. To refresh your memory, this is a quote from my first post with a little bit added at the end: "If I chose to show all dates for the month...

The user inputs a start date and an end date in text fields in a form. Time(hh:mm:ss) does not apply. These dates are picked up by VBA and used in the SQL for an append query that populates the table with all the data from the start date to the end date. One of the fields in the table that...

Weirdest thing. I have a table with 12 fields. It is populated by a chosen date span from a form. If I chose to show all dates for the month half of my columns won't filter. That capability just goes away. BUT if I just chose two weeks of data, any two weeks, the filter option is there. WEIRD...

Andrzejek, you are absolutely right. I will write that in immediately. Thank you. Looking back at my post my indentations didn't show (guess I didn't preview well enough, in a hurry). It should have looked like yours...heh-heh. Dan Dan Rogotzke Daniel_Rogotzke@oxy.com

Andrzejek, I always rename my controls to represent what they contain. Such as cboFailLoc (Failure Location). I combined your suggestion with MajP’s using the Tag property with combo1, combo2, etc. I tested it using just a couple of controls and it looks like this: For i = 1 To 3 For Each...

PHV, using the TabIndex property I get a Run-time error '438' "Object doesn't support this property or method". Any other ideas? Thanks. Dan Rogotzke Daniel_Rogotzke@oxy.com

Yes, MajP, that works great but I failed to elaborate more as I should have. Here is my dilemma, this form has many combo boxes so say if I also wanted to do the same for stop 7 to clear stops 8-15 and leave 1-6 alone; also maybe do the same with stop 13 to change stops 14-15 and leave stops...