Search results

I'm using an Excel spreadsheet that is importing external data from an access database in which I've got a field where the name of a person checking materials out is entered. it is currently set up, and I cannot change it, as a free form field. So folks enter information in a variety of ways...

Still Can't Figure This one out Anyone have any other ideas? I am totally stumped on this one and my boss really wants a custom report that includes that piece of data. Thanks!

Curiouser and curiouser... Changed the name of the module so now the query will run but I realized it's giving the the total count of all documents in the collection rather than what I want which is: Park Total Jellystone 20 BigMountain 15 LittleMtn 10 and so...

Hi thanks for the quick feedback. Unfortunately that didn't work either. When I cut and pasted your text and tried to run the query I got an error message. Then if I remove the "red" comma it goes back to the "undefinded function 'ECOUNT' in expresion" :confused: Should I perhaps give the...

Not sure what the difference is? I clicked on the Modules tab in Access. Then said, "New" which took me to a VBA editor window where I then "pasted" the code verbatim. Thanks, C.

I've got a database that I've "inherited" that tracks various documents. Each document has it's own unique ID. However the database was set up such that rather than having subjects linked in a parent child table, all subject records are in the main table so I end up with something like: DOCID...

Weird...I't working again... Tried the References suggestion. None said they were missing so tried the thing about marking and unmarking one and that seemed to work. Very weird. Thanks everyone for all your help. Once again this forum ROCKS! C.

Thanks for the suggestions, Moniker. Unfortunately, that didn't work so evidently that's not the problem. I still got the same "type conversion error" "Project Title line one: reduceit([DSC]![FolderTitle])" is a calculated query field value with the column heading of "Project Title Line...

Access 2007's answer They have set access 2007 to have this as a default, so if you are like me and use mouse to scroll between records you have to write a module to turn it back on. ARGH!

:eek: Way back in 2004 this wonderful group helped me create a module that split a long folder title field into two smaller chunks that i could export into my label software. Unfortunately now it's not working anymore. My query field headings look like It's been working wonderfully for all...

Sort of... Right now I have my tables like this: Table!Records ID....Sender.....Date.....Subject 1 Mary 2/11 BlahBlah 2 Sally 2/12 YakityYak Table!Recipients RecordNo.....Recipient 1 Tom 1 Dick 1 Harry 2...

Working Now I tried your suggested fix, Rickster and no luck. However, I went in and on page size in layout I had a choice of "Letter" or "Letter 8 1/2 by 11". It was set on "Letter 8 1/2 x 11" so I changed it to just plain "Letter" and voila it is fine now. Wierd, very wierd. Thanks for...

I'm working with a database that that tracks records sent to various users. One table contains the information on the record (sender, date, subject) and it links to a table that tracks the fact the record 1 was sent to person X, Y and Z. My problem is that I want to build a query that will...

I'm running into a bit of a problem. When I go into print preview for a report it displays all scrunched up (shrunken and way to the left side) but when I print the report it comes out like it should. I've checked page set up and it paper size is set to 8 1/2 x 11 like it should be. I've...

Neither aaaaaa or AAAAA solve my problem. They both allow the user to enter a blank space into the field. I want them only to be able to enter letters or numbers. There cannot be any other characters or blank spaces in the field. Also AAAAA makes that many characters required and the number...

I'm trying to figure out how to validate a field to make sure the users are not entering any blank spaces into the field. I've tried setting the mask up as "aaaaaa" but it still lets the user enter a blank space. I've also tried building an event procedure to run on exit that reads: Private...

I've got a database with a field PKGNum, that was typically a three digit number, that used to be the primary tracking number for each project. You could have the same package number for multiple customers. About two years ago they began to use what they now call a PMIS number which is a unique...

I've got a database with several users and we've had two people recently who rather than creating a shortcut to the db on their desktop copied it and then proceeded to enter their data there instead of into the one on the network. I would like to be able to add a field on the first page they...

Thanks Peter I think that might just be the ticket.

I have a field in a database that needs the data entered without any spaces and I'm trying to figure out how to set either the validation rules or the masks so that the system will either automatically delete any spaces or warn the user not to enter them. My preference would be for them to...