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 derfloh 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: *

  1. mizsydney

    compare 3 dates?

    thank you for the quick replies! where do I place that bit of code? I am very unfamiliar with Access, VBA etc. I should have made that clear, I apologize.
  2. mizsydney

    compare 3 dates?

    I am trying to compare three dates on an Access form. the later of the 3 dates is the result I need to appear in this field. I understand how to compare 2 dates, but I can't get the correct syntax to compare 3. this is what I have in the control source for this field: =nz(IIf(([org_date]...
  3. mizsydney

    how to loop thru rows?

    I'm sorry, I am just not smart enough to get this to work. could someone please explain how the loop works, maybe using small words? I know what I want the macro to do, I just don't understand how to make it go thru more than one row. I've read thru other posts on looping until you hit a...
  4. mizsydney

    how to loop thru rows?

    thanks Skip!
  5. mizsydney

    how to loop thru rows?

    thank you again for your assistance and your patience, Skip! but I think you may be improperly assuming that I am not clueless. I am utterly lost. I inserted your code and compiled - five bugs, in order - range is not a record type FOR syntax error r is not a record type r is not a record...
  6. mizsydney

    how to loop thru rows?

    sorry so dumb - I got so excited when Skip helped me fix the last macro, that I thought I could expand on it on my own. HAHA! big mistake. the intent is to collect 2 cells from Excel, send to extra, enter and wait for an update screen, then paste another cell and enter. this should be able...
  7. mizsydney

    borrowed code not working

    works perfectly! thank you, thank you, thank you. it's like magic!! you are a god. thanks again!!!
  8. mizsydney

    borrowed code not working

    thanks Skip! actually my first choice was to specify the worksheet name, but I couldn't get it to work so I reluctantly changed it back to activesheet. when I use your code, I get an object error for that line: Set xlSheet = xlApp.Worksheets("Sheet1") thank you again for your willingness...
  9. mizsydney

    borrowed code not working

    sorry! meant to include that important bit of info - line 96: Set L1 = xlApp.activesheet.Range("B3") 'get line 1 if I rem that out, line 97: Set L2 = xlApp.activesheet.Range("C3") 'get line 2
  10. mizsydney

    borrowed code not working

    this code worked for me until I tried to modify it for a different use. now I get and "object value set to nothing" error, even though I didn't set any object in my old code. this is horribly written, I copied it from other functioning macros and since I don't fully understand the dim, set...
  11. mizsydney

    Stop all Macros Button

    no doubt you have already discovered that the "Stop Macro" button that is available for your Attachmate toolbar, does not work worth a darn. I look forward to a functional response to your post!
  12. mizsydney

    get data from excel, send to extra?!

    I most humbly apologize in advance for my lack of knowledge, I'm sure my questions are painfully obvious to you guys! I am trying to set up a macro that will scrape a cell value from excel, send to extra & <enter> to bring up a record, send more data from cells once the Extra screen comes up...
  13. mizsydney

    STUCK! attachmate macro, excel to extra

    thanks zach, I did! in fact that was where I swiped most of my code. if I better understood VBA that code would be almost perfect, but I am so darned dim that even Skip's answers didn't help. I'm clueless as to why I have to set an object, much less understand why setting it twice is a...
  14. mizsydney

    STUCK! attachmate macro, excel to extra

    I most humbly apologize in advance for my lack of knowledge, I'm sure my questions are painfully obvious to you guys! I am trying to set up a macro that will scrape a cell value from excel, send to extra & <enter>, send more cells once the Extra screen comes up, <enter> and keep going row by...
  15. mizsydney

    dlookup not always working?

    thanks so much for your help, mrkshpntf! I try to remember the caps, but when I'm experimenting trying to get something to work it often seems to slow me down and/or I forget. I think I must have misunderstood something somewhere: I tried adding the code to the afterupdate on the appraiser...
  16. mizsydney

    dlookup not always working?

    thank you, PaulF! but where exactly do I place that code/formula? I've figured out how to just show the appraiser, but I need to store it in the table. any ideas welcome! thanks again.
  17. mizsydney

    dlookup not always working?

    I apologize for this question in advance if it is painfully simple, but I have been clomping around trying to teach myself Access as I set up this DB. I have two tables, one is a list of book numbers and appraiser assignments, the other is the table where the data is stored. (info from the...
  18. mizsydney

    formula works on form but not on report or query?

    for crying out loud. everything works great today! I don't know what changed, but whatever it was I am pleased! thank you so much for all your assistance!!! and your patience!
  19. mizsydney

    formula works on form but not on report or query?

    oops! I forgot - I tried your SQL, but I get the same error - the same date for all the records.
  20. mizsydney

    formula works on form but not on report or query?

    dhookum - unfortunately I am so Access-clueless that I don't even understand your question. I will do my best tho! when I first tried comparing the dates, just using the field names wouldn't work. I borrowed the DateValue from another Tek-Tips post and it started working, at least on the...

Part and Inventory Search

Back
Top