Search results for query: *

Hi All. Im a bit of newbie when it comes to this aspect of Access, so I hope this makes sense. I have a database that is located in a groups directory on my server. However, this database will now need to be accessible to a larger number of users across the country, who are located on...

Hey all, I'm wanting to run both an apend and a delete action query with a single command button, but I really want them to run without the "Are you sure you want to run this type of query" and the "You are about to apend X rows" message boxes. Is this at all possible? Cheers. This is a...

Hey all. I have a form with three combo boxes on it, and all are linked to their own table - cboBuilding cboDepartment cboArea Specific areas are linked to departments and the departments are linked to buildings. What I would like to see is when the user selects Building A, only those...

Hey all, I'm a bit of a newbie when it comes to creating queries, so any advice is welcome. I have a basic database that holds the majority of records in a single table. Data is entered via a form linked to the table. I have created a form that users can use to search the database. Basically I...

Hey all, In Access '97, I've created a form with a sub form contained within, and they have a one to many relationship. The subform records staff names, the main form records observations. How can I limit the subform to contain no duplicate staff names for the linked record in the main form...

I was wondering if someone could answer this simple question for me. I have a fairly basic form that is displayed in a continous format. Each field is disabled pending data being entered into the previous field. When you enter data into the first field, the second field becomes enabled on the...

Hey guys, Wonder if someone could give me a little advice on how to do this. I can get a report I've created to insert itself into a blank e-mail in Notes by way of a commend button, but it is really annoying how the "Select Format" window appears every time I want to email a report. Is there...

When attempting to convert a MS Access XP Db to Access 2000, I receive one of the MS error messages where they ask if you'd like to send a report. The technical content of the report is huge, so I won't bother to reproduce it here. Just wondering if anyone else has encountered this problem when...

Is this possible? Do I need to load a patch or something, or am i stuck with having to purchase a later version of Office Suite? Thanks in advance, Kev. Never trust the French. How can you trust a country that has 256 different types of cheese. - Spike Milligan.

Hey all. I have a form that I use to select records based upon fields in that form. For example, on my form I have the following fields - Manager, Work Area, Result etc. The user can enter a value in either of these fields via a combo box. When they click a command button, a new form is opened...

Hi all, I've trolled though the archives to find an answer for this, but gave up after two days. Maybe I'm looking in the wrong spot. I have a small bitmap on my form that I want to act like a button. In other words, when I depress the mouse button, it will look sunken, and when the mouse...

Hi all, I'm having trouble setting the properties of a field, based on the value of the field itself. I have a field on my form called "bywhen", which is a date field. Based on the value of this field, I want the properties to change to reflect the value. For example, if the field is...

Hey all, I recently invested in a laptop (Sony Vaio) running XP pro. I also have a desktop running XP home. Using a crossover cable and Acton card, I thought I might network the two for file sharing purposes. My problem is that although the network connection seems to be present, I can't access...

Hi all, I've searched the FAQ's, but was unable to find any info on this, so I hope someone can help. I have a multi page document loaded onto our LAN, that is accessable by a large number of people. At times, users will print out certain pages from the document for use. I need the document to...

Hi all, I need to disable the File menu Print option in my database. This is because some users who want to print out a single report, select the File menu Print option, and print out all reports in the db. Is is possible to lock this option out of the File menu? Many thanks in advance. Kev.

hi all, I have a form that I use to search for records by various fields in my main table. One of these search options is for records between certain dates. On the Frmdatabasesearch form I have two text boxes - Txtstartdate and Txtfinishdate, and a Search Now command button. The user enters the...

Hi all, I need some way of making a label on a form VERY obvious to the user. I was thinking of something like the background colour of the label changing every few seconds, but any ideas are welcome. Thanks all. Kev.

I've searched the FAQ's, but was unable to find anything that answers this question, so I hope someone here can help. I have a database that is opened by any number of users at any one time, but probably not more than 5-8. The problem is that some of these people tend to stay logged in the...

hi all, How can I find the latest date value in a group of records? if i run a query to select all records that meet a certain criteria, can i then find the record that has the latest date value, and insert it as another date value on all records selected by the query? Thanks in advance, Kev.

Hi all, Not sure if this is possible, so I'm after some advice. I have a field in my form that records the turntime taken for items being returned by a vendor. There will be multiple records in the db that are linked by a common serial number, but the different items will be despatched and...