Search results

Thanks so much pbaldy! Saw this link in another post, but hadn't read down to the rare situation part. Sorry for the unnecessary thread!

I understand right off the bat if you're reaction is "don't duplicate data!!" -- mine would be too (don't fret, I know my normalization). I've linked a table in my db to my Global Address Book in Outlook 2007 and, upon entering an employee number as a new record, would like to verify that the...

Hi All: I have split form that has the record details on the top, with a list of all records on the bottom. In the top, there is also a few cmd buttons, one of which needs to become enabled or disabled depending on the record that is selected. Currently, I've got the following code in the...

Just created the test datasheet form like you suggested and the memo field is not truncated. I also tested it with the filter and it did not negatively affect the memo field at all, so I suspect you were correct in your Update2. The reason I liked the split form was because the main form...

Thanks for your response spikepl :) I had reviewed Allen Browne's Truncation of Memo Fields, but then posted here b/c none of the conditions that he describes (totals row, distinct values, formatting, etc.) were met. And for the reason its important, users are selecting all of the records in...

Hi All, I created an electronic document management system (EDMS) in Access 2007. Within the database, users can search for documents by doc number, title, author, mandatory reviewers, etc. I am having problems with the mandatory reviewers field specifically. In the base table...

Hi Ross -- I completely agree with your solution. Ultimately, I don't want to have to distribute new copies of the front-end every time a change is made. And as you said, having the shortcut is a great tool for seamless updates. We had a very tight deadline for getting this db in use for...

Well, I'm sold! You scheme sounds fantastic and I have already started doing some research on batch files to expand my knowledge base in this area. I would love to adopt this process, but can I clarify: Would it be possible to have one batch file located in a shared drive for all users to...

Hi Ross -- yes, they are all using the same .accde file and I agree that the bloating could potentially be caused by many users in the database at the same time. I'm just not sure why it is happening now, after 3 months of the same process being used. As it is not currently affecting...

Hi Nigel -- thanks so much for your response. I've never come across the MS FlexGrid control before. I've just done some reading up on it and I'm certain that my database does not have the FlexGrid attached. Thanks! -L

Hi All, I created a database for a department in our company to track the projects they work on (15+ users). In order to protect the data and design, I split the database and also created an .accde file for production that the staff use from a shared location. Today, I noticed that the...

Re: SOLVED - Text Field in Report Showing as Number Hi all, Just wanted to close out the thread as I discovered what the problem was. To determine whether the problem was occurring in the query or the report, I created a form based on the query and the Equipment Type text appeared...

I don't see why it is displaying the text as numbers either -- I've never experienced this problem. To my knowledge, there aren't any special properties on the Equipment Type field, but I can't get it to display the results as they appear in the query. I've attached screen shots of the design...

Hi Ted! Thanks for your reply, but my text field is indeed formatted as a Text Box. Just in case, I did a quick check and changed it to a Combo Box to view the properties, but they were set correctly. ColumnCount = 1 BoundColumn = 1 ColumnWidths = null (default) -L

Hi All: I have a report that calculates equipment totals for the month and is grouped on Equipment Type (Text) and sorted by Equipment Name (Text). The report is based on a query that returns the results exactly as I want them; but for some reason, the report is showing the Equipment Type...

jzwp22, thank you so much for your help! I re-created the query and changed the relationships to LEFT join and everything is working beautifully. Not sure why I was experiencing the error on the other query... Sometimes the problem is so big, you don't realize that the answer could be...

No problem. I can provide an outline of the tables and fields. :) If absolutely necessary, I can compact and zip, but I'd prefer not to have to remove all the sensitive data, plus there are multiple BUs in the db that track their own projects differently, so there are a ton of tables and queries...

Hi jzwp22! Thanks for your response. I tried changing the join types in the query as you suggested. When I select the left join (#2), I get an error that says: The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first...

Hi All! I have created a project tracking db for a business unit at work. They use the db to track each project's details, as well as info from three categories (equipment, stock and labour). In the background of the db, I have calculations for the month-end reports that take the equipment...