I try to open a database designed in Microsoft Access XP , in Microsoft Access 2007. All forms and tables seems to be ok but NO COMMAND THAT I WRITE IN VBA...

I have a dbase in miltuser environment. I have a form frm_Entries that may be use from many user in the same time. When we enter data we cant see all records...

I have a multiuser database in MSAccess 2007 and I would like to have password in order to protect my database design. Please help me!

Hi and thank you in advance for taking the time to help me. I need to set up a db that will allow me to compare prices from my suppliers twice a week. My...

pcehcpvuggxxxhbcyxeuuosdlgzfhndkpjqcclyjruvlriwrzbp

My relationship report will not show in a report because it says the relationship is too large. Besides MS Visio, what other way can I print out my...

I need to add credit card data in my table and I need a date field to collect and show data as "mm"/"yy". I have tried different approaches and none worked. ...

I completed a reverse engineering of my Access 2007 database into Visio. When I review all the tables, there are dublicates. The duplicates have TMPCLP in...

Hi Please help. I have created a form with a subform. I have a 2 combo boxes in the subform. When I choose an option on the 1st combo box it restricts the...

I have a need to have a parent table for ALL projects. The projects fall into four kinds (WRD-Municipal-Minnesota-Local). Each kind has its own set of...

Is there a way to set\change the Format Property of a filed in table by SQL statement?

I am setting up a database at work to record when 6 monthly questionnaires have been sent out. Is it possible to set up a reminder system that flags up when...

Hello folks. I'm relatively new to MS Access and I'm having a Dickens of a time figuring out whether materialized views are supported in MS Access, or even...

I am completely new to Excel and have created a spreadsheet which background should have no fill. Unfortunately, part of the spreadsheet has a gray tone and...

Hello, Access newbie seeking expert advice. I have listed the fields I currently have in one table and would like to obtain advice on how to split out the...

I have several tables in my database with ID number as a common fiels for the customers. How can I make access fill in customer first and last...

i wonder where is "Table Wizard" in access 2007

I have created a database for products that i sell. I would like the Primary key to be a combination of the Category Id for that product and a...

In the query design toolbar I have Field, Table Sort, Show, Criteria and or opitions. I am missing the "Total" opition for grouping. Any suggestions....