ms-access

A good MS Access tutorial?

Hello, I need to create a relatively simple database with a few forms in MS Access. Could anyone recommend a decent tutorial on the subject? (developint 'apps' in MS Access) I googled, but I god a bunch of similar titles as a result, and I'd like to learn basics relatively quickly. Application will be used only to enable a medical te...

Save file to attachement field in MS Access 2007/2010 and C#

I want to save a file (pdf, bitmap, word doc etc) in an application that uses Microsoft Access 2010. The application is written using C#. The Access database field is an attachment data type. How do I save the file using C# and how do I read the file out of the database. The idea is that the user can drag and drop a file attachment and...

Most reliable solution to determine whether to use ACE or OLEDB in connection string?

I'm handed a path of an access 2000(/2003 (edit)), or access 2007 database: C:\database.mdb or C:\database.accdb I have to determine a suitable connection string, using either ACE or JET, to connect to the database. I was wondering whether parsing the last part of the string and determining whether it is mdb or accdb is guaranteed...

putting records in new table that don't have 6 or more different addresses for same name - Microsoft Access

Hey all, If the names repeated is more than 6 and there are six different addresses for that same name, then I don't want to output them to the KeepThese table: harry baker 1 street harry baker 2 street harry baker 3 street harry baker 4 street harry baker 5 street harry baker 6 street donald ross 11th street So harry baker should be...

table locked or in use when calling RunSQL

I have some code which re-arranges some items on a form, but only one SQL query. All my tables aren't locked before the code runs but for some reason I get an error when running: DoCmd.RunSQL ("Select * Into MasterTable From Year07 Where 'ClassName' = '7A'") Error: The database engine could not lock table because it is already i...

how to query a table?

Suppose we have one table in Microsoft Access: ID | Data I need to select one row with a SQL query in VBA code. In what variable to store that row? How to write that row back to the table in VBA? Could you please write simple code? ...

Manipulating Access VBIDE from VBScript

I'm trying to write a vbscript that will export and import the code modules from an Access MDB file to text files. From within the app I can loop through the DAO Container & Documents and use the 'undocumented' Application.SaveAsText method, but can I do it exeternally? Your thoughts and ideas are appreciated. Ben ...

How to export all tables from an Access Database into Excel - A sheet for each table...

I have an Access database with ~30 tables. How can I export all 30 tables into separate sheets in an Excel workbook? I'm hoping to find some VBA/VBS code which I can run from within Access to accomplish this task. Any ideas? ...

SQL round to the nearest hundredth.

UPDATE prodfeatures2 SET featureprice = featureprice * 0.6316; I am trying to setup a round of to the nearest hundredth. HELP! I do not want the answer to be 104.7648, I would want it to be 104.76. I do not want the answer to be 104.7668, I would want it to be 104.77. ...

How Do I Convert an Excel XLS to an Access MDB using Excel VBA

I need to use VBA from Excel to load an Excel workbook in access and transfer it out to a database. Dim acc As New Access.Application acc.OpenCurrentDatabase "C:\Test.xls" I got that far and Excel crashes and has to restart. My plan was to use the following but I can't get that far. acc.DoCmd.TransferDatabase Any ideas? I've googl...

Handling incorrect SQL Server Log-On Password from Access VBA

I'm using a Switchboard Database to run macros on multiple Access databases one after the other using the code below. Running the "Updata Data" macro in Data1.accdb requires logging on to a SQL Server. If a user enters an incorrect password the code freezes. Any suggestions for how to gracefully handle an incorrect log-on attempt? Se...

Error 3218 Could not update; currently locked -Msaccess

Hi, I got an error with my Msaccess DB. multiple users are using this DB's frontend. I do not know why I am getting this error message as follows Error 3218 Could not update; currently locked can someone help me please...... ...

Database design for recursive children

This design problem is turning out to be a bit more "interesting" than I'd expected.... For context, I'll be implementing whatever solution I derive in Access 2007 (not much choice--customer requirement. I might be able to talk them into a different back end, but the front end has to be Access (and therefore VBA & Access SQL)). The two ...

Looping through a all items in a field and updating another field using VBA in access.

I have two fields, one is just the number of the other one, e.g. Field 1 = "12AB" and Field 2 is "12". I'm trying to make Field 2 auto-update but I'm not sure how. I'm trying to get: ClassName ClassYear 12AB 12 13BU 13 15BE 15 But instead the whole fields update to the number in the last one: ClassName ClassYear 12AB...

Image doesn't show up in picture control

I have a report in MS Access with 4 image controls. In the format event of the detail section I have code that sets the picture property based on the values of fields in DAO.recordset. Below is an example of my code. For i = 0 To 3 If Not rs.EOF Then Me.Controls("img" & i).Picture = blobGet(rs!phBlobId) rs.MoveNext ...

How to store data from MATLAB to Access DB?

I want to store my results from neural network in MATLAB to Access database, and also store video with it to the same database. For other time when everyone result the same pic from neural network the output for him is video that was stored before in DB... Can you help me? ...

Using MS Access database as a file format for desktop application needing open / save type functionality

Hello! This is probably a pretty novice design question. I'm trying to work my way through a number of requirements and give the users the experience they're looking for... I've written a tool that does big calcluation-type things. It currently consists of a class library and command line tool (separate .NET projects.) We're using an...

using ace engine for updating excel workbook

Hi all when I use microsoft jet database engine for udpating excel work book it works correctly but when I usnng microsoft.ace.oledb 12.0 for working xlsx files I got this error : operation must use an updateable query ...

Conditional Count of Related Records

I'm sure there must be a simple way to do this, but I've been tearing my hair out for hours now and I'm getting nowhere. Here is a working query from a customer listing utility: SELECT c.customer_ID, title, surname, forenames, COUNT(booking_ID) AS bookings FROM customer c LEFT JOIN booking b ON c.customer_ID = b.customer_ID WHERE cust...

Can I fire-up an Access 2007 app from within Excel and automatically import excel values into Access?

I have a pawnshop app where when a customer arrives at the shop, the clerk uses an Excel worksheet to calculate how much money he can lend to the customer, based on the current market price of gold, gold karats and weight. If the customer agrees with the calculated amount, the clerk then goes into my Access 2007 pawnshop app and has to r...