Search results for query: *

Thanks goes to 'smah' for amusing us. The people I work with frequently come to me and say "just Push the Freaking Button" after I showed them the program. It has become the source of many one-liners around here. Thanks Kaz888 for your link. ...and don't forget to just Push the...

Ahh, my bad. I thought that link was to your personal website. When I read the post, I thought to myself, "This person is patronizing me". I didn't realize this was the name of a software. My appologies... -------------------------------- Fortius, Citius, nullis secundus Strength...

Yes pushing the button is a workaround however, I don't have time, nor get paid to come into work at 3:00 AM and push a button over 100 times! The workaround you suggested is a horrible waste of time, wouldn't you agree? -------------------------------- Fortius, Citius, nullis secundus...

Outlook Experts, I'm having an issue with Outlook 2002 XP that has me baffled. Background: I have an Access database that automatically sends bulk email to 100+ people at odd hours of the day i.e. 3:00 AM (This way normal daily traffic is not dirupted). Each person gets a different report, so...

Thanks Hugh, that works. -------------------------------- Fortius, Citius, nullis secundus Strength, Speed, second to none

I just upgraded Gentran Server NT from 2.1 to 3.1.1. Everything was working fine until I altered a map. When the new map started generating errors I rolled back to the old map. Now the old map is not working correctly. I read in the release notes that old maps by default had a compatibility...

Let's try this again faq705-2562 -------------------------------- Fortius, Citius, nullis secundus Strength, Speed, second to none

fred, Try looking at faq705-256 This might solve your problem. -------------------------------- Fortius, Citius, nullis secundus Strength, Speed, second to none

hallian92, Yes there is another way to do this that is better. You will use the DoCmd.RunSQL statement. Basically, the easiest way to implement this is to build an append query and change to SQL view from the design grid. Then use the SQL to build the statement in VBA. Search Access help for...

Check out Sterling Commerce at: http://www.sterlingcommerce.com/customer/education.html They have very in depth training and also the software (Gentran Server) as well as the VAN/VASP networks to help you set up your EDI solutions. -------------------------------- Fortius, Citius, nullis...

santosh1, From what I understand these are the fields you have for your three tables: -Temp has countryID -Geography has countryID, currencyCode -Currency has currencyCode, currencyDescription If this right? If it is then your query would look like this: SELECT Temp.countryID...

Hi santosh1, What you want to do is set up a make table query that writes all of the data from the Geography table where the countryID is equal to the countryID in the Temp table. Here is a piece of SQL you can use to set up the make table query: SELECT Geography.countryID...

Ahhh, I'm a bone-head. Thanks Paul -------------------------------- Fortius, Citius, nullis secundus Strength, Speed, second to none

I'm trying to truncate the decimals from a calculation that I'm making in a query. I have the following function but it returns 0 (zero) for all of my values. Public Function RndDn(MyNum As Double) As Integer Dim lngResult As Long lngResult = Int(MyNum) MyNum = lngResult End...

Super Dave, Thanks for the help. The "Interior" property was tripping me up. Not to mention the column selection. -------------------------------- Fortius, Citius, nullis secundus Strength, Speed, second to none

I have a range of columns that are currently hidden. I would like to unhide a column based on a cells color. Here is the code I have so far (it doesn't work). Range("R2:DQ2").Select For Each Item In Selection If Item.Font.ColorIndex = 35 Then With Item...

Hello, Instead of using the "enabled" method you can use the "locked" method. cbo.locked = True The locked method is similar to enable with a few exceptions. With locked equal to True, the field is not grey and can receive focus however the data in the field can't be...

DanEaton, Access does not allow you to delete controls out of the Tab Order list but you can set the properties of a control so that it won't tab stop. In the properties dialog box go to the "Other" tab. You will see a "Tab Stop" property. "YES" gives the control a...

Martin007, There is a work-around you can use to bypass the wizard. 1. Set up a combo-box on the form without using the wizard. 2. Go to properties then select the Data tab. 3. Make "Row Source Type" = Table/Query 4. In "Row Source" enter an SQL statement that gets the...