I have a form (personnel view) that is based on a query that pulls information from several tables together. I want to be able to update certain fields so I...

What is the best way to add a new table to my existing database? I want to add several fields, and thought it would be easiest if I could just create a new...

I have a datasheet form when it opens I'd like it to setfocus at the "Enter NEW Area HERE"(defaultvalue of txtAreaName) new record instead of the first record...

Using Access 2000 and am trying to format a Date/Time format to just a date.. In other words id like 3/5/2008 2:43:13 PM to look like 3/5/2008 Is there...

In ACCESS office 2003, i could change the import specs lusing the advanced button. i can't figure out how to edit an existing speps in ACCESS 2007 without...

I have a report I'd like to generate that will tell me the time between each transaction in the database for a user, and the average time between...

Hi, I am using MS Access 2000 and Windows XP. I have a desktop shortcut to an access database on another computer on my network. Recently, this shortcut has...

I'm trying to run a check on two fields so I can ascertain if the third field should be updated or if a new line should be added. I'm using the index and...

Is there a way to change the default setting on the Find and Replace box?

what is the query to list records with a certain field empty?

I am trying to achieve the following : 1. No Access Ribbon 2. Uncustomisable Quick Access Tool Bar containing an UNDO button I can achieve 1. Buy putting this...

Can anybody tell me what's wrong with this: Dim MVIN As String MVIN = MID(Forms!Accident.Vehicles.Form.VIN, 10, 1) Me.Year = DLookup("str()", "YearCode",...

I am trying to create a default report template - once I have created the template, I change the default from "Normal" to the name of my report template in...

today i will very happy....

Hi Everyone! In Excel I can format time like so: :mm:ss which will allow me to see time as 37:33:28 - how do I do this in Access?? Because this doesn't work...

Hello Forum Members: I am using Access 2000 and the sub form on the main form is displayed as datasheet view. When the filtered results are opened, the...

èÝëù íá ìðïñþ íá ìðþ óå ðåñéóóüôåñá chut áëëá äåí îÝñù ðþò

For some reason I cannot import a union query in from access. Does know a reason why this doesn't work?

I know just enough to be dangerous but most times get frustrated and translating what is in my head to Access and actually have it work. I'm stuck so...

hi wanted to now if it is possible to make a value in one form equal to the value in another form. for instance i have a form called properties and another...