I am copying a record from one table to another in Access 2007. I iterate through each field in the current record and copy that value to the new table. It works fine until I get to my lookup column field that allows multiple values. The name of the lookup column is "Favorite Sports" and the user can select multiple values from a dropdow...
![alt text][1] [1]: http://C:\Documents and Settings\Administrator\My Documents\My Pictures\Ashampoo Magical Snap 2\Magical Snap - 2009.11.16 23.07 - 003.jpg In referring to the picture there are several entries where the same Student ID repeats. Where this happens I'd like to combine the money owed by totaling any multiple entries un...
I want to disable the command ctrl + a (select all) in Access 2007. Is that possible? ...
How can I hide this bar (see picture) in Access 2007? ...
I have an embarrassing question regarding Access. I can build relational databases in my sleep but I have always used PHP, mySQL and HTML to build my applications. I've hated Access with a passion for various reasons ever since I can remember but now I'm stuck using it for a particular project. I have a number of tables, one of which i...
Hi, i need to open a connection to a remote access db. in the local environment to the remote acess db is working great . when i run this application from production server (other server) it's fail with message " It is already opened exclusively by another user, or you need permission to view its data. " my code : conStr...
Is it possible to set a value to values who is NULL? The sql I use now is this: SELECT date FROM Activity WHERE date BETWEEN [Forms]![Search]![fromDate] AND [Forms]![Search]![toDate] But the problem is when there is no value for fromDate or toDate the result is zero rows. So what I want to do is when fromDate is NULL, change the from...
SELECT id FROM Activity WHERE important = see below IF [Forms]![Search]![important] = false, search for both true and false IF [Forms]![Search]![important] = true, search for only true I hope you understand what I want to do. Is this possible? ...
My company will be upgrading from Access 97 databases to Access 2007. I have created an .accdb file and have imported the objects from the Access 97 .mdb file. The problem now I see is that even clicking on a button that just opens a form (no significant code behind it) takes 5 min. Going into a design mode for a form takes like 3 min...
Hi! When a user start an Access 2007 database that have macros and vba, a security warning is shown. I want the user to deal with this warning, so if the the content is't enabled, the user should not be able to use the database. Now I use a macro named AutoExec (opens a form that works like a menu), and that macro is run before the us...
I have an old Access 2000 app (I don't do much Access dev these days) that a client is trying to run in Access 2007. It runs fine for the most part, except the forms do not behave as-designed when they are called/instantiated, etc: Access 2007 puts every new form inside a "Tab" of sorts, which is causing confusion on the part of the end ...
I would not dare label myself as a programmer. But I am running a website with a storefront. I want to label some of my products with multiple categories. This involves creating one column in my MS Access database (called categories) that has categories separated by commas. i.e. "shirts,clothing,wearables,sports" I've added a lookup co...
Hello , before a little time , I used a code to get the dates between 2 dates from the database (column with dates dd/mm/yy) , I think it works nice first time , the code is : Dim b As New Date Dim a As Integer a = Val(tx2.Text) b = System.DateTime.Today b = b.AddDays(-a) ...
Im using: Visual Web Developer 2009 Access 2007 I am trying to insert into a products table, however i keep recieveing the error: "Data type mismatch in criteria expression." The Edit and Delete sections work fine.. <%@ Page Title="" Language="VB" MasterPageFile="~/Master/MasterPage.master" AutoEventWireup="false" CodeFile="Produc...
I've got a MS Access 2007 DB with records of passed and failed attempts to pass an exam. Student_id, Course_id, passed S001 C001 0 S001 C001 1 S002 C001 1 S003 C001 0 'Passed' is used as a boolean where 0 is failed an 1 passed, but is stored as a number. I want to build a query dis...
Hi all, I just converted ACCESS 2000 to ACCESS 2007 application. How do I access to the switch windows - "select window" dialog, how can I open this dialog from VBA Thanks ...
Let's say we have a [Valuations] table containing several values per date and per fund: -FundId -ValDate -Value1 -Value2... The Primary key is obviously FundId+ValDate. I have also indexed the ValDate field since I often query for values on a specific date. My question is: should I also create a specific index for the FundId, or i...
Hello, I'm trying to get a list of all tables from an Access 2007 database using VBA. I have followed this post: http://stackoverflow.com/questions/201282/how-to-get-table-names-from-access Using: SELECT MSysObjects.Name AS table_name FROM MSysObjects WHERE (((Left([Name],1))<>"~") AND ((Left([Name],4))<>"MSys") AND ((MSysObjects.Ty...
Hello I am dealing with some unfriendly import files which import as: timestamp position name 001 2 Jon 001 3 Bob 001 1 Ann 001 4 Mike 002 1 Joe 002 2 Sue 003 1 Jeff 004 ...
I've look around and I haven't find anything in the Web pointing me to the right direction, so I'll try the knowledgeable stackoverflow people :) I have 4 tables in Microsoft Access 2007 (Warehouse, Cars, TVs, Toys). __(many) Cars / Warehouse 1---(many) TVs \__(many) Toys The Warehouse table has a 1...