Search results

Yeah you need a new table. In database terms, it's called an 'Associative Entity' because the table contains two 'Many-to'Many' relationships. Each staffer can take Many courses and each course can be taken by Many staffers. It is one of the more complex relational tables you can make, but if...

The only way I cant think of doing this is to grab all the records you need into an ADODB Recordset object. Then run two SQL commands to update your local database: 1. Run an UPDATE command to update records that have matching primary keys between your selected ORACLE records and your current...

Make sure the Primary Key of the table you are editing is part of the query for the form. Also, yes: check the AllowEdits property of the form.

I'm not sure how RuralGuy's solution would work. Here's my suggestion: In your query criteria use the LIKE operator. For example: SELECT Table.Field FROM Table WHERE Table.Field LIKE 'Frog'; The key is that if your query states LIKE '*' all records will be returned. Now do this: 1. Add a...

If the field you are filtering off of is a 'Date/Time' field, you probably need to surround the criteria date with # signs. Something like this: "Date = #" & [2004 Lookup].[Date of Booking] & "#" These symbols tell Access to expect a date variable. Try that and see if it helps. Also, I...

What do you mean by "saved"? If you want the data to be "saved" into a table record you have to: A. Bind the checkbox to a table field or B. Use the unbound value of the textbox to update a table field by executing a SQL command for instance In either case, "saved" in access always means...

Yes you can do this all in a query. The query needed would be the one I described for the listbox. You'd have to use 'parameters' to prompt the user to enter the needed emp num and attendance type criteria. Adding a 'attendance count' field to this query would be a bit strange however because...

I think the reason you are getting an #error is because field [txtExtended_Price] isn't a field on your main form. Because of this you have to point Access to where this control exists. Something like Sum([Forms]![SubForm]![txtExtended_Price]) Still, even if you fixed your reference problem I...

You've asked for a lot...so I'll try to give it. Steps needed: 1. Create a form with an unbound text or combo box for users to selected employee numbers 2. Create a second unbound combo box of all absent codes for user selection 3. Create an unbound text box and set its default value to...

Sorry, but you've lost me. Before you said the notes were "all the same". Now you say they are different by therapist. If they truly are different then each note is unique and I don't know how to display the first one but not the others.

I don't follow you... What criteria are you using to decide what the "first" record is and the "last" record? If you have a unique key (hopefully an autonumber) then my suggestion will work fine. If not, then I don't know how to help. There is no SQL statement for "SELECT TOP <WHATEVER I...

To get a horizontal report like the one you're describing can only be done with a cross tab query as far as I know. The 'line item' report I was referring to is just the vertical group-by report you've already played with. What I'm not sure about, is if you can make a visiual report out of the...

Something like this: SELECT Table.Field1 FROM Table WHERE Table.FieldID > 9 AND Table.FieldID < 21; That should select only those records with IDs between 10-20.

Basic database setup: 1. Create a Batch table 2. Create a Core table and have each Code record linked to 1 Batch record (each Batch can be linked to many Cores). Also include the 5 values for each code record as fields in this table. 3. Create a Form linked to Batch records 4. Create a Subform...

In your report's recordsource, list all training records linked to the master staff record associated with it. Next, in Design View of the report, right click and select 'Sorting and Grouping...'. Group records by the master Staff record and then the report will list the individual training...

2 thoughts: 1. If the data already exists in SQL somewhere, why not create a Linked table in Access that directly attaches to the data in SQL? Then you could simply base Access forms/reports off this linked table. Do do this you need to: A.) Create a new File DNS connection to the SQL data...

Why don't you move the Notes field from the Notes table to the Info table? That way there is only 1 Note per patient. Then create a report listing all patient info records linked to the main patient record. Group records by Patient (and show the note for them) and then list each information...

You've mentioned 2 problems: 1. STARTING VISIBILITY Since the code I mentioned should only be triggered when the combo box is changed, the opening of the form leaves the control is whatever visibility state is default. Solution: Open form in Design View and set the Visible property of the...

I don't think the problem is with the connection string. To test this, instead of asking MsgBox to display the record count have it display a field value from the first record. If the field value comes up then you know the connection to SQL has been established. If I'm right so far, then I...

Have you taken the SQL string you've created and set it as the RecordSource of the form? 1. Open the form in Design View 2. Right click on the Form and select Properties 3. Find the form's Recordsource property, click into it, then select the '...' button next to it 4. Set the recordsource of...