Search results

I have a query that uses a linked table from an external database and joins it with a table from my database to return records that contain the same values. Is there a way to return only the records that are present in the external database and not in my db? Thanks

thanks mate, just arranging to get the references installed on to the other computers

hi Ive been using the following code to zoom on a text box as posted by ghudson: DoCmd.RunCommand acCmdZoomBox The problem is it works fine on my PC but not on any of my colleagues, even if logged on as admin. Can anyone suggest any reason why this would not work. It doesnt come up...

cheers ghudson, I wont be needing it anymore. I've been using your zoom function that was part of your audit trail on this form- which by the way is excellent :D

Thanks for the feedback. I am using a continuous form, but unfortunately in access 97 which I beleive doesn't support conditional formatting. Can anyone correct me on this, or does anyone know a way around this problem?? :)

Hi, I'm trying to write a simple update vb code for showing/hiding a text box dependent on whether any values are present in subforms: Private Sub Form_Current() If Not IsNull(Me.tbComments) Then Me.LblComments.Visible = True 'shows Comments label when comments box is...

many thanks for all the suggestions posted above, I have gone now replaced the buttons with labels and it works fine thanks again

Hi Hayley I have a problem that I think your solution might solve. I am however using an access 97 db. Could you please send me a copy of this in 97 format or the code?? Many thanks

Does anyone know if the command buttons in access 97 forms can be changed? thanks

hi sorry for bringing this post back, but it's exactly what I was looking for , well not EXACTLY. I have the same problem with trying to maintain an audit trail for a subform which is part of the main form. Using the excellent code provided here and following the suggestions to make it...

Hi I need to send an email order confirmation for when an order is completed to only a handful of people. From the way that my tables have been setup, I cannot add email addresses against people names. I have had a trawl through the excellent archive in this forum and am trying to use the...

now I made a real booboo! After hiding the toolbars in startup I can no longer get into startup or get access to the toolbars to show all options. Can someone please help! Thanks

thanks a lot guys, problem solved. I created a custom toolbar with the icons i needed and hid the rest ta much

Hi I have access 97 and I need to find if there is a way to keep a track of changes made in data entry and if you can identify who input the message thanks

I need to find a way to not allow users to access the backend by using the database window. Is there a way I can password protect this? Thanks

thanks mate. Our company has two servers for two sites, so after putting a copy on each server and linking them, it seems to have done the trick!

thanks a lot, I'll give it a try for it tomorrow. :D

thanks for the quick reply Ken No, we are all accessing it from one point on the server. Should I be putting a front end on each system? If so can you please tell me how? I'm a bit of a Newb :( Thanks a bunch

the changes that I'm making is just regular data entry. I would understand if I was actually changing the layout of the form. I was hoping that i wouldn't have to get others to come out for regular data entry- I certainly dont have this problem with the other databases that I use :( cheers

Hi I'm trying to use an access 97 database that I've created but there has been some problem with saved information being lost. when I go to save updates to the form I get the following message "Form has been changed since the last time you opened it, either by another user or because another...