Search results

Hi, Is it possible to append to a form so that I can have a record from one table, query, append to a form. Then add additional info to that record and save it as a new record in the table the form is based on?! Thanks Sue

Hi everyone, I have a query as below: Row1 Row2 Row3 Row 4 Row 5 1, 2, 2 , 0 , 15 1 , 2 , 2 , 1 , 7 0 , 1 , 1 , 4 , 2 1 , 2 , 2 , 0 , 29 I need to pull our records which have the same entries in Rows 1-4 and then add up Row 5. For example The above query would make three more queries i.e One...

Hi, I have a form for data entry relating to experiments. I have several fields such as catagory, purpose, outcome. Each field has a listbox to choose criteria from i.e. Category = 1 Environmental, 2 biological, 3 toxicology, 4 other and so on. What I need to happen is if the user puts in a...

Hello everyone, I have a form with an unbound control linked to a query. So I can put an item name in the control and the query returns all records for that one item. For example, in the query criteria I have 'Like [forms]![formname]![itemname] & '*'). Is it possible to use the same underlying...

Hi, I have a look around the site but can't find anything that either helps me or that if it does I don't understand it!!! Any advice would be great! I have a continuous form and as I have found out have had to use conditional formating to hightlight buttons (unbound controls) to appear...

Hi I would like to make a command button appear on a form only when certain criteria is put in a control on the form. For example, one of the controls has a drop down menu. When the user picks "Washed" from this menu I would like a comman button to appear. The control is called status and...

Hi, I am using Access XP. I have a table for experiments - tblexp. Each experiment can have one or more projects within it. So I have a drop down list of the various projects in a separate table - tblprojref with fields project no (projno) and project title (protitle). When I am setting up a...

Hi, I have looked through past threads but can't find the help I need! I have a table with the following : ID RequestNo Startdate Finishdate Can I put this into a query and use an IIF statement to tell me when each request has finished. Something like IIF([Finishdate] = Now(), "Yes","No")...

Hi guys, I'm in need of some help!!! I have two tables: Table 1 holds information about a experiments, i.e. 1A, date started, equipment used etc. There are 24 parts to an experiment, i.e. 1A1, 1A2, 1A3 - 1A24 Table 2 holds information about each part. i.e. 1A1, used 5 people, 8 cars etc. I...

Hi, I have a report 'Cards' based on a table 'Pimbook'. I'm trying to find a way to set criteria so that I can have specific pages printed without having to sort through them manually, there is over 900 pages. I would like a form that allows the user to put in a start number and an end number...

Hi, I've looked through all the past entries on this but can't find exaclty what I need! I have a query which I want to sort via a form. For example, my query holds a range of records such as 295A-1H/2, 284A-1L/23...

Can anyone help? I'm trying to write an IIf statement but am getting a bit confused. I have several columns in a query. Two columns have a number in them, either 0 or 1. If these two columns are less than 2, (i.e. 1 and 0, or 0 and 0) then I wanted a calculation. I.e. Field = IIf ([Field1]...

Hi, I need to display a field's last entry on a form so a user will know what the next entry needs to be. I know how to creat subforms but I wondered if there was a simpler way to do this? thanks Sue

Hi! Me again... I have a report that I would like to sort but via a form. I would like to put in a criteria and then just have those ones in the report? I know how to sort it by going into design and grouping etc. but I need to make an easier way to access this for other people who don't know...

Hi all! I need some help with a few calculations in my database, but please bear with me as I'm not too crash hot on how this all works. I have a field in a table with a julian day..i.e. 50.04 instead of 19th Feb 2004. I would like another field on the same table to plus 250 days to this...