need urgent help!!!!!!!!!!!!!!!!!
hi i wanted to be able to add or upload images from the form? i have a field called image which is a data type OLE Object, i right click on the field click on the insert object option on the menu an a bitmap image is linked having browsed for it and clicked on the link check box. i want to be able to add images from the form not go to the datasheet view? can you help me please!!!!!!!! also i wanted to have a button assigned to a text box in the form in which you input the image path( where the image is located) and a click of a button the image is displayed in the datatype OLE object field! so i want the code for the button, code for the text box and a code that will place the image in the image field?
|
0 |
|
Utf
3/11/2008 5:37:11 PM
access
16762 articles. 
3 followers.
6 Replies
1373 Views
Hi Try this link http://support.microsoft.com/kb/285820/en-us -- Wayne Manchester, England. "T3E" wrote: > hi i wanted to be able to add or upload images from the form? i have a field > called image which is a data type OLE Object, i right click on the field > click on the insert object option on the menu an a bitmap image is linked > having browsed for it and clicked on the link check box. i want to be able to > add images from the form not go to the datasheet view? can you help me > please!!!!!!!! also i wanted to have a button assigned to a text box in the > form in which you input the image path( where the image is located) and a > click of a button the image is displayed in the datatype OLE object field! so > i want the code for the button, code for the text box and a code that will > place the image in the image field?
|
|
0 |
|
Utf
3/11/2008 5:47:13 PM
"Wayne-I-M" wrote: > Hi > > Try this link > > http://support.microsoft.com/kb/285820/en-us > > > -- > Wayne > Manchester, England. > > i cannot understand a single fing sed in that support fing! which code is for the button and the text box if u can eplain that then i really appreciate it. >
|
|
0 |
|
Utf
3/11/2008 5:59:04 PM
Hi You don't a button. If you follow the steps given in the example you will "link" to a file (image in this case) held outside your database - you should do this or the database wil get too big. If you really want to see the path then you should just use a bound textbox - bound to the table field holding the path. -- Wayne Manchester, England. "T3E" wrote: > > > "Wayne-I-M" wrote: > > > Hi > > > > Try this link > > > > http://support.microsoft.com/kb/285820/en-us > > > > > > -- > > Wayne > > Manchester, England. > > > > i cannot understand a single fing sed in that support fing! which code is for the button and the text box if u can eplain that then i really appreciate it. > > >
|
|
0 |
|
Utf
3/11/2008 7:31:00 PM
Have a look at the very detailed answer given by Larry Linson on this subject. He has also given some links that may be helpfull http://groups.google.com/group/microsoft.public.access/browse_thread/thread/29ec4d334ba2a0d6/84324f7457e5d4c7?lnk=st&q=#84324f7457e5d4c7 -- Wayne Manchester, England. "T3E" wrote: > > > "Wayne-I-M" wrote: > > > Hi > > > > Try this link > > > > http://support.microsoft.com/kb/285820/en-us > > > > > > -- > > Wayne > > Manchester, England. > > > > i cannot understand a single fing sed in that support fing! which code is for the button and the text box if u can eplain that then i really appreciate it. > > >
|
|
0 |
|
Utf
3/11/2008 7:49:39 PM
hi, erm i've linked it the picture is displayed but what i wana do know is make it possible for a user to insert an image to a new record from the form. for example: my database is about an estate agency when a new property added the details are added then the image yeh! u wudn't expect you end user to use the datasheet view to add an image isn't it ! it should be done in a click on a button of sum sort! http://www.databasedev.co.uk/image-form.html check this out! THIS IS WHAT IM TRYING TO ACHIEVE? THANK YOU PLEASE GET BACK TO ME SOON I REALY NEED YOUR HELP!
|
|
0 |
|
Utf
3/11/2008 9:43:01 PM
The examples at http://accdevel.tripod.com cover what you indicate you need to do -- in fact, creating a new record with either an embedded or linked picture. Download and take a look at them. Most people here are volunteers and don't have time/energy to go off "surfing" to examples, nor, in fact, to provide specific code solutions (AKA free contract work). That's why we create "generic" examples to which we can refer. Larry Linson Microsoft Office Access MVP "T3E" <T3E@discussions.microsoft.com> wrote in message news:FFC18446-E4AC-4428-9F23-1086D2130F36@microsoft.com... > hi, erm i've linked it the picture is displayed but what i wana do know is > make it possible for a user to insert an image to a new record from the > form. > for example: > my database is about an estate agency > when a new property added the details are added then the image yeh! > u wudn't expect you end user to use the datasheet view to add an image > isn't > it ! it should be done in a click on a button of sum sort! > > http://www.databasedev.co.uk/image-form.html > check this out! THIS IS WHAT IM TRYING TO ACHIEVE? THANK YOU PLEASE GET > BACK TO ME SOON I REALY NEED YOUR HELP!
|
|
0 |
|
Larry
3/12/2008 2:14:00 AM
Similar Artilces:
Help!! can I recover lost contacts?
I just got a new windows smart phone. My celluar provider was assiting me to preform a sync. of all my contacts. There were no contacts on the phone I preformed the sync and when the sync. was over it wiped out all the comp. contacts in office contacts. The celluar provider said hmmm wonder what caused that. Anyways I think what happened is that the path the sync follows is phone (which was blank) to comp. back to phone. If this is the caseThis tech should of know better, but who am I to blame the only person's fault is mine ,I should of did a PST back up of thoes files....
URGENT! Exchange 5.5 Error
This error: "The Microsoft Exchange Information Store service terminated with service-specific error 4294966278." The event ID is 7024. I also get this error: "The Microsoft Exchange Event Service service depends on the MSE Info Store service which failed to start because of the following error: The service has returned a service-specific error code." The event ID for that is 7001. I found this link http://support.microsoft.com/kb/q219419 and I have followed the directions on that. I'm at step 5c right now and can't go anywere because of another error: &q...
Help with drop-down box creation
I have a large spreadsheet of case manager activity. Each case manager has a certain number of rows and columns for his/her information (case manager A uses the area A3:G43, case manager B uses H3:N43, etc.). There are 13 case manager areas in group 1 (rows 1-43), 13 in group 2 (rows 44-86), 13 in group 3 (rows 87-129), 4 sets in group 4 (rows 130-172), and 5 sets of totals at the bottom (rows 173-215). I want to create a drop-down box that would point to and locate the case managers' last names or worker ID#s. These items are not contiguous--they are located at cells B...
Do I need ADC? #2
to access Exch5.5 mailboxes in Windows 2003 AD (interim mode) + NT4 BDC environment? You don't need the ADC just for users to access the mailbox, but I recommend you look at configuring it so that it synchronizes the Exchange 5.5 mailbox attributes with the user accounts in Active Directory. Run the Wizards under ADC Tools first to make sure that you have one mailbox per one user account. When you get ready to install E2K3, you can install it in to the existing 5.5 organization and easily move the mailboxes over to E2K3. -- Jim McBee Blog - http://mostlyexchange.blogspot.com...
Help with Formula #11
Hi, hope someone can help me. I have a column (column A) of dates in my spreadsheet in the following format DD/MM/YYYY what I would like is formula in column B that will look at the date in column A and take off the DD so I will ultimatly have two columns e.g. Column A Column B 12/01/2004 01/2004 25/08/2005 08/2005 26/09/2005 09/2005 Many Thanks Try this. Where your list starts in A1 in B1 type. =TEXT(A1,"mm/yyyy") Copy down your list. Cheers, Stev -- Steve ----------------------------------------------------------------------- SteveG's Prof...
Help with ComboBox
Hi, I'm using Excel 2003 I have a spreadsheet using a ComboBox that allows selection of one of several sets of data. Each set is a 3 column row of data. I have the following properties set: BoundColumn: 2 TextColumn: 1 When a selection is made the ComboBox displays the column 1 value. The ComboBox seems to behave normally, except that when I close and open the file the combox initially displays the value of column 2 (instead of column 1). When a new selection is made it goes back to displaying the column 1 data. Shouldn't it always display the data as assigned by TextColu...
Need help formatting text
I am using OE 6 to read newsgroups and I sometimes post articles that I find on the web, often copying and pasting articles into new messages. However, when I do this, it formats it in such a way that when I open my posts, the paragraphs are separated by at least 3 lines, rather than 1 line. I have tried adding an additional step of pasting articles as unformatted text in word before I paste them in a new message in OE. It seems that no matter what I do, however, I get this weird extra spacing between the paragraphs. Anyone have any idea how to solve this problem? -- Aloha, G-Ride &qu...
Need help.......about Excel and Macro
I got two excel file in difference location. Both save in sharing folde at company server. 1st excel name is Operation file and the other name is NPI file. Bot have Product name, Package, Actual Ytd at Xfer and Actual PML at Xfer Engineer will key-in the data(Actual Ytd Xfer and Actual PML at Xfer at Operation file. I want make it automatically copy and paste that ne data(any changes) in Operation file to NPI file by click 1 button(follo the same product name and package). I know i can use formula( using ' ') for every box, but my company got so many product and that not mak sense. ...
Help needed with database design
Hi Heres hoping someone can help me with a problem. I need to design a small database to hold stock parts. This part is well within my abilities and is quite simple. eg Part_no Location description Price etc. The problem I have is that I need to be able to create some master parts which will make a kit composed of individual parts. The users need to be able to choose a master part which will return a list of the component parts and details such as price etc. On the same order the individual parts may also be ordered in addition to the master part. Also some of the individual parts will...
Adding 3D vectors ... need some help...
Hey guys -- I am new to this forum, it looks good. Here is my problem: I have created a worksheet for my AP Physics class where I ask them to create certain vector parameters and do various things to the created vectors, such as multiply and add them. But that is not what is important. What I need is the following: To have a cell show the addition of three numbers, with added coefficients. For example Cell A1=2.3 A2=3.4 A3=1.2 Cell B2=2.3i+3.4j+1.2k I want cell B2 to read exactly as the above, without actually adding the numbers in cells a1 a2 and a3, and I also need those coefficie...
function help for counting text as a value....
I have a schedule spreadsheet. i have 7 names in column A starting at row 4 the assignments are in Column B through O representing 2 weeks. (yes i have them labeled too in rows 2 and 3 for day of the week and the date) i can't remember the formula for calculating the assignment as a value of 12. here is an example of my spreadsheet. Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat 17-Jan 18-Jan 19-Jan 20-Jan 21-Jan 22-Jan 23-Jan 24-Jan 25-Jan 26-Jan 27-Jan 28-Jan 29-Jan 30-Jan Theresa AJ D AJ D OFF AJ D AJ D AJ D AJ D OFF OFF AJ D AJ D AJ D AJ D AJ...
Please help me -urgent
Hi, I have 2 work books. One is weekly schedule and other one is yearly vacation schedule. I would like to link both books matching names and dates. Vacation schedule is in monthly format and weekly schedule is in weekly format. Eg: yearly vacation schdule jan 1 Jan 2 Jan 3 and so on ram siva ganga weekly schedule jan 1 Jan 2 Jan 3 ram off 10-6 9-5 ganga off 9-5 11-7 siva 10-6 off 9-5 I need a formula in weekly schedule saying that if the date and name match in yearly schdule says “off” otherwise shift time under the same...
I need an Excel Spreadsheet for Cafeteria Plan Accounting.
I am using Office XP. I have been asked to track employee receipts for a small daycare/elementary school. This is our first year to implement this feature for about 30 teachers/employees. Each person will be allowed $500 for the year. I must record their receipts and be able to give them a running balance at any time. I need to show spending catagories. Thank you for your help. I suggest that you have an input sheet and a sheet for each employee. In the Input sheet you would have a one row, multi-column input area. The first cell would be a Data Validation cell with all the empl...
Need Archive help
I've recently set up a few worksheets(with the very impressive minds of the people here) that has four consistent formulas across every row. Now Im trying to be able to cut and paste a row to an archive without losing the formulas or the formulas staying in their columns. Is this possible? Or do I have other options, such as linking the worksheet so that it will archive itself? I really dont know how to save or move this info without having to delete the non formulated cells and then adjusting the whole worksheet. Any help comes highly appreciated Thank you Bryan Bloom ...
I need to list multiple related records within a single report she
I have a report which shows data, one sheet per school, for secondary schools. On each school's sheet I need to list the feeder primary school(s). At the moment, when there is more than one feeder primary school, the report is creating one duplicate sheet per secondary school, each with a different primary listed, rather than listing, say, 2 or 3 primary schools on the one secondary school reoport sheet. How do I solve this? Any help would be much appreciated. The primary school data is drawn from a different, but related, table to the secondary data, with a one-to-many join on the...
Top Urgent: message all stuck in "Message Awaiting Directory Lookup" queue
what is the problme??? On Fri, 21 Jul 2006 19:10:13 +0800, "John" <john@home> wrote: >what is the problme??? > For urgent issues, you should call PSS. Nonetheless: http://msexchangeteam.com/archive/2006/06/23/428114.aspx ...
help to paste
i have a cell which will have a number put in it.how do i tell exel to paste to different cells (depending on what number is put in the cell) EXAMPLE : if the cell contains "1" then paste "hello" in cell A2 if cell contains "5" then paste "hello" in cell F6 You can put a formula in cell A2: =if(A1=1,"Hello","") And cell F6 would have the formula: =if(A1=5,"Hello","") If you did not want to put formulas into all of the cells you want the message to appear then you would have to use some VBA. I could pro...
Help Sendobjest
I am hopping some one can help me I have an application in Access 2000 which has been running on XP and XP professional for a very long time every morning this application creates a list of reminders it then creates an E-Mail for each reminder and with a loop it sends all the e-mails one at a time the code is DoCmd.SendObject acSendNoObject, , acFormatTXT, StrFullAddress, , , strMailSubject, strMailMsg, False All of a sudden a couple of months ago I noticed that it was sending the first mail ok with the usual out look message and then it just looped through the rest but did not send...
help #42
Hi! I have Microsoft outlook express 6. Internet links in messages, when I click on those they don't open automatically, I have to use cut and go to web browser to paste to open the link page. Is there anyway, they can open automatically when I click on those on messages? If there is a way, what do I have to do? Please help. Raj Goel goels wrote: || Hi! || || I have Microsoft outlook express 6. Internet links in messages, when || I click on those they don't open automatically, I have to use cut || and go to web browser to paste to open the link page. Is there || anyway, they...
What happened to Help/"Send Feedback on Entourage (Word, Excel.)?
One of the lovely features of Office 2004 used to be (past tense) being able to go under the Help pulldown menu on any sub-program (Entourage, Word, Excel) and click on "Send Feedback on__________ (name of Office 2004 sub-program on which you wish to submit feedback)." The website page that now comes up makes it more cumbersome to send a Mac product suggestion to Microsoft via the Help/Send Feedback route. Clicking on that pulldown menu item takes you to: <http://support.microsoft.com/contactus/> I made the mistake of clicking on "Select a Product" at the top of th...
Printing Help #2
Is there any way for me to be able to print specific colums from multiple worksheets all at once? Is there any way to select colums from a spreadsheet that would normally be on different pages, and have them print on the same page, without having to copy & paste them into a new worksheet? First create a new worksheet Then for each range: copy|Paste special|Values to a nice (contiguous) spot on that new worksheet. then print from there. Then make sure you do File|page setup to make it fit your piece of paper. In fact, if you edit|copy, then go to the new worksheet, you can Shif...
~~ Need Help Creating Composite ActiveX Control
Help! I'm having a very tough time finding examples of how to do something which I think should be fairly easy. Could you kindly point me in the right direction? I have an application that has dialog boxes which can be extended by hosting an ActiveX control written by a third party. Typically this ActiveX control will consist of a number of edit controls and checkboxes. How do I create an ActiveX control with C++ that consists of mulitple controls? Is it possible to do this with MFC or do I have to use an ATL composite control? My hosting application is already a MFC app. How do I ...
Access 2007 Package Solution Wizard
I have successfully used the Access 2007 Package Solution Wizard to deploy my databases to computers without Access 2007 and it really works great. It saves a lot of trouble, money, and makes my database install & run like a real application. But one simple problem still eludes me: - How do I enter the Install Subfolders Path under Additional files? I have tried using: c:\filename (but the Wizard does not allow / or : etc..?) I have tried using: %WINDOWS%SYSTEM32 but this just creates a folder by that name and puts the files inside? I have searched the web but no one explains the proper...
Need Help (i'm at the end of my rope) WMP wont work Missing DRM
Hello, i konw i'm new here but i'm really at the end of my rope. i had to upgrade my motherboard and processer not long ago, and when i did i seemed to lost my drm folder in windows. i have tried everything i can find online, including upgrading windows vista to windows 7 (no good) show all hidden files to delete all files in drm folder. (no drm folder) went to that upgrade drm thing microsoft has and i cant because the button is greyd out or i get a error in internet explorer. running a reg cleaner for missing dll's. i'm losing it. i need major help. please ...
Help Creating Form
I have 5 tables: Manufacturers, Products, Brands, Varieties, Sizes. I would like a combobox Manufacturer that would filter a Products combobox that would in turn filter a Brands combobox. After selecting a Brand from the Brand combobox, I need to enter several Varieties for each Brand and several Sizes (Size, Unit, Pkg) for each Variety. Please help. I am new to this. I have the relations set in the order that the tables appear on the 1st line of this post. On Thu, 11 Mar 2010 06:38:14 GMT, "rnjalston" <u58689@uwe> wrote: >I have 5 tables: Manufacturers...
I just got a new windows smart phone. My celluar provider was assiting me to preform a sync. of all my contacts. There were no contacts on the phone I preformed the sync and when the sync. was over it wiped out all the comp. contacts in office contacts. The celluar provider said hmmm wonder what caused that. Anyways I think what happened is that the path the sync follows is phone (which was blank) to comp. back to phone. If this is the caseThis tech should of know better, but who am I to blame the only person's fault is mine ,I should of did a PST back up of thoes files....
URGENT! Exchange 5.5 Error
This error: "The Microsoft Exchange Information Store service terminated with service-specific error 4294966278." The event ID is 7024. I also get this error: "The Microsoft Exchange Event Service service depends on the MSE Info Store service which failed to start because of the following error: The service has returned a service-specific error code." The event ID for that is 7001. I found this link http://support.microsoft.com/kb/q219419 and I have followed the directions on that. I'm at step 5c right now and can't go anywere because of another error: &q...
Help with drop-down box creation
I have a large spreadsheet of case manager activity. Each case manager has a certain number of rows and columns for his/her information (case manager A uses the area A3:G43, case manager B uses H3:N43, etc.). There are 13 case manager areas in group 1 (rows 1-43), 13 in group 2 (rows 44-86), 13 in group 3 (rows 87-129), 4 sets in group 4 (rows 130-172), and 5 sets of totals at the bottom (rows 173-215). I want to create a drop-down box that would point to and locate the case managers' last names or worker ID#s. These items are not contiguous--they are located at cells B...
Do I need ADC? #2
to access Exch5.5 mailboxes in Windows 2003 AD (interim mode) + NT4 BDC environment? You don't need the ADC just for users to access the mailbox, but I recommend you look at configuring it so that it synchronizes the Exchange 5.5 mailbox attributes with the user accounts in Active Directory. Run the Wizards under ADC Tools first to make sure that you have one mailbox per one user account. When you get ready to install E2K3, you can install it in to the existing 5.5 organization and easily move the mailboxes over to E2K3. -- Jim McBee Blog - http://mostlyexchange.blogspot.com...
Help with Formula #11
Hi, hope someone can help me. I have a column (column A) of dates in my spreadsheet in the following format DD/MM/YYYY what I would like is formula in column B that will look at the date in column A and take off the DD so I will ultimatly have two columns e.g. Column A Column B 12/01/2004 01/2004 25/08/2005 08/2005 26/09/2005 09/2005 Many Thanks Try this. Where your list starts in A1 in B1 type. =TEXT(A1,"mm/yyyy") Copy down your list. Cheers, Stev -- Steve ----------------------------------------------------------------------- SteveG's Prof...
Help with ComboBox
Hi, I'm using Excel 2003 I have a spreadsheet using a ComboBox that allows selection of one of several sets of data. Each set is a 3 column row of data. I have the following properties set: BoundColumn: 2 TextColumn: 1 When a selection is made the ComboBox displays the column 1 value. The ComboBox seems to behave normally, except that when I close and open the file the combox initially displays the value of column 2 (instead of column 1). When a new selection is made it goes back to displaying the column 1 data. Shouldn't it always display the data as assigned by TextColu...
Need help formatting text
I am using OE 6 to read newsgroups and I sometimes post articles that I find on the web, often copying and pasting articles into new messages. However, when I do this, it formats it in such a way that when I open my posts, the paragraphs are separated by at least 3 lines, rather than 1 line. I have tried adding an additional step of pasting articles as unformatted text in word before I paste them in a new message in OE. It seems that no matter what I do, however, I get this weird extra spacing between the paragraphs. Anyone have any idea how to solve this problem? -- Aloha, G-Ride &qu...
Need help.......about Excel and Macro
I got two excel file in difference location. Both save in sharing folde at company server. 1st excel name is Operation file and the other name is NPI file. Bot have Product name, Package, Actual Ytd at Xfer and Actual PML at Xfer Engineer will key-in the data(Actual Ytd Xfer and Actual PML at Xfer at Operation file. I want make it automatically copy and paste that ne data(any changes) in Operation file to NPI file by click 1 button(follo the same product name and package). I know i can use formula( using ' ') for every box, but my company got so many product and that not mak sense. ...
Help needed with database design
Hi Heres hoping someone can help me with a problem. I need to design a small database to hold stock parts. This part is well within my abilities and is quite simple. eg Part_no Location description Price etc. The problem I have is that I need to be able to create some master parts which will make a kit composed of individual parts. The users need to be able to choose a master part which will return a list of the component parts and details such as price etc. On the same order the individual parts may also be ordered in addition to the master part. Also some of the individual parts will...
Adding 3D vectors ... need some help...
Hey guys -- I am new to this forum, it looks good. Here is my problem: I have created a worksheet for my AP Physics class where I ask them to create certain vector parameters and do various things to the created vectors, such as multiply and add them. But that is not what is important. What I need is the following: To have a cell show the addition of three numbers, with added coefficients. For example Cell A1=2.3 A2=3.4 A3=1.2 Cell B2=2.3i+3.4j+1.2k I want cell B2 to read exactly as the above, without actually adding the numbers in cells a1 a2 and a3, and I also need those coefficie...
function help for counting text as a value....
I have a schedule spreadsheet. i have 7 names in column A starting at row 4 the assignments are in Column B through O representing 2 weeks. (yes i have them labeled too in rows 2 and 3 for day of the week and the date) i can't remember the formula for calculating the assignment as a value of 12. here is an example of my spreadsheet. Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat 17-Jan 18-Jan 19-Jan 20-Jan 21-Jan 22-Jan 23-Jan 24-Jan 25-Jan 26-Jan 27-Jan 28-Jan 29-Jan 30-Jan Theresa AJ D AJ D OFF AJ D AJ D AJ D AJ D OFF OFF AJ D AJ D AJ D AJ D AJ...
Please help me -urgent
Hi, I have 2 work books. One is weekly schedule and other one is yearly vacation schedule. I would like to link both books matching names and dates. Vacation schedule is in monthly format and weekly schedule is in weekly format. Eg: yearly vacation schdule jan 1 Jan 2 Jan 3 and so on ram siva ganga weekly schedule jan 1 Jan 2 Jan 3 ram off 10-6 9-5 ganga off 9-5 11-7 siva 10-6 off 9-5 I need a formula in weekly schedule saying that if the date and name match in yearly schdule says “off” otherwise shift time under the same...
I need an Excel Spreadsheet for Cafeteria Plan Accounting.
I am using Office XP. I have been asked to track employee receipts for a small daycare/elementary school. This is our first year to implement this feature for about 30 teachers/employees. Each person will be allowed $500 for the year. I must record their receipts and be able to give them a running balance at any time. I need to show spending catagories. Thank you for your help. I suggest that you have an input sheet and a sheet for each employee. In the Input sheet you would have a one row, multi-column input area. The first cell would be a Data Validation cell with all the empl...
Need Archive help
I've recently set up a few worksheets(with the very impressive minds of the people here) that has four consistent formulas across every row. Now Im trying to be able to cut and paste a row to an archive without losing the formulas or the formulas staying in their columns. Is this possible? Or do I have other options, such as linking the worksheet so that it will archive itself? I really dont know how to save or move this info without having to delete the non formulated cells and then adjusting the whole worksheet. Any help comes highly appreciated Thank you Bryan Bloom ...
I need to list multiple related records within a single report she
I have a report which shows data, one sheet per school, for secondary schools. On each school's sheet I need to list the feeder primary school(s). At the moment, when there is more than one feeder primary school, the report is creating one duplicate sheet per secondary school, each with a different primary listed, rather than listing, say, 2 or 3 primary schools on the one secondary school reoport sheet. How do I solve this? Any help would be much appreciated. The primary school data is drawn from a different, but related, table to the secondary data, with a one-to-many join on the...
Top Urgent: message all stuck in "Message Awaiting Directory Lookup" queue
what is the problme??? On Fri, 21 Jul 2006 19:10:13 +0800, "John" <john@home> wrote: >what is the problme??? > For urgent issues, you should call PSS. Nonetheless: http://msexchangeteam.com/archive/2006/06/23/428114.aspx ...
help to paste
i have a cell which will have a number put in it.how do i tell exel to paste to different cells (depending on what number is put in the cell) EXAMPLE : if the cell contains "1" then paste "hello" in cell A2 if cell contains "5" then paste "hello" in cell F6 You can put a formula in cell A2: =if(A1=1,"Hello","") And cell F6 would have the formula: =if(A1=5,"Hello","") If you did not want to put formulas into all of the cells you want the message to appear then you would have to use some VBA. I could pro...
Help Sendobjest
I am hopping some one can help me I have an application in Access 2000 which has been running on XP and XP professional for a very long time every morning this application creates a list of reminders it then creates an E-Mail for each reminder and with a loop it sends all the e-mails one at a time the code is DoCmd.SendObject acSendNoObject, , acFormatTXT, StrFullAddress, , , strMailSubject, strMailMsg, False All of a sudden a couple of months ago I noticed that it was sending the first mail ok with the usual out look message and then it just looped through the rest but did not send...
help #42
Hi! I have Microsoft outlook express 6. Internet links in messages, when I click on those they don't open automatically, I have to use cut and go to web browser to paste to open the link page. Is there anyway, they can open automatically when I click on those on messages? If there is a way, what do I have to do? Please help. Raj Goel goels wrote: || Hi! || || I have Microsoft outlook express 6. Internet links in messages, when || I click on those they don't open automatically, I have to use cut || and go to web browser to paste to open the link page. Is there || anyway, they...
What happened to Help/"Send Feedback on Entourage (Word, Excel.)?
One of the lovely features of Office 2004 used to be (past tense) being able to go under the Help pulldown menu on any sub-program (Entourage, Word, Excel) and click on "Send Feedback on__________ (name of Office 2004 sub-program on which you wish to submit feedback)." The website page that now comes up makes it more cumbersome to send a Mac product suggestion to Microsoft via the Help/Send Feedback route. Clicking on that pulldown menu item takes you to: <http://support.microsoft.com/contactus/> I made the mistake of clicking on "Select a Product" at the top of th...
Printing Help #2
Is there any way for me to be able to print specific colums from multiple worksheets all at once? Is there any way to select colums from a spreadsheet that would normally be on different pages, and have them print on the same page, without having to copy & paste them into a new worksheet? First create a new worksheet Then for each range: copy|Paste special|Values to a nice (contiguous) spot on that new worksheet. then print from there. Then make sure you do File|page setup to make it fit your piece of paper. In fact, if you edit|copy, then go to the new worksheet, you can Shif...
~~ Need Help Creating Composite ActiveX Control
Help! I'm having a very tough time finding examples of how to do something which I think should be fairly easy. Could you kindly point me in the right direction? I have an application that has dialog boxes which can be extended by hosting an ActiveX control written by a third party. Typically this ActiveX control will consist of a number of edit controls and checkboxes. How do I create an ActiveX control with C++ that consists of mulitple controls? Is it possible to do this with MFC or do I have to use an ATL composite control? My hosting application is already a MFC app. How do I ...
Access 2007 Package Solution Wizard
I have successfully used the Access 2007 Package Solution Wizard to deploy my databases to computers without Access 2007 and it really works great. It saves a lot of trouble, money, and makes my database install & run like a real application. But one simple problem still eludes me: - How do I enter the Install Subfolders Path under Additional files? I have tried using: c:\filename (but the Wizard does not allow / or : etc..?) I have tried using: %WINDOWS%SYSTEM32 but this just creates a folder by that name and puts the files inside? I have searched the web but no one explains the proper...
Need Help (i'm at the end of my rope) WMP wont work Missing DRM
Hello, i konw i'm new here but i'm really at the end of my rope. i had to upgrade my motherboard and processer not long ago, and when i did i seemed to lost my drm folder in windows. i have tried everything i can find online, including upgrading windows vista to windows 7 (no good) show all hidden files to delete all files in drm folder. (no drm folder) went to that upgrade drm thing microsoft has and i cant because the button is greyd out or i get a error in internet explorer. running a reg cleaner for missing dll's. i'm losing it. i need major help. please ...
Help Creating Form
I have 5 tables: Manufacturers, Products, Brands, Varieties, Sizes. I would like a combobox Manufacturer that would filter a Products combobox that would in turn filter a Brands combobox. After selecting a Brand from the Brand combobox, I need to enter several Varieties for each Brand and several Sizes (Size, Unit, Pkg) for each Variety. Please help. I am new to this. I have the relations set in the order that the tables appear on the 1st line of this post. On Thu, 11 Mar 2010 06:38:14 GMT, "rnjalston" <u58689@uwe> wrote: >I have 5 tables: Manufacturers...