Search results for query: *

Hi, Basically I want to have a webpage with a single table that has 4 columns 1st- Date 2nd- file 1 3rd- file 2 4th- file 3 The files are word doc's that I am opening with window.open() what I need is for the user to be able to dynamically add rows to the bottom of the table and then...

Hi, I have a 3 columns with a series of rows. The first Column contains a persons name, which may repeat several times. What I want to do is have something like the autofilter, but just for the name cell, then when a name is selected all the rows for that person are filtered and displayed. I...

Hi, I am using the following code to copy across rows of data from one excel sheet with rows of information to another blank sheet. It works but some of the data stored on the main sheet are hyperlinks, and when I copy them across only the text is transferred, hyperlink is lost. Any ideas on...

Hi, I have a table of notes on a 'notes' form that I need to open from a command button. The notes need to be specific to the currently 'focused' primary key called ipcisID of the main form. I cannot link them up, I have tried using the wizard but it will only link to one of the primary key ID...

Hi, I need to be able to 'refresh' a subform after data is input from my main form, how can i do this. Thx

Hi, I have a field on my main table that gets data from a lookup on another table. There are 3 fields in the lookup name, address and telephone number. How can I get the corresponding fields in my main table to automatically fill in with the related data, e.g I select the name and the address...

Hi, what code would I put on a button on a form that would allow a user to specify the location of a file on a harddrive and then assign that file to another button that has this code on it to open the specified file: Private Sub Command273_Click() On Error GoTo Err_Command1_Click Dim...

Hi, How would I go about running a report that checks a table based on 3 dates, the first the date sent, the second the date expected and the third the date received. Basically if there is no date in date received and the current date exceeds the date expected then It must be included in the...

Hi, I have a field on a table that holds a figure of 40 hours. This field is represented by a textbox on a form I want to be able to input a value of rounded to the nearest half an hour into a text box on a form and then the new number of hours to be displayed within the original textbox. Any...

Hi, ipcisID is the priomary key of the table I am searching, I have a combobox that allows the user to input the ipcidID and it then goes to that record. I have this code on an onclick event of a combo box: Sub Combo38_AfterUpdate() Dim strSearch As String, rsCL As DAO.Recordset...

Hi, I have to get this done by this week any ideas would be great. I have created a standard search button using access' wizard. the code on the onclick event is as follows: ------------------------------------------- Private Sub Command205_Click() On Error GoTo Err_Command205_Click...

Hi, I have inserted a standard search button on my main form and this works fine, but it does not look up any data within the subform that is on the main form. How can I make it search there as well? Thanks

Hi, I would like to run a report that the criteria for is selectable from a variety of tickboxes. i.e All the fields are available as tickboxes and the user selects those that they require the information about, there will then be a 'run report' button that will then gather the selected...

Hi, I have some code on the control surce of a textbox to automatically calculate a date from another textbox. =DateAdd("y",+14,[date sent to]) It works but the calculated data isn't automatically put into the table, the cell just remains blank. How can I make it paste into the...

Hi, I have this code in order on an onclick event of an textbox DoCmd.SendObject acSendNoObject, , , [email], , , "IPCIS: " & Forms!frmmain.ipcisID, , vbYes It works but my works novell network always asks me for my profile first, anyone know how to bypass this? Or another simple...

Uh oh! I have a huge problem, I was tinkering around with events on one of my subforms when somehow it's record source got changed. I changed it back but now no data appears, even though I know that everything is linked and named correctly? Any ideas? I can email the files if anyone can take a...

Hi, How would I code this If (the current date) and 'datereceived' are greater than 'date expected' then show an alert label --------------------------------------- I currently have this code Private Sub Form_Load() if Now and date_reply_received > dateexpectedex then Me.lblalert.Visible =...

Hi, I have put a standard search command button on my form, however it will only search for info on the main form. How do I set it up to search both the main form and any subforms? Thanks!

Hi, I have this code to open a tiff from access, based on the primary key of the current record in focus: filename= "c:\docs\tiffs\" & Me!primarykey & ".tiff" How could I adapt this to locate the file in a folder named the same as the primark key. ie. filename=...

Hi, I have a tickbox called 'cinc' that when ticked enables a textbox called 'datecin'. But when I move across to anothe record the enabled status is lost and the text box becomes grayed out again. How do I keep the box enabled/disabled per record? My code is: Private Sub cinc_Click()...