Search results for query: *

Thank you. I've been working with your suggestions for days now but nothing has seemed to work. JonFer, I tried your last suggestion but ListNum can not be unique in those tables because each list will have multiple users and multiple projections. Any other suggestions would be welcome, but...

All tables have primary keys defined as follows: tblSysLists - ListNum tblLiveProjDetail - DetailID tblListAssign - AssignID There will be multiple ListNum references in tblLiveProjDetail & tblListAssign since there could be more than one user that has access to a given list and more than one...

NOTE: I just noticed that I used the word "update" when describing what I want to do. I'm not using an Update query, I need to modify the field values in the query result. I can do it if I use a single table in the FROM statement but not if I link that tables.

I have and haven't had any luck. HEre is the query with all of the keys: SELECT tblSysLists.ListName, tblLiveProjDetail.MoStart, tblLiveProjDetail.ActFS, tblLiveProjDetail.ActAdj, tblLiveProjDetail.DetailID, tblSysLists.ListNum, tblListAssign.AssignID FROM (tblListAssign INNER JOIN...

Here is the SQL for the query I'm working with: SELECT tblSysLists.ListName, tblLiveProjDetail.MoStart, tblLiveProjDetail.ActFS, tblLiveProjDetail.ActAdj FROM (tblListAssign INNER JOIN tblLiveProjDetail ON tblListAssign.ListNum = tblLiveProjDetail.ListNum) INNER JOIN tblSysLists ON...

Not sure if I can make this work, or even if I can communicate exactly what it is that I need to do but here we go: I have a continuous form to list product details that a given user has access to modify. However, the query that I have won't let me update the couple fields I need to. I...

I've tried setting the Forms' RecordSource equal to an SQL String and the Forms' Recordset equal to a code recordset but it locks me into the same problem as if I had an Access Query...I can't modify the values. I have a solution, although I know it's probably not the most elegant solution...

I've tried all of these suggestions without any clear improvment. What aobut this...is there a way to create a control array on the fly based on the number of records I have in a recordset? I know you can do this in VB6 but can it be done in Access 2000?

Thanks PJ. That SEEMS like the answer I should be looking for but I'm still just getting one record showing the last item in the recordset. BTW - this code is in the Form_Load event. I tried your code in the beginning of the Loop (as suggested) and at the end with the same result. I tried...

Hello all. Here's my problem: How can I use the following code in a continuous form? The result of this query gives me 288 records but when I use this as-is in my continuous form, I only get one record...the last one. dim db as DAO.Database dim rs as DAO.Recordset dim strSQL as string...

The form is set to Continuous. If I put the SQL query into an ACCESS query and make that the RecordSource property on the form, it shows me all of the query result records with no problem. However, I can't update any of the records because of the query links. My ultimate goal is to be able to...

Hello all! I have a recordset that I need to populate into a continuous form. When I try the normal methods to set the textboxes equal to the recordset fields in the VBA I'm only getting the last record on the form, not the 200+ records that are in the recordset. I'm sure there is a line of...

The subject pretty much says it all. I have survey results in Excel that I need to merge into a Word document the contains several other pages of result analysis. I have SEVERAL of them and I will be doing this several times a month. I want to be able to copy all of the graphs from Excel...

I've actually developed the same error. No matter what allowances or tests I attempt in my code, I continue to get the Error: You Cancelled the Previous Operation. It occurs every time I execute code. It come up twice in a row and then I get a run time error on the action I tried to run...

The "ME" is a shortcut for the form you are working on.

That's great. I hadn't thought of that. I can still use that someone in my app but is there a way to disable or format the record's textbox on load so the user knows tehy can't modiy it?

I really hope this can be done. I have a continuous form listing projected quantities ordered by month over a period of time (user defined but usually 12 months). I want to allow users to modify some of the values but I want to lock others (i.e. dates that have already passed) but I have not...

What is the error you are receiving? If you aren't getting an actual error and your result is just an incorrect date in the MySQL CUSTOMER table, what is that bad value?

PLEASE throw me a bone on this one... I have a table of "TimeClock" punches for employees. They are listed in the normal, horizontal record fashion by punch time & date: PUNCHINDEX, EMPID, TIMESTAMP, TIMEUSED (representing the time since the last punch) I need to display this...

You can't open a query as a recordset if the query has criteria that the code isn't aware of. It sounds like that is what you have. You can do one of two things that I know of. 1. Instead of calling the Access query in the OPENRECORDSET method, use an SQL string to do the same thing. You...