Search results

  1. J

    Question Use single front end to pull data from multiple copies of same backend; how?

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

    Question Use single front end to pull data from multiple copies of same backend; how?

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

    Form Size / Screen Resolution in Access 2007

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

    Form Size / Screen Resolution in Access 2007

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

    Form Size / Screen Resolution in Access 2007

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

    Form Size / Screen Resolution in Access 2007

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

    Print report causes refresh of data in subreport, help stop it please.

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

    Print report causes refresh of data in subreport, help stop it please.

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

    Find subform record that is not matching current main form record.

    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)...
  10. J

    Data Manipulation In A Table

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

    Data Manipulation In A Table

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

    Data Manipulation In A Table

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

    Data Manipulation In A Table

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

    Query with combo on form for parameter

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

    Query with combo on form for parameter

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

    Access 2007 Bug (Has it been reported)?

    I really need to start refreshing before I post!
  17. J

    Access 2007 Bug (Has it been reported)?

    I couldn't resist giving it a try and it seems to have worked on the forms I had the problem with. I also did a little more testing and discovered it doesn't happen on every single form. The best I can figure is it has something to do with what is on the form and where it is placed. Is this...
  18. J

    Access 2007 Bug (Has it been reported)?

    Thanks for the tutorial anyway, I'm sure I can use a lot of the other info on your site. I pretty much just jumped right in to 2007; trial by fire. Funny how they hid that button right in plain sight!
  19. J

    Access 2007 Bug (Has it been reported)?

    I found out how to remove the layout (grouping), I will try it when I get done working on the database tonight and see if the problem still occurs. Even if this fixes it there is still an issue here though.
  20. J

    Access 2007 Bug (Has it been reported)?

    No I haven't tried that, I'm not even sure how to do that. The only way I have been able to ungroup them is to delete and add them again manually (away from the group). I figured there was another way to do it but don't know how.
Back
Top Bottom