Search results

No misspelling........however, I just found the problem. The field was locked.

No. Not on a subform.

Yes, the form is open at the same time. What I am trying to accomplish is actually print out the current work order. I have a print button on the form which runs the report based on this query. In testing, I am just opening the form and running the query directly.

When I put that into the design grid, it prompts me for the fieldname. The name of my form is frmWorkOrders and the field is Comments. I put into the grid as such: Comments:Forms!frmWorkOrders.Comments Then the box "Enter parameter value" pops up with Forms!frmWorkOrders.Comments.

I know this is probably an easy solution, but my brain is not functioning properly at the moment. I have a query that lists the usual from some tables, but I want to include a field from the current form the query is run from. What is the method to do that? For example, I have a Work Order...

I'm afraid I'm not very familiar with where to create functions. Where would I put this code? On a side note..........is there any way to keep this board from logging me out? It seems to be set on 10 minutes, or so. Quite annoying.

Is there a way to display them in the main form comments field, then? This just makes it easier to see what has been done when someone is closing out a work order.

I have a database that has a Labor subform associated with it. When you open up the labor form, you can enter various information. There is also a Comments field. On my main form, I have a Comments field as well. Is there a way to populate the main form with the comments from the labor...

Thanks for all your help. I believe I finally have it working as desired.

I believe I have solved the problem, although I don't quite understand why this worked. I deleted the primary key field (which was just an autonumber key) and recreated it. That seemed to do the trick. Now my question is another matter. Let's suppose I'm on record number 10 when I copy the...

It's too big to post on here. This database is in production at our facility.

I looked right over that before. Sorry. However, I am still getting the key violation and I have removed the ScheduleID field. INSERT INTO tblEquipSchedule ( SchNextGenDate, DaysToCmplt, SchCalFreq, SchCalRun, SchXTime, Priority, Craft, eqsCompleteClassLuId, EquipKey, AssignTo, JobID, JobKey...

Still getting a key violation. Updated code is: INSERT INTO tblEquipSchedule ( SchNextGenDate, DaysToCmplt, SchCalFreq, SchCalRun, SchXTime, Priority, Craft, eqsCompleteClassLuId, EquipKey, AssignTo, JobID, JobKey, JobDesc, SchRTInterval, SchRTNext, SchSeasonal, SchJan, SchFeb, ScheduleID...

Here is my SQL. The primary key is ScheduleID in the tblEquipSchedule table. INSERT INTO tblEquipSchedule ( SchNextGenDate, DaysToCmplt, SchCalFreq, SchCalRun, SchXTime, Priority, Craft, eqsCompleteClassLuId, EquipKey, AssignTo, JobID, JobKey, JobDesc, SchRTInterval, SchRTNext, SchSeasonal...

I'm getting a key violation now when I try to copy the schedules. The primary key is the ScheduleID, shouldn't it just create a new key when a new record is created?

I've got the copy part down of the main record, but I'm having trouble with the related info. I can run a query to pull up the ratings based on the old key value, but how do I append them to the table with the new key value?

I understand how to run a query using the old key to pull up the values I need, but how do I append them to the table using the new key? I have the query running with criteria on the key pulling from the form and the old key value.

Is there a somewhat easy way to copy a record and have all related records from other tables copy as well. For instance, I have a maintenance database that has an equipment form. Within this form is a subform that lists schedules and yet another that lists ratings. I can copy the equipment...

That wouldn't be automatic.

I have a memo field on a form that I want the user to be able to overwrite beginning where the cursor is placed. Is there a way to make that field not go into insert mode when it gets focus? In other words, there will be a set of instructions in the field with lines to be able to fill in for...