Search results

Hi, Each time I add an a link / tag; all my links show the # sign. Eg: <li><a href="#">Link 1</a></li> Will render: Link 1(#) Is there any way of gettting rid or not displaying the (#) ? TIA :) Dreamweaver CS5

Hi for some reason I am getting duplicates in my query :confused: What I have is Park Road. There are 3 Park Road' but in different Wards. The table has only 1 input of the word Park Road for ONE of the areas, yet all 3 areas show, like: STREET WARD Park Road DRO Park Road STA Park Road...

Hi, I am trying to calculate a total of a column based on a criteria. I have in column B either "Y" or "No". I have in Column C a figure Column D (at the bottom) I have the total for Y AND the next row of totals for N. I'm kinda stuck. Do I use the If formula or the Vlookup or even combined...

Hi, I would like to know if I can have some sort of pop up that shows dates which have expired. Basically I want access to automatically tell me (upon opening which items/products have expired). Is it poss? Hope to hear. Thanks :)

Hi, I am trying to set up some tables for my DB. I have a list of Schools, Streets, (Council) Wards and ORDERS. What I'm trying to achieve, is to see which SCHOOL has an ORDER which STREET has no ORDER which WARD has what ORDER The street table has some streets more than once, as there may be...

Hi, i have got my year format set as yyyy, which displays the year only. But when I click on the field it shows the full date.:confused: This causes me a problem when concatenating two fields together, as I get the full date also. How do I solve this? I only need the year to show. Thank you :)

Hi, I need some advice as to how do I make the Option Group work with each record. Basically, I created an option group on a form and each time I move through the form the same option is highlighted for all my records :D Where am I going wrong? :o Hope to hear.

Hi, I am creating a field that requires the following type of data: 2005/06 2006/07 2007/08 and so on. What format can I apply to get my dates like this, or do i use the text format? Jus worried if a search is performed :confused: Any advice? :o

Hi, Is it possible to make a text box field active based on content from another box? Basically I have a drop dwon combo box that shows a list, such as 'active, withheld, archived, etc'. If the used selects archived, then I'd like the the textbox to be active so the user can input a date that...

Hi, Does anyone know if there is a limit in a filter list (using auto filter), as many of my records do'nt seem to show, unless there is a glitch of some kind :( I have approx 1300 rows. :o Thank you.

Hi, I have a chart that has figures/data and in one of the cells I need to put in N/A - this is treated like 0 (zero) and messes up the chart. Any way of getting round this? Thank you :)

Hi, I am trying to display all records that are 30 days old from date of registration (& not paid). I have: 30 Days: [SrDate]+30 SrPaid = No But I don't want to see those that have registered in the (say) last few days, but only those that have not paid and 30 days are up. How would I achieve...

Hi, Trying to get back into Access after a long time, just need some refreshing :) tips. I have 2 tables, one of the tables stores titles (mr, mrs, etc). I tried using the 'lookup' data type to link the data from the other table. This however stores the field as a number and causes problems on...

Hi, Could some one please jog my memory, what I'm trying to achieve is formatting of text. Basically I'd like to have text on 2 lines but in one cell (not merged)...I used to use a short cut but unable to recall. Any help appreciated. :o

Hi, I'm testing out some VBA coding and have created a simple userform. How do I get this to oped/display in my spreadsheet? Thanks! :confused:

Hi, I have 3 tables, tblCompany, tblBranch & tblJobs all linked together. 1 Company to many Branches and 1 Branch to many jobs relationship. The problem is that when I create a lookup field in tblJobs to look up the company (for easy insertion) I get a number instead, rather than the Company...

Hi all, I am creating a demo recruitment db and need some advice in knowing how to design it. Basically, an employer (tbl_Employer) will most likely have more than 1 branch. Would I have create a separate table or do I include all the details in the main table with address, phone numbers and...

HI, I need to create the following: "S" = 5 days "M" = 3 day "N" = 0 days So if a user selects from a drop down list 1 of the 3 options (S,M,N) then I need to add the number to the present date. If S then (5 + 3rd June 03) = 8th June 03 How do I tackle this? TIA

Hi, Each time I create a form the font size seem to be small ie 8pt. I have had a quick look in the Tools > Options...but couldn't find anything. Is there a way of setting the font size of forms to something like 12pt? Thanks!

Hello all, I have a date field which is filled in by users when they take out the relevant material and a 'yes no' field, so other users can see if it is available or not. Is there a way of automatically making the 'yes no' change to yes/no when the date field is filled in? This I would like...