Search results

Hello folks I wonder if anyone can advise me as to how to address the following problem: On a form I have to input a [StartDate] and an [EndDate] The underlying query then calculates the total number of days between these dates [DaysWorked]. This works so far. What I would like to do next...

Good Morning Foks I have a form [MainForm] and a continuous subform [subForm1]. The subform is based on a table [Ordertbl], which contains a payment method field [Paymeth]. The payment method defaults to (1)"Cash" every time a new record is created by selecting one of the 'classification1'...

Hello folks I would be grateful for any suggestions to solve the below problem. It's a fairly straightforward problem, but incredibly difficult to explain straightforwardly. I will try though. As part of a stock control database, there is a facility for parents to purchase school uniforms and...

This problem has got me scratching my head. I would like the report to simply print without opening and I have a button on a form that orders 2 copies of a report to be printed. The report is an invoice for items purchased. Everything works well except that when I click the button, the...

Good Morning everyone I wonder if anyone will be kind enough to help with this problem. I have a form [AddNewStock] which is based on a table [ItemBalance]. [ItemBalance] holds information on each unique item, includimg [ItemID], [Name] and the numbers in stock [Total]. The form shows...

Hello folks I wonder if someone could tell me where I'm going wrong? I have a command button that produces a MsgBox which should give the options to 'Proceed' or to 'Cancel'. Here's what I have: Private Sub Command10_Click() If MsgBox("continue?", vbQuestion + vbYesNo) = vbYes Then...

Hello folks I have a form [StockSub1] which contains a field [CurrBalance] and another [Numentered]. The user enters the number of items ordered and this is displayed in a subform below. The new current [CurrBalance] is recalculated, ready for the next [Numentered]. Is it possible to write...

In a stock order database, I have a main form [mainform] which containes the customer name and ID based om an underying table [OrderTbl]. Below this is a subform StockSub1. This is based on the underlying table [ordertbl] and contains order details, Item classification, Item description, order...

Hello folks, I am looking into creating a stock control/allocation database and have come to a problem. I have a form which contains the customer details. I have also created a sub form based on resources allocated to that customer, with the idea that a continual record of stock allocation can...

Hello Folks First thing I'd like to say is that the help and advice I've received on here has been tremendous. Thank you all. I have another question to ask of you, if I may. My Library database has a continuous form, each form contains the book details and the [dateOut] (the date of the...

Hello folks. A quick question if I may. I'm not sure if this is an Access issue or a general windows one, but here goes. I have a library access Database. One of the search methods is by Barcode. A form pops up upon request and the barcode of the book is scanned in. As soon as this is...

Good Moring Folks I have a question. In my library database I have a field entitled 'Summary' within a table called 'SynTitleTbl'. The field is a memo and it contains a summary or synopsis of each book. My question is this: Is it possible for Access to highlight Key Words within this memo...

Hello folks I wonder if anyone here can help with this potential problem. In my school library database beside each book title there is a combobox that lists all the student names and classes. The librarian scrolls down to the book title then selects the borrower (student name) from the...

Hello folks, I have a question for the boffins on here. I have a school library system set up and one of its functions is to record each student's library activity (for awards at the end of the year). The function works well, however I've thought of a scenario which could well occur at some...

Hello folks I wonder if someone can advise me? I have a form containing a memo field, and, when populated with text, I would like to highlight certain words, if they appear in the field. The underlying query looks at the gender assigned to each record and compares this to the pronouns...

Good morning folks I have a database project that is held on an internal network. There are multiple users. Since the design is now finished, I would like to split the database. When the database opens for the first time each day, a module runs, appending the contents of one table to an...

Hello folks, I wonder if anyone can solve this problem for me. I have a table with a memo field that contains teacher comments. Each student in teh database has been assigned a gender. I have discovered that some comments have been copied and pasted and as a result there are incorrect...

Hello folks, I wonder if anyone here can help me? I have form which contains a number of combo boxes, but there are two of particular interest. [Target Level] and [Target Grade] Each database record has a Year Group number 7, 8, 9, 10, 11, 12 or 13 and this number determines which of the combo...

Good morning folks. I asked this question in the 'query' section of the forum, but so far I've had no luck. Perhaps some of the VB gurus on here can help. I have a query that has to look at the contents of five fields in the same table to determine if any or all has a null value. I can...

Good morning folks. I have a query that has to look at the contents of five fields in the same table to determine if any or all has a null value. I can underrstand how to return records that all five fields are null and all five fields are not null, however I need to know if any records have...