Search results

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?

HI CJ_London, Yes, thanks! So, how can I arrange that by the MCJSubCategory and Assembly week like shown in the image I posted?

The reason why there are three tables is because the actual MCJ/PRTBackorder table has so many fields that and so we now have extra tables to handle additional fields for any queries which require those additional fields (such as MCJCategory and MCJSubCategory). The versions of the tables I have...

Hello, Thanks for the replies. There's a lot that I don't know about access and visual basic, etc. so I appreciate the help. Most of my experience is with just basic queries and forms in access and I don't know visual basic. I've attached a sample database which should give a better idea of...

Hello, If it is a report though, the user wouldn't be able to interact with the data, right?

Hi Pat, Would the crosstab query at some point be made into a form or how would that work? Thanks!