Recent content by dreamspy

yeah adding the criteria by using a button might do the trick. I'll try that.

Hi My Problem in short: I have a form which runs in it's "On Open" event the VB code: Me.OrderBy = "Category & Date" And the record source query has an input parameter. The error I get is that the user is asked two times for the input parameter. This error goes away if I remove the VB...

Is there any way of disableing users from entering visual basic from access? I have occasional problems with visual basic popping up on my clients computers, f.x. when there is a code error, the debugger starts up.

In this case if the child record doesn't exist, I get into troubles when I'm using filters in a form. I have a form which is shoving some fields from a parent record, and some true/false fields from a related child record. Now when I do "filter by selection" on an empty (not ticked) box, and...

In this case if the child record doesn't exist, I get into troubles when I'm using filters in a form. I have a form which is shoving some fields from a parent record, and some true/false fields from a related child record. Now when I do "filter by selection" on an empty (not ticked) box, and...

I actually found out the answer to my second question. Quite simple actually. I set the query criteria to "is null or no". That includes also records that don't have an entry in the child table. But I'm still interested in how to to automatically create entries in linked child tables :)

Hi I'm in a similar case as Matches is describing. I have two tables linked by key field. I would like access to create the entry in the child table, when I make a new entry in the parent table. Pat says as long as the master/child links are properly set. Aren't you just talking about...

Column names. Can I make the name field "higher"? (to make room for more lines) I'm currently working with a form, which is in datasheet view. I have many rows which are combo boxes (yes/no), and the name is rather long. So each line (each row) spreads on to 2-3 pages to the right. What I...

easy as 1, 2, 3 ;) thanks!

My question in short: Can I make a global function in access? (some function that I can call from every form in the database), My problem: I have an access database. It has a startup menu for the user, which has some buttons on it. Each of these buttons take you to another menu with more...

Thanks for your answer The reason for why I put up a new thread was because the old one was getting rather confusing. But I'll keep this in mind in the future. ( I usualy don't do this)

That could work, going to give it a try. I also got another solution, which came from another thread: Include the field in the RecordSource query. It doesn't need to be bound to a control. Then the code in the click event is just as you suspected: me.Item_arrived_date = date Originated from...

That's working like a gem. Thanks :) But I have another question. If the date field should not be visible on the form (both in form view and datasheet view). How would I go about this? Making the form "not visible" doesn't work because it's always visible in datasheet view.

I currently have this question in another thread, but it's probably less confusing just to post it again: I have a checkbox on a form called "Item_Arrived", and when it is clicked, I want to put the current date into a field called "Item_arrived_date". Both of those are in a table called...

But let's say I don't want the text box on the form. I just want to record the date to a field in some table. Anybody know how to do that in code?