Search results

Thanks for the replies! I was planning on only have the 2 buttons ("Submit" or "Cancel"). I changed the form properties to only allow record navigation within the current record and to remove the close form option, other than the "Cancel" button. I'll try your suggestion for the Undo command...

Hi, I've read a few other threads about this but the suggestions offered didn't work for me. I'm hoping I can paste my code here and someone might be able to help. I want a message box to appear when the user clicks "Ok". The message back should ask the user to confirm adding a new client...

Hi, Sorry for the delay and thanks for all the replies. I've been reading up on relationship modeling trying to learn more. I'll add some additional context that might help the discussion: There are many employees to many accounts. The accounts follow a yearly structure, so there is a 2010...

Hi, I'm currently trying to model out the relationships for a sales database. I've walked through the structure with the client and established the relationships. However, I'm concerned about future exceptions and how to position the database to accommodate. The current model is as follows...

Problem solved. I used =Trim() in excel to remove excess spaces, then copy/pasted special as values only. Upload worked after that. Thanks anyways!

I'm under the assumption that there is a limit to the amount of text you should upload into an Access database. When I try to upload the information from an excel spreadsheet into the access table, I get an error message: "The search key was not found in any record" "An error occurred trying...

Hi, I have a database with over 30,000 products. Each product has a description that is roughly a paragraph. I'm hesitating to upload the product descriptions into the database, as I'm concerned it will inflate the size of the database and slow it down. Does anyone have suggestions on how...

Hi, I'm trying to find the best way to handle hierarchical relationships for employees in an access database. I currently have a table that simply holds each employee ID and their manager ID. I've then created a query using this method...

If your queries are returning duplicate values, you can use the "unique" feature of a query.

Hi, I'm trying to figure out the best way to layout my tables. Each object has it's own table (i.e. "t_employees", "t_accounts", "t_funds"). However, how would you recommend I setup the relationships between the tables? Assume there are many employees to 1 account, many funds to 1 (employee +...

Hi, Yes I do want a crosstab query, however the "values" are text and rather than summing or counting them, I want to display the individual value as text. Is there a way to do this? Thanks.

Hi, I've created my tables and a normalized efficient way and queries are currently pulling from these tables. I'd like to be to pull in historical data from prior years, but I don't have enough data to create the relationships in the tables to make it efficient. The current format of the...

Hi, I currently have a database that has the following tables: t_Employees t_Cost_Centers t_Changes The [t_Changes] tracks what cost centers the employee is in with a start date and end date: Change_ID Employee_ID Cost_Center_ID Start_Date End_Date I want to run a query that will show...

Thought so. Thanks for the reply.

Hi, I've created a form with a combo box to allow users to set the Manager of an employee. I've set the control source for the combo box to the Managers table that contains a primary key and the manager's name. I've set the bound column to 1, the column count to 2, the column widths to 1;2...

Hi, I'm trying to brainstorm the best way to maintain historical employee information. I'm thinking of 2 different ways, but not sure how Access will handle them. 1) A table that maintains the start and stop date of the relationship (i.e. employee has a job title from a start date to an end...

Hi, I want to query both unique and non-unique values in the same query, without having to create multiple queries. For example, I have a table that contains 1 column of divisions, 1 column of managers (repeating values) and 1 column of employees (non-repeating values). I would like to...

Hi, In Excel Pivot Tables I can move my sum/count values from the column to the row. I can't find how to do this in Access Pivot Tables. To clarify, I currently have: [Column Header 1] [Column Header 2] [Sum][Count] [Sum][Count] But I want: [Row Header 1] [Sum] [Count] [Row...

My company maintains a proprietary database for the information. Employees use this database to make changes to their information. The designers of the database created a standard excel report that can dump the data for manipulation. Unfortunately, I can't get them to create more customized...

Hi, I'm still working on that sales database...and I now ran into an issue with multiple employees per client. I have 2 tables, tbl_Employees and tbl_Clients. tbl_Employees: [Employee_ID] [Employee_Name] tbl_Clients: [Client_ID] [Employee1_ID] [Employee2_ID] Suggestions?