Search results

Surfette Your Recordsource (as described below) is in the wrong field... What you are attempting to do is causing a circular reference (endless loop) where the value of AdminID is being used to calculate itself...:confused: Access also likes spaces between the "&"'s, but this is usually...

Your user manual... Surfette Attached is a host of files on how it was done. They should be read in the order: 1) Tables & Query 2) Forms & Fields 3) Button & Code Hope this helps your understanding. Rod Mods - If having these files on the board creates a problem, please delete them after a...

Hi Surfette Rather than type up a long post, I will put all the detail into a Wod doc and post it back here for you. I will take a look at your last post, at a glance, it looks OK, but will delve a little deeper. Watch this space... Rod

The real answer Fulltime The reason why the contents of a cell seem to be "chopped off" is because there is an entry (even a space) in the cell to it's right. You answered your own question in a way when you said That is exactly what is happening. The only time that Excel allows text (it...

Sample attached Hi Surfette Attached is your sample - updated with what I think you wanted. I created an Append Query that takes the date from the main form, and adds the list of students for a particular course to the attendance table. I have taken an optimistic approach and set all students...

An alternative approach... I believe in not using code unless I have to, so...as an alternative... Create an unbound text box on the report (InputDate for example). Set its ControlSource to =inputbox("Enter date :") You can hide it (after testing) by setting its Visible property to False...

Hi Matt If you open the "Forms" toolbar, you will see a padlock icon. This needs to be clicked to protect the form you have created and allow user input. Lookup in help for "text form field" which will give you some tips and pointers. Be aware though that protecting the form (to allow the...

Are you sure it is the query that is the problem? The data type of the field is more likely to be "at fault". Check the definition for this field, you will probably find that it is set to "Long Integer" which cannot hold fractions. Lookup help on "field size property" for the options here. HTH Rod

You have lots of options here... Hi FT Access stores data in tables in the most efficient way that it can - rarely is it in the way we would like to see it. When viewing the data, sort orders are applied "in the background" so would appear to be sorted, but actually are not. To fix your...

M20ael You have posted this in the "Word" forum - but the way you have worded the question looks to me to be an Access issue.... I would guess that you have named your report textbox "Truant". If so, change it! "Truant_YN" for example. Be careful when you do because the value of the IIF may...

Hi Fulltime I would not recommend turning off the error messages as they are global and you will not trap valid errors elsewhere in the workbook. For the line of code - Syntactically it is OK, but... You use .Value to get the contents of the cell, this is not required and should be deleted...

Hi Bess If you change the label that contains the body of the letter to a text box and set the control source to the following, you should not have to do a mail merge, which would avoid another layer of complexity ... ="Due to the change in your " & iif([Sex]="M","Sons","Daughters") & "...

In my *very* limited experience of using <control>.Caption = "...", the new caption is not saved when the form is closed. Have I missed a trick here? Rod

Try here Hi Alastair I have found Tony Teows site a veritable mine of info. He has a section devoted to image handling. There are a lot of links from this page that go into a lot of detail. You could be quite a time going through them all! http://www.granite.ab.ca/access/imagehandling.htm...

Hi Sam Ken, I hope you don't mind me "butting in" here... I have attached a DB with an unbound form that I think solves the problem. Each of the toggle buttons in the option group has been created with it's value being set at the % rate described by it's label. There is a tick box to select...

Fuga If the other workbook is already open, type the equals sign "=" as you would to start a formula, then click on the cell you want to reference, then press Enter to complete the formula. The contents of the referenced cell will be displayed. If the other worksheet is then closed, Excel will...

Hi Keith - pleased to see that you are making progress. Your sorting probem can be resolved by adding two lines of code. Me.OrderbyOn = True Me.OrderBy = "Section_ID, Project_Status_ID, Project_Phase_ID, Project_Title" This will allow the sorting to take place and then applies the sort order...

Thanks for the kind words Hi Keith Thanks for the kind words - I sometimes worry that I "ramble on". I am a little concerned with what you said in the last post. Firstly: The selection criteria for the Phases has changed dramatically - you will know if this is correct or not when you apply...

It works in Excel too! I'm glad I could help. As a matter of interest, there is a similar function in Excel, where you can search all the worksheets in the workbook. In the Search dialog box, click the "Options >>" button and change the "Within:" option from Sheet to Workbook. A screenshot...

This looks like the classic "cascading combo box" question to me. Do a search in the forum on this - you will get lots of information.