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

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.

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

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

Hello, I wanted to ask if any one here know of a formula or step to replace any blank cells in Excel with the value located above the blank cell. Here is an example: Prov Org Owner Name Value SK 12345 Scott John,Smith 4 2...

Hi, I'm trying to figure out how to replace a number within a table column to another number. ie. What I am trying to do is get MS Access 2000 to find all values equal to 2 in a column and replace it with 10002 I am using the UPDATE Query and have this in it: UPDATE SMT SET SMT.Transit =...

Hi, I'm trying to get a query to update or replace a number within a field/column with MS Access. I could do this step manually using the find/replace tool, but I would like to make a query or module that will automate this process to save me time in the future. What I am trying to do is tell...

Hi, would anyone here know of a way or a formula to convert a string field to number? I've managed to convert it to a number field, but I ran into a problem. When I check the browse data field, it lists it as a 'number' field but the box is blank (if done correctly it should have a range of...

hi, just wanted to ask if anyone could help me on this problem. I'm trying to create a "sum" formula from the formula fields to calculate total time (in numbers strings) I had used: WhilePrintingRecords; //get the login date of the next record DateTimeVar nextLogin :=...

hi, wanted to ask if anyone knew of a process where I would be able to filter a certain end data so that is does not filter out the rest of the data. eg. I want to filter out all tickets in a closed state done by a certain group, but would also like to see the stage processes that may include...

Hi, I'm fairly new to Crystal Reports v. 8.0 and I wanted to find out if anyone knew of how or a way to create an automated format or a set template for Crystal to follow instead of having to create the report manually each time. The data fields and charts will be the same, just the actual...

Hi, Does anyone know how to convert a time format to an integer value? I'm trying to convert HH:MM to an integer but for some reason I can't see it only converts the hours and forgets about the minutes. I'm using CR 8.0 eg. trying to convert say: 4:45 (in HH:MM format) to 4.75 HR...

Hi, Need some help with calculating time in between the end date (in dd/mm/yyyy hh/mm/ss) and the next start date. I work in a call center and I'm trying to figure out how to get Crystal to measure this time inbetween. eg. START_DATE END_DATE 2001/11/26 06:16:00 2001/11/26 06:37:00...