hi you, i've created a database for my dept and place it on shared server. The problem is everytime user exit from the database, there will be a duplicate of database at the server. Example: my database file name is correspondence_log.accdb, when user finished used the database, there will be an...
This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn't checked, return all the fields whether they have text or not...Pretty basic filter I thought Seems like I'm getting close but can't...
My mail email routine for sending emails with a .doc attachment work fine using MSAcess 2003 but don't work using MSAcess 2007 Software/Hardware used: Office 2007 OS = XP
I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How should I go about solving this problem? ...
I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application. Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user. Is there a way...
SQL Server 2005 security, Access 2007 security, SQL Server 2005
We have several clients with access to reports (provided via Views). The reports for each client are separated by being under a different SQL Server 2005 Schema. Obviously we can get each client to link to their Views but the client wants things to work like an ADP - that is, as reports are added,...
I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks
I am using MS Access 2007 on Windows XP Professional. The main table in my Purchase Ordersdatabase has dropped its primary key and index (no duplicates). Previously, it worked without any problems, and caught duplicate values. Now, when I try to reset the primary key, I get the message, "The...
I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version of...
Is this possible to take a MS Access Db and run it on the Xserve Server
The title of the switchboard changes to the title of one of the items. I can't figure out why.
I remember in Access 2000 you used to be able to import an external document and use it as a Access form after overlaying the table fields. We use a "User Request form" that I would like to use but I do not see where or how to accomplish this with Access 2007(??) If this option has been...
How do you convert filmaker pro 7 database to an access 2007 database file
With a form based on 1 table, can I have info from a related table automacially appear based on linked field? For example, let's say I have two tables linked by a Vendor ID number. On a form that is based on the Purchase Order table, I'd like the Vendor name to automatically appear on the form...
Greetings, I have an objective that's been driving me in circles.... Windows XP Office 2007 I need to figure out how to convert "multiple" Microsoft Access reports into one pdf file through vba. Access 2007 has easy way to convert one report at a time to pdf, however, I cannot figure out how to...
Cheers, I have an Access 2007 application that uses mostly vb.net code to create an excel spreadsheet with all the necessary data in the right places... The program uses a specific set of data that resides in a different database. What I would like to do is connect to the foreign table (which I...
Can multiple instances of the same access database be open when linked to same excel file?
I need to duplicate all fields in a form based on a table based dynaset. The duplicate record will then be modified and given a new pk.
I am trying to populate a form object based on the value from a combo box. I have tried FindRecord and SetValue and so far nothing is working. Please help.
I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked...



