Search results

Hi All, I have a 'supplier contact' database. I am using a programme called maptive to create a map of all my suppliers. I can view my map inside my database via a webcontrol on a form. To cut a long story short... I can click on a point on my map to view information about the supplier in...

Thanks again for the response. I'll have a look at a continuous form. Cheers

Thanks for the swift response Simply because it would look better on my form. Can I change the colour at all?

Hi All, This seems like a really simple question but I have searched everywhere and can't find a solution. I have a main form with a subform. The subform is in datasheet view. How do I remove the grey bar from the left of the subform. I.e the row selectors where you click to highlight the...

Thanks MLUCKHAM Just did some research on the open args and think this will be much better

Thanks a lot for the link but I still can't see to get this working... According to the link I should be using... DoCmd.OpenForm "frmSuppliersSummaryCategories", acNormal, , "Forms!frmSuppliersSummaryCategories!frmSuppliersSummaryCategoriesSubForm.Form!CategoryID IN(" & strWhere & ")" I.e...

Hi All, I have probably a simple NOOB question that I hope you can help me with please. I have a multi select list box which I am trying to use to open another form and apply a filter based on the user's multiple selections. List box - lstCatergories Main Form -...

Ahh that's working now thank you. I did change the field and query names originally but didn't reference them correctly as you have done... Did I mention I'm a noob :confused: Thanks again for your help

Hi Cheryl, Thank you very much for the swift response. I don't seem to be able to get this working, I'm a bit of a noob sorry!... maybe a sample of my db would help. Please find attached - Access 2010 format My button is on the frmAgencyRequest - called 'Submit' Thanks again Andy

Hello, I have a button on my form that opens a report and emails: Private Sub Submit_Click() DoCmd.SendObject acReport, "rptFM83", "PDFFormat(*.pdf)", "exampleemailaddress", "", "", "Agency Authorisation Required", "Hello, Please authorise the attached agency request. Thank you", True, ""...

Does nobody have any suggestions for this? I would really appreciate any help Thanks

Hi all, I'm having a tough time with my database. I have the following tables: tblCourses tblCourseUnits tblStudents tblStudentsandCourses tblStudentsandCourseUnits I have a form called frmCoursesandStudents. This shows each record from the tblStudentsandCourses I.e. Students...

Thanks for the reply. I will try as you have suggested and report back with any progress Thanks again

Hi all, I've hit a brick wall with a database I'm trying to create and would really appreciate some help :banghead: I am creating a training database that will show information on Students, Courses enrolled in, Units in selected course including some optional and some compulsory units I...

Ah so simple when you know what you're doing. Thank you very much for your help. I had to create a new query with the relationships as per your guidelines and point the form data to the new query. Previously I was trying to point my form at two separate tables - all working now Thanks again

Hi all, I'm hoping someone can help me with a small (I hope) problem I am having with my database. I am adding fields to an existing form ('Courses') from 'fields available in related tables'; however, when I add these my form excludes records that do not have data in these fields. I...

Hi all, I'm new to Access and new to the forum so please go easy on me :D I was hoping someone could help me with a form on a database I'm designing. The database is a simple employee database but I need to restrict access to some employees with certain users. I.e. Hire Manager can...