I create an MS Access 2007 query where the same customer has multiple project and data appear like: 1 | Foo 1 | Bar 1 | Baz 2 | For 3 | Cad 3 | Cam and I want to transform it into something like 1 | Foo | Bar | Baz 2 | For | 3 | Cad | Cam | The goal is to create a spreadsheet view per customer (1,2,3) which can be read from word...
CDO works fine in Access VBA for me except when I try to use UNC paths for the attachments. According to MSDN documentation on CDO, AddAttachment should allow UNC paths. Here's what I think should work, but doesn't: msg1.AddAttachment "\\serv.dom.local\path with spacesh1\file.xls" It works perfectly fine if I use "C:...". What's th...
In a SQL database I have a table, Table1. This table is related to another table, Table2 which in turn is related to Table3. There is a query Query1 that selects certain records from Table1. This database is linked to in an Access database project A form Table1Data is based on Table1, with a datasheet containing related Table2 data (an...
Hi is it possible with cross query to do this ? (in Access 2007) I have this table: 50 | A1 60 | A1 70 | B1 80 | B1 90 | C1 I need to get this result: A1 ------------------ B1 --------------- C1 sum | avg ----- sum | avg ----- sum | avg 55 | 110 --------- 75 | 130 ...
Hi I ask before, but still any answer....... is it possible with cross query to do this ? (in Access 2007) I have this table: 50 | A1 60 | A1 70 | B1 80 | B1 90 | C1 I need to get this result: A1 ------------------ B1 --------------- C1 sum | avg ----- sum | avg ----- sum | avg 55 | 110 --------- 75 | 130 ------ 90 | 90 I t...
Hi! I have Access DB with One StudentTable. I have created multiple queries from that table then Exported to SharePoint Different Sites. Student table is exported to Site Collection. I added multiple records to Student Table that is uploded in site collection. Now My problem is - those new records don't get reflected to other list (cre...
Hello folks - My question is twofold. I have around twenty assorted tables in a database. The table layouts are diverse; the one common thread is that all of them have a 'County' field. I need to set up a series of reports which allow a user to select a county from a drop-down box, triggering the report to run and return only rec...
I have a database that the client needs to update. They like to you access. Some tables randomly become read-only for them. Any ideas why? They are using Access 2007 and MS SQL 2005. SQL Table: CREATE TABLE [dbo].[Users]( [SyncGroup] [varchar](20) NULL, [UserID] [varchar](20) NOT NULL, [Password] [varchar](20) NOT NULL, ...
Is it possible, in Microsoft Access 2007, to allow a user to select and update data only when they are editing via a form? I have a form which contains a datasheet of a foreign table (which in turn has another subtable). I want the users to only edit their own content via the datasheet in the form. Running a SQL backend, so stored proc...
I have an SSIS package I am developing. I am attempting to write data from SQL Server 2005 to MS Access 2007. I am pretty stumped on how to convert a SQL char(1) field to an Access Yes/No field. From the information I have gathered, the SQL equivalent of an Access Yes/No field would be a bit field, with values of either 0 or 1. My SQL...
I've recently been upgraded to Office 2007. I have several Access databases (that I've kept in the Access 2000 format for several reasons) that are linked to SQL Server 2000 databases. I have dozens of queries in these databases that I use often. I create new queries daily, sorting, summarizing and generally analyzing the data. Since...
Keep getting this error after inserting a subdatasheet into a query and trying to show it by clicking on the + Column (Cost) was used in a CALC expression but is not defined in the rowset. What is confusing, is that there isn't even a column named 'Cost' anywhere in the database. Although there is a column that starts with 'Cost' and ...
Following the instruction found here: Insert a datasheet into a form I get an error when trying to insert a query as a datasheet in an Access Project (SQL Server 2005 backend) The form name you entered doesn't follow Microsoft Office Access object-naming rules I selected the view View.dbo.viewname from the dropdown in 'Source Objec...
When creating a new database in Access 2007, should ADO (ActiveX Data Objects) or DAO (Data Access Objects) be used? Edit: Part of this database will be importing data from Excel 2007 spreadsheets. ...
I have a table titled MIUInfo. In it there are three columns; MIUID, Latitude, and Longitude. In it I'm running the following query which gets the number of MIUIDs in the criteria range. SELECT Count(MIUInfo.MIUID) From MIUInfo WHERE ((MIUInfo.Latitude Between " & minLat & " And " & maxLat & ") AND (MIUInfo.Longitude...
I have a access database setup which i am connecting to via ODBC, the access files already has all the required queries built and i would simple like to call them from within my application. I am using Visual Basic .NET and this is what i have tried so far..... Thanks in advance for any help you can offer. Ben Dim command As ...
In an Access Project (ADP), with a SQL backend, what are the minimum permissions required for Access to be able to update records returned from a view bound to a form, yet prevent a direct SELECT on the underlying table? For instance: Table: Table1 Columns: ID, Column1, Column2, Column3, Column4 View: View1 SELECT ID, Column1, Column2...
Hi, so basically I have an AddCompany Form, where theres a textbox [CompanyName], i want to type a new company name in there, but meanwhile check if theres an already existing one. So for example,say i want to type Microsoft, when i type M, the textbox shows whole bunch of other names with M, and then keeps going until I type finish ty...
Hi, I am using Access 2007 and need help creating a query. If this is crazy long, sorry! I figure the more details the better understanding. I am not a programmer--I hope someone will help. I need to know how to collapse/summarize/roll up non-numeric data into a single row that shares a characteristic/value. What I want is like a crosst...
The code below is what I am trying to use in order to get the count of one column and the averages of two other columns from multiple tables and then put the results into another table. I thought this would work, but the count that is being put into the new table is incorrect as are the averages. A lot of times the averages are outside t...