Getting Started

Creating Macros
Hi everyone, I'm new to macros and would like your assistance. I have created a database in access 2003. Did the tables, queries, and reports for current data. My question is how can I overwrite old data when importing new one from an Excel file? I need to update the information each week and need to figure o... 18 Jul 2008 15:28

How do I disable a hyperlink warning?
I have read previous answers to how to disable a hyperlink warning. I have changed the setting in my registry (HKEY_CURRENT_USER...), but this does not work for a link to a local file. This problem was also brought up in previous discussions, but no one answered this particular problem. Can someone help? I h... 21 Jul 2008 08:56

Adding Contact Records to Contact Database
I have a list of contacts that I would like to add a table that would do the following: In a single record view (if it is available versus table view) I would like to record telephone conversations with date, and what we discussed. Also, I would like to have an option to add a sub record for date and other ... 18 Jul 2008 01:04

DATE SEARCH CBO
I would like to be able to search classes by date. I have created a query ClassesSearch Query and then created a form with an unbound combo box that points to Row Source. When I click on the ... I have, ClassID [Classes], ClassName [Classes], and Class Date [Classes] Sort Ascending. I then created a button o... 30 Jul 2008 22:02

Show icon in record selector of continuous form
Hello, I have a split database. A continuous form in that application has it's Record Locked property set to 'Edited Record'. The database Tools-Options-Advanced property has also been set to 'Edited Record', and the checkbox indicates " Open databases using record-level locking". When two users have the same f... 17 Jul 2008 15:48

Please help! Where Condition in a Macro
I have very little knowledge of VB and I thought Access 2007 would be easier but I am still running into problems. I have a split form that contains records of distributors and I would like users to be able to click on the distributor's id and have a form open up that contains all that distributors information.... 25 Jul 2008 12:29

subtotal on only one item
I have a table with Stockname, Symbol, SecurityType, OptionDate, OptionStrikePrice, OptionDesc(which is OptionDate and OptionStrikePrice concatenated), Sharesbought, Sharessold, Number of Shares(which is Sum of Sharesbought and Sharessold). Would it be possible to subtotal only the "Stock" SecurityType, and onl... 20 Jul 2008 13:30

double conformation on delete
Private Sub cmdDel_Click() On Error Resume Next DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 If Err = 2501 Then Err.Clear 'user canceled End Sub It gives me two confirmation: How to suppress 2nd confirmation? 1. Are you sure... 17 Jul 2008 10:38

Record does not show in Combo Box until close/reopen form
I have main form with a combo box to search name and add form to add record. After adding record and close add form, newly added record does not show in search combo box of main form. I have to close the main form and re-open it to show the newly added record in the search combo box. How to fix it? Thanks. ... 21 Jul 2008 12:02

DropDown Box
ACCESS 2007 User I created a drop down box that changes color based on what you select in the dropdown box. I did this by selecting the dropdown box, right clicking and selecting Conditional Formatting > set it to Equal to - green show the background color green, etc... well now when I go to create a new record ... 16 Jul 2008 23:21