Search results

I took your suggestions and created a checkbox in the table and left it as False for default, then once the user presses a button the checkbox becomes enable. I also added a code to the on current of the form but still I can't get it to do what you suggested. Attached is the example of the...

Is there a way to keep the old record enabled for editing and lock the new one?

Thanks for the suggestion, and what type of code do I need in my after update event to transfer this information to the table?

Hello Everyone, I have a Continous Form in Access to enter data, I have a textbox called "txbstartenter" thatI want to keep Disabled until the user doesn't press a button, then this textbox can become enabled and the user can edit information in it. I made the txbstartenter disabled by default...

Hello Everyone, I'm using an append query to feed a table with raw data. In the Table I am also collecting the Working Day which is always the Previous Working Day from the Date I am running the Append Query. So for 10/09 I need to have all records append with the Work of Date of 10/08. In the...

Hello Everyone, I'm attaching here a copy of my Pivot Table, I wanted to see if I could add a column next to each Site that will show the Percentage distribution by the Task Description. It would basically take the total volume for both days and divide it by the Grand Total of all sites and then...

Hi HaHoBe, I actually need to go as long as there are different dates in the first Worksheet Let me know if you can think of anything.... Thanks

Hello Everyone: I'm trying to format my data in a specific way, attached is the spreadsheet that contains the initial data and then the formatted template. Sheet1 is the raw data and I need to get it in a format similar to Sheet2. Any help would be greatly appreciated. Thanks

Just 2, the person that initiates the change and the person that then approves the request

Hello Everyone, I would like your opinion on a project I am working on. I have a table that contains sensitive information and we want to have 2 people basically sign off on any Modifications, additions, deletions etc... My database has a sign in system where I am able to retrieve who signs in...

Hello Everyone, I'm attaching a sample of the database with my post. I have a query called Evaluation_Qry based on the result of the other queries in this database. As you can see I am pulling data using a site criteria and a data range criteria. I'm trying to take the Evlauation_Qry and create...

Hello Everyone, I'm attaching a sample of the database with my post. I have a query called Evaluation_Qry based on the result of the other queries in this database. As you can see I am pulling data using a site criteria and a data range criteria. I'm trying to take the Evlauation_Qry and create...

Thanks that's exactly what I needed

Hello Everyone, I currently have a table that contains Groups. For Example I have Group A, which contains Menu - File - Exit Group B, which Contains Menu - File - Next - Exit Multiple People can have access to multiple Groups. So for example User 1 can b part of Group A & Group B How Do I get...

Hello Everyone, I would like to create a form where employees can add new records, however if a record from a Site (Orlando and Philadelphia) has been created for that day, I want them to edit the existing record. For example, if for 05/13/09 employee A goes in and creates a record for Orlando...

Makes sense but how can I generate a query that will show the dates volume is not existent when there are no entries for that day in the table?

I thought that at first too and I tried to put Total: NZ([Volume],0) but didn't produce the result I wanted. I guess because for 04/21/09 there is no data at all for the Orlando and Philadelphia Site. Any ideas how I can overcome this>????? Thanks

Hello Everyone, I'm attaching a sample of my database here, I would like to see if the query I created can place a 0 volume and display the Site even if no data is present in the Table. For example on 04/21/09 there is no data available for Orlando and Philadelphia in Queue 03 only India has...

I'm attaching to this post a sample of my database. I have a Query that obtains data based on a date range and other filters from a form. The Query has everything I need but I'm trying to display this data in a way it can be easily compared from day to day. What I would like to do is have a side...

Hello everyone, Can I create a MS Access Report with a cross tab query as my underlying source? Is there anything special or different I have to do when dealing with a cross tab query vs. a simply Select query? Thanks