Search results

Hello everyone, I was wondering if someone could explain to me as to when I create a form and add an Option Group it takes me through the wizard setup but when I try and add and Option Group to a Data Access Page it doesn't appear as though I can configure the options. How do I do so on a Data...

I have a report that I need to run either once breaking by each department or individually for each department. Once the report(s) are run, there is a table with a specified email address for each department. I would like for each department report to attach to each corresponding email...

thanks for the response but... Thanks Smart, unfortunately I could be appending 50 invoices to the table at once and would like them all to have the same batch number not individual id's (already have that). But I have high hopes you know another way. Thanks, Jim

I have a table which records are appended to in batch format. I would like to update a column called batch number for newly appended records with the Max of that column + 1 but I keep getting errors such as "operation must be an updateable query". Anybody have any suggestions. Mind you I am...

I know you're all very busy, I am just under a time constraint here. Any thoughts?

Perfection!!! This is exactly the functionality I needed. Thanks, Jim

Close Maybe I was a little unclear as to my problem. The sample you posted duplicates an entire record. My problem is within the form, as I am entering data, there are two "sets" of address fields. After filling in the first set, street, city, state, zip, I would like to click a check box...

I have a form that enters in Bank Information. On the form there are two sets of address': "Physical Address" "Mailing Address" PA_Street MA_Street PA_City MA_City PA_ST MA_ST PA_Zip...

I know this has been posted several times, and I have tried to utilize the code and just replace with my pertanent info, but I have been unsuccessful. Using the button wizard on a form and have created a button which will run and create an email to send the report. The qry which runs the...

Thanks so much!! To JFGAMBIT and DOUG, thank you so much for your help!!! I always find this sight to be tremendously helpful and am so thankful that folks like yourselves take the time to help us hack/wanna be's!! I have my first and last names now! Thanks again, Jim

Thanks so much this is great! One problem though.....It worked beautifully to get the FirstName, but when I tried the LastName code it kept giving me an "Invalid procedure call" error. All I did was copy and paste your code and put in my column name, this is what I have...... LastName...

The problem is, if I am reading your code correctly, the comma isn't always in the same place. The length of last and first names are all different. I'm probably not understanding. I tried copying and pasting into the "builder" but it didn't seem to work.

I am hoping this is fairly easy for some of you extremely smart folks. Here is my problem. A person originally create a "Name" column in the format "last name, first name". I would like to create two new columns, "First Name" and "Last Name". I am looking for a function to give me everything...

More questions You're correct, my mistake, I meant list box. Unfortunately it looks like the thread you referenced didn't end in success. To be honest that was a little complicated for me and would need that broken down into a little more basic (like copy and paste to a specific area)...

I replied to an old thread and was just concerned it wouldn't get noticed. If anyone can help with the below listed it would be greatly appreciated. This is fantastic and have utilized this, but now I have an additional question. First, when I want to change the combo box property to support...

This is fantastic and have utilized this, but now I have an additional question. First, when I want to change the combo box property to support multiple clicks (this I know how to do), but what should the criteria field look like to support one, many, or all values selected. Again, if...

I have a macro that I would like to run once a week and have it kicked off at a certain time each week. Help. Thanks, Jim

I have a form that is set to open upon the opening of the database as my startup screen. How do I make it so the form is the full screen. Nobody will need to see the database behind the startup form so they don't need to see the command bars. Thanks, Jim