Search results

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...

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

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...

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...

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

Hello Everyone, Attached is a spreadsheet showing what I'm trying to accomplish in Access. I have a database that has information of volume by a specific queue for each employee. What I would like to do is summarize these volumes by Queue based on the Employee Location and display it Day by Day...

I have a database where I uploading data in from a secondary source. I wanted to be able to assign to the field name in my Table called "TimeWorked" as default a value of 0 if the amount in the Table Field called "Dollar Amount" is < or = to 200 I added the following expression in the Default...

Hello everyone, I have a tabular form that displays records from a query, when a user doubleclicks on a record a second more in depth form appears. What I wanted to do is give the user a visual reference to what records were viewed and which ones were not. So I thought I would place...

Hi Everyone, I had an idea and wanted your opinion on it. I was thinking why not creating a section in this forum where people can discuss the current market outlook for MS Access Developers, what kind of trends they are noticing, what employers need and want. Suggestions and ideas on how to...

Hello Everyone, As you might know I work for the Banking Industry which has been hard hit with the current US Economic crisis. As of today I still have my job (knock on wood) but dark clouds are always on the horizon. So, I wanted to see what your thoughts were regarding the Job Market right now...

Is there a way to create an if statement so that if say Forms!FormA is Open then close Form!FormB? Thanks

I am using a multi-select list box to pass various search parameters to a query. The code below is working great but in the IF statement at the end of my code I wanted to do the following: Instead of the user getting a message and having them select at least one item from the list box I wanted...

Hello everyone I have the following code listed below. I need to be able to have a " and the beginning and ending of every item is selected in a muti-select listbox. so for example if a user selects Balance and Capture in the list box. This code right now populates a text box I am using for a...