Recent content by 2RUEXX

Ok, thanks Pat.

Ok, I am thinking that @The_Doc_Man's theory as to multiple users having the file open may be the cause of the issue. Thanks for your help. We have been allowing users to modify queries directly. It seems like it has worked for us, although I understand now that it is dangerous and not ideal or...

Hello, Thanks everyone for your replies. So, if these queries they are accessing were forms, perhaps then it would not be giving the "save as" prompts occasionally? @The_Doc_Man - Each user uses a separate copy of the database file so that multiple users are not in the same file. But it is...

Hello, Sometimes when a user makes a layout change to a query and Access prompts the user upon closing the query if changes should be saved, it then prompts the user to save a copy of the query instead of just saving the layout changes to the original query. I am not sure why at times Access...

Hi Larry, I appreciate the time and the posts you wrote. I messed around with the queries and tables and I have been able to create a suitable jobboard format for our needs. For now, I don't need further assistance, but I appreciate all the help and all of what I learned through the various...

Hey Larry, Sorry for not getting back earlier to your posts. I have been busy this week and have not had time to work on this project. Let me get back to you about some of your posts. Regarding this question, I believe that right now they are mostly interested in displaying just the current...

Hi Larry, Yes, they are stretch wrap machines. This is our company: Highlight Industries | Home

Thanks Larry! I am analyzing it and I may reply later with questions.

Hi Pat, I am studying Larry's example and it is making more sense now. I was confused at first but am working through understanding it better. Thanks for your help!

The example database I uploaded has much less than the actual tables. In the actual MCJ table, we have around 67 fields. Access didn't warn us but the table was already so large so that new fields have been added to tables like MCJFreight which I realize now doesn't seem to be good practice...

Hi Pat, I was curious as to what is the better way of dealing with a table that has too many fields rather than making a new table with the same primary key. Thanks!

Hi Larry, Yes, that is basically correct as it pertains to machine sales. We also sell parts, but the job board is specifically for machine orders. The PO is first assigned a sales order and the sales order is then assigned the job #.

Ok, thanks! So, forgive my ignorance, but as you have it in your example, the cross tab query only shows the First record for each MCJSubCategory. How can I get the query to show every job that exists within a MCJSubCategory for a given ship week and not just the first one?

Ok, thanks! That is looking pretty close to what we want. Would it be possible for me to use a query like this then as the data source for a form so I could style it how we want it?

Ok, there are more than 4 or 5 subcategories. I was thinking maybe each assembly week could be a separate page of the form? When you say use a recordset, do you mean in the form?