Search results

  1. G

    Moving A record from one table to another

    OK right I understand this. I have created the query and then put a command button on my form When i click it, it tries to move every item in the original table into the history table. How do i associate it with the current record that is being displayed within the form? and not the entire...
  2. G

    Moving A record from one table to another

    Database is an asset register. I have a table called assetcurrent It displays the asset and where it is, who its with and what it is. I want a button on the form which when clicked will move the record from the table assetcurrent into another table called asset history. Any ideas?
  3. G

    Moving a record from one table to another

    I have a database of assets. For example a computer will have an asset . This database will show the asset, where it is, what it is and who its with . It will display this on a form. When this asset gets given to someone else i want a button on the form which displays the assets current data...
  4. G

    Filtering to display most recent

    that is correct thank you but as you said what if i want to see who passed the ball to him and sethim up as well before hand. that will add in extra rows is there anyway i can just view the most recent goal with all the information about it, ie, time, assist, competition etc
  5. G

    Filtering to display most recent

    Right i have a table which lists football players and what days they scored their goals. so its a total history for the season. so for example if tierry henry scores 32 goals he will have 32 different entries how can i run a query which will tell me when each player scored their most recent...
  6. G

    Linking form to search or create new record

    could you upload that for me please? that is exactly what i did and it didnt work as you saw by my second upload thank you
  7. G

    Linking form to search or create new record

    I have done this and it still does not work? any more ideas? thank you
  8. G

    Linking form to search or create new record

    dude so have i and it still doesnt work please see attached file and could you be so kind as to point out where im going wrong please Thank you
  9. G

    Linking form to search or create new record

    nope still not working if i enter a new record on form1 and then click form2 it just opens up at another record with some sort of error message Any ideas?
  10. G

    Linking form to search or create new record

    erm when you say function what exactly do you mean? where would i insert the code you have just given me im using this code from your example on the onclick event Private Sub Label75_Click() On Error GoTo Err_Label75_Click Dim strFrmName As String strFrmName = "Contract Filtered"...
  11. G

    Linking form to search or create new record

    Thank you, but that does not do what i require that opens the second form up to display the data for the state selected. Which is what i want But the problem with your example is that if i enter a new project on form1 and then click form2 it doesnt create a record for that same project in form...
  12. G

    Linking form to search or create new record

    I have uploaded an example of my database As you can see there are two tables and two forms. What i want is for a user to view or enter data for a record on the first form. And then when they are done they click the button to open up form2. What i want to happen is for the company name/id from...
  13. G

    filtering to display one entry per row

    thank you but not realy enough instructions for me to implement. could you upload an example please or include more detailed instructions Many thanks
  14. G

    filtering to display one entry per row

    im running a query on a table which contains many entries for the same thing the many entries are different years finanical information for that project how can i get a query to display a projects total spending for its earliest year, and not display any other year for that project bare in mind...
  15. G

    Locking A Database

    Steve I have used this code But it doesnt really do much?!?!?1 firstly im not sure what the module does I have created it. but i dont know what to call it and what to do with it Secondly I have tried turning my database into and mde and have note been able. Access just hangs thirdly i...
  16. G

    Filter Out Many Entries For One Type

    Right I have created a report from a query which is created from my tables The report displays a project and the phases that project is in and what date the project reached that phase. So if one project has been through ten phases it displays it ten times with the date at which it reached...
  17. G

    Dependant AutoFill Text Box

    Right I have a form which users will fill in There will be a date field they fill in in one text box and then next to will be "Financial Year" text box which I want to be autofilled depending on the date they enter. For example if they enter 01/01/05 then in the FY text box it will...
  18. G

    Cascading combos with Many Entries

    could you explain this a bit more for me please as Im not sure if i understand could you upload an example please im really desperate here thanks dude
  19. G

    Cascading combos with Many Entries

    Thanks, but that is what i have done You have the project form which is one and the location table which is many the many values are stored in the location table the location form is a sub form on the project form? could you please upload an example?
  20. G

    Cascading combos with Many Entries

    Right i have a project form which has a sub form of location One project can have many locations therefore it is nescarry to enter more than one location Problem is with the cascading combo boxes i have for country to region to sub region, is that you can enter one fine, but if you enter...
Back
Top Bottom