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

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

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

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

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

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

I'm trying to create Avery Labels using the reports in Access and have hit a bit of a glitch. There are several fields where I have to put a Label in front of the actual field so that folks looking at the label know what the value ties to. So I have a label PKG in front of a field called...

Splitting / Breaking One Field During Export :confused: :confused: I have a bit a a quandry. I'm trying to figure out a way to Export some information from a Database into Excel so I can load it into a label printing program. My difficulty results from my need to break the "FileTitle" field...