Search results

Hi, I was wondering if anyone could shed some light on this problem. I have a pop-up form that is used to filter info on a report for Labels. When I filter info on the report and click the print button. The filter doesn’t seem to be applied to the report when it is printed even though it seems...

Hi, I have a pop-up form which I use to filter data on a report that prints out labels. I also have some code on my report which asks the user if they wish to skip labels, they enter the number of labels the wish to start printing from. This code runs when the Apply button on the form is...

Hi, I have a continuous subform, where records are saved too. The number of parts used are entered in each row and then the new UnitsInStock value is calculated accordingly. UnitsOnHand:[NumberUsed]-[UnitsInStock]. This UnitsOnHand becomes the new UnitsInStock value which is working fine so...

Hi, I have adapted code from ghudson's example on 'http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52736 I have a subform called frmsJobPartsUsed, which contains a multiselect list box where the user can select multiply parts used for one job and click a save button...

Hi, I have adapted code from ghudson's example on 'http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=52736 I have a subform called frmsJobPartsUsed, which contains a multiselect list box where the user can select multiply parts used for one job and click a save button...

Hi, I am having problems with an If statement and was wondering if anyone could help me out with it. What I am trying to do is; If UnitsInStock is 0 (maybe this should be null not 0) Then show a Message. Or Else If UnitsInStock is greater than 0 but less than or equal to ReOrderLevel Then Show...

Hi, I need to copy a record in the table tblAccDetails to all other records in the same table that equals the same Collection Type in table tblCollections. (The user will enter the first record in tblAccDetails) tblAccDetails AccDetailsID YearID CollectionID (FK) CollectionDate Status...

On my subform (frmsCollectionDetails) I need a combo box that look up values (CollectionID, CollectionType) in a different subform(frmsCollections) on a different form. (there is a one-to-many relationship between these tables). On selecting the CollectionType, I want the corresponding...

I have four tables called; tblParishioners:- AccountNo, AccountName tblYears:- YearID, AccountNo, YearPeriod tblCollections:- CollectionID, YearID, CollectionType, NoCollections, AmtPerCollection tblAccDetails:- AccDetailsID, CollectionID, CollDate, Status, Remark, AmountPaid A person will be...

Hi, I have a main form and two subforms (in datasheet view). On the main form (frmPar), I select a persons name which finds the records for that person on the two subforms. The first subform(frmsParYr) shows a list of years, depending on the record selected, the second subform (frmsParCol)...

Hi, I have three tables called tblParishioners tblYears tblCollection I am trying to make a form so that when you select a parishioners name, it will find the record (years, collections made) associated with that person which is/or closest too the present year. I have attached two forms...

Hi, I am really stuck on this and would really appreciate if anyone could help me out. I am working on a small database that records the names of people that pay different types of parish collections and the amount they pay to each collection in a year. At the moment I have two forms...

Hi, I have a problem filtering date ranges in a subform. On my main form (called frmStore) I have two unbound date fields called txtStart and txtEnd. The user enters Start Order Date and End Order Date and presses return (the dates are entered dd/mm/yy format). These dates’ ranges are then...

Hi, I have a form that is used to enter employee information. On the text box for entering employee name I want to prevent the user from entering certain characters such as ' . If the user enters an employee's name like Barry O'Connor a message should appears saying Please do not use the...

Hi, On my database I have create gif images and used them as buttons as a main menu across the top of each form. When an image is clicked it opens that form and closes the previous one. They change colour when the mouse moves over them. All is working fine, except when I open the form the...

Hi, I have two calculated controls on my continuous form. TotalCostofParts In the control source I have the following; =DLookUp("[TotalCosts]","qryStoreJobs","[StoreID]=" & ([tblPartsUsed_StoreID])) costofpartused In the control source I have the following...

Hi, Not sure if I am suppose to start a new thread for this question or not but anyway, this question refers to an old thread called; Create a pop-up Message box to display results? http://www.access-programmers.co.uk/forums/showthread.php?t=67460 When you open frmStoreRoom, you are asked if...

Hi, On my form frmOrders, I have a calculated control called UnitsonHand.This calculates the total units when a product is being ordered or re-ordered. This is the calculation: =([QtyPerUnit]*[Quantity]+[UnitsInStock]). I need this value to be stored in UnitsInStock in a table called...

Hi, I really need some help with this as I am a novice at vb. I have a table called tblStores which contains the fields PartName, UnitsInStock, ReorderLevel and Discontinued. I have created a form called frmStoreRoom, this form displays the PartNames details upon selecting a part name via a...

Hello, On my form, when adding a new record I select Job Name form a combo box, which creates a new record for the Job Details table. On the Subform, the Job Details ID creates a new record for the parts used table. It will allow me to save that record once. I need to be able to select more...