Search results for query: *

Hi, Does any have or know the code to pull information (dates) from a textbox into another textbox for formatting. What I want to do is take startDate and add 30 Days to that date once I hit a button to calculate the 30 days beyond a date. Thank you.

Hello, I am trying to create a form in Access to calculate future dates. What I am trying to accomplish is setting a due date. i.e. 30 days, 60 days and 90 days. This works fine with the simple formula, however I would like to add some special conditions. For example: 1. I've figured how to...

I have a problem regarding excluding certain dates from calculating future dates. Say I can't use specific months. (i.e. Winter months) and I want to be able to calculate a year from a date, but it doesn't include Dec., Jan. and Feb. So a year from a date (say Sep. 1, 2006) futuring dating it...

Thank you again. Here is another one.. Say I can't use specific months. (i.e. Winter months) and I want to be able to calculate a year from a date, but it doesn't include Dec., Jan. and Feb. So a year from a date (say Sep. 1, 2006) futuring dating it for a year should return Mar. 1, 2008 as it...

Pwise, Thanks for noticing the quotes. I have removed them and the query works now. However for some strange reason it doesn't show the dates unless I go to Form Desisn and back to Form view. Odd. Also... how would I change the query to use a 1 year range instead of a 30 day? Thanks in advance

CautionMP, This formula works great. Question, would I use the same formula or something close to it if I want to expand the criteria to be a year instead of 30 days? Keep in mind of any leap years with 366 days instead of the normal 365.

Yes, this is a form. I tried and created a table named "Tbl_Digits" Added a Field Named "DigitID" and put type as a "Number" and set as a primary key. then I added 1, 2 and 3 in the table. Created a new SQL query: SELECT Min(forms!"FutureDates"![StartDate]+30+[DigitID]) AS FirstWeekDay FROM...

It works with either "d" (day) or "w" (weekday) right now. "ww" is week

I have it on a MS Access Form right now. There is no Table data or queries. Would I have to import data into tables?

I put in the basic: =DateAdd("w",30,[StartDate]) where StartDate is date that is inputted to future date 30 days. Now.. where would I place this code? As an Expression or Code in MS Access?

Does anyone know the formula or Date function to use at future date 30 days? The key here is that the last date or day 31 must be a weekday and not a weekend date. i.e. The start date can be anydate, but after 30 days, the next date showing must be a weekday.

So you want to add a year (365 days) PLUS the number of days between the specified date range (89 days in this case)? I wanted to add 270 days (future dated) from the time of the StartDate, but to not count the days in between Dec. 1 to Mar. 31 of any year. So if the Start date is July 1, then...

I need a formula that will exclude all dates from Dec. 1 to Mar. 31 regardless of any year for the date calcuation. So if I have a StartDate of Jan. 14 200X, the future date of say 90 days forward should be June 29, 200x (30 in April + 31 in May + 29 in June = 90 days) The Datediff only works...

Will these dates apply to on-going years or would I need to restate the dates? Thank you

Hello, I created a form to calculate future dates based on an initial date entered into a form box. Where I am stumbling is setting an IF statement where I want to calculate 1 year future dated, but exclude a certain date range. i.e. Start date = July 1, 2006 and I want to future date for a...

Hi, Does anyone know of a way to create a pop up screen in access to let the user know that there is another or specified user currently within the database? Which would make the database read only, since the settings were be set for Exclusive mode wihn no editing. Thank you, Q

Craig, This code doesn't seem to work properly when I enter it. So basically it seems that Access does not have a setting to inform a user(s) that another user is in the database. Q

I know of that option, however the users may not notice the .ldb file and go into the database without looking for it. I had this database as a shared file with the db compacting on exit and it crashed each time when 3 or more users where in the db.

Hello, I wanted to find out if there is a way to set up Access 2000 like Excel so that when one user is in the database file and the second user acesses the file, the 2nd user should get a pop up box stating that User X has it opened and the file is read only. I have set the setting for...

Hi, I need some help trying to figure this out. I have 2 Tables, table_A has the data for a database and table_B has updates to be updated into table_A and has all the same columns. The problem I am running into is when I do the update(s) from table_B to table_A and there are blank cells in...