Recent content by bwgreen

Found a solution that seems to work - before running the next SQL query reset the ADODB object: Set objRecordSet = New ADODB.RecordSet objRecordSet.ActiveConnection=CurrentProject.Connection It may not be the most elegant way to do things, but it appears to work!

Hi, I`m having an issue. I`m writing VBA code behind a form that used SQL SELECTS on various tables - the results of one query determine the next. I`m using the ADODB object library: strSQL = "SELECT * FROM Table1 WHERE Field1 LIKE " & value1 objRecordSet.Open (strSQL) Then later...

I hope it does too! Thanks for the pointers - sorry restrictions here prevent my giving more information.

Unfortunately no - it is on a system that is not connected to the Web and there is no way to get things like this off of it. I think that it is the object relationship that is causing the issue, but I found a way to get around it that works for what I am trying to do.

It does. I was a little off - the form doesn't come as a split form - it adds a subform object that shows a different table. I do see, going though the Object Dependencies, that this table is dependent on the one that is shown. But, now that I have a workaround, I haven't really been looking...

I got around it by making a query of just the table in question and creating a form based on the query. Thanks!

Indications - two things, on the form (it seems to default to a split form) the table displayed is different, and the number of recrds is wrong. Unfortunately, I can't put screenshots up for this.

Hi, I am trying to create a new form from an existing table and I'm seeing something strange. I click on the Table name, then create the form using the 1st icon (the one labelled Form) - it creates a new form, but for a different table. The recordsource of the form itself is the right one...

Thanks Uncle Gizmo - that's exactly what I'm trying to do!

Hi, I have several tables that are linked that I need to be able to add to. This is an example of the structure: Patient Info ID FK_Ward – ID of Ward table FK_Room – ID of Room table FK_Cond – ID of Condition table Ward ID WardID Room ID RoomNumber Condition...

Thanks - that did it!

Yep - each MEAL is to be handled distinctly.

OK, I have the COUNT working in the report section footer (not the overall report footer - that shows the total number of COLD foods, not just the ones in each MEAL!).

Not specifically the average, but one of three options - --> if all the FOODs are HOT, then HOT; --> if all the FOODs are COLD, then COLD; --> if there are both HOT and COLD FOODs, then MIXED Temperature is a text field. Hope this helps!

Hi! I apologize in advance for being somewhat vague about the contents of the database - security requirements where I am dictate it! I have a database with a bunch of related tables. One holds information on (let's say) types of food. A field in that table tells whether the food is HOT or...