Search results

Hello and Happy New Year. I'm using Access 2007 and need some help, please. Is there a way to use VBA to prevent the user from being able to drag the filter selections when in pivotchart view? I require the user to be able to still filter but prevent them from dragging the field away. Any and...

This is one of those probelms that I really thought I could solve myself. I have to admit that I am stumped. I have a button on my main form called "TestForm" with a record source from a query named "MonthlyPaymentDue". On my form is a button that when pressed executes a loop. I want the loop...

Hello, Is it possible to do a find and replace using VBA or SQL. I would like to be able to replace fields (the attendee's name) in my attendance_table. Each attendee's name appears multiple times in the attendance_table, so I am thinking that a loop would be the answer but I do not how to do a...

I would like to know if it is possible to have a query automatically run on the first day of each month. I want to be able to enter data into a table automatically using a query on the first day. I would prefer not to use Windows Task Scheduler as I will be distributing this database and want...

Hello, Thank you for your time. I want to set up an automated recurring monthly invoice for clients in my database. I know this is possible but I am having trouble finding the solution and in fact having problems how to search for a solution. On the 1st of every month I would like to have a...

Hello, I have been searching for the solution to this problem for a while with no luck, I have a form where users can edit data. One of the fields is PaymentAmount and I want to enforce that users can only enter numbers (no letters). Can someone please show me how to do this? Also I have a...

Thank you in advance: I have a form in my Access 2007 Database. It is a payment received form and asks the user to select a customer, declare what the payment is for, payment date etc. One combo box in my form asks user to select how the customer is paying. On the after update of this combo...

Hello, Is there a way to have a message in my combo box that tells user to please select from list. Any help would be appreciated. Rob

If I have a Cancel Command button on a players contact form. Is there a way to overide the code that requires a data entry in the playername text box? Basically I need a "way-out" for the user if they open this form by mistake and need to go back to the switchboard. Right now I can exit the...

I have a client contact information form which requires the user to enter details about the tennis player. I want to ensure the user enters the name of the new player on the form and for the user to not be able to exit the form unless a playername is entered. I have the following code on the...

I have a client contact information form which requires the user to enter details about the tennis player. I want to ensure the user enters the name of the new player on the form and for the user to not be able to exit the form unless a playername is entered. I have the following code on the...

Hello, I am going crazy! I have managed to do this in a previous database and now I can't remember how I did it. I want to create a shortcut menu for a report that when I right click the mouse button it gives me the option to print. When I select print on this shortcut menu it goes straight...

Hello all, This forum has been a lifesaver in the past and I hope someone can help me now. I have a Contacts form that is used to input all the client's information. (name, date of birth, address etc). I want to be able to force the person entering the data to not be allowed to tab to the 2nd...

Running Sum Blues!!! Hello, I have a report which is similar to a bank statement. I have a transaction date and then either a credit or debit depending on whether the customer made a payment or if I am invoicing them...

Hello, I have the following code to send a report via outlook. Private Sub OLEUnbound238_Click() DoCmd.SendObject ObjectType:=acSendReport, ObjectName:="Statement One Player", OutputFormat:=acFormatHTML, To:=Me!Email, Subject:="Rob Nickels Tennis", MessageText:="This is a friendly reminder...

I am trying to create a new macro in my database. I selected the Openform action and tried to choose the name of the form but when I try and select the name of the form from the dropdown menu, I receive the following message: THE SEARCH KEY WAS NOT FOUND IN ANY RECORD. I am not able to see any...

I have entered the following code to an onclick button. I am sure I have written it incorrectly (it's probably the line I highlighted below to do with username=Manager. By the way Manager is one of my usernames I have created. Thanks for your help. Rob Private Sub Label218_Click() If...

Hello, I thought of a possible way to solve the problem of the annoying msg box that appears when a user tries to open a form when the administrator has not granted permission. (The problem with the message box is that the user has the option of clicking help and I don't want this) Could I...

Hello everyone. Not sure if this is possible...but I hope it is! I have created user security with limited access for specific groups to certain forms in my database. However, when a user attempts to open one of the restricted forms a Generic Microsoft Access Message Box opens. Am I able to...

Please please please! It's driving me crazy! Is it possible to send e-mails to all of your e-mail addresses in one single e-mail? Right now I am able to open up an individual e-mails for each of my stored e-mailo adresses but it would be so much better (and more user friendly) if I could just...