Microsoft Access

Application.FileSearch no longer exists (in 2007)

My company is migrating to Office 2007 - I have VBA code that works wonderfully in "older" versions of Access, but will not work in 2007. One in particular is "Application.FileSearch" - what can I use instead? (And why was it removed??)

Access Form Question

Hi, I've studied Access for a couple years and can't seem to wrap my brain around the following: if a form and subform that has fields from multiple joined tables, how do you link the form with the subform so that the subform references the right record? I know the primary key of the parent table...

Format a field

I need to format a text box to begin with a zero with no decimals (i.e. 0310) If I type in 0310, it appears as 310.

Pop-up reminders in Microsoft Access

How to create popup reminder in Microsoft Access?i do not know to create with macro.can give me the answer step by step?

ActiveX control for Webcam

I'm creating an application with a webcam to get a snapshot data image, i want to use MS Access for database and use Crystal Report 10 for the print out. My friend told me if i want to use the cam then i hav to use the activeX control, can u help me, please..

Subject: Limiting information in combobox

I have two comboboxes, one shows a list of customers, the other shows a list of contracts. One customer can have mutliple contracts, but a contract can only have one customer. I want to limit the contracts in the second combobox to only the contracts of the customer in the first combobox. I have...

Windows Sharepoint Servs 3.0 - Linking existing Access 2007 Database with new list.

Is there any way I can link a pre-existing table/query in an Access 2007 database with a new Sharepoint list? At the moment, the only way I can find to do this is to copy the information from Access to Sharepoint, then import the copied data back to Access and link these two. I need to be able to...

Need Help With Multiple Conditions and Constraints for Access 2007 VBA Event

Hi, I’m working with VBA for On Click Event procedures in Access 2007. My knowledge of Visual Basic is rudimentary and I've come against a business rule I can't even begin to figure out how to code. I work at a college and was asked to build a database for a student conference we're hosting....

Date a specific record in Microsoft Access

I have a database where I would like to specifically date a record when a value/change is made in one of the fields of the record. Specifically, my database has addresses for donation solicitation, and I wish to date a donation made by a receipient at a particular address. So, basically, if I...

Allow Additions Property on Subform In Form View in Access 2000

I have a main form and a subform in access 2000. I have set both the properties to NOT Allow Edits, Or Deletions, but Yes to allow additions. However, when I open the form in form view the property for allow additions changes back to no. I am able to go back and change the property in form view...

Combining fields to create a unique ID in Microsoft Access

I have been working on a database for my research job.For our research purposes we are trying to create a unique identifier that tells us 4 things: 1) what study they are a part of, [this will be “QQQ” for EVERYONE] 2) what group they are in, [this will be a four digit number, such as...

MS Access Tools References...

Cheers, Does anyone know where I can get a list of what a specific reference in Access can do. Specifically, I have VB.NET code that Imports System.Web.mail that I would like to use in my vba code. I have had luck with similar .NET code: I used the reference Microsoft Excel 12.0 Object Library...

Database connectivity between Microsoft Access and C++

how can i give database connectivity in code of c++, and my database is stored in ms-access?

Formatting a subform for printing in access 2000

I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the subform. I Don't want the...

New Access user!

I am a new Access user with no training. What I know, I have figured out on my own. The issue I am having now is why does Access always save a copy whenever anyone exits the database? It will save a copy and number it every time. Most days there's about 12 -15 copies. ( Example: mdb12 ) Is...

Access 2003 using IIf statement on a form

I am building a database to help my daughter with keeping a record of pupil progress. I have a form in which I have a field for 'current grade' and a field for 'target grade'. I also have a field 'progress' in which I am using an 'IIf statement' to compare the two fields (to show either 'under...

MS Access 2007 Author credit

I'm designing a database for my town office as part of my class project. I want to put my name on the project somewhere as author so I get some credit for my work. Where/how can I do this?

access 03 sending emails

I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can't get it to work. Please help

Viewing the guts of a Microsoft Access form, query and report, programmatically

I have over 1000 MDB's which need to be checked to make sure they don't reference any external sources. So, I'm searching for 'A:', 'B:'... 'Z:', '\', etc. I need to search the guts of each form, query definitions, and reports to find any references to something external. The data is done. Is...

Microsoft Access Drop Down List

Hi, I have combo boxes in Microsoft Access where if the user starts typing the drop down list expands. Now if they use the keyboard to select the item, Access moves to the next control and the list is brought back up, but if they use the mouse then the list stays down. I was wondering if there...