I need to create an IIf function. I have a field called "BREED". There are only two types that can go in this field, either "Siamese" or "OSH". In the next...

I know I posted this question time a go, but I have to keep trying I am connecting MS Access to a Pervasive SQL Server with a very old table structure...

Hi I was wondering if it was possible to set the font default value lable, textbox or what ever. Right now the default value is set at MS Sans Serif 8. How...

Hi, is it possible to do self reducing lists in Access ? I have an Excel sheet that can accomplish this, but it is getting very cumbersome and with lots...

I have an Access database which has a number of tables, queries, forms, macros etc. If I want to make some changes to a particular query, macro or subform, is...

When attempting to change data types, or even field sizes in my base table, I get the message "too many fields defined" and it does not allow the changes to be...

From a menu I am running macros that do data updates, deletes etc. How do I stop the dialog boxes that come up?

Is there a way that i can have access run a math formula: 2 formulas, one to convert one type of weight to another (metric tons to short tons). so i would...

Hai Guys, I created a form which contain a subform. I'm trying to write a code to display the value in the textbox from the subform. msgbox...

Hey Reggie Thanks a million. You helped me with all my posts. And that's within an hour. Thank you again man. Salute. Ram.

Hi there, I'm trying to write some code that will loop through the value of a field in table and display the value in a msgbox, however Access 2002 does'nt...

Hi Guys, Please I need help to debug the following code, intending to check in the main form whether there is double entry of data, but when I try to run it,...

Whenever I try to Import a Sybase table into access 2000 my machine freezes. I can likn but not download.

Colors in slides and photo slides created in the powerpoint presentation are different when showing on the TV which is output by modulator? Any suggestions as...

Hai guys, I'm writing a SQL code in MS Access to store the value selected in the form from a combo box. The value I want is in the 2nd column of the combo...

The subject just about says it. If I should delete records, in this case about 85% of them, from a table of course the now current "first" record has an...

Hi Again All I created a form, and on that form when it come time to select a state or province. I want to use a pull down menu to select the state or even...

Is there a way for me to create a custom error messege that way if i set it that lets say has to be numbers in the field, so instead of the default error it...

Hi, I wish to create Yes/No field and would be obliged if you could advise correction to the following code. Set fld = tbl.CreateField("tblTempActive",...

I am trying to enable 3 text boxes when a check box is ticked. I can get one text box to enable and disable when the tick box is clicked. I have tried the...