Search results for query: *

Hi everyone, I am having issues with references in a MS DB I created. I recently upgraded from Access XP to Access 2010, and now the users (who are on Access 2007) are getting a compile error: "Can't find project or library." The program works fine on my computer. We never had this problem...

Subreport did the trick. Thanks again.

Problem is that I need them to be able to grow if there is a lot of text inputed; I just need the boxes to grow without affecting the other items (there is plenty of room). My other idea was to programatically move the items back after the text boxes grow by coding in the picture and label's...

Hi everyone, I have a report that is generated from a form, and the text boxes on the report "can grow" depending on the amount of text entered in the form. The probelm is that when the text boxes "grow" it pushes other pictures and labels onto the next page of the report. Is there a way I can...

Hi everyone, I have a simple letter that is being generated from a mail merge in Word. One of the names I am using has a prefix ("Mr. John Smith") from the datasource and I need to strip the prefix off ("John Smith"). If this were excel I would do: =RIGHT(A1,LEN(A1)-FIND(" ",A1)) where A1...

Hello everyone, Could somebody remind me how to do the following: Suppose I have two tables, mytable1 and mytable2, respectively. My master data: ID Name 1 Joan 2 Jill 3 Jenny 4 Jack And a table of entrees I wanted excluded from my query: ID 2...

Yes, exactly, thanks. Just for future reference is there a way to change the name of the table/sheet which the linked table points too? (I know how to change the location, but not the table name/sheet in the linked table manager) Collen

Thanks, PaulF- that was the problem. Collen

Hello everyone, I am having some trouble with a linked table. The linked table had been pointing to a file, professional_07.xls, saved in "My Documents" and it had been working fine. But I just recently updated the file (keeping the same file name) and now I'm getting an error. The error...

Perfect, thanks. Collen

Hey everyone, Suppose I have this sample data in the query MyQuery in the field FullName: John Smith Julie L. Jones Josh Jacob Wright I would like to create a new field to pull out the last name so I can sort by last name. Could somebody suggest the SQL that would do that. Thanks, Collen

Hello everyone, I have a report with a few tables at the top, and then under them five text boxes (stacked vertically) which have can grow propery set to "yes". These five text boxes hold long sets of notes that can be any length. Sometimes all fit on one page. Sometime there may be, say...

Perfect, thanks.

Hello all, Suppose I have the following query: 2005 2006 %Change 10 5 -.5 3 4 .33333333333 0 0 #Error 0 4 #Error I want to get the table in my report to look like this: 2005 2006 %Change 10 5 -50% 3 4 33.3% 0 0 N/A 0...

jrbarnett, Thanks for the help with the table structure. lespaul, Thanks for the article reference. I had read it before, but had apparently forgotten a great deal of it. Collen

Hello everyone, Suppose on a form I allow a user to pick a particular product type. After the user picks the product type a combo box is enabled which lists manufacturers who make that particular product type. The user then selects a manufacturer. A manufacturer can make many different...

Skip, Thanks for the suggestion and for looking over the sheet. I'll definitely try these suggestions. Thanks again, Collen

Hi Skip, The tick marks are there because they the pivot filter values appear as " " instead of (blank). It makes it easier to filter- the other people using the sheet have requested that they be left. Perhaps they didn't have performance in mind when they initially created the sheet with all...

Please disregard... found a non-programmatic solution to the problem. Using Edit-> GoTo-> Blanks Then I enter the blank and hit control + enter. Thanks, Collen

Hello all, This code takes a long time to run... is there a better way? Objective is to add a blank to every empty excel cell in the range. Sub AddBlanks() For I = 1 To 2000 For J = 1 To 50 If Trim(ActiveSheet.Cells(I, J).Value & "") = "" Then...