Search results

I have a description field that starts with a basic name of an item followed by a comma and the more descriptive text. I would like to return everything before the comma and truncate the rest. I can do this in Excel with: =LEFT(A1,FIND(",",A1)-1) but Access doesn't recognize Find. Thanks...

Hi, all. I really don't know where to start with this. I have a database I use to check compliance with certain items. An auditor goes to a division and asks some questions, taken from the database, and enters a compliance level for that question. When the auditor enters a response to a...

Hey, guys. It's been a while, but guess who needs help again. I use the form in this db to select search criteria for the subform. I have another db that uses a form similar to this with no trouble at all. I got the code from some one here and it works great in the other db, but no matter...

Can some one direct me to some information on the best way to set up form filter. I need to set up a form so that it looks like a search form. I need two, maybe three fields to drop down, choose the value and then show me the related records. I have an action item database and i want to...

I have a form that users use to input new report information (tblLog). Each entry has a 8-digit report number (PK) based on the following convention, given 12345678 as a hypothetical report number: |12| = the site code |34| = current year |5678| = next report in sequence from 0001 - 9999 Up...

How about this? If I link from one database to another db, the second db window is half-size. I would like each window to max when it opens.

I have a form that when it opens runs an append query. I would like it to skip this step if the query is empty, which it will be most of the time. What do I key on? Search hints? Taunts?

I have been in the habit of using lookup fields liberally, but have noticed the you more advanced folks don't. I was just reading on another site about the 'evils' of lookup fields. Why is it better to enter these as a value list from your main table? Say is I start with a list of 5 topics...

I have a form that pulls data from a union query. It also gets data from a few more queries, all with different criteria. Initially, i made the union query with the statement 'UNION SELECT', but one machine in our group kept getting the error message 'can't use a memo field with the SELECT...

Is there a way to block users from entering a database by holding down the shift key and getting to structure stuff?

I have a table with some contact information. One piece of info is a file location. As part of my process, I generate a note with this file location in it. I set the field up as a text field because in the note it becomes an active link. For example, I have a database in...

I have a database that links to tables in other databases. I then pull that data together with a union query. This all works fine on my machine and on another machine in our group, but on the machine it really needs to run from, I get the following error message: Cannot use Memo, OLE, or...

I have a union query I am using (for now) to combine several tables. If you would like some background on the setup, read this: http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=169358#post169358 I query this union for counting three items: Findings, Resolved Findings and...

I have a numbering question. In my database, I generate a table from a query. Right now, I am using the autonumber property as the unique ID. I would like to concatenate three fields to create my own ID still unique. I want to join a Division ID (ABC) with the year from my date field (yy)...

Hi, all. I have a report that lists items that are overdue. I would like this overdue report to be emailed to the responsible person on the due date. I have a macro that will handle the email portion and I am using Task Scheduler to open the database daily and I have a report that lists items...

In my assessment database I have a DueDate when resolutions for findings during an assessment are due. I would like an email to be generated as a reminder 30 days from the due date. Any ideas? Thanks.

Sorry for the cross posting, I intended to post it here in the forms forum originally. I would like to populate a date field across a range of records by entering it one time. Any ideas? Thanks.

I would like to populate a date field across a range of records by entering it one time. Any ideas? Thanks.

I have a button on a form that when pressed closes my form and sends a report to email recipients. This works great the first time, but if I reopen my form and try to send it again either nothing at all happens or I get a SendObect error. Should I have something else in the code to clear it...

I have to thank you guys right off the bat. I have been searching for a way to fill one field based on the value of another and found that answer here. So, I decided to join in. This is that best source of information I have found for Access. Many pats on that back to the founders! Now...