Search results for query: *

Hi I would like to generate an email using fields from my database from a command button. The following code below works well if all the fields are located within the form I am in at the time when I click on the button. However I want to get the email address from a different form...

I am working in Access And i would like to calculate the total number of hours in the feild [Time], the property is short time. The formula i am using is as follows; =Sum([Time]) The problem is that once the calculation exceeds 24 hours it then reverts back to 0, for instance if the sum...

I would like to count all the columns in B3;B307 that contain the text SE, and then count all the columns in F3 and F307 that are between two dates. C12 in this case equals 1-1-03 C13 and 11-7-03 This formula works for below howver this includes all dates greater than the 1-1-03...

I would have thought this would be fairly simple; although i am struggling to do this from a particular field as the automatic default everytime you open a form, it seems to sort by the primary key Any help appreciated

I would like to count all those feilds on form/table main that equals South East AND Form/table Sheet1 that equals '4. PLANNING APPLICATION SUBMITTED, For some reason the formula below is unsuccusful, i think it has something to do with this line, Forms!Sheet1![Sitestatus]. It works fine with...

I have split a table to limit the data in each table. I have then created a one to one relationship (referential integrity, cascade updates, and cascade deletes) between the primary table and split table, using the field name ID which is the primary key for both fields. Autonumber for primary...

Does anybody know how to use the find command to search throught two tables where there is a main form and a subform with a one to many relation. I would like to search the main form and all the related records in the subfrom. If I do a search in the main form it only seacrhes the main feilds...

Access forms The following code should after you update [Sheet1][sitestatus] feild to red automaticaly update the feild [Main]![siteactive] to Site Completed. Sheet1 is a subform to the form entitlted Main. And both feilds are visable when the form entitlted Main is open. There is a problem...

I have a form called Main, There is subfrom called Sheets1 within the Main form and a subform below that called TLR within Sheets1 form. When I open main, both Forms sheet1 and TLR will be open and displayed. I have a feild in Sheet1 called Forms!sheet1[deso] and i would like a feild in the...

When i use the following script to merge from access in to a word document it works fine when i merge from the one table from access. i.e (CStr(Forms!sheet1!Client)) However when i try and use two tables from access and add (CStr(Forms!main!Clientname))the script does not work and the word...

I have a simple problem. I have a main form, and within that i have a sub form. When i open the main form, the subform is centred and I cannot see the top of the subform, which has all the relevant tabs. There is a horizontal scroll bar which will allow me to scroll to the top and view the...

After I enter details in a form called [Main] field sitename, i would like this informtation to be automatically be updated in a form called [sheet1] feild name sitename. The information will be hidden but it will be used to generate a query and mailmerge to word. I could use the following to...

I have teh following code shown below that works fine, however the feild client has been moved to a differenet table named [Main]; as oposed to [Feild1] which is located in the table named sheet1, hence i need to change the syntex of the top line to enusre that this script will work. Any ideas...

I would like to put a character limit of 1024 characters in a access memo field, it is fairly easy for a text field although struggling with the memo field, any help appreciated. thanks

I have a cell that contains allot of data, up to 1500 characters. The spreadsheet cell does not show all the text, and cuts off at a point where the row height is 152.2. If i increase the row height there is gap at the top of the cell but the text still cuts off down the bottom. The cell...

After the user hits the button in an Access form, i would like a VB program to determine If a field is blank, named [dcfdate]a message appears to say date feild is blank, please update information and hit the button again. Otherwise it runs the command to generate with word. Any help...

Is it possible to link an access file with excell so that after I update either the access database or excel spreashett the informtaion will automatically be updated in both Access and excel. I have been able to generate informtaion in excel from access, howver the problem is whenever you make...

I am pasting information form one spreadsheet cell to another cell, The cell incorporates approximately 50 words however when I cut into another spreadsheet with existing data, only half of the information appears, I have obviously tried to wrap the text and increase the row height but this has...

I would like to allow the user to format (Bold and fill)those cells that are not locked in the protected sheet. Specifically to be able to Fill and bold cells, is anyone able to help on the resuired code to add to what is already below. Any held appreciated. Thanks ActiveSheet.protect...

I would like to insert cells and include formulas from above line, with one click of the button, as opposed to dragging each of the fromlas down from the above cell,any ideas on how to this would be appreciated.