Search results

How can I delete a record from a form? I set Allow Datasheet view to yes, Allow Form No, and Allow deletions Yes. Nothing happens. Perhaps A delete button could be added, but I don't know the code? I do not want to use the Datasheet view as the means of deletion.

I found the switch to turn off the database in the start up window. I turned it off and it did not work; that's why this message. Tried it again and all is well. Guess something went wrong the first time. Thanks anyhow.

I run a Switchboard and everthing works well. However, the "Database Object Screen" remains in view. This is not a good thing, as unintended events may ensue by unwanted guests. How can I stop this screen from appearing and having only the Desired Switchboard displayed? It's probably an option...

I have a Combo Box that places the Address into the given Address field. How can I have it place the second and third cloumns, from the Combo Box into the next two adjacent fields on the Form (Last Name & First Name)? Please describe in detail, not just code, but where a how it goes. I am new at...

I have an Input form that does not clear the fields after I hit the Save button. Data Entry is set to YES. If I use the navigation bar, there is no problem, but I would like to have the fields empty after hitting the Save Button, so that the navigation bar can be removed. What is wrong?

Just started with numerical data and I cannot believe this! Below is a simple table. All I want to do is SUM QTY in the QTY column using the Query structure. Rec_No PN Qty State 1 234562 23 NY 2 234562 450 NY 3 234568 288 FL 4 234569 45 FL 5 234344 3 NJ This is...

I moved the Address field from third postion to first position, so that clicking on a list box places the address from the List Box into the Address field. I adjusted the bound and source boxes and it works perfectly. The cursor now points to the Last Name field (second position, which it did...

The report prints correctly, but every other page is blank. Therefore, a 3 page report gives you 3 blank pages plus the report. How Can I stop this without redoing the Report, or how can I prevent this from happening in the first place?

I did what you suggested and removed the Quotes and it worked fine. Thank you and all the others on this helpful Forum! I need to learn to fish-not just copy. The Access manuals, with VBA, are not good. At least, I have not found one yet. Microsoft help, on the web, is scattered all over the...

Placed the code you gave into the following, but no result. Question of position? Private Sub Save_Click() Dim Add As String Dim Length As Integer Add = Val([Address]) Length = Len(Add) Me.Address = IIf(Length = 3, "0" & "[Address]", "[Address]") On Error GoTo Err_Save_Click...

I have to learn the correct syntax for this, as I think it should work to place a zero in front of the address number. Please advise Private Sub Address_Click() Dim Add As String Dim Length As String Add = Val([Address]) Length = Len(Add) IIF(Length =3,"0"+"[Address]","[Address]") End If Is...

I have a list box, on a form, in which the horizontal scroll bar works perfectly. However, the right scroll bar is stuck. I can scroll with the mouse wheel, but not the scroll bar. How can this be fixed?

How do you hide the canned record scrolling keys on the bottom of a Form? I have placed my own controls and do not need them to confuse the Operator, or cause problems.

Moving to next field Could not find any focus in properties that makes sense. How do you do it? Under keyboard options I have "Next Field" checked for both arrows and "move after enter." Behavior entering field is checked to "Go to start of Field." This has no affect at all. When I hit enter...

How do you get the cursor to jump to the next field in a Form?

What I would like to know is, how to make an Option Group that allows for multiple choices instead of one. MS explains in detail for a single choice only, or you can use their Option Group Wizard (again single choice)?

Report Problem Here is the Paradigm: 1.Created Input Form and saved it 2. Set Query to reference Input form:Between [Forms]![Input Form]![Start Date:] And [Forms]![Input Form]![End Date:] Note:EndDate and Startdate are from Input Form button controls. 3. added two controls to Input form: Open...

This is no big deal, just a matter of syntax and execution. This is what I did: 1.Created Input Form with two unbounded fields 2. Named Text4 Box to Enter Start Date: 3. Named Text6 Box to Enter End Date: 4. Created two Command Buttons ( I'll only describe one) as follows: First Button Name...

Everything works, except I cannot get the Start date and End Date to show up on the Report. I created a Form called:Input Form It contains two text boxes- Enter Start Date: and Enter End Date: for Labels and two unbounded Text boxes. I placed the following into the Initial Date Field in the...