The previous problem stands solved i.e. ReportTime field shows 9:50 always.But it has created another problem as under
The Formula for ReportTime : Format(Date(),"m/d/yyyy") & " 9:50:00 AM"
The formula for ReportedAt then becomes as ReportedAt: Format(Now(),"hh-nn ampm")
And the next step LateByMinuts:=IIf([StatusID]=1,DateDiff("n",[ReportTime],[ReportedAt]),0)
Where stutusID is
1. Present,
2. AbsentExcused.
3. LeavePrivelege etc.
is correct for the first time.That is when at the first time the Reported time (system time) is recorded it works fantastically but when next time the Form is opened the saved "LateBYMinuts" field is changed with the system date thus disparaging the previous save data.
I have a report that shows the daily activities. it shows how long it takes to do each task. however some tasks are 8 hours andsome are 10 hours. when all these times are added together it will give the time on a clock. not a total of hours spent.
i.e. treatment1 : 8 hours treatment2: 10 hours
this will give 06:00 in short time. in medium time it will give 18:00.
however if I add another 12 hours to that it will give 06:00.
I want it to show either 1 day and 4 hours /or 30 hours.
Access Query. I am creating a time sheet / pay roll database and I want to be able to get a total of the daily hours in a query.
For example I have 'Mon Start' and 'Mon Finish' for Mondays in/out times and I have a 'Mon Total' which gives me the total hours worked for Monday.
The problem I have is that Mon Total only works if the hours are say between 07:00 and 17:00, anything after midnight (00:00) like 21:00 to 07:00 and 'Mon Total' goes crazy !!
At the moment 'Mon Total' is the result of CDate 'Mon Finish' - 'Mon Start' (bit rough I know).
Hi Everyone, I am new here...need your help. I am trying to sum a field which is defined as a Date/Time field and is a substruction of Time1 - Time2. at the end of the month, i would like to sum all these fields in a query. the problem is, the fact that i sget the SUM result as a daily hour and not accumulated time (i should get like 92:35 Hours, and i recieve 3.45 coz it divids by 24).
How can i format the field to be (like in Excel) an accumulated sum of the hours...is it possible to do without VB code?
I have a variable (dtDueDate as Date) showing as 6/28/2013. I want to append a time value to it (dtMaxTime as Date) which is 5:00 PM so dtDueDate reads 6/28/2013 05:00:00 PM. I have been going in circles trying to figure this out. My goal is to append this date to a table field which has a datetime (General Date).
In VBA, how to compare date variable with date/time field from table, as when defined the data type in table, date/time option is the only choice for date data type even though I don't want the time portion.
I am creating a 2 level report to confirm an order. Main report already created, runs successfully called as subform/subreport under "OrderDetails" form. Linked to master using Order.ID. There are two versions of the confirmation report that have different layouts for different program types.
The hangup comes when I try to add a "Class Dates" subreport. It lists dates of individual classes and Skip dates. I have created the subreport as "srClassDates". When I add it to the main report, it lists the records. However, when I try to link it to the Main report, an error message box appears with the "object variable or With block variable not set".
I have tried rebuilding both the main and subreports, rebuilt the query, have not found anything that changes the result.
Linker has been working successfully on other subforms. Report with groupings works fine, but I need data from 2 tables both linked to order.id.
I want to create a report that will generate from a specific date then have as the second criteria i want the date to change to what ever the current date is
Error 91 - Object variable or With block variable not set
I am getting this error telling me that an object variable is not set.
I know which variable it is but when I step through the debugger it sets the variable and all is fine? Issue is that public variable of a class is not getting set when the VBA Editor is not open?
This code runs fine the FIRST time, however trows up a message the SECOND time it is run.
The error is on the line ".Range"
I am trying to sort records which have been exported to Excel.
Dim LR As Integer LR = 5 Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True Set wbRef = xlApp.Workbooks.Add With wbRef
wbRef.Activate .Worksheets("Sheet1").Activate With ActiveSheet .Range("A2", .Cells(LR, "O").End(xlUp)).Sort Key1:=.Range("C2"), Order1:=xlAscending, Header:=xlYes End With end With
I've got a table with CAR_ID(pk), supplier_id, Company_name, KPI, and warehouse. I need it to do a count total for me. I.e. query gives me this: s4001, 1111, ibm, ship, atlanta s2001, 1111, ibm, ship, atlanta s3001, 1111, ibm, price, atlanta s5001, 1111, ibm, price, atlanta s6001, 1111, ibm, quality, atlanta
I need it to do this 1111, ibm, ship, atlanta, 2 1111, ibm, price, atlanta, 2 1111, ibm, quality, atlanta, 1
So if the supplier_id, KPI, and warehouse all are the same then it just counts total number of CAR_ID
Hello I have a report reading off of a query, the query shows an #Error whenever the 0 spend is divided by the 0 potential. In the report i would like this #Error to show as N/A. I tried =IIf([BY PROGRAM BY UNIT 30 DAYS.AdminRate]="#Error","N/A",[BY PROGRAM BY UNIT 30 DAYS.AdminRate]) but it doesn't work. can you suggest something else?
Hi, I have an issue with reporting in Excel. A table has a Fax Id field which holds unique Fax Ids. The ID is a unique number given to a fax received. The fax is processed by an employee and the table stores the employee id and fax id processed by him. I have a query which pulls up the report. I take the report by opening an excel sheet and running the query through New Database Query from Import External Data from Data Menu in Excel. In the report, sometimes I get same fax id getting repeated for each employee. For eg, if an employee has procesesed 50 faxes for the day, the same fax id gets repeated 50 times, though in the database fax id are stored correctly. What could be the reason?
I am currently trying to do a total of several fields in a report. The fields in the report do contain null values. I have been trying to write this through VB but I am getting the error that I can not seen to get around. The thing I am trying to do is to us a single variable to add the total up by using if then statements. But in the end it will not let me update the final total. The total field is a unbound field.
In my application I have the option of selecting different check boxes (6 different options). My database is storing the values 0 and -1 for nonchecked - checked boxes as it should be.
Now, I would like to create a report to display which values were selected from the options above but I don't know how to do it as if I display the values, I will only get -1 and 0.
Is there a way I can convert again or I can give the check boxes other values in order to be able to report them with their original names ?
I am creating a database in order to log in the location of certain files based. I began by creating an entry form with fields for "Individual", "Committee", "SubCommittee", "Issue", and "Location". Once entered into the form, the data is stored in a table. While I managed to do this with relative ease, I also created a search form that mimics the entry form in requested information.
However when creating the query to conduct a search I am missing data. Basically the query pulls information from the "Location" table, the "Individual" table, and the "Issues" table. Unfortunately if the "Individual" is left blank on the "Location" table, even if I am searching by issue, the query will exclude this entry in the final output. In otherwords, if I am searching by an issue, say education and there is an entry that is not related to an individual (in the Location table), that entry will on be displayed by the query, eventhough it falls under the parameters of the search
I have read through a few posts but none seem to resolve the issue I am experiencing.
I have a form with a FilterByForm button. This works fine. I also have a button that is supposed to display the results of the filter on a report. Everytime I click this button it prompts me to enter a parameter value.
I want to display data from a database I have in MS Access. Any ideas on what sort of tool I can use to display the data locally? Can I get a free VB dev tool anywhere?
Access's reports and data access pages just aren't flexible enough for me. I know ASP and SQL well, but I don't want this database to be stored on our server.
Hi Everyone, I have an Access Database with an Appointments and Expences table which are unlinked and have no common fields. I want to create a profit and loss report using these unlinked tables. The Appointments table has the fields "apptdate" and "apptcharge", The expence table has the fields "expdate" and "expcharge". I would like to create a report that shows a summed total by month and a Appt minus exp to show the profit per month. I am having trouble as no fields are linked, the dates of the expences are usually different to those of the appointments. I have even tried with Crystal Reports but this only lets me do it in sub-reports and I can't use the combined data for any totals. How do other financial databases do this simple function? is my table design flawed?
I create a Job with a number such as E649 (excel) I then log each employee hrs by date as they worked on this job. I also put cost of material and outside services charges, shipping and invoicing information. I then have to produce a report for this number with all the time, expenses and invoicing. I have been trying to create this on access. Do not know how to get a report on just on particular number. Help Thanks
how to delete footer in reporting? my report form has 4 footers. i dont know how did it all appear. all i need is the page footer. but, i dont know how to delete the extra 4 footers.
