Search results for query: *

i want to make a report that sorts by the name of the person and then by a check box. i have tried to sort by the name and it never works right. i have seperate tables for the name.

i added a check box to my form to check off when a job is completed. i want the data that shows in the table to be a 1 for checked and a 0 for not checked. right now it comes out as a negative or a positive 1. any thoughts?

does anyone know of a way to make a field reference in word? or do i have to create an excel chart in word?

i am having tremendous trouble formating a pivot table form in access. i have to do my reports this way for my boss. its easier to control the amount of data in access. when i load a pivot table in access 2000 once it gets to the excel wizard it only loads 16 million or so records before it...

ok i am creating a pivot table in access 2002. is there a way to format it so there are percets and so you can turn the row headings facing up instead of horizontal?

i am setting up a pivot table form that has severale tables involved. everytime i go to setup the pivot table excel gives me the error message that i don't have enough memory. i have 384mg. i know excel can only handle 16 million records. is there a way to change that or am i going to have to...

i was trying to combine tables to make a pivot table and when it was counting the records to create the table excel comes up with an error "Not enough memory" any thoughts on how to change that? i have upgraded memory and shut off everything on my computer except access and excel.

does anyone know how to copy a pivot table form and change the data range?

is there a way to add scroll bars on the side of a form for a pivot table to view the bottom of it. in the design mode i can see everything, but i need the scroll bars so in normal mode.

i finally got my pivot table to work, but after i have followed the wizard and made it look how i want it won't display in access. its like it clips the edges of the table. i have changed everything in propertied in the access form and nothing changes it. i have changed the size of the object...

i setup a pivot table form and none of my data is in it. i setup a sum of all my fields and everything comes up 0. when you double click on a cell it displays the records that are suppose to be in it. what am i doing wrong? i have been making pivot table in excel for years. this is the first...

i am setting up a pivot table form and every time i set it up there is no data in the table. yet when i double click on a cell in the pivot table it will display all the records that fit into that field. any suggestions?

can you have more than two filters on one form? i have one and i need to add two more. when i added the second filter it popups to ask for the info ok, but it says i have syntax error, but the code is written the same as the 1st filter. can anyone help. Here is the code: Private Sub...

my boss is used to looking at a pivot table from excel for his reports. we have moved our database to access because of the amount of information. i have tried so many different designs of reports is there a way to setup a report to resemble that of a pivot table from excel?

i am looking for a way to copy down information in an access table that is the same.

is there a way to fill a column with the same information. i have tried everything from highlighting and pasting, changing settings; and i still have to fill in the same info by hand. any help would be great.

i have several tables setup for the same data for multiple months. i need to run a report on this information. i have tried to setup a query, but it won't let me divide it just by the salesrep it wants to take it all by the individual tables. i need the totals for all of the tables combined. is...

i have several tables that keep track of individual programs that are running. i need to run a report on for info on all of the tables any thoughts?

i have a text box on a form that won't let me add more than 50 characters. i have set it to yes in can grow, but that doesn't change anything. i have checked out every setting in properties and there is nothing set to this in visual basic. i tried to add an unbound text box and it didn't work...

i have a database that i add the same type of fields for every month. i am using the same report and form layout each time i create a new table. is there a way i can creat a template and just use that and change the table or do i have to continue to create it manually?