Search results

Thanks. I don't know much about macros either, but I'm trying to tweak a template that uses them. The FilterOn property set to false doesn't seem to do the job.

What is the macro command for removing all filters from a form? I tried "ShowAllRecords" but this doesn't seem to do the trick. Thanks much.

Is it possible to capture a form's filter? In Access 2013, I have a form (from a template database) listing contact information. I can set filters by clicking on the column headers and selecting which records I want displayed. There is also a button to run a mail merge with Word. I want the...

Is it possible to format values in a combobox so that some are in bold?

I'm trying to modify a MS template that has the following code: OnError Next RunCommand SaveRecord MsgBox =[MacroError].[Description],Yes, None, StopMacro OnError Fail, OpenForm Contact Calls Details, Form, , "[ID]=" &...

Thank you so much Bob. I'm going to find out how the user (there's one that primarily does this step in the process) would approach this and then try to design something around that. I've learned that how I approach a process may be very different than the way a user may. I'll let you know...

Not sure if this direction will work. My form2 has a combo box for a name and then a combo box for a room assignment, and both values are required. When the user clicks on the "name" combo box and doesn't find the name wanted (and therefore it has to be added to the name table using the name...

So, if the names form (form1) is already open, it will shift focus to it? I add the refresh/requery of the combo box on form2 to the close event of form1 (after determining if form2 is open)?

Thanks Bob. The user knows that if the person is not in the dropdown list to open up form1 and add the name. The second form (with the combo box) remains open. I'm looking for the event that will refresh/requery the combo box on the second form.

I have two forms: (1) List of names (2) List of events A person is added to an event on form2 using a combo box with a row source being a select statement from the table of people. When the user wants to add a person to an event, and that person does not yet exist in the table of people, the...

Thanks! I'll give it a try.

Thanks pr2-eugin. I've discovered that Access 2007 has a wizard you can use to set this up. "Collect Data." Would you possibly know if the code is available to customize? This process is what I am interested in, but I don't want to have to go through the wizard each time. Thanks much

How would I set up an Outlook email using a list of recipients from an Access table? I'd like to be able to run this from Access 2007 and not Outlook. However, once the email is set up, I'd like to be able to go into the email and add subject, body, etc. before sending the email. Thank you.

I have a report bound to a query that includes zip codes as a field. Zip codes are formatted in the table as 99999-9999 and display in this format when the query is run. However, when I place that field in the report text box as =[ContactCity] & ", " & [StateAbbreviation] & " " &...

Got it. Used the Replace() function.

Examples: Joe's Bar, Henry's Café, Women's Club...... When these values are picked up into the INSERT statement and run, it causes an error.

I'm using an INSERT statement which includes a text field that could have commas. INSERT INTO tblTEMP (Name) VALUES ('" & nRname & "') Is there a way to format for this? Thanks!

I have inherited a database with, among other tables, one table of rooms and one table of room reservations history. For some reason the table of room reservations history has a foreign key to the room name, not the room "unique ID" (primary key). What would have been the reason for...

We've been told by the network administrator that the users who were not able to create a lock file on the network server did not have share permissions to this folder. Once this was corrected, all is well. Thanks!

The message that displays is "cannot use ___; file already in use." So it's a file locking problem. It happens as I mentioned in my first post.