Search results for query: *

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

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

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

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

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

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

could someone please explain why this formula works perfectly on my form, but not on queries or reports? =IIf(DateValue([rep_date])>DateValue([org_date]),DateValue([rep_date]),DateValue([org_date])) thank you in advance for ANY assistance you can offer!

it seems like this should be simple enough, but I can't seem to get my brain around it. I need to compare and calculate several fields in order to create flags that warn the user that certain parameters have been exceeded. I have worked with nested IIFs before, but this has me stumped. if the...

struggling to learn Access 2003! brain hurts. apologies in advance for total noob question. I have a form to enter data into a table called P60. I have another table called Appraiserlist. when I enter a number into my form, I would like Access to refer to the first 3 digits of that number...

please be kind, I am really stuck. I'm not a complete idiot and had no problems coding in the "old" version of Extra basic, but I haven't been able to figure out the new version and haven't been permitted much time to work with it. here's what I'm trying to do - our users will have 2 (or more)...

I was trying to use the print macro suggested here (thread99-575428), but the screen print adds line feeds at the top of the page that aren't there when you print from the toolbar or File>Print Screen. we need the print screen to line up on a preprinted form, so this code won't work for this...