This may sound silly, but how can force a currency field to be only 2 decimal places? I've set the decimal places to 2 in the properties box, but i still get...

I have been trying everything I can to get this to work and I'm still stumped. I have a table which has numeric primary keey value which is set by a...

On all of my forms the the combo boxes are blank. The values are their when you scroll down using the drop down box but they dont actual appear in plain sight.

I am trying to set forms for six users and one admin. Each user will log in and work on his form only. he won't be able to see or update other users forms. The...

Okay, I give up. I can't figure it out. I wrote in a previous post my dilemma of having a field that add all costs (see original post below). I was told...

Hi all. I would like to create a calendar in Access to use for tracking tasks for my team. I want to be able to enter text on certain days, the name of the...

I have a procedure that concatenates some WHERE style sql, sticks that into the .filter property for the form, then sets .filteron = true. The moment this...

Hi. I have a form where the record source(query) changes based on the icon the user selects. I have a printout button on this continuos form. When...

Dear All, I am reposting this as I have not got any response to my earlier posting. Can someone please help I have a form with a listbox lboemployee which...

Hi I would like to create a list of queries (not all ) to include this list in a drop-down menu. But I cannot find where I start creating the list. Could...

I want to ask the same criteria (to find items of a certain date) in 18 different fields. Is there an easy way, or do i just copy & paste? I want to run the...

I am trying to convert the entry in a text box (which is a std date 01/01/08) to Julian date. The format for the Julian date is: 108001. So, in the end I...

I have a form, that a couple people use. Can I take the below and lock two fields instead of 1? The two fields would not always have data in them at the same...

I have a Text Box whose record source is a field of a query. I want to update the query field upon 'change' What code do I need to put in the event procedure...

I have a combo box which has three possible values, e.g "Poor", "Fair" and "Good". I have conditionally formatted each so that when they choose Poor it's got...

I know I saw a post about this, but I can't find it. After entering data into the main form, and then attempting to enter data into the subform fields, the...

My apologies in advance as I'm an Access newbie. I've been doing light database work for a couple of decades -- mostly in Paradox for DOS -- and I'm now...

In Access 2002 I have a form ‘Employee’ and a sub form ‘Training’ that lists all the training courses that the employee has taken. There’s a...

I am looking for an alternative to Dlookup to autofill a form. Because this process is very slow and we are working across a WAN, I do not want to bog the...

I made a form from a table. I can edit the data in the table, but for some reason, I can't edit the entries in the form view. I checked all the settings, and...