Search results for query: *

Hi, I've been searching the net for an example of my problem, but alas I can't find it. Basically I need to select a department name and related code number on a dropdown on a main page (Sheet1). To do this I need to be able to either select the name, or the code, on the two lists located in...

Hi, I'm trying to search between two sets of data across multiple lines. (That's not very decriptive, so I'll give an example) A B C 1 1 1 259 2 2 260 322 3 3 323 460 4 4 461 513 In D1 I have a search box. The idea being, if I put say 280 in D1, I'll get...

Hi, I have a database sheet 'Data', where I wish to add 4 buttons/checkboxes to each row of data. The idea being that I can check only 1 of the 4 per row, up to any 4 rows and this data is then passed to my other sheet, 'Labels'. The label sheet contains four spine labels based on L7171 Avery...

Hi, this is a bit of a biggie, but I was wondering if anyone could help please. I'm creating a database for loans of season tickets and I'm having problems with calculated fields in a query. The Database is based on a spreadsheet, which goes like this: Name AmtofLoan PeriodLoanPaid...

Hi, I was wondering if anyone can help please. I'm using a report based on Avery 7171 labels. I have 12 text boxes on the report, each set at Arial 30 Bold, which basically allows for 8 characters width. My form is also set this way for consistency and is based on a table with the 12 fields...

HI. I wonder if you can help. I'm creating a filing system database for box files of invoices. For my table 'tblINVOICES', I have the following fields: Name Datatype Description FILE REF: Number The file box number PERIOD: Text - lookup The financial year (eg. 2008-09) OPENED: Text -...

Hi, How can I go about hiding the #Error appearing in a text box please ? Ideally so it shows a blank. This relates to a value depending on input from e.g. box 1 - so when that box 1 is empty, #error appears in box 2. I'm currently using dlookup as the control source for box 2. Is it possible...

Hi, I have an unbound control on my main form where I type a date. This should produce a search on table data between 2 dates which would then populate another control on the same form with a file reference (a box file number). My table is "tblPYTRUN" and has fields: "FILE REF:" (datatype...

Hi, I hope someone can help me please. On a filing database, I'm trying to set up a search text box on a form, which will show the one record it relates to on the same form. To simplify, I have a table called INVOICES. Fields are BoxNo, InvFrom and InvTo. I've created a (think it's parameter)...

I have a form called frmCCPYT, a combo box called comboCard, and 3 text boxes called txtAMT, txtCHG and txtTOT. Basically, I have a standalone form which needs to apply a charge to txtAMT, depending on the value of comboCard. i.e. MasterCard is the first value in the box and is presumably...

Is it possible to have a form that only holds the data on the screen to send to a report without having to store data in a table? And would it also be possible to then have a command button which clears this data for another go? Any ideas? Cheers.

I have several 1 page reports which need to be printed up to 3 times, but with each having a different line of text on them i.e "Yellow Copy" and "Pink Copy" etc. Is this possible? In the past, I've had to duplicate the report into 2 pages and add the text on the bottom copy...