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.

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)...

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 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...

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?

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 listbox with 3 columns: Date, Shop, Amount I want to format the amount and have it right aligned. Can anyone tell me how to do that?

I have actually 2 questions. They are probably very easy to solve, but I have no idea where to start looking. 1) I have a form (Form1) which has a combo box. When pressing "F2", I start a second form (Form2). On Form2 I want my records order by Name, but I always have them ordered by ID. I...

I have a form where I want to enter an ID and then see the Name in the next field. How do I do that? Everytime I enter an ID I get "?Name" in the next field. The Table is "BudgetLine" and I enter an ID from a table "Item" Item ID Name

I have a problem with counting the people in each city. I will give a discription of my tables first and than explain what I want. City ID City LocationID People ID Name BirthPlace DeadPlace ... What I want is a list of all the cities in LocationID = 1 and a count of all the people that where...