Search results

  1. M

    Solved Expression Builder for address on Report

    Hello First off, I didn't write the code below, I took it from one of the Microsoft templates, so I am not 100% what it all does, as I am not the best at Access. However, it works very well if every field in the address boxes are filled in. The problem occurs when there is a null value in one...
  2. M

    Solved @;[Red]"(Required)" problems!

    Hello (yet again) I have been using one of the access templates (Northwind) to build an inventory system... While looking through the template I noticed a really cool feature that I have never seen before @;[Red]"(Required)" on the format of text boxes in the forms. So, I have since used it in...
  3. M

    Solved Loop through using OpenArg on main form and 2 sub forms deep

    Hello I have spent the best part of the day on lockdown trying to sort an issue out - what I want to do is so simple, yet seems the most complicated thing I've come across so far in VBA. I have tried everything I can find online without any luck! So any help would be great. I am at...
  4. M

    Update query for stock levels

    Hi guys I've honestly been on this topic for a few days and can't figure it out :banghead: I have searched this forum and google for hours on end without finding an answer. So if someone could point me in the right direction or help me here that would be awesome :) The problem I have a form...
  5. M

    equals to not working!

    Hi there everyone I have a problem with some code that does not work and I am beginning to pull my hair out, so any help would be appreciated. The problem is on the line If Forms!F_Overall_MainMenu!IDStaff = FindTutorTxtBox Then When both numbers are the same it does not execute what I have...
  6. M

    DLook up returning multiple records - Help

    I have a continuous form which displays contacts (private pupils, as I run my own music tuition business) from the contact table. There is another table which links to the contact table which stores the contacts lesson history and whether or not they attended those lessons. I want to work out...
  7. M

    Calculate multiple records

    If anyone can help it would be awesome!! Anyway... I run my own music tuition business and I want to be able to do take an annual record attendance score for each customer/pupil, just so I can see who is the worst and best attendant etc. I currently have a system where I take a register of...
  8. M

    DLookUp only selecting first two records! (moved from General)

    Hi Guys I have another problem and new this was the right place to come as people have sorted out some problems for me before! So... I have a hidden form that pops up when the main menu is opened. I have put the code below in the 'On Timer' event. TimeReminder = DLookup("TimeReminder"...
  9. M

    Another question on else function! Please help

    Hi I have a problem which has been bugging me for a while now, so thought I would sign up here to get it sorted! So here it goes. I have a form with a close button on it. I have written a code for it which is as follows. (It has been condenced though) if isnull (FirstName) and isnull...
  10. M

    Croeso (Welcome in Welsh)

    Hello Not a big fan of talking about myself but here it goes anyway! I am from Wales and am a fluent Welsh speaker (Welsh being my main language). For those who have never heard of Wales before check it out ;) I am a professional musician and have been for a number of years, since becoming a...
Top Bottom