Search results

I don't have that property, I think it was introduced in 2007. BUT- changing the recordsource as you suggested worked like a charm! Thank you!!

I am working in Access 2003, so I don't have that property. Sorry- I should have mentioned that I'm working in an antique version. Is there anything comparable to Order by On Load in 2003? Thanks!

The form was created straight from the table using the wizard. Is there still any hope for me? Thanks!

Hello, I just noticed that one of my forms is not ordered by the right field. When the user scrolls through it, VendorName field should go in alphabetical order. VendorName is specified in the form's Order By Property. But for some reason the form is ordered by VendorCode instead, so when I...

Hello, How does one handle an insert statement in vba in which some fields (values coming from unbound textboxes) may or may not be blank? Specifically, the problem is with date fields which are not required and may therefore be left blank by the user. I did an extensive search, but all the...

I did not know about TypeOf. Thank you!

Hi Bob, I just did what you said and it's still giving the error. Here is the exact code: Dim ctl As Control For Each ctl In Me.Controls If Not ctl.Name = "SaveInvoiceRecord_button" And Not ctl.Name = "Box95" Then If ctl.BackColor = 10092543 And Len(ctl.Value & vbNullString) < 1 Then MsgBox...

Hello, On my form, I designated the textboxes and comboboxes which the user has to fill in in order to save a record by making their back color yellow. In the on click event of the Save button, I want to check if any of the yellow controls are blank: Dim ctl As Control For Each ctl In...

Thank you, Bob! I actually did NOT know how to remove the lookup. This was very helpful.

I am convinced! I will remove the look up from the table. It's just that it's so convenient in the short term... Thank you!

Hello, the field is not a combobox. The form was created directly from the table using the wizard, so the source of the field is the corresponding field in the table. I want to have the user do additions and edits in this form preferably without having to write vba on the back end, so that's why...

Hello, I have a table, Transactions, in which one of the fields is a look up field, looking up values from another table. I created a form based on Transactions and I want all new records to be added using this form. However, the field in question is NOT coming up on the form with a drop down...

Thanks for your suggestion to step through (I've always been resistant to the stepping through feature for some reason). Using it, I found my silly mistake. I neglected to move back to the first record after the inner dates loop was done running for each name. That's why it didn't insert...

Hi Rx, thanks for your suggestions. Just tried to debug.print the error number like you said and the error is 0, which I guess means there is no error. And the code is behaving as if there was no error, really. The insert statement runs and successfully appends the desired set of records for the...

Hello, I'm trying to update a table called EmployeeTask_FTE with insert statements via vba. I have two recordsets based on queries: rs_FTEforupdate based on: SELECT employeetask_FTE.lastname, employeetask_FTE.firstname, servicesubcat, Worktimetype, FTE, FTEEntryType FROM employeetask_FTE...

Wow! That's a really awesome way to do it! Thank you! I just tried it and the form does get filered. HOWEVER, something truly bizarre is happening: no matter what purchase order, year, budget code, etc I specify, the form gets filtered by one and only one purchase order number- the same one...

Hello, I apologize if this topic was posted before- I couldn't find an answer to this particular question, though there are lots of threads about multiple criteria. Is it possible to have a SINGLE filter button that filters a form only by the filter criteria that the user specifies and not all...

It's the same version of Access. And I didn't have any problems importing any other forms that have sql statements with subqueries as record sources... Not sure what went wrong with this one...

Thank you, thank you, I've been trying to stick to your less is more advice. I understand that an alias is assigned in queries with subqueries. But why all of a sudden does the import process kill the db's ability to read its own syntax? It says the source doesn't exist. But all the tables are...