Search results

I would like to edit the recordsource in my subform with a click on a button. The button is in the mainform. But when providing the form name of the subform forms![mainformname]![subform] there's no recordsource property! It seems only the recordsource within the form with the button can be...

Ok, I found out how it should be implemented: Cascaded --> define both updating and delete Restricted --> Only define cascaded updating, don't define delete; access will tell you when a record with childs will be deleted it isn't possible Nullifying --> simply don't define a relationship.

Ok this sounds rather stupid but I was busy in the wrong table which didn't relate to my query. When setting Now() to date() in the right table everything looks fine.. sorry for bothering

I was using a Now() function as default value and changed it in date. Within an experimental table everything looks fine now. But my current table was already spoiled with now data so I ran an update query to get all dates to 00/00/0000. That worked, but when inserting new dates Access still...

I'm trying to define a short date field in access but it gives me headaches. The short date also displays time, this gives problems in my group by queries as I want to group on date instead of date and time :mad: Is there any datatype in Access to really store the date and not date+time? I...

I found out the Ampersand to shortkey buttons in a form (for instance ampersand the caption), but I'm looking for a more general shortkey for instance F3 to invoke search.

I would like to define several hotkeys: F3 to start a search CTRL+t to insert the current date in a date-field and I guess more hotkey wishes will come up. How can I easily define hotkeys within MS Access?

But..my line number is part of the primary key so it won't work

Hi, I might not remember it well but normal subforms will slower your form performance. And there's a trick to activate/inactivate them. I was wondering do forms on pages (=tabular sub forms) also slow down performance or do they only load when being clicked? thanks

Thanks for the advice. As Í'm struggling with updating issues just sending the whole front-end might be easiest thing to do. Guess the query/form/macro code won't take much space. Very soon I'll be using attached tables making it easy to update the front-end. Fizzio, thanks about the Inno...

Access offers a great way to update single objects. But as most users don't know how to import new objects or shouldn't be hold responsible for something like that I was considering a 'packaging' tool. Before programming it myself I guess there are off-the shelf programs for easy updating...

I have a query which is used in two forms. Both forms share the same subform and the query depends on a value in the subform. I have to declare the whole form (form>subform>control) in the query and would like to switch between the 2 forms depending on which of them is the active form. This...

Solved :) FInally solved it. The original plan (in the posting above) didn't work out well. Then I got back to my original idea of placing Docmd.Applyfilter in VBA code. The first time I did it I placed it in the subform and tried to filter the mainform which didn't work. Then I'd put a...

Hi Colin, thanks for your help the example looks nice. But it doesn't compete with the 'form-filter' search capability of access. The 'result' fields (with all of the data of the company) could easiliy filtered by a form-filter, so the search via the list-box is quite obsolete or better say less...

When Looking in Northwind I can only find orders as an example. You select customer and the address field will be filled. But this is selection on one field, not a 'filter' like the form filter which makes it possible to filter on the like statement. In my current subform the user can filter...

Hi Colin, the user should be able to filter, not a pre-filtered listbox. I can show as many columns as i want in a listbox, and I'm able to put a query in the listbox with criteria in multiple fields but the prob is...the user has to give in criteria. For instance the user determines the name of...

When taking a leak :D I realized I could put up an textbox on the subform with value * . When pushing a knob in my subform this box will be updated with the customer-Id. Within the main form the source query should use a like operator in the criteria to this subform textbox. Only hassle is I...

Hi Colin, Problem with listbox is I can't filter 6 fields!! So I'm using a subform on a page with 6 fields (query with 4 tables) to give the user the possibility to filter on company name, contact name etcetera. All this data is spread throughout tables. Problems with listbox you can only...

Hey guys, is there an activeX object to embed crystal reports within Access? Are there any prerequisites like an installed crystal reports on each client to run it?

Hi, I'm trying to pass a value from a subform to a form. My subform is a filterable lookup form for companies. So when someone point at a company he/she can click on a button to 'select' that company to filter the main form I use a button with the following procedure in the subform...