Search results for query: *

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.

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]...

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...

thanks Skip!

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...

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...

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

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...

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

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...

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!

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...

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...

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...

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...

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.

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...

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!

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

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...