Search results

I have a query that pulls the records by month and year this worked great Query is set up as Field: Month: Format([ErD],"mm/yyyy") Criteria: [Enter Month and Year (mm/yyyy)] Like i said this works great. But I need the Month that is pulled to display in the report header along side the report...

I am having a problem with the code in the Close event on a report when asking the user if they want to view additional reports after closing the current report in preview. Report Closes after the Yes/No answer is selected. If yes selected it does nothing. If No is selected it does nothing...

Is it possable to create a sub form using a single table. I can create one using 2 tables but am not sure on how to or if it can be done using 1 table. All i can find in forum is about multiple tables. Thank you for your help.

Hi All, I’m creating a database in Access 2010 and would like someone look at it and tell me if I’m creating the tables correctly and if my relationships are correct. Those that look at it thank you So much. I’m open for suggestions good or bad. Chuck.

Im using Access 2010 Pro to re-due a 2003 version database. it will still remain an 2003 database due to not everyone has 2010. I have a field that is named FromCustomer field size 6 can contain Alphanumeric information, 2nd field is ToAccount field size is 8 and again it can contain...

I am not sure if there is a forum for Access 2010 they updated my office to 2010, I do not have 2003 any more on my system. I am using Access 2010, I have been told that it is the same as Access 2007. I know nothing about Sql so I am stumbling here. I have created my database and tables with a...

I am not sure if this would fall under Queries or Reports, if it belongs under the Query section of the forum please let me know and ill repost. I am using Access 2003, these are the 4 Numeric fields I’m using. newacct disc dlraccess entdate I currently print a daily report that lists the...

I am using Access 2003, my Program is running great and pulling the information correctly, But when a person selects a command that requires a input parameter value the input box comes up ok, if they decide to press Cancel the program exits and does not return to the last menu. This is all...

Hi All I have a net change per customer for each day which is pulled by date from the Query on my current report, the owner now wants me to add a running total for the month to the same report. These are my fields new _accts dlr_access disconnect My current calculation located in the Detail...

Hi all I have been asked by our company owner to change a daily report she gets which the layout is ok, but when I pull the information from the query the numbers are correct but she wants a daily total for each customer at the end of each customer line, I have placed a text box in the report...

I am trying to place a bar chart in a report but having no luck, I have read through the Access 2003 Bible but it has me lost. My report page gives a total of the following from a Query. In the report header, the data is listed in the detail area. New Accounts 432 Disconnects 56 Dealer Access...

I am trying to pull certain data from a query for a report, I believe it is in the query that I need some help with. Field 1 through Field 7 were field 1 (Dlr_Num) which text and is sorted Descending, and field 7 (dcadmind) which is a data type Yes or No, this information is all based on date...

I have created a report that shows the total of New account and Dlr access account and disconnected account for each day, this was no problem using the text box and ControlSource. But I am now supposed to also add a small section on the report in the header. Which would add the New accounts +...

I have a database with multiple Tables, Months January – December and reports for each month. Currently it totals up the number and type transaction and prints a total of the transactions, the customer number is printed only once with the Sum Total of transactions for that month. I wanted to...