Search results for query: *

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...

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...

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...

I hope I can explain clearly enough. I want to loop through only some controls on a form. Using tab stop numbers for explanation purposes only, say I’m at stop 3 and it’s a combo box, if I change the value in that control I want to loop through all controls that come AFTER that (4-15) and clear...

I hope someone can help me with this one. I want the data table in a chart show % values with one decimal place. I formatted the source query field to percent with one decimal, I formatted the chart datasheet field the same and I added the following code to the On Print event for the Detail...

Say I've got a form with an option group with three choices that are values 1,2 and 3. Say I choose value 2, is there any way to keep that value 2 floating around out there in the air somewhere so that it can be used by other forms or modules even if the original form is closed after choosing...

Hi, I looked in here for a thread on this but couldn't find it anywhere. I need to search through about 200 tables in an Access 2003 database for a field called "evcEventEndDtTm". How can I do this? I appreciate all the help I can get on this. Thank you. Dan Dan Rogotzke Dan_Rogotzke@oxy.com

I need to check to see if a field exists in a recordset. I've tryed the following code but it doesn't work. It returns the same result whether it exists or not. Does anyone have a better idea? It will be greatly appreciated. Dim fld as Field On Error Resume Next Set fld =...

Is there an event that is equivalent to a 'before record change' event? I need to run check on a field to see if it's null or 0. If it is then a message box will pop up and tell them that data needs to be in this field before they can change to a different record and if this is true, I need to...

I have a form that when you click a command button it creates a form behind the scenes and inserts code into the form module for objects that are created for the form. I can use the 'Application.Echo False' statement to keep the creation of the form from being seen by the user but it doesn't...

OK, I'm gonna start screaming pretty soon now. This is driving me up a wall. There's something I'm not seeing here that I'm hoping somebody else will see and help me out here. After I've programmatically created a form I want to insert code into the Form Open event and I keep getting this...

In my database, upon a certain condition and a certain event, it progammatically creates a form with an optiongroup on it. The optiongroup's toggle button's captions are derived from a tables 'name' field and the optionvalues are derived from said table's 'autonumber' field. Now I need to...

I know I've seen this code somewhere quit awhile back and I can't find it anywhere. Does anyone out there know how to do this? Or is there code you can attach to a button that will select all that is in a multiselect list box? There's got to be a way to do this with out the combination of...

All of a sudden all of the controltiptexts in all of my access programs no longer show up on my computer. They will show up other's computers but not mine and a couple of other's in the building. PLEASE, has anyone seen this before? Can someone help? I'm using Access 2000 on Windows NT 4.0...

No matter what I do! Everywhere, the table, the query, the form, the combo box...everywhere it is formated to Single; Fixed; 3 decimal places. But when I use a combo box to query the table to populate another field the combo box is rounding my values from 3 decimal places to 2. I even went...

OK, I'm brain-dead here...how would I copy a record from a recordset to another recordset? Can someone help me? Dan Rogotzke Dan_Rogotzke@oxy.com

Say I have a Recordset that has a Recordcount=20. Then I want a Querydef that pulls just the last six records of this Recordset. How can I do this? Dan Rogotzke Dan_Rogotzke@oxy.com

I need to write code the checks to see if a table exists before I either delete the table or create the table through code. What do I write to check for the existance of a table? Dan Rogotzke Dan_Rogotzke@oxy.com

When closing forms that I made with embedded charts on them I always get an annoying popup that says, "The object is locked, so any changes you make will be discarded when the form is closed. Click Save As/Export on the File menu and save the object under a different name." Is there...

How would I write vbscript to install a True Type font? Dan Rogotzke ddrogotzke@alturaenergy.com