Adding new entries to a table via a combo box in a form
I have a Database for tracking conference attendance. Because of this I want to be able to both retrieve attendees and also adding new attendees. I have a form that allows me to retrieve attendees already input into a table via a combo box, but I can’t add new attendees via that same combo box. [...]
Answer Question
| November 19, 2008 5:41 PM
Access 2003, Access Database, Database issues, Microsoft Access
I have a Database for tracking conference attendance. Because of this I want to be able to both retrieve attendees and also adding new attendees. I have a form that allows me to retrieve attendees already input into a table via a combo box, but I can’t add new attendees via that same combo box. [...]
Answer Question
| November 19, 2008 5:41 PM
Access 2003, Access Database, Database issues, Microsoft Access
Trying To Make A pop up on MS access to come up every time a client needs to pay me..
So I have a table full of details of my clients.. including when they have to pay me (the date) and how much they have to pay me.. Im not an expert at MS access. i know how to make forms and all that but not this.. can somebody tell me how to get a [...]
Answer Question
| November 14, 2008 4:35 PM
Microsoft Access, POP
So I have a table full of details of my clients.. including when they have to pay me (the date) and how much they have to pay me.. Im not an expert at MS access. i know how to make forms and all that but not this.. can somebody tell me how to get a [...]
Answer Question
| November 14, 2008 4:35 PM
Microsoft Access, POP
Sample Microsoft Access database to capture Image from Webcam
I’m looking for a sample ms-access database with a form that can capture an image from a connected webcam.
Answer Question
| May 22, 2009 12:50 AM
Access image database, Database programming, Image databases, Microsoft Access, Webcam
I’m looking for a sample ms-access database with a form that can capture an image from a connected webcam.
Answer Question
| May 22, 2009 12:50 AM
Access image database, Database programming, Image databases, Microsoft Access, Webcam
MS Access & EDI
Is there a way to use MS Access to interface with a database that uses EDI? If so, what do I need to do to do this & where can I get more info on this?
Answer Question
| November 11, 2008 1:32 PM
Access, Database Management Systems, DBMS, EDI, Electronic Data Interchange, Microsoft Access
Is there a way to use MS Access to interface with a database that uses EDI? If so, what do I need to do to do this & where can I get more info on this?
Answer Question
| November 11, 2008 1:32 PM
Access, Database Management Systems, DBMS, EDI, Electronic Data Interchange, Microsoft Access
Combo box date/alpa field
Can it be done and how… I create a combo box and I want the field to have some alpha some numeric. the drop down will say “N/A”. But if they want to put a date in that field, should be able to. My testing show it has to be either or. Also when I [...]
Answer Question
| November 10, 2008 8:46 PM
Access 2003, Microsoft Access
Can it be done and how… I create a combo box and I want the field to have some alpha some numeric. the drop down will say “N/A”. But if they want to put a date in that field, should be able to. My testing show it has to be either or. Also when I [...]
Answer Question
| November 10, 2008 8:46 PM
Access 2003, Microsoft Access
create database using java
How to create database (not table) using java? For example, I want to create database in MSAccess, MySQL, Oracle etc.
Answer Question
| May 11, 2012 2:53 PM
Database, Java, Java Database, Microsoft Access, MySQL
How to create database (not table) using java? For example, I want to create database in MSAccess, MySQL, Oracle etc.
Answer Question
| May 11, 2012 2:53 PM
Database, Java, Java Database, Microsoft Access, MySQL
Access 2003 checkbox to perform calculations
I have modified the ledger template database from MS to incorporate 4 columns containing yes/no checkboxes. The checkboxes refer to 4 phases of contruction for the line entry. Some line entries may have nore than one box checked. My problem is that when I need to run a report on an individual phase, the line [...]
Answer Question
| November 7, 2008 7:48 PM
Access 2003, CheckBox, Microsoft Access
I have modified the ledger template database from MS to incorporate 4 columns containing yes/no checkboxes. The checkboxes refer to 4 phases of contruction for the line entry. Some line entries may have nore than one box checked. My problem is that when I need to run a report on an individual phase, the line [...]
Answer Question
| November 7, 2008 7:48 PM
Access 2003, CheckBox, Microsoft Access
Create table by comparising 2 tables
I am new at Access but have some help with creating a db. I would like to know if it is possible to compare table 1: prior data and table 2: current data, and then create a table 3, with all the changes/deletions from the 1st table to the 2nd. All the data is workflow [...]
Answer Question
| November 6, 2008 4:38 AM
Access conditional expressions, CREATE TABLE statement, Database programming, Microsoft Access
I am new at Access but have some help with creating a db. I would like to know if it is possible to compare table 1: prior data and table 2: current data, and then create a table 3, with all the changes/deletions from the 1st table to the 2nd. All the data is workflow [...]
Answer Question
| November 6, 2008 4:38 AM
Access conditional expressions, CREATE TABLE statement, Database programming, Microsoft Access
About UPDATE query
hi friends , i am using VB 2008 . database access 2003 in my project , i include an update query,its below con.Open() Dim cmd As New OleDbCommand(“update device set manu=’” + mtxt.Text + “‘,desc=’” + dtxt.Text + “‘,model=’” + mdtxt.Text + “‘,pdate=’” + prodate.Text + “‘,price=’” + ptxt.Text + “‘where ano=’” + atxt.Text + [...]
Answer Question
| November 5, 2008 4:09 PM
Access 2003, Microsoft Access, RSS, VB 2008, Visual Basic 2008
hi friends , i am using VB 2008 . database access 2003 in my project , i include an update query,its below con.Open() Dim cmd As New OleDbCommand(“update device set manu=’” + mtxt.Text + “‘,desc=’” + dtxt.Text + “‘,model=’” + mdtxt.Text + “‘,pdate=’” + prodate.Text + “‘,price=’” + ptxt.Text + “‘where ano=’” + atxt.Text + [...]
Answer Question
| November 5, 2008 4:09 PM
Access 2003, Microsoft Access, RSS, VB 2008, Visual Basic 2008
Advice on buying new PC
I have a Pentium 4 & need to upgrade. I teach Microsoft, use graphics in my manuals, & use CorelDraw a lot. I also design huge Excel spreadsheets with lots of formulas and design databases in Access – what would be a good PC processor, ram, etc? I have been quoted on a system with [...]
Answer Question
| November 8, 2008 1:50 PM
CorelDRAW, Hardware, Hardware configuration management, Microsoft Access, Microsoft Excel, Pentium
I have a Pentium 4 & need to upgrade. I teach Microsoft, use graphics in my manuals, & use CorelDraw a lot. I also design huge Excel spreadsheets with lots of formulas and design databases in Access – what would be a good PC processor, ram, etc? I have been quoted on a system with [...]
Answer Question
| November 8, 2008 1:50 PM
CorelDRAW, Hardware, Hardware configuration management, Microsoft Access, Microsoft Excel, Pentium
Need to modify an existing form in Access 2007
I have just migrated to ACCESS 2007 from previous versions. How do you bring up a window that displays all the objects in the database and then select one for modification. I have been able to modify tables and queries but cannot work out how to modify existing forms or reports.
Answer Question
| November 4, 2008 4:04 AM
Access 2007, Access forms, Database programming, Microsoft Access
I have just migrated to ACCESS 2007 from previous versions. How do you bring up a window that displays all the objects in the database and then select one for modification. I have been able to modify tables and queries but cannot work out how to modify existing forms or reports.
Answer Question
| November 4, 2008 4:04 AM
Access 2007, Access forms, Database programming, Microsoft Access
How to change the location where jpg is looked for in ACCESS
I enter data for trophy fish catches into an AK. Dept of Fish and Game database. I inherited the DB. I have no IT help. All pictures were in a messy folder with the DB. I sorted the pics into sub-folders. Now the program cannot find the JPG associated with a particular entry. I assume [...]
Answer Question
| October 31, 2008 6:40 PM
Access Database, Access File Paths, Microsoft Access
I enter data for trophy fish catches into an AK. Dept of Fish and Game database. I inherited the DB. I have no IT help. All pictures were in a messy folder with the DB. I sorted the pics into sub-folders. Now the program cannot find the JPG associated with a particular entry. I assume [...]
Answer Question
| October 31, 2008 6:40 PM
Access Database, Access File Paths, Microsoft Access
Issue SQL Query with Localized String through PowerShell
Hello, I am attempting to execute a an SQL query through PowerShell against an MS Access database. My query works 99% of the time, but occasionally a localized string will cause an error beacuse it contains a single quote (‘) somewhere within the localized string. You can look at the following example to get a [...]
Answer Question
| November 5, 2008 11:51 AM
Database programming, Localized String, Microsoft Access, PowerShell, Scripting, SQL, SQL Query, Windows PowerShell, Windows scripting
Hello, I am attempting to execute a an SQL query through PowerShell against an MS Access database. My query works 99% of the time, but occasionally a localized string will cause an error beacuse it contains a single quote (‘) somewhere within the localized string. You can look at the following example to get a [...]
Answer Question
| November 5, 2008 11:51 AM
Database programming, Localized String, Microsoft Access, PowerShell, Scripting, SQL, SQL Query, Windows PowerShell, Windows scripting
Access 2007 Replace operation
In Access 2007, can a replace operation be performed using wildcard to replace a variable string with a known string.
Answer Question
| November 4, 2008 5:33 PM
Access 2007, Microsoft Access
In Access 2007, can a replace operation be performed using wildcard to replace a variable string with a known string.
Answer Question
| November 4, 2008 5:33 PM
Access 2007, Microsoft Access
Conditional Format – Access 97
Unfortunately, the company I work for uses Access 97, and the Conditional Format Wizard is not available in this version. Can you help me with building a macro/expression to create a conditional format for a form? I need to format the form’s background color based simply on whether the record is “Active” vs. “Inactive.” Thanks, [...]
Answer Question
| October 30, 2008 6:07 PM
Access 97, Conditional formatting, Microsoft Access
Unfortunately, the company I work for uses Access 97, and the Conditional Format Wizard is not available in this version. Can you help me with building a macro/expression to create a conditional format for a form? I need to format the form’s background color based simply on whether the record is “Active” vs. “Inactive.” Thanks, [...]
Answer Question
| October 30, 2008 6:07 PM
Access 97, Conditional formatting, Microsoft Access
Creating pop-up reminders
I am maintaining a data baase of living documents whic require a review every 2 years. I need a reminder before the 2 year anniversary arrives. The table currently has a “Effective Date” column. Please keep in mind that I am not well versed in macros. Thanx for any help,
Answer Question
| October 28, 2008 10:39 PM
Access 2007, Access 2007 pop-up reminder, Database programming, Microsoft Access
I am maintaining a data baase of living documents whic require a review every 2 years. I need a reminder before the 2 year anniversary arrives. The table currently has a “Effective Date” column. Please keep in mind that I am not well versed in macros. Thanx for any help,
Answer Question
| October 28, 2008 10:39 PM
Access 2007, Access 2007 pop-up reminder, Database programming, Microsoft Access
Not allowed to edit Microsoft Access forms
A previous employee built a very usable db, and has gone on to greener pastures. It isn’t password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use [...]
Answer Question
| November 3, 2008 12:08 AM
Access 2003, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Office 2003, Office 2003, VBA, Visual Basic for Applications
A previous employee built a very usable db, and has gone on to greener pastures. It isn’t password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use [...]
Answer Question
| November 3, 2008 12:08 AM
Access 2003, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Office 2003, Office 2003, VBA, Visual Basic for Applications
permission to open database
ACCESS 2000 which we used to write two databases. We added a new user, and correctly added the group. Then the next morning and every day since we can not gain access to the database. There are 3 user computers. 1 user reads the reinstalled ACCESS database fine, the other two can’t gain access to [...]
Answer Question
| October 20, 2008 7:42 PM
Access 2000, Access Database, Access database permissions, Microsoft Access
ACCESS 2000 which we used to write two databases. We added a new user, and correctly added the group. Then the next morning and every day since we can not gain access to the database. There are 3 user computers. 1 user reads the reinstalled ACCESS database fine, the other two can’t gain access to [...]
Answer Question
| October 20, 2008 7:42 PM
Access 2000, Access Database, Access database permissions, Microsoft Access
field C is the result of the substraction between filed A and field B from the same table
How to create a field C into a MS Access table which will be the result of the subtraction between filed B and filed A on the same table. Like: C=B-A
Answer Question
| October 20, 2008 9:41 PM
Microsoft Access, Ms Access 2003 Database Table
How to create a field C into a MS Access table which will be the result of the subtraction between filed B and filed A on the same table. Like: C=B-A
Answer Question
| October 20, 2008 9:41 PM
Microsoft Access, Ms Access 2003 Database Table
VB and MS access
I have finished develop a project in VB 6. Back end as Ms Access(Office 2003). Finished up to SETUP file. MY question is how to install the setup file with the database.
Answer Question
| October 20, 2008 8:16 AM
Microsoft Access, Visual Basic 6
I have finished develop a project in VB 6. Back end as Ms Access(Office 2003). Finished up to SETUP file. MY question is how to install the setup file with the database.
Answer Question
| October 20, 2008 8:16 AM
Microsoft Access, Visual Basic 6
