Search results

Hi, I am trying to run a check that will make the user aware if the request they are adding via the form is likely to be a duplicate. If so I want the option to allow or reject the entry. Alternatively I have seen solutions that just notify on the form is something might be a duplicate, by...

I'm sure this is easy but I'm properly stuck I am making a database that processes access control requests for a large building. I need to filter what is a valid request between two dates. Requests come in with an access from and an access to text box on the table. I can get it to filter on...

Hi, Ive been trying to do this for about five days now, reading the internet, watching youtube and I just cant work it out. Please, please help :) ...pretty please This is for a database to handle requests for site access (I live in a shiny new datacentre). I have a main [mainAC] table...

In this age of war, isms and economic collapse that people still help each other. Each day i spend my free time trying to batter out my first shiny database and making up new problems as I go. Noone at work has the first clue what im doing so cant be any help, the internet as a rule is kinda...

I am trying to get the message Request added :) to show up when the new record command works. The message "add button error" show if there are any errors, rather than just doing nothing and stopping. However when it works I get both, I know I doing something very simple very wrong...

Probably the wrong approach but to enable me to run some code before a button is clicked I want to be able to click a button via VBA code. Basically I used the auto button wizard to make an add record button. To ensure a shed loads of if checks and queries on the entered form data run I...

Im struggling again so once more return for advice, Ive been trying a few random work arounds but im sure my basic approach is askew. I have a combobox that selects the reason for access [CBreason] when the slection is "Incident" I want the user to input an Incident Number in the[IncidentNo]...

As previous ill start with im still learning.. Ive gone through pages of internet searches but nothing pertinent seems to come up making me think its something small im missing out. I have a combobox [CBreason] that reads from a table to show me why someone is gaining access to the building...

Hi All, My first post on this forum. As most people start with..."ive been teaching myself Access and Ive got a few problems I cant solve"... I am creating a data base to handle access requests to a building. All has gone well so far and ive built tables, reports, forms and used queries...