Search results

  1. B

    Help adding new records using a Query

    Hi all, well i've got myself really confused.. and have a major headache.. I have 2 tables.. 1st is Cases and 2nd is NETANFImports i've already got an update query that works perfectly.. it updates fields in Cases from that of NETANFImports however.. the problem i'm having is, i cannot seem...
  2. B

    DCount Problem.. in form load

    Hello Everyone, Hope everyone is having a better day than me.. as i just cannot get this to work... This is the problem, I have a table for tickets, and want a popup to show for the current user.. if i take out the & Me.Text42) it shows theres 90 Active tickets, but thats for all the...
  3. B

    Limit number of clients in date range

    Ok, not sure if this is even possible or where to even start.. I've got a form that has all the info for a client, eg.. Client First Name Client Last Name Client Hours Client WE/CS/EE Client Day And Times Client Phone Client Comments Begin Date & End Date (2 boxs) on there for date input...
  4. B

    goto form with current user and current date

    ok, how do i explain this... what i really need is for when the form opens, it looks at todays date, then matches current user and then goes to that record for today, if no current user there, then will goto new record.. i know, sounds complicated, and probably is really easy, but my heads...
  5. B

    Creating a Sign in Form..

    Ok i'm having a few problems, as Access only allows 255 collumns and not sure how else to do this.. so hopefully someone else has already had this problem or even knows a way round it.. I've been tasked with building a sign-in form for staff to use daily.. with multiple fields.. Date...
  6. B

    Weird problem, code works with in built however in VBA doesnt.

    Good Morning everyone.. Ok i've come accross a weird problem.. lol i have a countdown on 1 of my main startup forms, that checks to see if outlook is running if not then it'll auto start-it outlook, then when the counter gets to 0 it continues to load the main menu... Now if i have a...
  7. B

    Merge a spreadsheet into an already created table

    Hi all, Ok this is going to probably be an easy one, however as i've not done this at all yet.. i've been having problems merging a spreadsheet with data into an already created table.. the main things in comman is the "MC", "First Name", "Last Name". I'm trying to update dates etc that are on...
  8. B

    how to check textbox to see if date expired

    Hi everyone, well so far so good.. and now i've got a stupid problem that i just cannot seem to get to work... basicly i want to check Textbox text528 and if the date in there has expired (anything older than today), then it'll notify me.. however weird thing is.. its notifying on dates still...
  9. B

    How To Switch To Correct Record When Switching Forms

    Hi all, Well i'm in need of some help and just cannot seem to be able to work it out, i've looked all over and cannot seem to find an answer that will work... Here's the problem I have a form called "Customer Details", on that form i have child forms, including one that has a schedule on...
  10. B

    Hello Everyone..

    Hi everyone, i'm a fairly good designer and creator, and have created many scripts, apps etc in the past.. However i'm now learning access 2010, would you belive i've never used access in all the time i've done programs.. lol Anyway i've been using information her to create my first database...
Back
Top Bottom