Search results for query: *

I am trying to write an update query that will update column B with 5 zeros and the contents of column A. For example: Column A = 12345 Column B = 0000012345 How can I do this? I have tried "00000"&[Column A] but that doesn't seem to work. Cheers, - Iain

Hi all, I have a table that shows name, id number, and last login. It has 21 last login columns (with the more recent checks being the furthest to the right). If the person's last login was in LL4 (last login colum 4), 1-4 would hold dates, and 5-21 would be empty. If the last login was in...

We are currently running an instant messaging application that is run through the web-client using javascript. It is launched by clicking on a link that launches the messaging window. The url for this link end as shown below: "/WebConnectLaunch?OpenForm" Some users are unable to...

We are running Windows 2000, and IE 6. the application uses javascript. cheers

We are currently running a web-based messaging application. To launch it a user must click on a link in an Internet Explorer window. When clicked, a new window appears prompting for username and password. This is working fine for the majority of users but there are a handful who do not see a...

Thanks a million - that did the trick!

I am trying to send out an active email that will allow receptients to response by clicking a button (much like meetings requests etc). So far I have found a drop-down list for 'voting buttons 'with: approve/reject yes/no yes/no/maybe Is there any way that I can make up my own options for...

I have a report that is laucnhed from a form, in the form you can pick the region whose information you want to display. The report that is returned includes a pie-chart. There is a maxium of 5 slices that make up the chart (A-E), and each slice is given a different color by selecting 'vary...

awesome - Cheers!

Hi all, This may be a pretty easy thing to do, but I can't do it and its driving me crazy! How can I set up Excel so that if I put the number "1" in cell A1 for example - when I pull the fill handle down it increments the numbers? Essentially I want to make a list in column A from...

Thanks, I've tried this and doesn't quite work. The problem is the 'Hourly Rate' that is referred to varies slightly between records (some our 54, some 30, etc). In the Project_Name_Header it matches the related 'Hourly Rate' and 'SumOfHours' records. When I put 'Hourly Rate' in the report...

Thanks for responding! I have tried to do that but never seem to get the syntax quite right, perhaps you could help? Label39 is a calculated value: =[Hourly Rate]*[Label48] Label48 is a calculated value: =Sum([SumOfHours]) I tried the following without success: =Sum([Hourly...

Hi all, I am currently having some trouble trying to total something. I have 5 'text boxes' in a Project_Name Header. One of these text boxes is called 'Label39'. In my report footer I want a text box that displays the sum off all the 'Label39' instances. I have tried =Sum([Label39]) but...

Hi all, I am currently trying to find a way to email a group of people a list of options to select from. They will have 5 options and need to select one. Is there a way to do this using radio buttons or something similar so all they need to do is check a box and hit reply? Cheers, - Iain

thanks!

Thanks all - that looks like just what I need. I did have some trouble calling the 'list' from another sheet in the same workbook. Is this possible? Or is there a weay to hide the list that is the source for the drop down? Cheers, - Iain

Hi all, Does anyone know how I can put a drop-down menu into an excel spreadsheet? I have a registration chart for people to complete, and in the fourth column I want to have a drop down menu for them to select from the list. I'm sure I've seen this done before but can't figure it out. Any...

Hi all, I have atable full of data, a lot of which is decimals (ie, 1.423). Does anyone know a solution for changing all this data to whole numbers - perhaps an update query or something? Ideally I would like to round everything to the nearest whole number. Cheers, - Iain

Hello again! - ok, here's the next question. I currently have 2 columns (first_name and last_name). However some people are entirely in CAPS and I want to change them to standard. example) KEMP >> change to >> Kemp Any thoughts would be greatly appreciated! Cheers, - Iain

thanks!