Search results

Thanks OH! I never scrolled down the page before. I didn't know there was an Excel specific forum. Thank you. Sorry to be wigging out in the wrong forum. lol PB

I've figured out how to delete all existing charts but when the chart generator names a new chart, it still uses the old chart count. I'm outputing the chart count to a msgbox and it say 0, and when I output chart name to a msgbox it say (chart so and so) depending on how many times I've run...

Hi, this is actually an Excel question but I believe a great deal of the programming is the same as Access..... I'm generating a graph in a spreadsheet. (using the handy dandy record macro function... it writes code for me...) The graph must be resized to fit the format of the page and when...

Thanks Thank you so much, all. I'm learning tons from you. PB

Hi all. Can anyone help with this? I am launching a form at database startup. No problems there. It starts the form and displays record one. I was wondering if there was a way to get it to jump to the empty record at the end of the table so they will be where they need to enter new data,(to...

Never mind. Got it!!!! Thanks everyone, but I got it. PB

Hi, I've got an autofill issue if anyone can help. I've got a Form called EntryForm. One field, called CBT Exam Date, is entered. Another field called, Anniversary Date, should be autofilled depending on the date in CBT Exam Date. It should be three years minus one day from CBT Exam Date...

Thanks Thanks. This stuff is really easy, but not very intuitive. There are soooo many capabilities and topics that it's nearly impossible to sort through all of the documentation. I'm embarrassed to ask some of these questions. Whew. Anyway, thank you. PB

Hi, all. That's about it. How do I tell Access to launch a particular form when the database is opened? I'd appreciate any help with this. PB

Repeats Don't know what happened, maybe a stray mouse click or something. Wasn't meaning to repost. Thanks for all your help. PB

OK Great, now here's the stupid question. Where do I put it? This is the example in the dateAd function = DateAdd("d", 30, [OrderDate]) where order date is the base date Where do I put this???? Thanks again for your assistance. PB

OK Great, now here's the stupid question. Where do I put it? This is the example in the dateAd function = DateAdd("d", 30, [OrderDate]) where order date is the base date Where do I put this???? Thanks again for your assistance. PB

Hi, I have two date fields next to one another in a database, one is always variable so must be entered but the second is ALWAYS 3 years - 1 day from the first. I've been asked to have the second autofill after the first is entered. Possible??????? Thank PB

Nice, thank you Thank you, looks similar to ASP. This is almost a rheatorical question, Why do I need to declare a database and set it to current when I'm "IN" that database to begin with??? Just a Microsoft quandery....... Thanks so much for your help. PB

Hi all, I'm trying to write a macro or module that will: 1) Run a query and 2) Step through the record set using the results as the basis for the next set of queries. Any suggestions? The macro builder builds the first one fine but I didn't recognize any options in the drop down lists for...

Thanks so much That was simple, there's just So much documentation it's hard to find what you need. Much much appreciated Patrick

Access has a very nice query builder but I can't seem to find a place to just type in SQL. Will Access let you do this? P

GREAT GREAT! Thank you so much. Just for future reference, where would you look something like that up? Most tutorials I've seen never get that far. Again, much appreciation. PB

Hello, I am trying to write a simple piece of code for a database that is just an employee info store. I am told to have a window pop up asking for the last name of the employee and have the record set displayed or a message displayed if not found. I come from a linux back ground so all this...