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 Chriss Miller 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: *

  • Users: qster
  • Order by date
  1. qster

    Date help

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

    calculate future date

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

    Future Date calcuation excluding dates

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

    Date must end on a weekday

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

    Date must end on a weekday

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

    Date must end on a weekday

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

    Date must end on a weekday

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

    Date must end on a weekday

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

    Date must end on a weekday

    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?
  10. qster

    Date must end on a weekday

    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?
  11. qster

    Date must end on a weekday

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

    Dateserial help with future dates excluding a date range

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

    Dateserial help with future dates excluding a date range

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

    Dateserial help with future dates excluding a date range

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

    Dateserial help with future dates excluding a date range

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

    Access 200 pop up screen

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

    single user only

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

    single user only

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

    single user only

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

    Update Query with null values

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

Part and Inventory Search

Back
Top