Search results

Once I click the close form button goes and sets focus on the first control on my form. I click again, it goes to the second control. it takes about 3-4 clicks before it closes???

Made a few changes to my form.. now I am back to this.. What is wrong with my close form button? Private Sub Close_Click() On Error GoTo Err_Close_Click If Me.Dirty Then Me.Dirty = False DoCmd.Close Exit_Close_Click: Exit Sub Err_Close_Click: MsgBox Err.Description Resume...

YOU ROCK!! I typed in Co and it went to the first item that starts with Co.. you are always so helpful..

When you have a combobox in your form and it is rather long. Is there a way to set it up to where if you type the first few letters it will go right to that area? Just to make the form flow faster?:confused:

I followed this process for my report created in Access: http://support.microsoft.com/kb/841779 However it still isn't resetting and it shows up now as Page 1 of then page 2 of it isn't calculating the pages nor is it resetting at the group level? What do I need to show you folks to see what...

Ghudson: Regarding your note below... Can you explain how it should state? sort of give me steps to where I fix this? I am a newbie to databases, forms and reports in Access but I have taught myself all three by getting help from folks here and it has been a blessing.. I just need to know where...

PARAMETERS StartDate DateTime, EndDate DateTime; SELECT DIQA.[Batch Number ID], DIQA.[Prepper Name], DIQA.[Date of Audit], DIQA.[Document Type], DIQA.[Document Count], Count([Audit Errors].[Prepper Error]) AS [CountOfPrepper Error], [Audit Errors].[Prepper Error] FROM DIQA RIGHT JOIN [Audit...

Ok I followed this example: http://www.allenbrowne.com/casu-08.html I created a query from my data table. I then followed through to the report and set it up so it will ask for a date range. However I am still getting data for all dates entered in both the query and the Report How do I...

When I click my control buttons to "Close Form" It clears my form but it takes me to click it 3-4 times before it closes. Everytime I click it it enables my first-fourth controls then it will finally close out. I also find if I simply click into any field it will enable it but I want them to...

Actually it works if you don't click the "Clear All" button. But once I click save then close form it then pops into a field and you have to hit close form 2 or 3 or more times before it actually closes. Below is my "Save" Code and my "Close Form" code. Clear All: (Which is actually a Undo All...

I placed a control buttont o close my form and It continues to enable a few of my fields before it will actually close. You have to click it several times before it will close correctly. I first had it in my mainform and it was behaving that way and thought perhaps I needed it in my subform...

Ok, I have a save buttong (next record) in my mainform (DIQA). I want to be able to click that save button after all records in both the mainform (DIQA) and subform (Audit_Error_Subform) is complete. but I get an error since my control in the subform has the focus. This is what I have done...

Holy Smokes what a dummy....I had things typed in way wrong.. like Error spelled Errror.. duhhh anyway I got it working now WHO HOO Here is what it looks like now: Private Sub Indexer_Name_Change() If Me.Indexer_Name = "" Then MsgBox "Please enter a Indexer Name" Cancel = True...

Here is my scenario I want to make a choice in the last combo box in the mainform and then set focus and enable) the first combo box in the subform. (I have the fields disabled till the previous field is entered and it works in mainform with no issues). Now why can't I get focus or enable my...

boblarson, Can you give me an example of the boolean? I am inlearning mode and I am so green to programing methods. I have done so well by getting tips here. I have listed my controls below. Main form: field 1: Batch_Number_ID (number only) field 2: Document_Count (number only) field 3...

Is there a way Manual Save and stop automatic insert? YOU FOLKS ROCK! Ok my final question and I am DONE! YAY.. Is there a way to set all of my form so it does not insert data into my tables untill the user hits my "SAVE" button? I know Access automatically moves the data as it is entered...

YAY, I went into my custom close button and placed a Form.setfocus and it closed the way it should. THANK YOU!!

:(I have successfully created my form and I have my combo boxes and subforms working correctly with pop up messages and my fields are greyed out till the previous one is enabled etc... Now I am having an issue when we are testing the form out if I decide in the middle of the form I want to...

THANK YOU JOHN this finally worked for me: For my text Boxes I used the below code under Lost Focus event. BUT on combo boxes I used this under the Change event. Worked great!!! If Me.Document_Type = "" Then MsgBox "Please enter a Document Type" Cancel = True Exit...

Thank you John.. forgive me with more questions, I have learned so much creating this database and using this forum.. however here is my question.. In regards to your post: "On Current event you would need to preform a logical (If Then) test on each of your control to determine if you want...