Microsoft Office (Excel, Word) forum -... - www.officefrustration.com | Site profile

The current queries (which used to run which seems unbelievable now) utilizes 1 data table (Daily) containing 1 Data Element (F1) which is set to Text 255 Here is a sample data values: F1 Suncor 103 Edson 10-13-53-15_EMKTC_20080825_DayCost.PDF Here are the 2 Query values that produce errors (Invalid Procedure Call) Well: Mid([F1],1,(InStr(1,[F1],"2008")-8)) R_Key: Mid([F1],(...

I have used the Access Developer Extensions Packaging Wizard to create a CD that will install my application's FrontEnd plus a Runtime Version of Access. My client has 2 computers that have the full version of Access and two computers without Access. I have used the CD to install the package on those computers without Access successfully. Can I use the same CD to install on the ...

I am working with 19 school districts and over 100 schools. Every computer can have different Microsoft Word and Microsoft Access installed. I am getting the mesage: Word could not re-establish a DDE Connection to Microsoft Access When we get the funding we upgrade the oldest software and machines. The system I am on now is SBS (Small Business Server) Word 2000 and Access ...

I found a way around having to change margin settings and it seems to work every time. The trick is that you HAVE to actually be in the header or footer field for it to work. Turn on Show/Hide so you see paragraph marks and go into the header field or footer field. If there is text to delete, highlight it, delete it then click on the Close Header/Footer button in the ...

I have been reading about using junction tables for tables that have a many to many relationship. In a lot of the examples they use a student table and a course table. Then they create a junction table with the primary keys from each table. When a student enrolls in a course, is that when the junction table is updated with a new row showing that student taking that course? ...

I have a symbol that looks like a backwards P at the begining of each line. I don't know how it got there, so naturally I can figure out how to get it off.

I am using Powerpoint 2003. I need to insert a long Excel spreadsheet into a single slide and animate it to scroll through the entire sheet. Any ideas how to accomplish this? Thanks.

I want to basically insert a powerpoint show within a slide in a seperate powerpoint show. Similar to adding a photo album onto a slide. Instead of images i want to have a seperate show be displayed with its animation effects within a slide on my presentation. Thanks in advance for any advice you can offer. "TAJ Simmons" wrote: megpinky, can you clarify, Is ...

i have two different tables - i want to compare two particular columns in the two tables . the columns are called as origin ciy in both the tables. Some of the entires in both of the columns are similar but not exactly the same. So i want to write a query which can update the entries in table 1 with the values in table 2- only when the entries are similar but not exactly the same. for ...

I am trying to LOOP through every field on my UNBOUND form. I am doing this to convert any ".." to "*" and then to concatenate the populated fields into a search string for the filter. My code is below, along with a list of fields found on the form. Any help is greatly appreciated. PS...I am open to changing the way this is setup. Code: Dim ACMD_Search_STR As String Dim ...

I have a data base with the following fields Customer Number Last name First name address phone number When I enter a customer number into my form that has already been entered in once i would like for the remaining information to auto fill so that i am not entering the information over and over. I know that there is a way to do this, however i am new to using access and ...

When I click on 'To' when sending and email and choosing an address the contacts shown don't match the contacts in the contact list. The contacts showing when I click on 'To' are not updating from the contact list. How can I fix this? I am using a Microsoft Exchange account but don't know a whole lot about how it works. Thanks.

Do the two individual select queries work? The queries don't look too long to me. Do the select queries look ok in the Access query design view? Are any of the fields Memo fields? (david) "Eka1618" wrote in message ... Hello, What I am trying to accomplish is to give the user the ability to run a report based on different criteria from 4 different tables: ...