Search:

Type: Posts; User: Egg 'n' Bacon; Keyword(s):

Page 1 of 19 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    4
    Views
    2,390

    Cheers Wendell. I was afraid it would be...

    Cheers Wendell.

    I was afraid it would be something like that.

    We're using 2007 & all the records paste (into a new record), but those in the related tables disappear when any PK field is...
  2. Replies
    4
    Views
    2,390

    This is being done in a user form (with relevant...

    This is being done in a user form (with relevant sub-forms).

    User would select the record, use Ctrl + C, then create new record & paste. The idea is to then change the value in one field...
  3. Replies
    4
    Views
    2,390

    I'm wanting to copy records & change one of the...

    I'm wanting to copy records & change one of the primary key fields to create a new unique set of records.

    This is based on the copying of the 'main' record, & related records in 2 other tables.
    ...
  4. Replies
    3
    Views
    533

    Cheers Big Al. I had the same issue with the...

    Cheers Big Al.

    I had the same issue with the results from Google.

    In the end (as it was a clean install, I just ran through the 'repair' install option & all was fine.
  5. Replies
    3
    Views
    533

    Just done a vanilla XP home install & trying to...

    Just done a vanilla XP home install & trying to install anything (almost) brings up the above error message & no install.

    I did briefly see a message about a file that couldn't be copied, during...
  6. Replies
    2
    Views
    351

    That's the one. Cheers

    That's the one.

    Cheers
  7. Replies
    2
    Views
    351

    I've got a little DB with a few basic tables &...

    I've got a little DB with a few basic tables & forms.

    I don't want to go into all the security issues, but I'd like to stop the right-click option of "design view", that users of 2007 seem to...
  8. Excellant! It was that YrMonth:...

    Excellant!

    It was that YrMonth: DateRecorded-Day(DateRecorded)+1 workaround I needed.

    Many thanks http://windowssecrets.com/forums/images/smilies/cheers.gif
  9. Apologies, I've never been too good at describing...

    Apologies, I've never been too good at describing things like this, but here goes;

    I'd like to have a query that returns 3 columns;
    1) the month & year (grouped so that there is only one month...
  10. Cheers Hans I'm sorry, I missed out a critical...

    Cheers Hans

    I'm sorry, I missed out a critical item; the [turnover] field from tblUKturnover has to be included. So I've played around with different ways of doing it, but the fact that the date...
  11. Hi, I'm trying to combine data from 2 tables. ...

    Hi, I'm trying to combine data from 2 tables. One has a date field used for month & year, the other for full date.

    The problem I'm having is that I want to group by month year & the table with...
  12. Replies
    2
    Views
    461

    Cheers Hans. That is FAR simpler than what I...

    Cheers Hans.

    That is FAR simpler than what I was able to find in Help.

    Many thanks
  13. Replies
    2
    Views
    461

    Likely to be a simple one, but i'd like to add a...

    Likely to be a simple one, but i'd like to add a sort to a filter, I've got on a button, but the help file is confusing me.

    Here's my filter;

    Me.Filter = "tblMain.Revdate < Now()"
    ...
  14. Replies
    8
    Views
    1,620

    There needs to be a space between Format and ( in...

    There needs to be a space between Format and ( in the string.

    It's good you said; I would never have found that.

    Cheers mate http://windowssecrets.com/forums/images/smilies/cheers.gif
  15. Replies
    8
    Views
    1,620

    Instead of the literal string "SnapshotFormat...

    Instead of the literal string "SnapshotFormat (*.snp)", you can also use the symbolic constant acFormatSNP, and instead of "PDFFormat (*.pdf)", you can use acFormatPDF.

    Now that is a bit weird;...
  16. Replies
    8
    Views
    1,620

    If you open the report in Preview mode, at the...

    If you open the report in Preview mode, at the current record, before you use Send Object, it will send the currently open report - i.e. just the current record.

    What Version of Access are you...
  17. Replies
    8
    Views
    1,620

    OK, I've found a solution for that one, but now I...

    OK, I've found a solution for that one, but now I want to filter the result to the current/selected record.


    Any ideas???

    PS here's where I'm at, at the mo';

    DoCmd.SendObject acReport,...
  18. Replies
    8
    Views
    1,620

    Hi, I'm looking to e-mail a report (from a button...

    Hi, I'm looking to e-mail a report (from a button on a form), but would like to send it in Snapshot format (or pdf as we've got CutePDF), but I'm struggling to find the appropriate syntax for the...
  19. Replies
    2
    Views
    368

    That's brilliant Hans & far more elegant than...

    That's brilliant Hans & far more elegant than what I had in mind.

    Cheers http://windowssecrets.com/forums/images/smilies/cheers.gif
  20. Replies
    2
    Views
    368

    I've got a bit of code to save a 'tab' as a...

    I've got a bit of code to save a 'tab' as a seperate file. No error checking as yet.

    I'd like to build in a check to see if the file is there, before the resto the code runs. Of course if the...
  21. Cheers Rory, that works a treat. Just as a...

    Cheers Rory, that works a treat.

    Just as a little add on, what could I use to then close the new file?
  22. Hi. I'd like to have a button to save a copy...

    Hi.

    I'd like to have a button to save a copy of the current sheet as a seperate workbook, in a specified folder. The file name will have the name of the tab & the current month & year e.g....
  23. Replies
    4
    Views
    463

    Thank you. That's what I needed. ...

    Thank you. That's what I needed.

    http://windowssecrets.com/forums/images/smilies/cheers.gif
  24. Replies
    4
    Views
    463

    Sorry, I was lazy explaining. I want the...

    Sorry, I was lazy explaining.

    I want the formula to return 'True' or 'False' depending wether the reference cell contains a specified value;

    e.g. value of A1 = U and M

    A2 = if(A1,contains...
  25. Replies
    4
    Views
    463

    I'm sure this has come up before, but have had no...

    I'm sure this has come up before, but have had no success in finding it.

    Anyway, all I want to do is get a T or F if a cell contains a specified value.

    PS I'm using 2007 SP1
Results 1 to 25 of 456
Page 1 of 19 1 2 3 4