Search results

Hi All, I've a form that I use to capture data and then want the form to email itself to our team's shared inbox, however I get the error: Delivery has failed to these recipients or groups: 'scsupportteam@***.***.uk' The e-mail address you entered couldn't be found. Please check the...

Hi All, I'm trying to make Vlookup's easier for my colleagues to do themselfves, does anybody know of a way of using [open brackets], or using a userform or VB like in Access to give the user a friendylier way of selecting the vlookup options? Hope that makes sense Thanks PHil

HI All, I have a form which has some questions on that a user updates to pass the parameters to a query, that works fine, but when opened I want this form to be a small square in the middle of the main main form. I've set it to Dialog and have set the width & height and have dragged the...

HI All, I want to add a parameter to a query that lets the user enter a number to filter on the 'Top Values' section of the query. I.E the query shows sales by product, the user enters 50 and it shows the top 50 records. I've had this working in the past but have lost my working and can't...

Hi All, I have a basic DB for recording supplier records, you enter a supplier ID and it performs Dlookups to run and display query results on the same form. That part works fine. I've added a subform and linked it to an existing query which returns the suppliers top selling lines and the...

HI All, I have a form which lets the user enter a contract ID and then a combo box that has a list of reports which run against whichever ID is entered. What I want to know if I put the ID's in a table if theres a way to allow the user to select multiple ID's in one go and run the report...

Hi There, I have a form with mulitple buttons that run different reports, I've used the mousemove VBA script to show text about the report when the cursor is placed over one of the buttons that all works fine. I'm wondering if using the same idea can you get it to display a image when the...

Hi, I have some code that when a check box in a table is ticked, sends a pop up message to the users logged in (message is on a hidden form), then it closes the DB after a pre-dtermined period of time. The problem I'm having is that we are a large site with a about 25 differnet servers that...

Hi All, I'm using Access 2003 and excel 2003. We currently manually run 5 different queries then copy and paste this data into 5 separate tabs on 1 workbook, I'm trying to automate some of this process if possible. I am trying to use the 'transferspreadsheet' action within a macro to run a...

HI All, We use Access 2003 as a ordering & inventory system, and the warehouse guys what to be able to see where products are ordered together, (i.e when a client orders tea they normally order sugar) so that they can stock the warehouse with these items closer together so theres less walking...

Hi, I'm fairly new into an analyst role and I know the basics of Access 2003 & VBA, but still get stumped by what may seem straight forward issues! Based in the UK and work for large multi site warehouse & Logistics company. Thanks Phil:)