Search results

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

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

I want to use the following statement in my "afterupdate" event code for [control1]: If [control1].Text = "No" Then [control2].Text = __ What do I use to make the text in [control2] disappear?

I have a tables [Company] and [BusinessUnit] One Company has many Business Units. I want to add a new company to the [Company]table but from the form based on my [BusinessUnit] table without having to go back to my Company table. i.e. make updates straight into the list.

Is there a way that I can justify text like in MS Word. I see 'Justify Right', 'Justify Left' and 'Center' but not 'Justify.'

How can I specify ascending or descending order for my data in a given field - text or number.

I have a field with numbers in it. I specified in the table that the field holds up to 2 decimal places. I did the same in queries that contain that field and columns with calculations that utilize those numbers. However, I still see even up to four or five decimal places used in my query and...

I have just deleted my 'Toolbar' button under the menu option 'View.' I thought I was customizing just my one database but it turns out it affects the whole application. Anyone know how to restore it? Shamiso

I would like a field that begins as 0000 and increases incrementally 0001, 0002, 0003 etc. I have heard that I need a query to do this. Also, what if I don't want to start at 0000 but start at some other number, e.g. 2000 or 1000.

How can I set the text to be "in/out" using a "yes/no" field? I know how to use the 'properties' function of a field in a table or query to convert a checkbox field to a textbox and display the words "yes/no" or "on/off."

Say each datum has a date e.g. if I have the fields 'Date' and 'Total Cakes Sold to Date' and my data is: Dec/11/01, 25 cakes sold to date; Dec/12/01, 32 cakes sold to date; Dec/13/01, 47 cakes sold to date; etc. (Where cakes sold to date is a cumulative tally i.e. whatever yesterdays number of...

I have several many:many relationships for my main table PRODUCTS. PRODUCTS ProductID and CUSTOMER CustomerID are linked in a 1:many relationship as foreign keys, and together form a concatenated primary key for the table PRODUCT_CUSTOMER_RECORDS. I have about 6 such relationships all related to...

I have several many:many relationships for my main table PRODUCTS. PRODUCTS ProductID and CUSTOMER CustomerID are linked in a 1:many relationship as foreign keys, and together form a concatenated primary key for the table PRODUCT_CUSTOMER_RECORDS. I have about 6 such relationships all related...