Recent content by mjreiman

I don't know why I didn't think of that since almost all the reports in this DBMS are controlled by queries. Thanks a ton! Matt

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 probably should've mentioned that haha. My problem is adapting to Access 2007, with ALOT of features missing since 2003 it's been kind of a pain.

That was my original plan. I'm definitely not new to access. But since the data isn't being maninpulated, it didn't bother me to have the input mask on the table field property. The form is strictly for filtering to view active orders. The control source is actually driven by a query so my boss...

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

So I installed AccessRuntime and I was able to create a certificate. Now I've managed to create two with the same name and can't figure out how to delete one of them.

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

I wanted to basically make the query contain the following fields: WeekEnding, TotalHours, and Paid. I prefer not to use things like the totals feature, just a quirk of mine. I discovered that if I go into SQL View and under my SELECT statement and simply include "Sum([Hours]) AS TotalHours"...

As far as using toggle buttons, you need to make sure they are in a frame so Access knows to group them together giving them a value starting at 1. I prefer not to use wizards within access. Coding what you want can be complicated. So just google close to what you're looking for and use snip-its...

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

Thanks a ton!!!

I recently ran into the same problem and thought it was because I was using a [Forms] in the query I was filtering from. I discovered that with this version of access that if you don't save the form in order for it to have a name to connect with, then sometimes it will come up blank. This is if...

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