Search:

Type: Posts; User: jaf90; Keyword(s):

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    1,510

    I don't suppose you've got an entry in...

    I don't suppose you've got an entry in Autocorrect which is replacing pretty with retty? Just a thought
    John
  2. Replies
    8
    Views
    10,598

    Not taking it wrongly - I asked the same...

    Not taking it wrongly - I asked the same questions of both myself and the others involved in the update routines.

    The mix of Office 2003 & 2010 components came because of some people thinking that...
  3. Replies
    8
    Views
    10,598

    Thanks Rui I'll keep an eye on the list of SP2...

    Thanks Rui
    I'll keep an eye on the list of SP2 related issues.
    Trying to manage an environment where there are a mix of Office versions has always been a bit of an issue, but nothing has wrecked...
  4. Replies
    8
    Views
    10,598

    Office 2010 SP2 update problems

    The update for Office 2010 SP2 kicked in last week and has presented a number of issues for us. Due to historic spreadsheets and the need for Access 2003, we currently have our PCs setup with Word...
  5. Compress pictures in Word 2003 - batch process?

    I use the compress picture option within Word 2003 regularly and keep my files to a workable size, but I have lots of other users who have lots of documents where the files aren't compressed. I don't...
  6. Extract the columns and rows used for a sum()

    If I create a sum in a cell eg. =sum(f47:f55), is there any way to look at this cell and extract the start column, start row, end column and end row into cells?

    In this example:
    start column...
  7. Replies
    3
    Views
    8,171

    Thanks both for your help, encouragement - and...

    Thanks both for your help, encouragement - and warnings. I guess there is never an ideal - Access 2003 is great for some things, VB will, I'm sure be good in other ways. Progress is never in a...
  8. Replies
    3
    Views
    8,171

    I'm just dipping my toe into Microsoft Visual...

    I'm just dipping my toe into Microsoft Visual Basic 2010 Express after a number of years with Access 2003 - no expert, but I get by.

    I was looking for some bigger samples of code - something like...
  9. Thread: Pitman shorthand

    by jaf90
    Replies
    0
    Views
    400

    Has anyone come across a method of recording...

    Has anyone come across a method of recording pitman shorthand directly to a computer?

    I wondered if it would be possible to record this using a tablet of some type, or if it would be possible to...
  10. Replies
    3
    Views
    441

    Many thanks I'll adapt it to work with what I...

    Many thanks

    I'll adapt it to work with what I need

    John
  11. Replies
    3
    Views
    441

    I have a cell which contains a mix of letters and...

    I have a cell which contains a mix of letters and numbers. I want to remove all the none numeric characters to give me the numbers.

    eg

    a 12 v would give 12
    3412 fgd would give 3412
    1234...
  12. Replies
    2
    Views
    1,203

    A memo field is plain text. Although you could...

    A memo field is plain text. Although you could enter multiple URLs in a memo field, they won't act as hyperlinks.
    A hyperlink field can contain only a single hyperlink.
    So you'll have to use...
  13. Replies
    2
    Views
    1,203

    I'd like to be able to insert multiple hyperlinks...

    I'd like to be able to insert multiple hyperlinks into a single memo field - is there any way to do this, or will I have to use multiple hyperlink fields instead?

    John
  14. Replies
    6
    Views
    522

    I can always rely on the "great minds" on here. ...

    I can always rely on the "great minds" on here.

    I presumed that would be the only course of action - I know that doesn't get me in the "great minds" category, but I'll keep working at it!

    John
  15. Replies
    6
    Views
    522

    I'm assuming that this can only be done in design...

    I'm assuming that this can only be done in design view, but here goes....

    I would like to change an input from a text box to a combo box dependant on what is entered into another control box. I...
  16. Replies
    2
    Views
    3,164

    I'm trying to find a screensaver which can take...

    I'm trying to find a screensaver which can take the contents of a file and display it as the screensaver text - scrolling I presume. I also need the screensaver to re-read the text file on a regular...
  17. Replies
    3
    Views
    540

    Does the database you're opening have a startup...

    Does the database you're opening have a startup form?
    Yes, it does have a startup form - this was where I'd expect to run the code

    Which version of Access are you using, by the way?
    2003
  18. Replies
    3
    Views
    540

    When starting up Access, sometimes the Properties...

    When starting up Access, sometimes the Properties Window is displayed, other times not. Is there a method of turning the window off via code?
    John
  19. Replies
    2
    Views
    1,481

    Does anyone have a routine I could modify...

    Does anyone have a routine I could modify allowing me to map a network drive, run an Access application and then unmap the drive when I have finished.

    I have a database which I want to run on a...
  20. Replies
    2
    Views
    1,687

    I have a pivot table which has course names...

    I have a pivot table which has course names across the top and names down the size with date of course completeion as the data. All works fine with that.

    The course names were long, so I formatted...
  21. Replies
    7
    Views
    453

    Re: DSum on Change (2003)

    In the after update event of the alloy field, enter the command docmd.requery "Forms!Mainform!SubForm!Total - or whatever the reference is to the running total you are trying to update
  22. Re: Invalid or Unqualified Reference (Access 2003)

    Steve
    Try converting baseloop in the function to a string before concatenating.
    Also, baseloop doesn't seem to be incremented - always 1 ?
    John
  23. Replies
    7
    Views
    453

    Re: DSum on Change (2003)

    Couldn't you just run a requery after the update of the alloy field?
  24. Replies
    2
    Views
    361

    Re: Records Not Linked (2003 SP3)

    I presume you are using a form to enter the name of the unwanted actor, so you use ="Movies That Don't Have " & [Forms]![FormName]![NotActor] - NotActor is the name of the unbound field in the form....
  25. Replies
    6
    Views
    567

    Re: Problem combo box (2003)

    Have you recently updated to SP3 of Office 2003? I had the same problem with combos with one of my databases. There is a fix on the Microsoft website - article 945280 in the Microsoft Knowledge...
Results 1 to 25 of 191
Page 1 of 8 1 2 3 4