Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SmallTime
  • Order by date
  1. SmallTime

    Problems manipulating text data - Access XP 2002

    I've come across this too, the concatenated text disappears, leaving a blank field when a pop-up opens over it. I found that removing the Trim solved the issue. I just have to put up with an untidy looking field. AceMan1 hope you feeling better. Regards
  2. SmallTime

    Convert update query to VBA

    Encapsulate the whole sql in quotes, get rid of the semi-colon at the end (VBA doesn’t seem to like it) and remove all line breaks (return) so the statement reads as one single line (you can break the line for easy reading with an underscore) DoCmd.Runsql “UPDATE MasterData SET...
  3. SmallTime

    Multiple unique records by date

    One further question. I’m trying to incorporate the same method into another table which unfortunately as a field with a space eg ‘Organisation name’ how would I handle this? Regards
  4. SmallTime

    Multiple unique records by date

    Thank you both so much. I'd never have managed it myself
  5. SmallTime

    Multiple unique records by date

    I have a table (Tbl_notes) containing amongst other fields RefId NoteID NoteDate NoteType Looks something like this RefID NoteID NoteDate NoteType 1 1 12/01/2005 Response1 1 2 13/01/2005 Response1 1 3 12/01/2005 Response2 2 4 12/01/2005 Response1 2 5 13/01/2005 Response1 2 6...
  6. SmallTime

    How do I get a common dialog box for Excel export

    Very nice indeed. got it to do just what I wanted with minor trickery on the form. Absolutely beautiful. Having done all that, I then played around with 'OutputTo' What would the drawback be with using something like this DoCmd.OutputTo acQuery, "QryTest", "MicrosoftExcel(*.xls)", "", True,
  7. SmallTime

    How do I get a common dialog box for Excel export

    Thanks guys, I did look high and low before asking the question, but as always, I was probably looking in all the wrong places. I'll continue the hunt this evening, starting with your suggestions. Thanks
  8. SmallTime

    How do I get a common dialog box for Excel export

    Hi all, Could some give me some guidance on how to get a dialog box to ask for a location when exporting to excel. Here’s an example of what I’m doing at the moment; eg DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, “QryTest”, "C:\test.xls", True I’ve had a look at ‘How to use...
  9. SmallTime

    Mystery code!

    Knew I'd seen this somewhere. Nice call. However, I didn't use the code in this app, but did in another. I'm gonna give you star just for having such a fantastic recall.
  10. SmallTime

    Mystery code!

    Thanks Golom, Just seemed so odd since I'm still developing the app. and haven't yet split the tables form the FE. Still scratching my head as to how this got there. Anyhow seems harmless enough. Take care.
  11. SmallTime

    Mystery code!

    Me.DBPathTXT = DLookUp("Database", MSysobjects", "[Flags] = 2097152") This mysteriously appeared on my main menu’s OnOpen event! Can anyone work out what it’s doing? Or event better still any ideas how it might have got there? Bizzar no!
  12. SmallTime

    How to target columns and rows in a list box

    Hi all, Thank you so much, both suggestions work perfectly Aceman, Sorry, neglected to mention I have column headings, but minor tinkering did the trick. Me! LstNames.Column(4, (Me! LstNames.ListIndex) + 1) PHV, Beautiful. As always you have a way for simplifying things that I spend hours...
  13. SmallTime

    How to target columns and rows in a list box

    Hi Romeou, You quite right, the list box isn't multi select. I tried your suggestion but got a run-time error "Runtime error 2480 You referred to a property by a numeric argument that isn’t one of the property numbers in the collection." (Just for info, the count starts from 0) Thanks for...
  14. SmallTime

    How to target columns and rows in a list box

    Hi, I have a list box (LstNames) with 6 columns and variable number of rows. I’d want to target the 5th column of the current (selected) row. I’ve read the help file and have spent the best part of the whole day trying various things without much luck. Me.LstNames.column(4,?) Any help or...
  15. SmallTime

    NEED URGENT HELP with display and data loss of a form

    I’ve found the offending script. I have a couple of fields on my main form that contain TRIMMED concatenated text. Eg. Address: Trim ([Flat] & " " & [No] & " " & [Street] & " " &[Address1] & " " & [PCode]) which seem to loose their data and either show a blank field or “Name”. When I first...
  16. SmallTime

    NEED URGENT HELP with display and data loss of a form

    Hi, Sorry for taking a while to get back. A little after posting my question I got involved in quite lengthy staff training. hermanlaksko, I had already tried something along the line of your suggestion without any luck. It’s quite strange. The app. works fine at every other client location...
  17. SmallTime

    NEED URGENT HELP with display and data loss of a form

    Need Urgent help I'm at a customer site as I type this and have run into a problem I can't sort out soany quick solution would be so apprecaited. Problem: when I open a pop-up form on top of another form thats displaying a record in various text boxes the unerlying forms data is lost and the...
  18. SmallTime

    Your thoughts on Fe/Be Set-up Please

    Update, After writing to my department head a meeting was convened with this chap and his line manager. Well, under these circumstances he was a different man. every so helpful and agreed to everything I asked. He even offered to write some script for me to assist with update(which I declined)...
  19. SmallTime

    How would multiple user AK2 mde behave under citrix

    I posted this earlier in the 'Citrix solutions' forum but it seems to be either a silly question or beat everyone. Either way I didn’t get any relies. I'm now posting it here in case someone with Citrix knowledge spots it and can help. Hi, I have an Ms.A2k db (front end /back end type) that I...
  20. SmallTime

    How would multiple user AK2 mde behave under citrix

    Hi, I have an Ms.A2k db (front end /back end type) that I normally distribute to run under MS.A runtime. However, recently I’ve been asked to install this on Citrix. There are 30 users of which perhaps at least third will be concurrent. I’ve never worked with citrix except on one occasion...

Part and Inventory Search

Back
Top