Search results

How do I display 10 records on a form? I have a table which contains FromDate, EmpID, CheckDate. I want to order the records by FromDate and display the records until the CheckDate is Not Null. This with a maximum of 10 records.

That works, thanks.

I have an insert that works perfect just until I have a name with a ' in it. Can anyone tell me how to solve this? I know what causes the problem, but I don't know how to solve it. I work with Access 2003 and here is the insert statement: sInsertStr = "Insert Into Persoon (Naam, Voornaam)...

That works. Thank you very much!

I have a form "Stock" on that form is a subform "DetailStock". On Stock I have a combobox and on the onclick-event I execute a Public sub GetTotal. I want to execute the same sub on the subform in the After-Update event. How do I do that?:confused:

I tried something like this: Private Sub Form_AfterUpdate() db.Execute ("Update Persoon set Persoon.RecUpdate = Now() Where Persoon.ID = " & txtID.Value) End Sub But then I get the error: Object required.

I have a form with personal information, such as name, address and so on. When I update a record, I want to update a field RecUpdate with the current date and time. I was thinking of doing this in the AfterUpdate event of the form, but I have no idea how to do this. I know how to write an...

Thanks the shift seems to work, the F11 not. But now I can edit my application.

I have an aplication with a switchboard. I want to change my application and tables, even run a few sql-statements on the tables. BUT it looks like this is NOT ALLOWED.:mad: Does anybody know how to get to my OWN application?

Fear Naught I tried it and it looks very good. Thanks guys, all of you.

Is it possible that the header/footer does not display because I am using a datasheet view? If so, how do I solve my problem: viewing the total?

In design view I can see the footer, I have a textbox on that footer. The problem is that I can't see the footer at run time. That is why I can't see my toal field, because I don't have a footer at run time.

That is one of my problems: I treid putting the total fiield on the footer of the subform, but I can not see the footer! I have no idea why the footer is not visible or how to make it visible.

I have a form with general information and then a subform where I enter items, price and quantity. I want to see the total form the lines that I have enter and keep the total up to date as I enter new lines. Can anyone explain how to do this? I have tried a few things, but none give the result...

I have a form that I want to display at startup and in that form I want to have a menu that will allow me to show outer forms and reports. Can anyone tell me how to do that?

I have a query with a sum in. But my problem is how do I connect this query to the textbox?

Can you give me an example how to do that?

Yes those textboxes.

Thanks. Do you know how I can fill in the fields on the top? At the moment they are just constants. I tried with a query that had a sum in it; but that didn't work.

Yes it is currency in the db table