Search results

I have a timesheet table that I would like to display the Distinct WeekEndings, which is every saturday, with a checkbox next to them in a continuous forms view. Then I would like to create a report that displays the data only for the weeks with the checkboxes next to them in the form. I don't...

I have an afterupdate statement putting customer information into a list box with two other fields. In the table I have an input mask for the phone number but the input mask is gone when the data populates in the list box. Any thoughts? Thanks, Matt

I have a database put together that I'm officially ready to deploy. I go to the Microsoft Office button and hit Publish then Package and Sign. As I expected, I go the no certificate available so I click OK which should redirect me to create a certificate, but nothing happens.

My boss recently lost a good portion of his vision. So I took it upon myself to create a feature with my Invoice form where in the Status combo box, the value will change the back color. When Status = "Done", I want the Details area to have a back color of green. This is my code so far, I have...

In the past, I have been able to use this expression for a Sum field in an Access query. I have two tables in a query for a simple timesheet application. The two Tables are tblTimesheet (fields: TimesheetID(PK), WeekEnding, Day, Hours, Date, and Paid) and tblPaid (WeekEndingID(PK), Paid). If I...

Am I blind or is there now way to disconnect my text box from the caption in reports in Access 2007? I want to cut my caption so I can have an invisible text box and I also need to be able to move my text boxes to another header but the caption and text box are bound together

I am using access to do a timesheet database for work. I simply have a table with the fields TimesheetID(PK), WeekEnding, Day, HoursWorked, Paid. I just imported the data from an excel spreadsheet then made a query with all the fields included. I then made a form with a combo box displaying the...

I am using Access 2007 now even though I'm used to using 2003. It's beginning to show how drastically it has changed. I have a query in 2003 where the field for an Attendance query was a custom one with the following syntax: WeekEnding: DateAdd("d",-Weekday([Day]+7,[Day]) Day is...

I recently upgraded to office 2007 as much as i didn't want to. I put a google desktop gadget that creates shortcuts to microsoft office products. Now with Office 2007 I can't find the actual application icons. I know it installs itself in both program files and program files(x86). Does anyone...