Recent content by TT13
-
T
Enter a date, add days from drop down, autofill another date box
Wow I feel like the guy who returned a chain-saw to the store because he said " this thing doesn't cut anymore wood than my old handsaw". When the salesman pulled the cord and started it up, the man jumped back and yelled "hay, what's all that noise"? THANKS so much! Great job! Tom -
T
Enter a date, add days from drop down, autofill another date box
Yes THANKS! Your sample works but I am having a little trouble taking it apart. Can't seem to find where NextApp comes from. Saw a MySQL something statement but can't seem to get it to show again. This may end up being a little too much for my brain but I have to thank you for helping... -
T
Enter a date, add days from drop down, autofill another date box
OK I have made a little progress. I built a que that takes the date from box1 and adds the number of days selected from box 2 and puts it into a column Expr1 of my que. This gives me an accurate future date calculation. My problem now is getting it to display on my form. I tried to use... -
T
Enter a date, add days from drop down, autofill another date box
I have a form where the user enters a date into a field (box 1). Next they select a time frame in days from a drop down (box 2). What I want is for Access to take the date entered from box 1 add the number of days selected from box 2 and place the new (later) date into box 3. From there I can... -
T
Combining query results
THANK YOU! Both solutions work but the Nz was the quickest to repair the form with. You saved me!! Can't thank you enough!! -
T
Combining query results
Hello, I have 3 simple selection queries that return records with a currency amount. I need to combine the currency amounts into one text box on a form. If I use text box contol source =DSum ((DSum[queX],[currency amount])+(DSum[queY],[currency amount)+([queZ],[currency amount])) to...