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...
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...
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...
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...
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...
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? ...
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 ...
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? ...
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. ...
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...
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...
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...... ...
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 ...
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...
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 ...
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? ...
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...
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 ...
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...
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...