Search results

Thanks Fuzzy - I'll give it a try! Ali

Aha! Managed to get error trapping working which will do for now. Thanks for your help.

Hi, I don't quite understand: "are the controls you are referring to subforms" The control (Port 17 loss) is a field on the subform [P1]. Am I not referring to it correctly? Many thanks Ali

Hi and please help as I'm very lost!! I have a form [Main form], and subform [P1]. In the subform's Current and After Update events there is code: Call tablevisibility, which is a module containing the code: Public Function TableVisibilty dim tablevis As Variant if not isnull...

BerLIMEY!!! That was quick! Worked a treat and after three days of head scratching really kicking myself for not posting sooner.... Cheers Colin!

I have a form called 'Address Lookup' consisting of a combo box called 'lookup' in the form header and a text box called 'Address' in the form detail. The record source for the form is qry 'address lookup query' and so is the row source for the combo box. On the After Update for the combo box I...

Hmmmm.........still the same thing with that but thanks anyway. Think its going to have to be opened from the windows start bar the unlazy way!! Cheers Ali

Strange thing this. I want to open another application from Access but when it does it will only open it minimized on the Taskbar when run in Windows NT, while access retains the focus. I have mangaed to make it work on my Windows 2000 PC. I have tried the following attached to a command...

Ian That did it!! Thank you very much for your help. Regards Ali

I'm sorry - I should have explained that this is in a form not a report, so there is no On Format. The line- if isnull ([me!text box1]) OR isnull ([me!textbox2]) OR isnull ([me!textbox3]) then didn't work but also didn't throw up any errors which is at least an improvement! It only worked if...

Hi! I am trying to evaluate whether several text boxes are null so that certain labels are visible. If I want to do this with one text box I am using: If isnull me!textbox1 then me!label1.visible=true else me!label1.visible=false end if How can I check if more than one text box isnull? I...

Thank you Pat. We have an improvement! I now have my two tables [tbl.Personnel] and [tbl.Vehicle] and they are related exactly as described in Graham's post. I have created a query [qryMaster] which contains all the fields from both tables. I can now add data to one field from tblPersonnel in...

Graham, Thank you for your help. I have done exactly as you suggest (and double checked!) but as before the data is only passed to the tblPersonnel. If I close the query right after adding records and then reopen it no records are displayed. I built a form on the query but the same thing...

This is something in Access I just don't get! Please help me understand. I have two tables, tblPersonnel (Names,clock numbers etc) and tblVehicle (Vehicle make, model, registration etc) If I make a select query including all the fields from both tables and type data into say the Surname field...

Peter - Thanks. In fact what I'm trying to do is have several reports based on only one query. Rather than have a separate query for each report I'd like to use the same query but insert different criteria in the criteria pane of the query for each report. This way I could get the cmd button...

Hello all, Is it possible to write code that will enter an expression into a query's criteria, overwriting what's already there? I want to attach the code to a command button on a form. Then I could have several command buttons which enter different expressions into the same query. Many thanks...

Another thing! Because of the demise of all my sendkeys actions, I am trying to find a way to make a query's Criteria pane = a text box in an open form. I used to (from a cmd button) open the query in design, arrow down to the criteria pane and paste in the data from the field in the form - all...

Hi all, Have run a database in Access97 for a few years now with no problem. However, since upgrading the operating system to Win 2000, none of my sendkeys actions work. I'm still using Access 97 as that is what most in the company use and the database is regularly distributed to them. I...

Pat - thanks very much for that! Must admit I was pretty terrified when I first read that code but I've managed to adapt it to my needs without any kind of nervous breakdown. Thanks again. Ali:D

Ian, That kind of does the trick, thank you so much. Now that I have a list with each email separated by a comma I'd like to try and work out how I could paste that so that it isn't a long column (there are 150 email addresses) but rather an email, next email, next email, etc. I'm sure there...