Hi - I've been trying with limited success to export a crosstab query result set to Excel using Access 2003. Occasionally, the export works correctly, and Excel shows with no errors. Other times, using the exact same query parameters, I get a 3190 error - too many fields. I am using the TransferSpreadsheet option in a macro that is call...
I have a contact database where I can send an email to a single contact or to a group of contacts based on a query - however I would like to add a checkbox function so if I decide I want to send an email only to a handful of people in one of my query lists, I can check their name and it will send. The issue I'm having is I don't underst...
Is there any way to change the autonumber field to a number datatype, when the field is used a primary key and linked to other tables? ...
Hi, I am writing the results of certain checks on access table to a excel file. Sometimes the results exceed 65k that is more than excel can handle( excel 2002). How do i check the end of the file and open a new sheet for the continuation Thanks ...
In Access, I have a table like this one: Date | EmployeeNum | Award 11-JAN-08 | 34 | GoldStar 13-JAN-08 | 875 | BronzeTrophy 13-JAN-08 | 34 | BronzeTrophy 18-JAN-08 | 875 | BronzeTrophy And I want to have a table count them like this: EmployeeNum | GoldStar | BronzeTrophy 34 | 1 ...
Hi all, I want to use the standard ADO connection string dialog box in MS Access. How can I do that? ...
I'm using this database where the date colomn is a numeric value instead of a Date value. Yes, I know I can change that with a mouseclick, but all the applications using that database were made by one of my predecessors (and everyone after him just ignored it and built on). So if I'd change it to Date a lot af applications would fail. ...
How can I do for inserting a Default Value into a column of a table in Access? I use this instruction: ALTER TABLE Tabella ADD Campo Double DEFAULT 0 ALTER TABLE Tabella ADD Campo Double DEFAULT (0) ALTER TABLE Tabella ADD Campo DEFAULT 0 ALTER TABLE Tabella ADD Campo DEFAULT (0) ALTER TABLE Tabella ADD Campo SET DEFAULT 0 ALTER TABLE T...
I have an access querie which creates some output 3 coulmns lets say named "A", "B", and "C". I would like to, create a function where I can automatically output this query to a text file without the header rows. I am currently outputting the file to excel then opening the file and deleting the first row. the user then has to convert ...
I have a couple of mdb files with the exact table structure. I have to change the primary key of the main table from autonumber to number in all of them, which means I have to: Drop the all the relationships the main table has Change the main table Create the relationships again,... for all the tables. Is there any way to export the...
HI, I have a large table from which i can query to get the following table type no of times type occurs 101 450 102 562 103 245 also i can get another table code no of times code occurs 0 1222 1 750 2 355 but now i want to write a query which ...
While I'm developing my MS Access application, I open it with shift click. When an Error occurs, that is not trapped (by ON ERROR ...), a message box pops up informing me about the error. This is a good thing. When a user open my application, he does't shift click, and an appropriate Start Form opens. However, now untrapped Errors don't...
In MS Excel there is a tool for an iterative calculation of one cell given a condition in an other connected cell (target search is my obvisoly very poor translation from Swedish). I now want to do this whatever-it-is-called in MS Access. Any hint or at least a correct English term would be of great help. ...
I have an access database that ouptuts a query to an excel file. The query uses a date parameter to run. This parameter is chosen by the user. I would like to use the parameter in the filename of the export. How can I accomplish that with the minimum amount of code. 01 01 09 Ok the new year has begun. sorry for the delay but I was...
This is more an observation than a real question: MS-Access (and VBA in general) is desperately missing a tool where error handling code can be generated automatically, and where the line number can be displayed when an error occurs. Did you find a solution? What is it? I just realized how many hundreds of hours I spared since I found th...
Hi I have a problem I have got stuck on. I want to export my Access table to an Excel file, currently, I am doing that using DoCmd.TransferSpreadsheet but I want some kind of formatting to be done on the exported data. Can I format that data I am sending to Excel or do I have to write a macro in Excel that will format that data after ...
I am developing a Tool in vb.net and need find out Activex Controls from MS Access DB forms. I am able to conut number of controls in form, but unable to get the Activex Controls only from the form. Can any one have any idea how to achieve this, please suggest. Thnaks, ...
Hi, I have a Powerpoint slide that contains textboxes. I would like to link those textboxes with a filtered view of a data table in Access. For ex, if I had a TaskList application in Access that displayed tasks with different priorities and affectations; is there a way to open that file, select that view, and filter it according to a v...
Access Datasheet view appears to be blank(charaters appear in white hence not visible) in WSS3.0 ...
How can the styling be changed on the sharepoint page so that my data in access datasheet view is visible ...