Search results

Hi, I have a form and if the user makes changes to a record I use the BeforeUpdate event of the form to ensure they wish to save these changes before moving to a new record. Private Sub Form_BeforeUpdate(Cancel As Integer) If MsgBox("Data in the current record has been changed since the...

Thanks for the offer of an example but figured I'd have to go down this road so hopefully I'll scrape something together :-) Thanks

That's my point. I would have though the OnPrint event for a report would be generated when the report printed but my brain works differently I guess :-) I am calling the report using DoCmd.OpenReport from vb within the form. When the report comes up I go to File->Print. Is there anyway I can...

Hi, Unfortunately my patience with MS Access is wearing thinner and thinner by the day now. I tried to do a very simple thing this morning. I have a form which previews a report - fine. Now if the user decides to print this report I want that to trigger the printing of another report also...

Hi, I have a db with the tables linked between a BE and FE. It resides in a folder on the server \\server001\RBRS\ and I want the users to be able to copy the FE down onto their own desktop with the shared BE residing on the server. When users copy the FE onto their desktops do they need to...

Hi, Using Access 97 everytime I export/pulish a report with Excel I get the same "invalid sheet name" error. It still opens the report in Excel but how do I get rid of this error? Thanks, Liam

Pat, I agree. In a perfect world that'd be the answer. However there were design constraints and I don't find one form in Access is flexible enough to cover all the different scenarios between adding/editing/viewing etc. Just for example on the viewing form I have unbound fields in the header...

Gentlemen, Lesson learned the hard way I'm afraid. I still think it's crap, a terrible design feature of Access and that I'm right :) What should have been 5 minutes work has now turned into 5 days literally. Liam

Apologies for being so sticky but is it!? Is it really the way to go? In this particular db for example I have a form for adding info to the table, a seperate form for editing/deleting info and a third for viewing the information in the table. I need these seperate forms for various constraints...

Why why why!? What possible reason would Microsoft have for setting it up this way? What you're saying is that if I create a form containing controls linked to fields so that a user can enter details into a background table then I alter an attribute of one of these fields in the table the...

Hi, Im using Access 97 and I was just putting the finishing touches on a small db when the user made some minor changes to some of the information being captured. No fields changed but some of their properties were altered, I put in new input masks in some cases, changed the field size slightly...

Hi, We've only recently switched our systems over from Office 97 to XP; now the VB in the back of lots of my databases doesn't seem to work anymore. This code now produces all sorts of errors: (the vars sqlSearch and qryName are two string set in other mods) ' @var dbs a database object Dim...

I still need users to log on as I have a number of different security levels depending on which sections of the db each user has access to. I need user-level security but I want to apply it to one particular db and not to Access as a whole

Hi, I'm having a bit of trouble getting my head around the user level security in MS Access 97. It seems to me that when I set up user-level security it is set up for MS Access as a whole rather than for a particular individual db. I do not want to have to log in every time I open Access or...

Thanks for all your replys guys. The info you've given me has been really helpfull and at least I've been able to make my argument :-) I still have one last hurdle though I'm afraid. There is plans now for a SQLServer BE but for the moment the DB will just have linked tables with a BE residing...

Thanks Mile-O-Phile, I did a little more digging just for curiosity's sake and found vague references to problems with actually linking the tables from the FE to the BE. Apparently if the queries in the DB are not passthrough queries there could be issues with traffic over the network. Has...

Hi, Just a few general queries I was wondering about. I've heard various rumours that Access is not "safe" to use in a network enviornment. I had intended using a split Access DB with an FE on each users machine and a BE residing on out local server here. However our IT department refuse to...

Hi, I have a database with a table tblSTORES and a table tblRECEIVED. tblSTORES contains a list of existing materials and tblRECEIVED contains newly received batches of materials. A user enters records of materials into tblRECEIVED usually in groups/batches and these records are recorded...

Hi, I don't think this is possible but I'm gonna throw it out there anyways. I ave a small DB which captures particular work done and also plans future work. Two fields in my primary table are Job Status and Job Date. The Job Date field is in the format "mm/yyyy". So jobs which have been done...

Jon k, I have used your example as a basis for my own and I now have it working. Thanks for going to that much trouble. Thanks again, Liam