Search results

Hello, I have a link table where I am forming a union query from and would like to take a specific set of data. The table is a timestamp table and I would like to grab the most recent entry. So in theory, I want the max value for the timestamp. I writing this in sql to facilitate the union...

Locking specific columns within a query Hey guys, I have a query on a form in which I want to lock the first two rows to prevent the user from manipulating the data. The user will input information in the third column. How would I go about this Thanks

Hello All, I have a query that the user selects the date range (parameters). I am running a report based on the query and would like to pass the query parameters, which have already been entered, to the report. As of right now, the user must go through the date selection (parameters) again...

Hey All, I have asked previous questions and searched extensively on this topic and I am still without a solution. Im trying to filter a range in a queries field. Here is the way my query is organized. All this data deals with forecasting for my company... Version - The current version of...

Hey All, I have a form with 2 subforms, both of which are queries. I need one of them to allow for data input/editing. I had it working for a while but now it does not work. Is there a process that I can make one of the them allow for data input?? Is it because Im using a query? Thanks

Hey all, Im trying to hide/remove the navigation bar on my subforms. My access install didnt include any wizards so I just put in the corresponding table in the subform. So there is no seperate Form that I call in the subform, it is embedded. Is there way I can hide/remove the navigation bar...

Hey everyone, I searched to no avail. I have a query that I am using to input data to a table. I need to display only the current record in the subform, not all the records. Is there code that will do such a thing? I have 3 fields in the subform being populated from combo boxes and need...

Hi all, I am designing a database that is completely input driven. This is my first database so because of the reliance on the user to populate everything it has been rather confusing. I have a query that I have set up that uses 3 selections, 2 from a combo box, and one from a text box to...

Hey guys New to access and new to this forum. Here's my first post. Im currently working on a database that will assist people at work with inputs into our Optimizer. The goal of the database is to allow the user to input their forecast for a particular material and have the data stored in...