Search results for query: *

It's been a long time since I've been in VBA. Working on a page that creates SQL code for me. Because of that, I would like to have the cells with field values I'm inputting automatically add backslashes before single quotes. I've worked on some code that does a simple replace of ' with \'...

Its been a couple years since I put an Access database together, and am working on a very simple one right now. This is super easy, but something is stopping the calendar from working at all. With a textbox of StartDate and Calendar control of Calendar1, this is the simple code: Private Sub...

I'm having difficulties changing the input of a merged document. I have a form in MS Word 2003 that is connected to an Excel DB. A field in Excel is "True" or "False". When I merge this document into the Word table, I would like for a formula to indentify this value and present either an "X"...

I imagine this is as simple a question as it gets, but since I've never had any formal training, I don't know how to do this. I have a query called "AmountDue". It has only one result in a field called "Total". The query is designed to sum up all values involved in a...

I've recorded a sort into a macro and then placed into code so as to allow me to easily perform a sort and then an "un-sort". When I perform the sort manually, everything works great. When the sort is repeated by the macro, I get a "Z" in the top-left cell of the sort...

Here's a question that I could REALLY use help with... I have a matrix with about 20 columns and 500 rows. The values inside the matrix has been given different background colors to provide a visual indicator as to what type of value they are. I have Red, Yellow, and Green cells. Problem...

Here's a question that I could REALLY use help with... I have a matrix with about 20 columns and 500 rows. The values inside the matrix has been given different background colors to provide a visual indicator as to what type of value they are. I have Red, Yellow, and Green cells. Problem...

Rather than trying to use words, below is an example of my problem. Query 1 Results: Column 1 Column 2 Column 3 Column 4 ==================================================== a 15 c 10 a 25 b 10 c 5 null null b 15 null...

I've seen this problem before, but I can't remember what solved it. In Outlook 2000, every once in a while, incoming emails suddenly default to 75% zoom level when opening them. This is a pain in the butt when you have dozens of emails to check. It doesn't appear to happen on every email, but...

I'm stumped. I'm using a text box on an Access form to present the results of a query built into its properties. The box is set up as a drop down list, but the only value showing to select from is the result from the internal query. The query is designed to only have the sum of values as the...

I'm perplexed as to why this doesn't fit the selected area to one page wide by one page tall. I tried the process manually and recorded it to a macro and came up with this. It works in the macro, but I noticed that it does not fit to the width in the preview. I had to go to the setup (within...

I've tried many different approaches, but haven't been able to get this to work. In short, I need to have buttons on several different sheets automatically copy a range of cells to a final page. Example: Button "3-5"... Copies range of cell on Sheet 3 and then Pastes Cells on Page...