Is it possible to use a subform's 'current' record set as the domain argument to DAvg() (etc.)? Basically, I have a subform that displays a subset of records from a query. I would like to run DAvg() over this subset. This is how I've gotten around it: =DAvg([FieldToAvg], [SubformQuery], "ChildField=Forms.MasterForm.MasterField And Fiel...
I am currently the only developer on a MS Access project, but we may soon be adding developers onto to the project. This will be my first time sharing the load on a single MS Access project and I'm a bit clueless as to what versioning system (ex. SubVersion) might work best. Any suggestions on programs I should be taking a look at or st...
I have a combo box on my form with the choice of choosing organization 10, 20, 30.... I have added ALL to the combo list box, but am having trouble implementing an all statement in VBA. Below is the case statement I have to get info from organizations 10, 20, 30. How do I get ALL to generate?? Case Is = 1 If cboOrg.ListIndex < 0 Th...
I need to connect to a password protected MS Access 2003 DB using the JDBC-ODBC bridge. I can't find out how to specify the password in the connect string, or even if that is the correct method of connecting. It would probably be relevant to mention that this is a Spring App which is accessing the database through a JdbcTemplate config...
I have table called emp. The table contains three columns empid, ename and salary. I have to store the empid as autogenerated ids, for example: E001, E002, E003. How can I do that using C#? ...
best solution for use access in project for database with security i need to use access with 600 megabyte in my project and my problem is low security for example i can rename access database extension to increase security and people don't use my database for other goals i will not to use sql server for every one to use my application ...
is it possible to restore deleted records in MDB? ...
Ok so this is a brand new snag I have run into. I am trying to launch a new MDE from my source MDB file, and it is locking up Access. So in my mdb, I am first compacting and repairing, and then selecting create a new mde (just as I have done many times before). It looks like it is starting the process, but never gets to where it comp...
This is the connection string that is currently working on a non-password protected MS Access database. this code snippet is from our properity file: db.url = jdbc:odbc:Driver\={Microsoft Access Driver (*.mdb)};Dbq\=C:\Inventory.mdb;DriverID\=22;READONLY\=true How do I add a password to this connection string for a MS Access DB pro...
I am trying to assign salespeople (rsSalespeople) to customers (rsCustomers) in a round-robin fashion in the following manner: Navigate to first Customer, assign the first SalesPerson to the Customer. Move to Next Customer. If rsSalesPersons is not at EOF, move to Next SalesPerson; if rsSalesPersons is at EOF, MoveFirst to loop back to...
I'm working on a simple Access 2003 application to keep track of things that need to be done for clients for some colleagues. Each colleague has a set of clients, and each client has a set of actions that need to be taken by a certain date. I've set up a form that consists of a combobox for client ID (indexed), a drop-down for the pers...
How do I query a MS Access database directly from SQL Management Studio, without using a linked server? Ie. something like SELECT * FROM ["C:\Data\Accessdb.mdb"].[SomeTableInAccessDB] Obviously this won't work but is there a away to specify the access database details within a sql query? ...
Hi, I copied an MSAccess 2007 db from a workstation onto another workstation. I added the DB folder to Trusted Locations. I check the file properties readonly flag, but it is unchecked. But the database is opened in ReadOnly mode. What am I missing here please??? Malcolm ...
Hi and thanks for reading. I am not a database/vba guy and my experience is strictly in the JAVA world. However, I need to have an ACCESS form open. While it is open and new data is entered into it (via the underlying query OR any other data changes in other tables based on sql updates attached to buttons on this form), is there a way...
Hi there, Is it possible to create a directory folder for individual records in Access 2007. For example tblUser ID firstName surName When adding a record, would create a folder C:\userdatabase\Surname,firstName,ID Could see this being useful in situations for example where a large amount of images/files would need to be associated ...
I am currently working on a MS Access 2003 mdb file which is converted to an mde file before being published. How do I go about enabling the reports function of MS Access once this is converted? or better still is there a alternative to the reporting in MS Access? opensouce or free? Thanks in advnace. MB ...
So if I was to take a an Access form, and embed either an Excel spreadsheet into it or a PowerPoint deck, how would I reference it in VBA code? I know I have to set the libraries, name the frame of the OLE object, and use applicable syntax to whatever I want to do, with whatever I stick in the form, however the only things I have ever d...
I would like to know the current idle time from user input on a given Windows XP machine programmatically. I am using VBA in MS Access. What options do I have? ...
It's been ages since I last used Access as a back end but I'm being forced to. I'm using Enterprise Library 4.1, the Data Access Application Block.. with .NET 3.5 and I wanted to know the best way (code sample if possible) to write an insert query that will automatically give me the newly inserted auto-number back..or if it's not possibl...
Status Time Handel Title --------- ------------ ------ ------------- CREATED 2009-10-16 03:37:38+01 902D8 Mozilla Firefox ACTIVATED 2009-10-16 03:37:38+01 902D8 -?- ACTIVATED 2009-10-16 03:37:41+01 902D8 -?- ACTIVATED 2009-10-16 03:37:41+01 E030E Windows Live Messenger DESTROYED 2009-10-16 03:37:4...