Recent content by Robert Saye

Hi all, I have an unbound option button in a subform, which is in continuous form view. It defaults to no. When the form is active, it shows up gray and checked. Is there any way to make it usable? Thanks, Robert

Hi pablotx, Try this : Private Sub Current_LON_AfterUpdate() Dim avglon As Long Select Case [Current LON] Case 1 avglon = 30062.45 Case 5 avglon = 33351.09 Case 8 avglon = 39770.3 Case 6 avglon = 50530.54 Case 9 avglon = 100790.65...

Query resonding correctly Access is performing correctly. I don't understand how you can have activity on a product before first having a description of that product. It sounds like you have a fundamental flaw in the database, you can't have sales activity on chryslers if you only sell dodges...

SQL statement looks good Hi Lory, I copied this into a test db, and changed the table and fields to my name, and the sql statement worked fine. When it breaks like that and it asks you to debug it just say yes, and hover your mouse over the txtbuilder and txtSubdivision variables, and make...

If you are getting an invalid use of null try this I would try to set a defaul value for avglon, you don't have a default for your select statement. So if [Current LON] doesn't fall into one of your cases, then avglon is never initialized. Then you would be trying to subtract that from...

Mile-O-Phile is a freaking genius Well, that was almost a perfect example of what I wanted. My only problem now is should I break up my database so it will fit your form? I have it in two seperate tables: tblQuestions tblAnswers QuestionID pk...

Hi all, I finally figured out how to write a module to get the data I need. Now I am clueless on how to get it into a form. I am attaching my database if someone could take a look at it. What I am trying to do is use the testing() method which returns 5 random questions from 3 different...

This is from VBA help (You get VBA help by opening help from a module window).: ControlSource Property Example The following example sets the ControlSource property for a text box named AddressPart to a field named City: Forms!Customers!AddressPart.ControlSource = "City" The next example sets...

Hello, If the textbox is bound to a table, why not just set the field required property in table design view to yes. This way if the user trys to leave the form without entering a date, Access will pop a MsgBox that says dateselect cannot contain an empty value. Robert

Try this, in the first column of your query select all records. The next column type for a field name: DateSubtract: Date() - ([Forms]![YourFormName]![YourControlName]) Uncheck the show box, then for critera put: < 30 (Or < 31 if you want those records too). Robert

Hello Charity, I really can't duplicate your form so I made do. You may try Me.Requery as the first line of the on click event for your command button. (That is if your Main form gets the focus when you open the form.) Just a thought... Robert

Allrighty here goes, This is the way I would do it. Create a new make table query, add all your fields * is okay, then in a new field put this expression. NewDate: ((Mid([YourNumericFieldNameHere],5,2)) & "/" & (Right([YourNumericFieldNameHere],2)) & "/" & (Left([YourNumericFieldNameHere],4)))...

Hi Amy, I'm not sure if this is what you want, but if you want your report to have the names like this: North NJ North PA South NC etc... Then build it in a query. Where it asks for field name type: WhateverYouWantToNameYourField: [Territory] &" "& [State] (You need the quotes to give you a...

I modified your code for one of my practice forms. The errors I got were caused by the following. Type mismatch error on the SET line, to fix hit tools, references, then check the Microsoft DAO 3.* and move it above Microsoft ADO 2.* (if checked). The second error I had was my control source...

Phillip I didn't make myself clear, so I remembered a free db download on MS that gives dozens of example forms. Here is the link. The form syncronizing combo boxes is what you want. http://download.microsoft.com/download/access2000/Sample/2000/W9X2KMe/EN-US/FrmSmp00.exe