Search results

Aside from the Typo, Strings need to be enclosed in double quotes. This means the Employee field values. So that part of the SQL query would look something like: "WHERE [tblRecommendedProducts].[Employee] = """ & [Forms]![frmClientSale]![Employee] & """" & Basically, when you want to do a...

You typoed. The field in the table is "ItemID" whereas your SQL statement is looking for "ItemsID".

Try something like this. In the Properties of the combo box, look for the After Update event. Use Code Builder/VBA: ' Replace ComboBoxName with the name of your combo box. Private Sub ComboBoxName_AfterUpdate() ComboBoxName.DefaultValue = ComboBoxName.Value End Sub See if that works.

The simplest approach, if I'm understanding you correctly, is just If IsNull(Grade 3) Then txtAverage = (Grade 1 + Grade 2) / 2 Else txtAverage = (Grade 1 + Grade 2 + Grade 3) / 3 End If It's not terribly robust though. You can put this as the OnClick event of a...

I guess the use of the term 'merge' is confusing me a bit. I'm not sure whether you want each volunteer to get an email with their personal timetable or if you want every volunteer to get the same schedule that covers everyone's roles. Assuming the first scenario, you can actually just make a...

I think it's unlikely to be your DLookup function. It's possible that there are line breaks, tabs or other things in your database fields that are causing the "#mailto:" to be hidden. Make a copy of your database and try this out: Dim r as DAO.Recordset Set r = CurrentDb.OpenRecordset("SELECT...

I've built an Access 2007 application that lists our company's suppliers and creates purchase orders. In this application, I want to allow different users access to different things. Some of the things that I want to control access to include: adding suppliers deleting suppliers, editing...

For your situation, I'm assuming that you are talking about department managers. I'm also going to assume your manager is listed in your Employees table with their department listed. If so, your Login table may only need a Primary Key, Login ID, Password and some way of linking the Login PK to...

Try putting in the line: Debug.print Cusemail after giving it a value, for example after your Cusemail = Nz(Dlookup...) line. This will print out the value given to Cusemail in the Immediate Window (press Ctrl+G to open the immediate window). You can also test out SendObject in the Immediate...

Sorry for the late response. The website wasn't responding for me for a few hours before I left work yesterday. 1. There's a bit over 300 rows. 2. I haven't explicitly set up something to be used as a key. I could though. I actually managed to make something work with your suggestion of using...

Just to make sure, but did you replace 'subForm' with the name of the control on your main form? It will generate such an error if you didn't. To give an example, let's say you have two forms called frmMain and frmAC. You create a subForm in frmMain linked to frmAC. Now you click on the...

Yes, you're right. To elaborate a bit, it's a search form where I have some Text and Combo Boxes on the main form as well as a few continuous subForms that display the records, filtered according to the controls on the main form. But due to page-size restrictions, I was asked to reduce the...

It could be the UAC that was introduced with Windows Vista/Server 2008 that requires elevated privileges to run almost everything. Have you tried right-clicking the Access program and using Run as administrator?

I'm not completely sure if I'm getting it right, but are you making a search form for AC cards, something that would look like this? [cboCompany] [txtDate1] [txtDate2] [ Filtered multi-item results ] [ Filtered multi-item results ] [ Filtered multi-item results ]...

Hello, So I'm working on an Access 2007 application for my company's suppliers list, but I am restricted to using a single Excel worksheet for the back-end. One of the fields, called [Files], is a list of files in .pdf format related to a supplier. The number of files can be 0, 1 or many. I...

Thanks for the response. I think I'll try out this solution, although I might need to find something that lets me automate the process since data entry will eventually be handled by other people. Perhaps I'll give geocoder.ca a try.

Hello, I'm currently working on a small database for my company containing a list of suppliers/services and their information. One of the information fields is a distance field, which allows people in the company to search for approved suppliers/services within a certain distance from the...

Hi there. I'm a new member to Access World, although I've already gotten a lot of help in the past from reading posts here. Rather than a programmer, I'm actually a mechanical engineer just out of school, currently designing plastic molded parts for an automotive supplier. I do get asked to...