Recent content by jwleonard

Lissa - Unfortunately removing duplicates won't work in this case. The database was meant to be only used in one office when it was designed. Therefore, the auto number for the primary key was sufficient at that time. When multiple offices started using it there also wasn't a problem since...

I have multiple copies of a back end of a database that are shared throughout different offices in my organization. Each office needs to have separate databases but I have a new requirement to generate reports for the organization. The issue I will have is the Primary Key is an auto number...

That might be quite a bit over my head! Is there a sample of it somewhere that I could take a look at?

I am back home now and have confirmed the higher the resolution the more the form size is off. At 1650X1050 it only uses about 60% of the available space, I think one of the problems is the code doesn't account for the change in the ribbon size as the screen resolution changes.

I attempted to build a form and use the form resizer in 2007. It seemed to work at first but then I noticed a problem. I created the form at 1024x768 and updated form resizer appropriately; then loaded the form at 1200x800. There is a space on the right side and on the bottom that is about...

I haven't done any new developing in Access 2007 and I am wondering if there have been any advances in the form size to screen resolution issues in the new version. I normally create databases that are used in my office only; all the monitors are identical and are LCD so the users really only...

That is what it looks like to me too. The only thing that has me wondering is I have other reports with subreports that are set up the exact same way and they work fine. I tried going through and comparing properties and didn't find anything that made a difference.

I have a report with two subreports on it; there is no record source on the main report. The criteria for the report comes from a form where the user selects the report type, the start date and end date. Then they click a command button that opens the report in preview for review prior to...

I have seen several ways of doing this around here but would like to know what is the correct or preferred way? For simplicity lets say I have the following table structure and these are single parents with children: TBLParents: ParentID (PK) FirstName LastName TBLChildren: ChildID (PK)...

Thanks for the tip, I was double clicking thinking that should open the table. The simplest things!

There are primary keys in the tables, they showed up when I drag a table in to build a query. How can you update tables in the management studio without building a query? As I said before I am completely new to this environment.

How would I link to the SQL database with Access? I know how to link an Access front end and back end, but I'm not sure how to do it in this situation. I would prefer to do it in Access since I am familiar with it. Lastly is there a quick tutorial somewhere for direct manipulation of the data...

I would like to know if it is possible to edit database tables in SQL 2005 directly. I am decent at Access databases and can work my way through VBA & SQL in that environment; I have absolutely no experience with SQL on a server though. I attempted to open the UI of SQL Server 2005 today and...

Thanks, that did it! I swear sometimes the simplest things mess me up the worst.

I have a report query that uses a combo box on a form to collect the parameters. I would like to be able to include an option that would be like not having any criteria at all, to show all the records. I have tried several combinations in the criteria to get it to work and haven't found a way...