Search results

Hi, I'm converting a couple of queries that currently have Between Date Criteria. The first query worked perfectly however my pass through query won't work when I add in the parameter instead of the date. Any ideas? Before (Works Fine) WHERE S.SLOT_DIS_LYR_TYP =...

Hi, Can anyone help me solve this issue. I have a main table lets call it [product] which has a [created by] field and also a [modified by] field. I need to link both these fields to the same [employee] table and returns the surname for each. I want to return all the records from the...

I'm sure this must be an easy one, I haven't used access for years and I've forgot how to do everything. I'm designing a query based on a linked table which belongs to someone else. Unfortunately they appear to have stored a cost value (eg. 12030.30) as text. I need to group the table records...

Hi, Its been along while since I've worked with Access, I've been using VB & SQL Server however I'm trying to repair an old database I built. So I would be very grateful for any help you could give me! I have a query which brings back lots of results with different 'Action ID Values'. Now...

I know this is a really simple question, but I've been away from Access for months and I feel like I've had my memory wiped! Whats the easiest way to detect whether a selection has been made in a listbox, I'm linking access to sql server tables which don't allow null values, to avoid nasty...

I'm looking for some help in reading messages in an inbox from Lotus Notes. I want to beable to search for a certain message from the inbox and then beable to extract the message from it. Does anyone know anything about this? Thanks for any help

Just a really simple one here but one that's annoying me. When I create a option group and place it around controls that already exist, then set the backcolour, it comes to the foreground and so I can't see me controls. How do I set the option group as a background object or how do I bring the...

I need to select the second tab(Page) on a form when I navigate to it from a specific button. Could someone tell me how to go to a specific tab? I can't make the it the default because normally I would like the first tab(Page) to be displayed first. Thanks in advance

I will have a query which sets a criteria from a table. Now on an onclick procedure I want something that will say, If all the records in the query have a field called "Completed" = True selected then I will do so and so. The "Completed" field is a checkbox, so if all those records in the...

I've got a problem on a form where everything dissapears, The structure of the form is that there is a recordset and fields based on a query. This query has a criteria of 13. So it should only show records of status 13. There is also a subform of tasks which is linked to the action plan ID...

I've been reading previous posts and have managed to find code to send an e-mail through lotus notes. However it won't send the attachment! I've played around with the code as much as I can but I'm not that great with it, Can anyone spot what I've done wrong? Private Sub Command143_Click()...

Help! I have a button which runs a delete query then an ammend query and then an update query but I wanted to get rid of the warning messages eg "You are about to delete 3 records" etc So I added a DoCmd.SetWarnings (WarningsOff) command. This worked but the DoCmd.SetWarnings (WarningsOn)...

Lets say I have two tables, table 1 and table 2. I want to delete all the records in table 2 whose Action_Plan_ID field = "12"(12 just an example) Then I want go to every record in Table 1 and if the Action_Plan_ID field in there = "12" I want to add all those records to Table 2. I need to...

Ok I have a massive task to perform as the main function of this database I'm developing however there is no way I'm going to figure this out without the help of you guys. On a form I will have a TextBox with a "Change Type" value. Now when I click a button I need it to search the record in a...

I have a form and a subform. On the mainform I would like to stop the records from being edited. So I have stopped editing, additions and deletions. However I would like the details from the subform to beable to be edited. However the subform has the same "Allow" properties as the mainform...

I have a subform which takes data from a query. The main form is attached to a Action Plan table and the subform to a query from the TypeTask table. The query has a criteria set for the Action Plan ID. This action plan ID is taken from the recordset of the main form. So when the mainform...

I have a database and have to develop a form which displays information about Action Plans and there tasks, however after playing around for days with listboxes and subforms I can't seem to get them to work. The tables (Action Plans) and (Tasks) aren't directly related. Here's how they are...

Right I'm in need of help AGAIN! This time I have a form with a subform on the left which is linked to a Requests table. This is read only sub form. What I want to do is select a record from this subform and this selected record is then filled into the fields on the right of the subform on...

I have a tricky problem I have a series of fields on a form. Date Entered, Deadline and Estimated Time. The Date Entered and the Deadline will both be date inputs by the user. What I want is that when a user inputs these dates the estimated time is then calculated between the two dates. So...

I'm a relative beginner and am in need of clarafication on an error message I'm getting. Two of the tables in my database are called Requests and Status, They are linked together.The primary key of the Staus Tbl (Status_ID)(Autonumber) is the Foriegn key in the Requests Tbl (Number). When I...