Search results for query: *

hi everyone... i am having a problem importing a certain table in access. everytime i try i get the error "search key not found in access". i have tried the compact & repair,but that does not work. any other ideas??? thanks schmals [ponytails]

Hi! I am running a report sorting by date. When there is no date available, the field is left blank. When i run the report, the info that has dates appears, but the ones that are left blank do not. How can i make those fields blank appear in the report... thanks schmals[ponytails]

i am trying to run a query where there are some zeros in one of the columns. when i run the query, it only shows the items that have numbers, and the zero rows are gone. is there a formula i have to put into the table or query to avoid this?? thanks, schamls [ponytails]

hello everyone... got a really quick question... i have 2 queries that i need to put into a report. the report wouldn't let me use both queries, so i combined both queires into 1. i have a few columns, 1 i have specified product #'s (10 out of 20) and the other i need sales $. what would be...

At the company i work at, we have to track our incoming products. Right now, my boss puts it into an excel spreadsheet and then i inturn retype it and put it into a word doc. (calendar template). does anyone know if you can go from an access database to creating a "calendar". or if...

I have created a report in access. I am having trouble printing this report. Sometimes it works when i go into print preview, and print from there. Other times it will print 5 out of 15 pages, or go to 16 of 15 pages and not print everything and i will get errors on the last few pages. I have...

Hello Everyone, quick question, i am trying to create a query in access when i notice that i need to filter/omit certain lines. the problem is that in this column are id codes, that do not follow a particular order (ie. 1-200). they are things like wxy342 or credit. is there an easy way for me...

hello everyone.. i am trying to run a report in access.. when i go into the print preview, sometimes it works, and other times it prints errors on the page.. also, when i print, sometimes it will skip pages (ie. print page 9, 10 , 12). now i am getting a "microsoft overflow" message...

Schmals (TechnicalUser) Nov 26, 2002 vince, I am actually copying the tables from d-base III into access. then creating a query from 4 different tables, but no filtering. i just have the one column that has text 01-12 and the other column is text 00-99. i am not positive that it actually...

hello everyone, i have created a report in access and i have included parameter values for the dates. when i open the report, it asks for the beginning month, ending month; then beginning year, ending year. i have the month in one column, and the year in another column, but it is in numberic...

I have no idea why i keep getting a runtime error. this usually occurs when i am on-line. then as soon as the message pops up, i go into some kind of debugger...then i have to keep hitting yes, yes yes, then i get bumped out of the interent! any help would be appreciated!!! [ponytails]

I am currently running a report in access and i need to exclude a line item in the table... any suggestions? i thought i had to do a filter in the query, but that didn't work...[ponytails]