Search results for query: *

Hello to all, I have a form that is based off a query. I have put a cmd button to delete the record but it only deletes from the screen. When I go to the actual table, its still there. I am not sure if the problem is because the form is based off a query or not. How would I be able to...

Hello to all, I have a form that contains 3 combo boxes. I need the value of the combo boxes be passed to a query that another form is based off of. 1st field passes a -1 or 0 to the query for a yes/no field 2nd field passes text for the country selected 3rd field is bases off a...

Hello to all, I have been searching these threads all afternoon, but can't find anything that comes close to what I need. I feel its a simple solution but just can't figure it out. Here's the situation: I have a form (frmViewOrphans) that has a combo box on it (cboSponsoredStatus). When...

Hello to all, I have been searching these threads all afternoon, but can't find anything that comes close to what I need. I feel its a simple solution but just can't figure it out. Here's the situation: I have a form (frmViewOrphans) that has a combo box on it (cboSponsoredStatus). When...

Hello to all, I have a form (frm_paymentform) that has a subform (subfrm_paymentform_payment) on it. On the Form_Load event of frm_paymentform I have the following code: If DCount("[Sponsorship ID]", "qry_paymentform", "[Sponsorship ID]=" & Me.[sponsoring.Sponsorship ID]) <> "0" Then...

Hello to all, I have a form that contains the fields 'Term of Sponsorship', 'Start of Sponsorship' and 'End of Sponsorship'. In the field 'Term of Sponsorship', the user picks from a combo box either, 1 year or 2 years, or 3 years and so on... In the field 'Start of Sponsorship', the...

Hello to all, I have a form (frmsponsoringinfo) that has 2 fields that need to be populated from 2 subforms on another form. frmassign contains 2 subforms: subfrmsponsors (based off a query qryunassignedsponsors) subfrmorphans (based off a query qryunassignedorphans) I need the field...

Hello to all, I know there are several posts in regards to deleting duplicate records but they all show how to do it in SQL using 'Select' and all... I am unfamiliar with this and would like to know is there an easier way or could someone briefly explain what steps are to be done to...

Hello to all, I have a database that has pictures embedded into an OLE Object field. I am now creating a new database that will use hyperlinks. I need to extract the original picture from the embedded OLE field and save it on my computer. From that point, I know how to get the info i...

Hello to all, I have a database that contains an OLE Object field to display pictures. Well, now that the database is getting too large, I'd like to use hyperlinks to view. I know how to setup the hyperlinks with no problem. But I'd like to be able to get the file path and name via VBA...

Hello to all, I hope this doesn't sound too weird or complicated but I will do my best... I have a form (frmSelect) that has 2 combo box's to select a Project and a Country. Those values are stored in a table (tblSelect). I have a query (qrySelect) that is the recordsource for...

Hello to all, I have a report that has 3 subreports. I have placed a pagebreak before the subreports so that they start on a new page. My problem is that sometimes the subreports grow due to numerous records added by the user. When this happens, it pushs everything down and sometimes on...

Hello to all, I have a report that has 3 subreports. I have placed a pagebreak before the subreports so that they start on a new page. My problem is that sometimes the subreports grow due to numerous records added by the user. When this happens, it pushs everything down and sometimes on...

Hello to all, I am using an image control on a report to show a picture through a hyperlink based off of 2 fields. I can get the picture to show with now problem. But if there is no file name in Me!Photo, the report uses the picture from the previous record. I am trying to use the...

Hello to all, I have been searching this forum for the past 2 hours and can't seem to find a post that will enable me to have a command button that when clicked, opens a file dialog box and select a file. Then save JUST the file name to a text box. I need to have the file dialog box open...

Hello to all, I am sure this is an easy question for most of you but I just can't figure it out today. I have a field that contains a file directory path that is retrieved from a Browse button. But the path is invalid unless there is a \ at the end. How do I add a \ at the end of...

Hello to all, I have a hyperlink to open a picture on an image control. I finally got it to work after numerous hours... But the problem is that once the hyperlink runs, it opens another form that contains part of the hyperlink. location = filepath Photo = file name Picture = Image...

Hello to all, I have an image control that is set to show a picture linked to it from hyperlink fields. These hyperlink fields are 2 different fields.. txtLocation (Location path) and txtPhoto (File Name). My problem is...once I input the file name in txtPhoto, I want the photo to appear...

Hello to all, I have a database that I want the users to enter the picture name (i.e. pic1.jpg) into a field. Once the name is entered, I was Access2K to open that picture in Windows Explorer window once the field is clicked. I have the field type as 'Hyperlink' but Access adds http:\\...

Hello to all, Thanks in advance for your help and/or advice for my question... My question is, I have a table that has an OLE field with linked pictures on the server. My database is huge and need to get it smaller. I would like to use hyperlinks but not sure if I can convert the field...