Recent content by Rats

  1. R

    Finding the last record

    Found the answer on Microsoft Help. Recordset.movelast achieves the result.
  2. R

    Finding the last record

    Hopefully this is a simple one. I am running an append query to update my database. I am then requerying it to display the record. On requerying it jumps to the first record in the database. I need it to go to the last record. Can anyone suggest the code to just simply select the last record please?
  3. R

    expression to identify leading alpha character

    Ain't that the truth. Thanks for the response.
  4. R

    expression to identify leading alpha character

    Thanks for everyones rapid response. I followed the link provided by Alansidman and came up with the Conditional Format expression of [myfield] Like "[a-z]#*". It seems to work a treat. But I wonder if it is as good as the code suggested by missinglinq. Thanks again.
  5. R

    expression to identify leading alpha character

    Hi I have a field that contains receipt numbers, most of which are numeric but a few commence with an alpha character such as "A12345". When the field starts with an alpha character I need to use conditional formatting to highlight the field. Can anyone help me with an expression I can use in...
  6. R

    2007 Runtime problems........

    I have just loaded a 2007 DB on a PC running Access 2003 using runtime 2007. The new program was fine but when the user opened the older database (2003) it loaded it in the runtime format and although it all seemed to work the formatting changed so much that she couldn't use it as the fonts were...
  7. R

    Input Data using Access 2007 Runtime

    Hi Pbaldy Thanks for your reply. I found the problem. It was a sharing permissions setting on the server. Once I allowed edits the problem was fixed. Thanks again. I do have another issue with runtime but I will raise it as another thread after I have done some research on the forum first.
  8. R

    Input Data using Access 2007 Runtime

    Hi I have just created a Document Management System in 2007. I have split the DB and am trying to distribute the FE via the Package Solution system in 2007 (first time). The installation went well and all seems to work except for the the lack of a new record input field on most of the forms. ie...
  9. R

    Data not consistent with Parameter Query

    Hi Bob Thanks for that. I had already added the +1 and achieved the right result so I can leave that as it is then. I was just puzzled that it wasn't picking it up as the code seemed to be OK but you have explained that and it makes sense.
  10. R

    Data not consistent with Parameter Query

    I use the following code in an application I use at work. It is used to query my data for records that fall between the start and finish dates provided in the parameter form "Office Reports". We have just noticed that when doing a monthly report for June that work done on the last day of the...
  11. R

    Thanks for the invite Alan. Hope your doing well. You must be thawed out by now cos we are...

    Thanks for the invite Alan. Hope your doing well. You must be thawed out by now cos we are starting to feel the cold (not by your standards) and wet. Cheers Peter
  12. R

    Creating Diaries/journal in Access?

    Diary Did anything come of this co-op. Looks like getting a good diary is still pretty elusive. I have tried the one referred to in Utteraccess.com and it would fit my needs but it seems flawed. I have sent off some queries on it and hope to hear back.
  13. R

    Copy data from one field into many fields

    I have a project with multiple tables with varying data but common to them all is a date field. The date field value can vary but generally is the same. At times i run a process to create a duplicate of the entire record so that I can produce another scenario for the customer. In most cases this...
  14. R

    Windows sharepoint compared to Microsoft Access

    Thanks for your reply. I'll certainly check it out before committing to any changes.
  15. R

    Windows sharepoint compared to Microsoft Access

    Access 2007 I have just done some preliminary reading on Sharepoint Services as I have just installed Office 2007 & have been reviewing the changes from 2003. It appears that an Access 2007 file can be moved to a Sharepoint Services site as quoted from Access 2007 Help below:- I am...
Top Bottom