ms-access

DDL to rename column in MSAccess

What is the DDL to rename a column in MS Access. Something along the lines of "alter table rename col1 to col2" which does not work for MSAccess 2000 format databases. I'm using OLEDB or ADO.NET with a MSAccess 2000 format db but would be grateful of any hint at the syntax or a suggestion as to how to achieve this using ADO.NET in some...

Microsoft office can't find the object "A_Z Schaltfläche"

Hi I migrated a database from access 2003 to access 2007. It seems to work but when I clicked the buttons from A-Z I'm getting this error message: "Microsoft office can't find the object 'A_Z Schaltfläche' If 'A_Z Schaltfläche is a new macro or macro group, make sure you have saved it and that you have typed it's name correctly" I di...

MS Access 2003 - Form question about a control source of a text box

How can I write the control source into VBA instead of in the properties window For example if I have a textbox that divides two amounts in other text boxes, then i put =[textboxA]/[textboxB] in the control source of the properties window. how do i accomplish this in vb so that I can trigger it by events?? i know it is not the same b...

ms access 2003 - Text boxes on a form: not jumping to any text box

Ok so I add all these text boxes on an unbound form, and everytime you open a form, it sort of jumps to the first text box so you can enter some information into it. How do I get rid of that, because I do not want it to auto jump to the first text box when the form opens...i do not want it to jump to any text box when the form open at a...

With VBA, find the version of the the MySQL ODBC driver installed in Windows

Using Visual Basic for Applications, how can I find out which version of the MySQL ODBC driver is installed in Windows on a user's machine? I have a Microsoft Access application that uses the MySQL ODBC driver to make a connection. The connection string looks like this: ODBC;DATABASE=mydatabase;DRIVER={MySQL ODBC 3.51 Driver}; OPT...

Getting records from between Date X and Date Y from my Access database?

I have a table called Recharge in a Access Database. Some of the fields are RechargeDate, Account, Number, etc. I wanted to retrieve all records between two dates so I wrote the following query: string Query = "select * from Recharge where Account='" + comboBox1.Text + "' and RechargeDate between '"+dateTimePicker1.Value.Date.ToShort...

Help me choose a data entry system for multiple users at multiple sites

I've just started working on a project that will involve multiple people entering data from multiple geographic locations. I've been asked to prepare forms in Access 2003 to facilitate this data entry. Right now, copies of the DB (with my tables and forms) will be distributed to each of the sites, returned to me, and then I get to hamm...

how to make query in Oracle - like Access

hi In access I can make a query (1) that returns something and make another query (2) that uses the first query (1). How I can do it in Oracle 11g ? thanks in advance ...

How do I get the username or PID in Access while using User level security?

Is it possible to get the username or personal ID of a user using user level security with Microsoft Access through VBA? If so, how do I do this? Just to clarify, I'm not looking to get the windows username. ...

MS Access 2007 - Identify users and based on that limit access to data

Considering the set up: Ms Access Application split into Front End and Back End = both native MS Access Front End consists of forms only - it will be the only way to access data Front End copy distributed to each user machine (thanks for answers to this question) I need to implement the following scenario: Ms Access application wit...

MS Access 2003 - Auto assigning an Identification Number

So I have a little db that is used for new hires in terms of who, where and what they are issued. One thing that is issued is laptops with little barcode/ID numbers, and I would like the db to auto assign an available ID number when the user is saved to the db. So I have a form that users use to input the information, and it is unbound,...

Display OLE Object(pdf) in axAcroPdf

Is there any way to get a pdf from an access database and display it directly into an axAcroPdf control without having to save the document on the disk? If this isn't possible with Access, can you recommend some other db to use? My "mentor" suggested I'd use firebird but until this problem occurred, access did everything I needed it to ...

How do I create a custom property with VBA in Access

Hello I am looking for a way to create a custom property in access with VBA. Here's how far I am and where I am stuck: A custom property's value (whose name is foo) can be read like so: Dim cnt As Container Dim doc As Document Set cnt = DBEngine(0)(0).Containers!Databases Set doc = cnt.Documents!userDefined doc.Properties.Refresh D...

Subquery question in MS Access

I'm not quite sure why the following query won't run in Access. It asks me to give the value of s1.sku SELECT s1.SkuApexId, s1.sku, s1.apex, s1.btw, s1.gebruikernr, q2.* FROM tblSkuApex AS s1, (SELECT MAX(s2.begindatum) FROM tblskuapex s2 WHERE s1.sku = s2.sku) q2 ...

Where can I find MSAccess Control in Database

I am updating a MSAccess Database for 2010. When it runs a report it is displaying 2009 rather than 2010. When in Design View I can see that a Control =GetThisYearLong() is being called. But where the heck is this function or whatever? is it code a query a bultin ?? where should I look? Thanks ...

MS-Access Get price of product at certain order date

I have a table filled with purchase prices, like this: sku price btw startdate PCR-CA5425023181515 21,17 € 1 01/01/2009 PCR-CA5425023181515 999,00 € 1 06/06/2009 PCR-CA5425023181515 444,00 € 4 09/07/2009 PCR-CA5425023181515 100,00 € 4 10/08/2009 I have another table filled with orders, ...

MS-Access 2007 - 255 character limit for exports and field concatenation

When I create a new Access 2007 database, the memo fields only export the first 255 characters (to any file format - i.e. Excel, CSV, etc). When I concatenate fields (grouping and converting multiple rows to 1 with data summarized), it only concatenates the first 255 characters. I am using a query and a Module to concatenate. Example...

Using PivotTable's in Access 2007 with large databases (~200 MB)

Hi guys, I'm trying to use Access to help me summarize scientific data - temperature and humidity over the past 30 years or so. The databases are quite large - approximately 200 megabytes each. The ideal for me would be to use a pivot table to perform the summaries for me, but I'm encountering the problem that every time I try to modi...

How do I switch between Access Form and Datasheet views, and remain on the same record, without filtering ?

In MS Access 2007, I want to switch between datasheet and form views, without filtering, and remain on the current record. Should I use a bookmark ? How ? or How might I place a button on the ribbon to switch views, without having to search for the record or use a filter. I need this to run Access 2007 Runtime, since it will be impleme...

show all tables in MS query editor "Excel"

via Excel 2003 vba I made dsn connection by this method Sub CreateDataSourceFile() Set fso = CreateObject("Scripting.FileSystemObject") Set txtfile = fso.CreateTextFile("C:\program files\Common Files\ODBC\Data Sources\" & Me.cnnName & ".dsn", True) txtfile.WriteLine ("[ODBC]") txtfile.WriteLine ("DBQ=" & Me.DBFolderName)...