Search results for query: *

Oh yeah, and how do I make the selected files selectable <a href= etc..> and not just a string? Thx

Thanks for the replies, Mwolf00, that works awesomely, except that it doesn't seem to save the rows or file that I add. Each time I open the page it is just a single blank row. How can I make it save any rows and files that I enter? Many Thanks

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...

I have figured a way of doing it, by putting an extra column with the code =hyperlink(name of cell) down it and then hiding the column that is transferred, give the 'illusion' that the link is copied. But is there a better way to do this? Thanks

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...

Good question, I have put the notes field on the end of the main table and it now works fine. Apologies for being dumb, thanks to everyone for the help!

Um, There really isn't a navigation as such just a memo text box with some words in it. For example you are currently viewing the data for ipcisID number BX1234, you click the goto notes button and the relevent notes for that ID number pop up in the notes form. The notes table does have a...

The notes form is just constructed from a table that has two fields: ipcisID (the foreign key) Notes (a memo field for notes) The notes form is opened by clicking on a command button on the main form, which has the following relevent field: ipcisID (the primary key) So basically the...

Hi Billpower, I have amended the code to make sure that it allows for a string but I still can't get it to link to the primary key. Have I set the relationship incorrectly on the tables, currently I have rererential integrity enabled with both cascades enabled. I am really stuck on this any...

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 got it to work but I havd to use: =[Combo289].[Column](1) on the control source of the textbox. I should have mentioned that I have an autonumber Primary Key, and not the name as I suggested before, sorry. I have taken on board your suggestions and will not repeat the data into the...

Hi, I have put the 'select distinctrow' that includes all the fields I need, and put the '[Address] = Combo289.Column(3)' on the after update event. But it doesn't do anything. I have also seen this: Me!Address = Combo289.Column(3) Does this relate to the textbox called address and...

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, I figured out the first query but still stuck on that path :(

Thank you both for your replies. Billpower, I am trying to use the hyperlink form to create a list of files, but I keep getting a error about glInitDir. Any ideas why? Also since you seem to know what you are doing :) I am trying to reference a field in an unlinked table from a form, how...

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...

Not sure how I would implement that, any pointers? Thx

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...