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...

Many thanks to PBaldy for the solution. Here is the working code now. Private Sub Click_Click() Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim sToName As String Dim sSubject As String Dim sMessageBody As String Set MyDb = CurrentDb() Set rsEmail =...

pbaldy, That you for taking the time to look at my problem. I have added a new unbound text box as you suggested, but it seems to me the text box isn't being updated with the rsEmail!PlayerName data, So the loop doesn't run because the report then has no Player name to link it to. I hope that...

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...

thank you for your time...in the vba code you say "code to create invoices goes here" Can you give me an idea of sample code. Thanks again

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...

Thank you Thanks, the numeric only for the paymentamount field works great but I am still struggling with enforcing the date field. I need some sort of validation rule on the field itself. I get a generic error message if I don't input he date as (xx/xx/xxxx) but it does not hold the focus to...

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...

ShaneMan Thank you so much for your help! Go Buck Eyes.

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...

Thanks Pete Thanks Pete, I have a follow up question. If I have a Cancel Command button on the same players contact form. Is there a way to overide the code that requires a data entry in the playername. Basically I need a "way-out" for the user if they open this form by mistake and need to...

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...

thank you thanks for your time!

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...

Sorry, I don't know what you mean by a boolean! Hi, I am sorry but I am not aware of what you are referring to. Would this bypass the onexit and beforeupdate vb code from my text box?