Search results

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...

Does anyone have any ideas... suggestions?????? :confused:

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, It's working now, great! Rich, I understood I had to repeat the Format for the second date and you didn’t mean etc. literally. I guess I was being lazy replying by not typing out the full line and just used etc. as well. Sorry, about changing the date format to "dd/mm/yyyy". I didn’t...

Rich, I tried your suggestion and am getting the following errors; "[OrderDate]>=#" & Format(txtStart."dd/mm/yyyy") & etc I get this error: Compile error: Syntax error "[OrderDate]>=#" & Format(txtStart.[dd/mm/yyyy]) & etc I get this error: Run-time error ‘438’ Object doesn’t support this...

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, Sorry, it too so long to get back to you, I was out of the office. Err!!! You were right, I tried out your suggestion and it works. I made an attempted at it the other day when you first posted it but I obviously did something wrong as it didn’t work for me. Anyway, I tried it again and...

Hi, Thanks for that, it worked perfectly. I added a message box to make it more user friendly. Case 192, 65 MsgBox "Please do not use the following characters when entering a name: ' A", vbInformation, "Information..." EmployeeName.Text = Left(EmployeeName.Text, Len(EmployeeName.Text) - 1)...

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, I tried to upload my form but it was a little too big 164KB. so, I taught that example would be the next best thing. I am sure it has the same problem except it only has 2 buttons (so it loads alot faster) and my form has 7. If you have an email address I could email it to you. Thanks again.

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...

Has anyone any idea?

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, This would be done by an If statement, am I right? I tried a few different ways but keep doing something wrong. I am not very good at vb. I would really appreciate it if you could let me know how this statement works. Thanks in advance,

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 KenHigg, The database is for tracking maintenance work done on boats. We buy parts to be used on the boats. Different parts are used for different jobs on different boats. Need to track parts, and the amount of a part used, on what boat, and on what job. Rita

Hope this helps; I have three tables called tblStore, tblOrders, tblPartsUsed. tblStore StoreID PartName ReOrderLevel Discontinued tblPartsUsed PartUsedID JobDetailID StoreID OrderID QtyOrdered PartsUsed tblOrders OrderID OrderDate QtyPerUnit QtyDescription Quantity UnitPrice Vat Discount...

Hi, Thanks for all the advise, it took a little while but I got it working. You were right of course, it's much easier and less confusing to just do the calculation on the form. Thanks again for all your help, Rita

Hi, Thank you for you advise on storing calculations. I understand all of this and normally I am against storing calculations. The reason I need to store this calculation is because on other forms in my db I need to use the value UnitsInStock to perform other calculations (I won't go into the...

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...