Search results for query: *

Hi, I have an Excel formatting question that I thought was pretty straightforward, but nothing seems to be giving me the desired result. Basically, I want to combine a number (in one cell) with text in another cell, while retaining the correct formatting of the number. It is all working...

Hi, I have a form that is basically displaying a financial worksheet/cash flow statement. I would like the figures to be shown in thousands (i.e., the last three digits would not show, and the digit before the final comma would be rounded up or down accordingly). For example, I'd like 456,000...

I wasn't sure whether to post here or in the Access Forms forum, but I have a suspicion that if this can be done at all, it will need to be done in code... I have a form on which all fields are locked except one, which is a "notes" field (memo format). I want all users to be able to add notes...

Even though I do not have a great solution, I wanted to post about a problem I'd been having and what I finally determined to be the cause. Over the past few weeks, I had posted a few questions here and in the Access:Other Topics forum, trying to figure out why a form of mine kept crashing my...

I have been struggling for several weeks to try to figure out the root of a problem in my Access application. I am working in Win XP and Access XP. I am experiencing frequent crashing, as described below, but without a consistent cause that I am able to identify. I don't think my application...

I will try to be as descriptive as possible, but this error has me stumped and I am not sure what relevant info to include.... I am running Access XP on a Windows XP machine. I initially began developing an app in Access 2000 but converted it several months ago to XP. So the app is now Access...

Hi, I have a pop-up form on which I need to perform a simple validation (verify that one item in an option group is checked, if another option button is checked) before the form is closed. The form may or may not have changes on it before it is closed. I first tried just putting my validation...

Hi, Thanks to this forum, I have a search form which, after the search is run, displays a list box of the search results. Then, when the user double clicks an item in the list box, a new form pops up, with the details of the item from the list box. My problem is that the table from which the...

I have a simple select query based on two tables with a one-to-one relationship (which is defined in the relationships window). For some reason, I am unable to change data in either of the underlying tables via the query. I have a nearly identical query which joins two other tables in the same...

I just converted a db which was created in Access 2000 to Access 2002, because I was going to make an .mde. I received an error converting it to 2002, so I read here on TT to first compile the code (which I did, and which was in fact the root of the conversion error). So, anyway, now that the...

I have searched Access help, as well as the FAQs and Access forum on this site, but am still unclear on how to do this... I have two tables, which are initially unrelated (and thus have no relationship defined in the relationship window). Just as background, they are both tables of financial...

Does anyone know if it is possible to have one form displaying data from two different tables, both in continuous form style? The two underlying tables are unrelated, but I want to display both side-by-side at the same time, and allow users to scroll through both (independently). I don't think...

I apologize for this novice question, but I am brand new to batch files. I wrote a simple "copy" batch file to copy a file to another directory. It then deletes an existing file in the destination directory, and renames the newly-copied file (giving it the name of the file which was...