Recent content by mapondera

I want a 'doctor's appointments' form in my database. It must show all the possible times for a given day that a doctor is available. The times are in 15 minute increments between 9 a.m. and 3 p.m. I want my form to show all of these time slots at once, and then the database user can fill in...

I have tried this using the 'grouping/sorting' property in design view and the report wizard. I don't know how to specify to group like products together but sort first by the value where year = 2002

1. In the underlying table for colour, how have you set up the field? e.g. is it text, what are the properties. 2. I think that you cannot filter or sort memo fields although you can use 'ctrl'+'F' to search for and highlight words in a memo field.

I have the fields: product, value, year For one product there are many years. The value of a product changes each year. have all three fields in one table (Yes, spreadsheet-like but because of how I have to use the database with other people in my team, it has worked so far.) I want a query...

After I enter numbers into one subform how can I update info in another subform that performs a calculation based on that entered data? I want the calculated field, based on a query, to update in the "after update" event of my data entry field. I have a subform based on a table to enter some...

I'm not sure what you mean. Where do I use it. How do I use it with the control

Go to the source table for the field, open in design view, click on the field, click on Lookup tab. Go to List Rows and enter the number of rows you want to display at one time.

I have a subform in which I enter the [Order Intake Value] per [Year] for a [Product] (Main form is products form and subform has values) I have another subform based on a query which is SUM([Order Intake Value]) for a given [Product] How can I get this SUM([Order Intake Value]) field to update...

See http://wa.apana.org.au/~abrowne/ser-27.html

It sounds like you need to make a 1:many relationship between say [office version] and [document] if what you are saying is that one document exists in many different formats e.g. an Excell version and a Word version . Please provide a bit more info about what office version refers to.

It worked. I just had to replace "Elements" for the name of the control. Thanks

I have a command button that opens up a form. How do I 1. get the form to open up to a new record 2. get the form to open up only to a new record i.e. make previous records invisible/un-editable

I just made and clicked on a command button in another file that I just created. I don't have any problems this time. It could just be the one file that is corrupt?

The software and file are on my hard drive

I have never had problems adding a command button to a form before. Now, after adding a command button to open a form and clicking on the button in form view I get the following informational message pop-up box. "Microsoft Visual Basic: Error Accessing File. Network connection may have been...