Search results

  1. S

    Removing records using a query comparing two fields with identical values

    Hi - I wonder if someone is able to help. I have two seperate fields in a query that I would like to 'compare'I would like to know if there is a way of being able to enter a 'condition' of somekind into the query to remove records, when the entry in each of the fields is the same.Thanks in...
  2. S

    Help with commas for report values...

    Hi - I have created a report, which shows some currency amounts - in the properties for this value, the format is "Currency" which means the value appears as £23,983,938.00 however, I don't want the £ sign to be shown. I want the value to appear as 23,983,938.00. If i have no format, it appears...
  3. S

    Showing date range on report

    Hi... I have created a report to show a particular date range of data. When i run the report, i am asked for a start date and end date. I have achieved this by adding the following simple expression into the report query underneath the date field: >=[Start Date] And <=[End Date] This way i...
  4. S

    Change Date Format on Data Table

    Hi Guys... I need some help pls. I have a very large data table, that contains a date field. However the date has been stored in a particular format: 20090602, and the field is highlighted as a Number in the field type properties. I want to change the field type to Date and change the format to...
  5. S

    Help with expression builder...

    Hi Guys... I am pretty new to access, and i really need a bit of help. I am trying to place an expression into a query using expression builder. I have a column in my table called "TradeStatus" for each record (company) i want to count the number of trades where the trade status is "Completed"...
  6. S

    Button to stamp users details based on windows username

    Hi, I wonder if someone is able to help me as i am completely stuck :confused: . I have built an access database which is used at work by a number of people within my team. I want to add an authorise button to the database, which when clicked will stamp the record with the date, time and also...
  7. S

    Display different form in a subform based on command button...

    Hi Guys, I am stuck on a subform problem in my DB - I would like to do something but not sure if it is possible - if someone is able to point me in the right direction i would really appreciate it. I would like to set up a subform on the main form of my DB and four command buttons, then...
  8. S

    Tick box True/Fales, Display/Hide OLE Object...

    Hi everyone - i wonder if someone could help. I am looking to understand the VBA code that should be used for a tick box on one of my forms. When the tick box is "True" i want an OLE object (which is on the form but hidden) to be "Displayed". When the tick box is false, i want the OLE Object to...
  9. S

    Conditional border colour on date field...

    Hi :D, I wonder if someone is able to help me as i am really stuck on this problem with my database. I have created the database in Access 2003. On one of the forms in the database, i want the "Date" field border to be displayed a different colour, dependent on how long the record has been in...
Back
Top Bottom