If there is no criteria for Bid, then it causes an error #Div/0! Bid's Default is 0 How can I get rid of this? =NZ(/,0)

I read an earlier post regarding conditional formatting of rows of a form in continuous mode. The post contained a link to Leban's site which had an example...

Hi, I have a form which calculates a final cost (frmWorkCosts, data stored in tblWorkCosts) and once calculated adds this final cost (Which isn't saved in...

Hi, I'm using Microsoft Access 2003 as front end to a SQL Server database. The SQL Server database has uniqueidentifiers... Displaying the uniqueidentifiers is...

I just switched from using Access XP back to using Access 2000 (not at my preference). With 2000, it doesn't appear to allow you to automatically select a...

Need to print prior years' calendars for tax purposes. Can't find the data.

Is there anyone there? I have posted this last friday and I still don't have an answer. Here is my request. I have a form with a drop down menu of 4 items. ...

In a form with black font, enabled has been set to no and the font color changes to grey. How do I get it to stay Black?

A program that has been running just fine has now decided to give me a message "Function is not available in expressions in query...

I have an unbound form containing a Listbox (lstTip) and a Textbox (txtTip). The ControlSource for txtTip is the second column of lstTip ( =.(2)) . The source...

Hi. I'm a bit stumped. I have a simple form associated with a table. When adding a record (via the record selector button) I cannot setfocus of the fields...

I have a main form and a subform,the subform is linked to the main form. On a different form, there is a combo box (data from the subform) that the user can...

i was looking for how to send an email from a field called e-mail address inside of a database I want to be able to click on one thing in my database on the...

Hello, Is there anyway i can get a spreadsheet to run in access. I can insert the object but when you put it in form view it doesn't do anything. I am...

Hi there, If you have a database like client database. you have the client table, the product table, the phone received table, the bank account table. you...

Can I replace this with my own error message? MsgBox Err.Description

I have a form which has a source query that links several tables. It shows all the controls in design view, but the form view is blank. Does anyone have any...

Have cretaed a database to register telephone enquiries but have run into a dealend trying to enhance it. I NEED HELP! To try and put it simply. I have 4...

Can anyone advise me how to make query, macro or code to be scheduled daily in Access 97? Or with any additional module? Thanks.

I am trying Allen's code from his web site to audit changes and I have a few problems. Dim db As DAO.Database didn't compile, so I searched and found that I...