Search results for query: *

Greetings. We are in the process of testing to upgrade from Windows NT to Windows XP. I am testing to make sure that the MS Access 2000 programs work correctly on XP. Once problem I have found is in a function that calls advapi32.dll. It can find it at c:\winnt\system32 on the old system but...

Can anyone suggest a good Active X control that will resize images when they are loaded into the database? Thanks.

Good Morning: We are currently in the process of moving our Access Databases into PCVS Dimensions to lock down the code. Dimensions takes the Access Database front end (all tables are linked from backends) and moved it into its control. It then makes the production a read only version. The...

Greetings. I currently have a module that sends emails to customers with no problem. What I want to do now is change the "FROM" email address from my personal email to a generic department email, so everyone can have access to the replies. I am currently using CreateObject.CreateItem...

Greetings. I am trying to create 70 reports based off of one template. I want the reports to be saved in a directory so each of our 70 offices can automatically be emailed with the report only for that office. I am currently using the docmd.outputTo function but cannot figure out how to set...

Greetings. I am trying to link an Oracle table through ODBC. It links fine, but chooses the wrong primary key. I have tried to change it through the properties, but it won't let me. Does anyone have any ideas? Thanks, Basia

Good Morning! I have an urgent question. I currently set the Enter Key Behavior to "New Line In Field" for all my fields on a form. Since there can be a lot of data, many users use the Shift F2/Zoom feature. The only problem is that when the hit enter in Zoom mode, it closes the box...

Greetings. I am currently using tabs to move between data. I have 4 tabs that each have a sub form on them. All of the sub forms use the same table. When I move between the forms and udpate data on each TAB, I get a message that I need to re-edit the data because the record was already edited...

Greetings. Can anyone tell me if there is a way to filter between forms with the following results? Form 1 - currently on clientA record and want to see training data for ClientA by clicking on form button to open training data. Form 2 - open training data for ClientA, but still have all other...

I am trying to set up an if statement using "like." Here is the If: If varTitle = "Manager" then process End If How do I make sure that anyone who has Manager in their title gets processed? Would it be the same for a Select Statement? Any help is much appreciated! Basia

Greetings. I would like to set up a button on my form that cleans up white space on a memo field. The TRIM function does not clean up Paragraphs or carriage returns. Could someone tell me how to use Find and Replace or SUBSTITUTE? Thanks, Basia

Greetings. I need to count the number of words in a memo box. Can help me figure this one out? Thanks in advance, Basia

Greetings. I am trying to do a simple select query and it is driving me nuts. I have two tables Personnel and Salary. In PERSONNEL, the grade and step are separate fields. I want to use these two fields to look up the salary for a specific grade and step in the SALARY table. How do I either...

Greetings. I am trying to open up MS Word from an Access Form using a merge. I have a field in an Access Table that strings together several fields. This field needs to be displayed on a pre-printed flyer and editable to users before printing. I want to: * Click on a button and open word to...

I have a table that has fields Address, Address2 and Address3. Often the Address 3 field is null. How do I get the labels to remove the field when it is null? It currently leaves a space on the label. I have tried: =trim[(address)&" "&(address2)&" "&(address3)]...

Greetings. I currently have a system that has an Access 2000 frontend and Oracle 8i backend. The Oracle 8i is set to timeout after 90 mintues of inactivity, but in Access, it times out after 15 minutes. Could someone direct me as to how to increase the length of timeout or is it located in the...

Greetings. I am currently trying to set up bulk email by looping through a recordset and sending a personalized email to each person in the recordset. When I debug, I see that the sendObject command line is set up correctly, but it only sends the first email but continues to loop through...

Hello. I am trying to set up a form that opens in Filter by Form so that I do not have to pull up all records (Access is the front end to several Oracle tables). When I try to use the ServerFilterbyForm = true in VB, It does not work. Any thoughts? Thanks..Basia

Greetings: I am trying to send out a personalized email to any given number of people. While the loop is working, only the first person on the list gets an actual email. Is some flag in the SendObject turning off? Here is my code: Set rst = Me.RecordsetClone rst.MoveFirst Do Until...

Greetings. I have set up a email system in Access 2000 to loop through a recordset and send each record a personalized email. Two problems: 1) I have the email function set up on a command button. When I click the command button, it sends out the email. If I leave the form and come back, the...