Search results

  1. A

    Not sure !

    Hi Guys Can anybody help? I am trying to put together a database for my organisation and i want the data entry form to work in a way that if yes is entered into a box then a new box will appear on the screen to allow supporting evidence to the yes answer, if a no is entered then the evidence...
  2. A

    Counting characters

    Hi All I need to create a qry that counts the chars in memo fields as if below 255 i can change it to a text field. Thanks Ant
  3. A

    Conditional formatting

    Hi Guys I have created a rpt that shows the status of projects. Three flags, Major, Minor and Acceptable. I have set the conditional formatting to fill with red, amber and green but they dont show on the report. Can anybody help please. Thanks Ant
  4. A

    Noob help please

    Hi Guys Ok I need to start by saying I am new to Access 2007 and may want to do something that is not possible but i'll ask the question anyway. I have a db that shows the status of a current part of a project, either Major, Minor, Acceptable or Unknown. What I want to do is create a qry...
  5. A

    Sequencing issue

    Hi All I have created a database that has a field for section number. Within this field there are numbers from 5.1 through to 15.1. However the records are displayed with either 10.1 at the top or 9.1 if sorted. Is there a way of getting 5 to appear at the top ? Thanks Anthony
  6. A

    Choice equals colour

    Hi All I have a question the revolves around getting colour onto forms. i have a risk database that shows red, amber and green, what I am looking for is a way to show a box on a form that holds a colour indicator not a word. thanks Anthony
  7. A

    auto populate field in table from 2 previous fields

    Hi guys I have a table for risk assessments and I am wanting to have the probability score and the impact score equal a value in the assessment field. So for example if the probability is selected as 1 and the impact is selected as 1 the the box will show the word "Green". If 3 & 3 it will...
  8. A

    Noob help please

    Ok guys I have a quick question. The Background I have created a very simple database so that I can enter takings from the shop on a daily basis. i have put income and expenditure into the same table then created seperate forms for data entry. The questions I am looking for a way of auto...
  9. A

    Auto populating a report

    Hi guys What I am looking to acheive is an auto populating rota system. By this I mean that Mr X works monday day tuesday night and wednesday day whilst Mrs X works monday night, tuesday day and wednesday night. Is there a way of setting the work patterns in the table and then populate a rota...
  10. A

    Yes no options in msgbox

    Hi Guys I am using Access 2007 (Works choice not mine) and I am trying to get a message box to pop up when a command button is pressed, simple enough but i want to have a yes no button on the box to either continue with form opening or to bounce back to the main form. I have written the vb...
  11. A

    Saving values on the on click event

    Hi guys i am looking for a piece of code if anybody can help. I have a text box that is hidden due to it mirroring another box that is running an equation. I assumed that a simple Me! function would work but alas . . no. So what i need is code to allow me to save the value of my text box into...
  12. A

    New to Access

    Hi guys Couple of questions. This is the first time i have created a database using access and am having an issue. I know from the one part what to do but its excaping me the process to follow. 1/ Need to bind a text box to a table, now obviously i just enter the value into the control source...
  13. A

    New to database creation

    Hi Guys I am fairly new to designing databases and so far the wizards have been great, I am told to avoid the wizards but when you are clueless they work fine. The database: I have designed a database that contains 2 tables linked via the customer name field. The first table is the client...
  14. A

    Confused

    Hi Guys I have a db that after opening the main form gives the option of entering a booking for a customer already registered. So on the bookings form i have a lookup combo box running to retrieve the name from the client table this bit works fine. I have then created text boxes to enter...
  15. A

    Forms to print on A4 paper

    Hi Guys Can anybody assist with the dimensions to set a form to print on an A4 sheet please. ie - 1 record one page, i know its a simple print command button but it keeps splitting onto 2 pages. Cheers Guys Anthony
  16. A

    Text boxes following to new record

    Hi All I have a very simple database to record mileage and work times etc. I have set up 3 text boxes, one is to enter start time and the other is to enter finish time, the in sequence the 3rd box gives me the difference between then using =Val([Text48]-[Text46]). This all works fine except...
  17. A

    noob needs help

    Hi Guys i have created a table and am trying to run a qry that counts specific data, i have been searching but cannot find the answer. I have a standard qry that has the criteria of "staff name" and dates between ## And ##. Now when that information is returned, how do i get a count figure for...
  18. A

    Can't find the answer - Can anybody help !!

    Hi Guys I currently have a database and the powers at be want me to enable a button that will count how many times in the database a particular month is used. So for example how many times did we visit a particular place in September/october etc. Is there a way of doing this that i can't see...
Top Bottom