Search results for query: *

Hello all. I've already made a book file out of 30 individual docs. I'd also like to make one great big doc file out of all those smaller docs. In most other programs out there that can handle text & images (at least the ones I'm used to - Acrobat and Word and various other text programs)...

This is either going to be a very odd question or a very simple one. I have a report which is built upon a query which draws from more than one table. One table is "company information", and the other table is "company notes". The company information is always the same...

Hi everyone, I have a series of check boxes all linked to date fields in a form. The check boxes have an 'after update' event that automatically places the date in the date field when the box is checked. There are also a second set of date fields which are dependent upon the first set -...

After getting some advice from the other forum members, I've decided that it's a good idea to split my db into FE and BE. But I also want to set up user-level security. My question is this: does it matter if I split the database first and then run the user-level security wizard (and if that's...

This is probably a pretty basic question, but I thought you all would be the ones to ask. In what circumstance would you want to split your database into front-end/back-end? What is the advantage of doing this? Also, is there something I can do which would still give the users...

This is probably rather easy to do, but I don't know how to go about it. I've set a form to open in datasheet view as the default. And it does. But when I open it using a command button from another form, it opens in single form view. Does anyone know a way to modify the following code so that...

Hi everyone - I came in this morning and found something wrong with the main form in the database I'm building. When I double-click on it, it's as if I'm clicking on white space - nothing happens at all. I can't open it in design view, either. When I try to open the form using a command button...

Hi everyone - I have a command button on one form which opens another form. But, I want to modify the button's on click event so that it not only opens the form, but it also filters one of the form's fields ("Manager") for a specific name, and then opens the form with only the...

Hello, all. I'd love it if one of you could help me solve the latest conundrum. I have two tables that I want to query with a user-specified parameter. There will only ever be one result in the query, which comes from one table or another, but not both. The query will return three fields for...

I can't imagine what's caused this, but all of a sudden, all of the forms in this database are showing up as blank. The underlying tables clearly have records in them, and up until recently, these records would show up in the forms, too. Now, they no longer show up. If I right-click on the form...

Hello, all - I've just built a database in Access, and had a request come up from the end users. I think this is possible, but I'm not sure of the easiest way to go about it. What they want is for the body of chosen emails in MS Outlook to be saved in a record in their Access database. This...

Hello, all - I've just built a database in Access, and had a request come up from the end users. I think this is possible, but I'm not sure of the easiest way to go about it. What they want is for the body of chosen emails in MS Outlook to be saved in a record in their Access database. This...

Hello, all - I've just built a database in Access, and had a request come up from the end users. I think this is possible, but I'm not sure of the easiest way to go about it. What they want is for the body of chosen emails in MS Outlook to be saved in a record in their Access database. This...

Hello, everyone - I think that there's probably a way of doing this; in fact, there may be several ways. What I'd like, ideally, is the most elegant and user-friendly way, as I'm going to be setting this up (I hope!) for a multi-user environment. I'm finishing up a database, and the person in...

Hi there - I started off with a question in the Forms forum, but after another member's suggestion, I realize that this may be more of a query issue (and if I can do this with a query, great - that would probably be easier). The original issue is in thread 702-593338, if anyone wants to see...

Hello everyone, Here's a repost from yesterday; I hadn't heard from anyone, and didn't want the post to get lost. If anyone has any insights, please let me know. I have a database with three forms which correspond to three tables. However, two of these forms need to add data to another table...

Hello everyone, I have a database with three forms which correspond to three tables. However, two of these forms need to add data to another table, as well as their 'main' table, when a user chooses to do so. I've accomplished this by following the suggestions of a few different forum members -...

Hello everyone - Yesterday we generated a long, long thread - thread702-587534 - about the best way to enter data from one form into two tables simultaneously when a user elected to do so. After a lot of helpful suggestions which for the most part didn't work for some reason, one of the forum...

I'll share my latest quandary with you; perhaps someone might have an elegant bit of code that would make this work out as easily as I think it ought to be! In my database, I have a form which, of course, enters data into its corresponding table. What I want to happen is that, if a user...

Hello all - In Microsoft Access 2000, I'm building an expression in a form which I want to return 1 of 2 possible values. The relevant fields are PARC 1 Sent (a check box) and Date PARC 1 Sent. What I want to have happen is this: if the PARC 1 Sent check box is not checked, I want the Date PARC...