Search results

Hi, I'm trying to calculate the percentage change between records/rows. I've searched around the internet and found 2 possible examples, but they are very specific to the individual's database and I'm struggling to understand. I was hoping someone could help explain. Here are two examples...

Hi, I created a report that only has gridlines around the outside border of the entire report (rather than around each record). I want the grid line style on the last/bottom record to be solid so it boxes in all the records. When I change the "Gridline Style Bottom" for the records, each...

Hi, I created a nicely formatted report, copied it and made a minor change to the new version. I then deleted the old version of the report, and the new version has lost all formatting. It looks like the basic report you get when you select a query and click Create -> Report. Is the new...

Hi, In Excel there is a common issue with precision vs. iteration when carrying calculations through multiple formulas. Excel has an option to adjust for this. I'm experiencing the same issue between Access' queries and reports. I have a query which calculates the percent increase between...

Hi, The data within my tables is formatted correctly and when I run a standard query on the data, it comes through the query with the same formatting. However, when I run a query that needs to total the values (whether it's sum or average) the values lose any formatting (and by total I mean...

Hi, I'm trying to create a report that has certain rows filled with a background color. In excel, the fill color is complete across the row. That is, there are no gaps between cells. In Access, each individual "cell" or field is filled with the color but inbetween each cell/field there is...

Hi, I'm attempting to filter my form with combo boxes. I've added the below code, but the if statement that checks if one of the combo boxes is null won't work. If the combo box is null or "", it's supposed to assign a wildcard to the variable. But it doesn't pass the test and goes straight to...

Hi, I'm trying to create a continuous form that allows users to filter. There are 2 combo boxes, "cbo_Field" and "cbo_Filter". I want "cbo_Field" to be a list of the available fields to apply the filter. I want "cbo_Filter" to be the value that is filtered (with wildcards at the front and...

Hi, I'm trying to run a saved import through VBA, add a new column called "Effective_Date", then update this field for all records to the effective date indicated by the user. It currently works for all records except 1 is always ommitted. Any help is appreciated. Private Sub...

Hi, I have several queries that perform an audit on data. I want to create a form that has two buttons, multiple labels and textboxes. When the first button is pressed, it runs all queries and returns a count of the records within each query into the corresponding textbox. Then I want a a...

Hi, I'm attempting to create an append query that will add new records only if there isn't an equivalent record already existing. Typically I would add the existing table to the query, and only add new records if the same do not exist. In this case, the table is maintaining records over time...

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

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

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

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