Setting up a field to store .png file in Access 2007 Database so that it can be merged with Word document
I have an Access 2007 database that includes a company logo( .png file) field. I have set up the field as an “attachement” data type and I have also tried OLE data type. The problem is that when I use the database as part of a merge with a Word document, the logo does not [...]
Answer Question
| July 2, 2010 9:15 PM
Access 2007, Mailmerge, Word 2007
I have an Access 2007 database that includes a company logo( .png file) field. I have set up the field as an “attachement” data type and I have also tried OLE data type. The problem is that when I use the database as part of a merge with a Word document, the logo does not [...]
Answer Question
| July 2, 2010 9:15 PM
Access 2007, Mailmerge, Word 2007
Access 2007 User Permissions
I have administrator permissions on a PC based database. I would like to add users and give them various levels of permissions. The bottom line is I do not want users to be able to change the design of database, including forms. I am just a touch above novelist so need real specific guidance.
Answer Question
| June 21, 2010 4:31 PM
Access 2007, Access 2007 security, Microsoft Access 2007 permissions, Permissions, User Permissions
I have administrator permissions on a PC based database. I would like to add users and give them various levels of permissions. The bottom line is I do not want users to be able to change the design of database, including forms. I am just a touch above novelist so need real specific guidance.
Answer Question
| June 21, 2010 4:31 PM
Access 2007, Access 2007 security, Microsoft Access 2007 permissions, Permissions, User Permissions
Access 2007 Recurring Jobs
How can I create a form that allows a user to create recurring (eg: weekly, daily, monthly) appointment/job in access 2007?
Answer Question
| July 14, 2010 2:05 AM
Access 2007, Access 2007 forms, Access 2007 functions, Windows 7, Windows 7 in 2010
How can I create a form that allows a user to create recurring (eg: weekly, daily, monthly) appointment/job in access 2007?
Answer Question
| July 14, 2010 2:05 AM
Access 2007, Access 2007 forms, Access 2007 functions, Windows 7, Windows 7 in 2010
Expression Builder, Calculation confusion in Access 2007
Ok I’m having trouble with this simple calculation. I have a Query with a field called “% of fire Calls made” it may contain a number (ie 23.34). I’ve tried to create another field in the same query that ask the question, if the # in “% of fire Calls made” is equal to or [...]
Answer Question
| September 22, 2010 2:21 PM
Access 2007, IIF function, Syntax errors
Ok I’m having trouble with this simple calculation. I have a Query with a field called “% of fire Calls made” it may contain a number (ie 23.34). I’ve tried to create another field in the same query that ask the question, if the # in “% of fire Calls made” is equal to or [...]
Answer Question
| September 22, 2010 2:21 PM
Access 2007, IIF function, Syntax errors
Search for Records Containing Word(s) in Textbox
How can I bring up records from a table, by using a query, that contain words that are entered into a textbox on a form? I can only get it to work if I enter in the specific word(s) into the field criteria in design view, which is not what I want.
Answer Question
| June 9, 2010 2:50 PM
Access 2007, Access 2007 functions, Query, TextBox
How can I bring up records from a table, by using a query, that contain words that are entered into a textbox on a form? I can only get it to work if I enter in the specific word(s) into the field criteria in design view, which is not what I want.
Answer Question
| June 9, 2010 2:50 PM
Access 2007, Access 2007 functions, Query, TextBox
Repeating Data
Can I create something in a form in Access 2007 that allows a user to make a recurring job? I have created a database for a Waste Management company. I created two tables. The first one is the date table containing the date the customer calls in for a skip or a sewage collection or [...]
Answer Question
| June 1, 2010 4:22 PM
Access 2007, Access 2007 form creation, Date Type Variables, Windows XP
Can I create something in a form in Access 2007 that allows a user to make a recurring job? I have created a database for a Waste Management company. I created two tables. The first one is the date table containing the date the customer calls in for a skip or a sewage collection or [...]
Answer Question
| June 1, 2010 4:22 PM
Access 2007, Access 2007 form creation, Date Type Variables, Windows XP
Recurring data
Can I insert a command that allows a user to create recurring (eg: weekly, daily, monthly) jobs? I am using Access 2007.
Answer Question
| June 18, 2010 9:30 AM
Access 2007, Microsoft Access 2007 Reports/Queries, Windows XP
Can I insert a command that allows a user to create recurring (eg: weekly, daily, monthly) jobs? I am using Access 2007.
Answer Question
| June 18, 2010 9:30 AM
Access 2007, Microsoft Access 2007 Reports/Queries, Windows XP
Trouble creating SQL statement from MS Access Form
I’m creating an INSERT statement from the text fields in a form. This is a snippet: mySQL = mySQL & Combo0 & "','" & Text3 & "','" & Text5 & "','" & Text7 I am alternating the double and single quotation marks to enclose the entire statement as a single STRING while using the single [...]
Answer Question
| May 10, 2013 9:51 PM
Access 2007, Microsoft Access, SQL, VBA, Windows Vista
I’m creating an INSERT statement from the text fields in a form. This is a snippet: mySQL = mySQL & Combo0 & "','" & Text3 & "','" & Text5 & "','" & Text7 I am alternating the double and single quotation marks to enclose the entire statement as a single STRING while using the single [...]
Answer Question
| May 10, 2013 9:51 PM
Access 2007, Microsoft Access, SQL, VBA, Windows Vista
Visual Basic question
I made a database and to get around security issues. I made forms that will open when someone opens the database. I want to build a visual basic code to look for the computer name and based off the computer name a form will open. I have the forms made and the table to put [...]
Answer Question
| May 20, 2010 6:45 PM
Access 2007, Visual Basic, Visual Basic developers
I made a database and to get around security issues. I made forms that will open when someone opens the database. I want to build a visual basic code to look for the computer name and based off the computer name a form will open. I have the forms made and the table to put [...]
Answer Question
| May 20, 2010 6:45 PM
Access 2007, Visual Basic, Visual Basic developers
Date fields in Microsoft Access 2007 when mail merged into a letter etc, become American. ie 5/18/2010 instead of 18/5/10
Can anyone advise me how to correct this. I have tried changing the format in MS Access to medium (18-May-10) and it still doesnt come through correctly.
Answer Question
| May 21, 2010 1:57 PM
Access 2007, Mail merge, Microsoft Access 2007
Can anyone advise me how to correct this. I have tried changing the format in MS Access to medium (18-May-10) and it still doesnt come through correctly.
Answer Question
| May 21, 2010 1:57 PM
Access 2007, Mail merge, Microsoft Access 2007
Windows 7 Access 2007 SBS 2003 Problem
Windows 7 client is set up on SBS 2003 and can access files, etc. An Access 07 back end database is stored on the server with an Access 07 database front end on the client machine. With tables linked, the back end does not operate correctly and VBA code in the front end does not [...]
Answer Question
| May 20, 2010 9:41 PM
Access 2007, SBS 2003, Small Business Server 2003, Windows 7, Windows Server 2003
Windows 7 client is set up on SBS 2003 and can access files, etc. An Access 07 back end database is stored on the server with an Access 07 database front end on the client machine. With tables linked, the back end does not operate correctly and VBA code in the front end does not [...]
Answer Question
| May 20, 2010 9:41 PM
Access 2007, SBS 2003, Small Business Server 2003, Windows 7, Windows Server 2003
Calculate Business Hours
I found a VBA code that fits the program I’m trying to create but I’m having a difficult time locating the 12-1 lunch break so I can make it straight time. Listed below is the code. Function CalculateDownTime(StartTime As Date, EndTime As Date) As Double Dim Result As Double, EndDay As Date Result = 0 [...]
Answer Question
| May 21, 2010 6:48 AM
Access 2007, Access 2007 alerts, Microsoft Access, VBA
I found a VBA code that fits the program I’m trying to create but I’m having a difficult time locating the 12-1 lunch break so I can make it straight time. Listed below is the code. Function CalculateDownTime(StartTime As Date, EndTime As Date) As Double Dim Result As Double, EndDay As Date Result = 0 [...]
Answer Question
| May 21, 2010 6:48 AM
Access 2007, Access 2007 alerts, Microsoft Access, VBA
using if in access 2007
i have 2 schedule on we call it patient and it have in side it gender (male or female), and the author schedule we call it patient problem and it have (pregnant,not pregnant,not female), i wont wen we chose male automatically in author schedule chose not female. thanks for you help
Answer Question
| May 11, 2010 8:14 AM
Access 2007
i have 2 schedule on we call it patient and it have in side it gender (male or female), and the author schedule we call it patient problem and it have (pregnant,not pregnant,not female), i wont wen we chose male automatically in author schedule chose not female. thanks for you help
Answer Question
| May 11, 2010 8:14 AM
Access 2007
Creating a database in Access 2007
I am not an expert on Access; however, as a student in college my professor commented that my Microsoft Database was built from a table. Can someone tell me what does that mean? And do your templates build from a table? I guess I really want to know how to prevent a template from building [...]
Answer Question
| April 24, 2010 12:08 PM
Access 2007, Access Database, CREATE DATABASE statement
I am not an expert on Access; however, as a student in college my professor commented that my Microsoft Database was built from a table. Can someone tell me what does that mean? And do your templates build from a table? I guess I really want to know how to prevent a template from building [...]
Answer Question
| April 24, 2010 12:08 PM
Access 2007, Access Database, CREATE DATABASE statement
Access 2007 filters
when i use the filter option and then go to advanced filter to save as a query. It is a ligth gray color and i cant click on save qurey. So i cant save any filters.
Answer Question
| April 15, 2010 2:29 PM
Access 2007, Access 2007 functions
when i use the filter option and then go to advanced filter to save as a query. It is a ligth gray color and i cant click on save qurey. So i cant save any filters.
Answer Question
| April 15, 2010 2:29 PM
Access 2007, Access 2007 functions
Look up values
I am creating a datbase for a lawyer. Some clients have multiple charges under their name. I have created a look up value for the name of the charges to make the process quicker, but so far I am only able to choose and display one charge. Is their a way to add more charges [...]
Answer Question
| March 30, 2010 11:09 PM
Access 2007, look up wizard
I am creating a datbase for a lawyer. Some clients have multiple charges under their name. I have created a look up value for the name of the charges to make the process quicker, but so far I am only able to choose and display one charge. Is their a way to add more charges [...]
Answer Question
| March 30, 2010 11:09 PM
Access 2007, look up wizard
Issue With Buttons in Access
I’m building an Access DB and would like to have people interact with it through forms and command buttons. Adding command buttons should be very straight forward with the wizard, and it is until I test the button – the buttons I create don’t work and give me this error message: A problem occurred while [...]
Answer Question
| April 5, 2010 12:23 AM
Access, Access 2007, button, error message, event procedure, onopen
I’m building an Access DB and would like to have people interact with it through forms and command buttons. Adding command buttons should be very straight forward with the wizard, and it is until I test the button – the buttons I create don’t work and give me this error message: A problem occurred while [...]
Answer Question
| April 5, 2010 12:23 AM
Access, Access 2007, button, error message, event procedure, onopen
Microsoft Access Relationship/Query Question
I have a database with around 3,000,000 records organized by account number, and another database with 100,000 or so organized by the same account number. I import both these databases into Access, and link up the account numbers… I want to pull data from both databases in order to create a new table. The problem [...]
Answer Question
| March 18, 2010 3:08 PM
Access 2007
I have a database with around 3,000,000 records organized by account number, and another database with 100,000 or so organized by the same account number. I import both these databases into Access, and link up the account numbers… I want to pull data from both databases in order to create a new table. The problem [...]
Answer Question
| March 18, 2010 3:08 PM
Access 2007
Setting Up Access Parameters/Questions to user
I am working with a very complex access database and my database knowledge is very minimal. I am needing to make it so that when a user clicks to edit an orgainiaztions information with in the database the form that pops up will prompt them to either display all of the organiaztion types or let [...]
Answer Question
| March 3, 2010 5:07 PM
Access 2007
I am working with a very complex access database and my database knowledge is very minimal. I am needing to make it so that when a user clicks to edit an orgainiaztions information with in the database the form that pops up will prompt them to either display all of the organiaztion types or let [...]
Answer Question
| March 3, 2010 5:07 PM
Access 2007
How to delete a database – MS Access 2007
I am using MS Access 2007 and I thought that I had managed to delete a database, but every time I open MS Access 2007 the database is still showing in the Recent Database list. Is there a way that I remove all traces of that database and stop it from showing in that list?
Answer Question
| July 23, 2010 4:16 AM
Access 2007, Access Database, Microsoft Access
I am using MS Access 2007 and I thought that I had managed to delete a database, but every time I open MS Access 2007 the database is still showing in the Recent Database list. Is there a way that I remove all traces of that database and stop it from showing in that list?
Answer Question
| July 23, 2010 4:16 AM
Access 2007, Access Database, Microsoft Access
