Search results

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

I do not mind entering the data manually... This is not running, I get : "Compile error: Method or data member not found" Highlights Form_Switchboard:Class Module Private Sub FillOptions() & CurrentProject It will no allow me to run the switchboard then. Although I can open it all if I hold...

Er... thanks but even though I can run it, I cannot make head nor tail of it? Whats it supposed to do, all I can find is a form asking for some dates. Thankyou for trying, however I think its not quite what I am looking for. I have knocked together a database, however I can forsee problems...

Hi & thanks for that, unfortunately I cannot open it. I assume that it has been created in one of the latest versions, only I forgot to say I was still on Access97 & cannot upgrade. Going off what you have said about it, that does not sound like what I am after. Never mind I guess that I will...

Hello, I have thousands of schematic diagrams and service manuals that I would like to catagorise into some tidy format & was wondering if anyone had done a similar database etc that they might share the basic template of it with me? I want to catagorise them by Type (TV/VCR/Monitor/DVD etc)...

Hello David, thank you for your reply. It may come to what you have mentioned, but what I really want to do is have the name or initials typed in, as "I" may be entering them for "others". As it is I have 1300 entries to backdate into this database once I have set it up. (long job....) Any...