Search results

Hi All, I have a combo box on my form and I use a dlookup to populate this with the highest Age from my table. is there any way to populate this combo box with the highest age and counting backwards to the lowest age? For example: highest age = 25 lowest age = 17 so the combo box would be...

Hi All, I have a table which has the columns, ID, ForeName, Surname, Age, Entry I need the Entries column to increment depending on how many entries a user has created, for example. ID ForeName Surname Age Entry 1 Dan Jones 21 1 2...

Hi, I have a form which has a hyperlink textfield which holds a unique ID number, the user can click this hyperlink to open a new modal form. 'The modal form holds the file location based on the unique ID and I wish to have an image appear below based on the file location. So for example in...

HI, I currently have a report which allows me to filter out data that I dont need to view, I have a button next to each row on my report and when the user clicks this button it hides the row of data. this is all working perfectly. But As I try to use this report on a form as a sub-report, the...

Hi All, I have a sub-report that shows data from two tables joined together. As there are multiple results shown on my report, is it possible to filter out the ones i don't want too see? For example I have 7 rows showing on the sub-report which is what I need, but I want to add a button next...

Hi All, i want to write a query that allows me to view all records from my Details table, if multiple names have the same age, i just want to show one row with that name and age. For example below from "Details" i just want to view Peter and Adam ID | Name | Age 1 Peter 19 2 Adam...

Hi, Im having an issue that I'm hoping somebody could help with? I have a main form called frmDetails, on this form there are a number of textfields, with one in particular that I use quite a bit, this is called Total, with adds values together from the other textfields and displays the total...

Hi all, I am currently trying to update a table that is in SQL Server 2000 whenever my tbale in Access 2010 gets updated. I've read that Docmd.TransferDatabase method would work, but I need this to be timed every two minutes. For example, every two minutes Access needs to check to see if the...

Hi, I have a macro which will send an email, but before it before it sends it shows the "A program is trying to send an email message on your behalf" message. (Attached) Is there anyway I can disable this so the email automatically sends? Many thanks

On my main form I have a textfield (Age) and a combobox for forenames. I have a "Details" table where I have Forename, Surname, Age when i enter an age and click go I want the combo box to populate with all of the Forenames that are that age. for example if i search for age 21 the combo box...

Hi, Does anybody know how to find the highest Value in a column and return all data related to that highest value? I have a table called Details: Name Age Gender Address1 PostCode Country I know how to return the highest value in a column.. SELECT Max(Age) As Age From Details; But I need...

Hi, I have a form called RequestInformation where users can insert new details and modify their existing details from data that is stored in my tables. if a user inserts new data this becomes Version 1 and if a user amends minor changes to their details this becomes Version 2 and so on. The...

Hi All, i have a form which allows a user to enter their personal details it allows them to add new or update existing records. if the user only fills in half the forms a submits it, this inserts the submitted data correctly. I used DLookup's to allow their user to enter their personal ID ot...

Hi All, I have a report that shows the data from my Information table. One of the columns is called First_Name and under that header i have a button which sorts them into ascending order using the code below. Private Sub btnFirstName_Click() Me.OrderBy = "[FirstName] Asc" Me.OrderByOn =...

Hi All, I'm currently using an update query for a form for users and I'm running into problems. the form consists of text fields that allow users to enter their details, once completed they then click a save button which allows them to choose one of two options, add new or modify existing. If...

Hi All, I have this report which allows me to see all data in all of my tables On the report next to each row of information I have a view button which posts the data on to my main form which is made up of the tab controls. The problem I am having is when I click the view button, I only...

Hi, I have an insert query that is causing me hassle. Currently I have two tables Machine_Type and try Machine_Type ID Machine_Type 1 NM 2 NC 3 Esco 4 Rotary the Machine_Type column populates a combo box (cmbMachine_Type) on my form so i can see what...