Recent content by Tourniquet

  1. T

    Problem with selection query

    I created the 'links' as you can see in the attachment. The only prob now is that it again, only shows pand_id 1 four times. I'm really getting frustrated !! PLEASE HELP ! I made the following connections pand-id - huurcontr_pand_id gefact_id - huurcontr_gefact_id eig_id - pand_eigenaarid
  2. T

    Problem with selection query

    After searching the forum for my problem, i couldn't find an answer. I do have the following problem. I created a query for printing a report. I would like to print the data of the current data that is shown in a record. I made a query named beknopt_overzicht. Data has to be sorted by pand_id...
  3. T

    Formatting a Date

    Thanks, works great ! :rolleyes:
  4. T

    Formatting a Date

    Getting actual date in query, and format that date Hello, i do have a problem I have to create an invoice nr. base on : pandnummer, huurnummer and datum now i have created the following field in a query with an "expression". factuurnummer: [pand_pandnummer] & "/" & [gefact_huurdernummer] &...
  5. T

    How to : Delete record in a form, and archive the data to another form

    So if i create a field for example called 'deleted' an if i check the box of it, the sytem copys all fields from the form ?? I also would like to ask, where does the information go ?? Do i need to create another table or something like it ?? I really appreciate your help, but i am a little...
  6. T

    How to : Delete record in a form, and archive the data to another form

    Read it I have read all your replys, and would like to thank all of you ! The only problem is that the yes/no idea wouldn't work for me, i think. The one who posted that message said that yes/no checkbox was for one field !, but it has to be for a whole form with a lot !! of information. So...
  7. T

    How to : Delete record in a form, and archive the data to another form

    Read it I have read all your replys, and would like to thank all of you ! The only problem is that the yes/no idea wouldn't work for me, i think. The one who posted that message said that yes/no checkbox was for one field !, but it has to be for a whole form with a lot !! of information. So...
  8. T

    How to : Delete record in a form, and archive the data to another form

    Hello, I am working with a team on a building-management system. This means that the company were working for wants to enter their data about buildings in a Acces database. I only have a problem now. The company would like to have the possibility to delete records with use of a button. If they...
Back
Top Bottom