I really need help with a formula to calculate the loan amount based on the mortgage payment, interest rate and term. How would you calculate this in Access...

Hi, I am having trouble with a combo box om parent form intended to lookup records based on the name of a client. Whenever I create ti works just fine. I type...

Hi, I have a table that has two fields: a number field and a text field. I also have a simple for that has a text box where I enter a number and a combo box...

I could use some help with ms access. I'm really not very proficient with access and don't understand too much. I have never had any classes and what I've...

How can I add the ability to insert images? I have a form that asks for 'name' 'address', etc. and I want to be able to add an image to that record...how do I...

I would like to do the following on a form: When the user leaves the current record (goes to next/previous, closes form etc) he should get the question: "Data...

Aside from lining things up neatly I have *No* ability to make an access form look nice. Usually this does not matter because they work and cost a lot less...

I've created a subform for my standard buttons such as Save, Cancel/Undo, Search, etc. However the Cancel/Undo button doesn't work properly because the Main...

I have a listbox with 3 columns and I have added an control that will store the sum of the numbers in column 3 of the listbox. I tried something like this in...

I haven't (successfully) used global variables yet, so I have a couple of questions. The general context here is a multi-user environment with user profiles...

I have a list box that displays 3 columns of information based on a combo box which runs a SQL statement. For example, the statement is something like SELECT...

i have access 2000 and tablet xp. when i click on a file.mdb, it merely creates the file.ldb and doesn't load either access or open the file. i've tried to...

I have a button on an Access form that sends a Client's details to a registration page on the internet using the 'Application.FollowHyperlink' method. It...

Why am I getting "Show Parent Information for each record in SQL Statement using Parent ID" after setting Master Field to "ParentID" and Child Field to...

hi, i've got a query something like SELECT MaterialsAssigned.material FROM MaterialsAssigned WHERE MaterialsAssigned.jobDesc=...

Hi, Would be cool to change a TEXT BOX to a COMBO BOX using the .gotfocus property on my forms. Is this possible and ,if so, what would the code looking...

Hi, I have a tabular form giving some results to a query. All good. Is there a way I can have access no display the blank new record at the end?

I have a form that works perfectly for adding new records to two different, related tables called "Projects" and "summarytasks". However, when I use that form...

Is there a way to set the underlying date to be now() with out seting a date in the field it keeps a date of two months of 5 days ago i would like for it to be...

I have a text box on my form that is linked to a data field in my datasource. I would like to specify an input mask that would allow either single or...