Search results

I have a report that needs to show total for current year and a total from previous year side by side. My field is incnumb and i will do a distinct count on that field to give me a total count of each incident number. Here is sort of what i am trying to make it look like...

I have a report that prompts for date range of startdate and enddate. once ran, it takes the starttime and endtime and calculates total time per day. however if somone works on the last day of the month, it needs to only calculate the time up til midnight for that current month. Here is what I...

I have a report that pints by date range selected. However, instead of putting in the date range, I would like to run the report and let the user select only the month, then print data for that current month. Example. field= startdate If the start date is 10/1/2011 I want the user to be...

I have a small form that has 3 fields from my employee tbl. Field1-IsSelect ( yes/no) check box Field2-lname Field3-fname I want the users to be able to put a check mark next to each emp name that they want to print the timesheet for. I can get that all to work, but now I need a button to...

My db has 4 fields name,phone,email1,email2,week My current records have data in email1 field. Email2 field is currently blank. I want to move the email addresses in email1 over to email2 but keep them inline with name,phone,week. Will this command do it for me Update tblName set fieldA =...

I have built a small timesheet app for our fire depatment. I want to create a form that allows me to select an individual FF or multiple FF, then when you click on a button it runs a query i have that prompts for date range, then it opens a report that is the timesheet for each of the selected...

I have a small form that I want to put a list box on that will allow my users to select several names in the list. Then by selecting a command button i want it to run a report that looks at a qry which prompts for a date range already. the report already calls the qry and and displays a time...

I have a report that I need to pull records for time range. I am using Crystal XI incident.date = date&time dd/mm/yy hh:mm:ss incident.date holds both the date and timestamp of the record. I need the formula to look in the incident.date field and then look at the time stamp in 24hr time and...

I have a query that needs a calculation field for a report. This is my field in the query. Gross: [TBLinvamt]-[TBLinvqty]*67-[TBLfrtamt]-[TBLocamt] Here lies the problem example: 3210.81 - 25 * 67 - 0.00 - 0.00 If the frtamt and ocamt fields are 0.00 then my Gross field does not display...

I have a table called tbltechissues that has a field called problem that is a combo box. I placed that field on the form and set the multi select to simple, but i need to pass the selected data to the field into the table. can someone assit me in this process Thanks

I have a small database that will have a button on a form. That button will run a query that I have setup and working. The quesry just prompts for a date then returns data for that date range. that all works fine but once I have th datasheet view I want to be able to modify a record from there...

I have 2 calculations in a single query. 1st - ProdCost: [TBLinvqty]*67 2nd - Gross: [TBLinvamt]-[ProdCost]-[TBLfrtamt]-[TBLocamt] The query runs and works fine but it keeps prompting me for ProdCost but if I hit ok it runs fine. How do I get it to quit prompting me for Prodcost BTW...

I have a frmCustomer as a main form with a subformOrders as a sub form. I now want to add another subform that is based on a query I build. I only want that subform to refresh (update totals) when data is entered in the subformOrders fields. I am trying to use the TimeInterval, I created a macro...

I have a small db with a form and a subform When data is added to the subform, i need a little warning light that tells my user that they have exceded the max amount for that day. Example: Fields in Subform schedshipdate deliverydate qty pkgwt pounds this is a calculate field (=[Qty]*[pkgwt])...

Is there a way to have a Criteria set to promt a user to select a item from a dropdown list. So when the prompt is made to ask for the Item Name it will have a dropdown list that the user can choose from

I have a small database with 3 tables. tblBilltoCustomer Fields - Key - BillCustID , companyname, address1, address2, city, state tblOrders tblCustomers I have a form that has tblCustomers as the main form then tblOrders as a sub form. I want to place a combo box on the form that will...

I have created the following code to put the date and username into a table to track any changes made to a record. All I am interested is when the change was made and by who. When I change a record the Now() command works fine and puts the date and time but the Username = User_FX does not grab...

I have a form (entry screen to enter data) I then created a report in the layout I need for my order form. I want to creat a button that a user can press and it will print the current record to the report (order form layout) Here is my current code for the print button on the form page: Private...

I am trying to make a layout just like the attached file. Is this possible in Access ? There is 6 fields in the table each of the boxes is a day so the layout is in a week at a time view on legal paper. this is done in excel right now. Thanks for the help:confused:

I am trying to create a button to delete record, I have used the wizard and it works fine but now I want to have a confiirmation message to confirm that they really want to delete this record. below is my code. The prompt works but the record never deletes. Any Idea's Private Sub...