Search results

One in a long list of the endless things I hate about Microsoft's 2007/2010 "upgrades" is the obnoxious little detail of it finishing words for me as I type, particularly in the 'criteria' section of queries. I don't want or need the suggestions and end up having to hit the backspace delete key...

Somehow a form has suddenly stopped working. I get the following error: Run-time error '-2147352567 (80020009)': You tried to assign the Null value to a variable that is not a Variant data type. Not a clue what I could have done / changed to cause this to happen but the debugger highlights...

I'm using Access 2003. I want the users to open the database and only be able to use the data entry forms and view/print reports. The main problem I have is that I don't know what order to do things and Access help isn't very helpful. I know I have to split the database, run the security...

I've been reading & printing endless threads on 3 different forum websites for days now and my head is going to explode. I need moron-proof step by step instructions because clearly my brain capacity is on the same pathetic level as Kelly Bundy. All I want to do is take a new database that...

I would like for a field to become disabled and left blank based on a combo box selection. I wrote in a code that I thought would work - but it doesn't. Any ideas where I went wrong? Private Sub Company_BeforeUpdate(Cancel As Integer) If Category = "MG" Then Company.Enabled = True Else...

I have a transactions table with a simple "units" field that I want to use to determine inventory. When items are received the # entered in "units" is positive; however, I'd like to create another form for those same items once they ship and set the "units" field to a negative number so when I...

Need help, please, with writing an expression. Goal is to have the text field on report highlighted when the value of that text field reaches 90% of another field on same report. My Access "Reference" book is as helpful as a hernia. I've tried typing in >([Qty Projected]*[.9]) a variety of...

Having a little trouble creating tables/queries/etc that will accurately track our inventory. I don't seem to have a problem with creating tables/forms, etc that are used for receiving inventory - but the sales part is causing me grief. We don't actually sell these inventory parts...

I've got an option group and would like to create a macro whereby when a choice is made in that option group, only certain disabled text boxes on the form become enabled for entry. Any ideas?

I have a brand new database in-the-works that is causing me headaches. For some reason, if I create a query and then exit and re-enter the database, I cannot re-open that query. I get an Error 3112 (cannot be read; no read permission on <name>) and to contact the administrator or creater of...

I want to move from the last control of my subform back to a control on the main form WITHOUT opening up a new record on the main form. Right now I have coded: Me.Parent.Form![Subtotal].SetFocus DoCmd.GoToRecord This almost works - it takes me to the correct control on the main form but on a...