Recent content by Matthew Lamkin

Hello, I am wanting to create a holiday request form for use with Word97 onwards. This form has 3 sections, employee copy, managers copy & personell copy. What I would like to do is enter name/dates etc in a single field in the first section and it automatically copy the contents to the 2nd &...

Thankyou Pat, I guess that's that then. Will have to write the report from scratch to look similar. Cheers.

Hello, I have a database that I would like to have a report that uses the same layout etc as a MS Word97 Document that I have. The doc has a big table in it, split up like a form with spaces to enter details etc. I would like to be able to reproduce this as a report in Access97. Rather than...

OK Where do I put this? Thanks.

Further to this. When I double click on a field, I can get it to bring up a new form that allows me to enter data into the table. however once I exit that form, although the data may be in the table, its not displayed in the form that called it in the first place. how do I achieve this...

WAY TO GO! Thanks, thats much easier. I guess the default MS stuff has a lot of error checking or something in etc.

So thats all I would need to add into the doubleclick event?

Me not know, me from Barcolona! (apologies to anyone actually from there :) ) It's part of the database created by the access97 wizzard, try it. Maybe this bit send it to the end of the table & gets it ready to enter new data & hence does not display any current data (which is what I want) I'm...

After looking, is this done in the coding? with the string? Private Sub RoomID_NotInList(NewData As String, Response As Integer) MsgBox "Double-click this field to add an entry to the list." Response = acDataErrContinue End Sub Private Sub RoomID_DblClick(Cancel As Integer) On Error...

Hello, I have just made a small form to do an identical job as the "Rooms" form that is used in the 97 wizard room inventory database. Eventually I want to do the same function & double click on a field, bring up this form & use it to enter a new record in a table, that then displays in the...

I have been helped by the IT manager who has pointed me in the right direction to start with & am trying it thankyou.. I have a table with static info like "Boardname" & "Description" in. Then another table with "Boardname" (relationship pointing to other table, same filed), also an...

I don't think it needs to affect any old forms etc. I want to have a database that lists schematic diagram names, then records the issues of them. I think (with brain of a potato) this should be case of having a table with the names of the diagrams in, then another linked to the first with...

Hello, I'm looking into creating a databse that will allow me to record the issue of schematic diagrams & printed circuit board files. If I start small & make one that will issue diagrams, using a table to keep static main info in & another to record what gets isued to who. Can I later on then...

Thankyou. I shall now go away and try and see if I can understand this lot... Thaks again. I'll come back when I have finished.

HI again, this looks excellent.. what does " Set con = Application.CurrentProject.Connection" do/mean? Its what its having a problem with. the ".CurrentProject" does not appear in the help searches. Is this perhaps a feature of 2k that I do not have? me = vbdunce. I have a few other questions...