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 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
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
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
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
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 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
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 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
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 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
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 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
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
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
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’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 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
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
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