Search results

Thanks. I had worked it out. Thanks for your help.

Thanks Plog. I've managed to remove all characters before the '<' but how do I do a Mid on the remainder when each one is a different length?

I have a field which contains various text including an email address which i need to extract. My research says that I need to use a regex code but dont know how to get that into Access. I have attached an example of the file i'm importing into Access. Any help appreciated.

I have a form with a combo list and a check box. The combo list has values 1-4, the default is 1. By default the checked box is ticked I want that if a user changes the combo value from 1 to 2,3 or 4 then the check box changes from true to false.

it's ok. it works. the record didnt have a corresponding email address.

Run-time error '-2147352567 (80020009) No current Record sendexpiredproposals is a table. the fields are: Projectcode, BDLead, Email, ID

still crashes. The highlighted section in the code is emailadd = Nz(rs.Fields("Email"), vbNullString)

I have the code below which works if there is data in the field "Email" but crashes if the field is empty. How do i get it to ignore if the field is empty? Dim db As Database Dim rs As Recordset Dim emailadd As String Set db = CurrentDb() Set rs = db.OpenRecordset("sendexpiredproposals")...

Brilliant Thank you.

thanks but what I was asking is how do you control user s permissions on a form? I have 3 user levels and i could use the same form but i want them to have different abilities. EG. Open a form that has a combination of text boxes and subforms. I want user level 1 to be able to edit the text...

I think the error is actually coming from the onCurrent code which displays a picture on the page. The code is : EmployeePic.Picture = Photo Where Photo is a field with a path to the object. I tried changing it to the below but got and error msg saying object required. If...

I have a button that opens a form which is based on a query. The query has a prompt so when you click the button the prompt pops up. However if nothing is entered you get a VB error 94 error. How do i get it to show a msgbox if the search is empty?

Thanks Gizmo. How do I go about doing that?

Thanks again Plog. Have now normalised the entire database and it's working well.

Is it possible to have a form and dependant on the security level of the user, will depend on what control will appear? Or can I have the controls there and lock them to a user? I have a DB of staff directory and I want to lock it so users can only view information, supervisors can edit and...

That works brilliantly! small point, if i want to do a query\report listing a user and their qualifications. how do i stop the user details being listed for each qualification?

should also say that I selected more than 1 entry but the userid was only in the qualification table once.

ok, getting somewhere. I did what you said earlier.I created the forms and and just typed in the list values. I made the list multi select. Then saved the qualsubform with the list control on it. Then on the new staff page I dragged the subform onto it. Saved and ran. Entered test data which...

Ok but the Qualifications are a lookup (list control) from another table.

Sorry, dont follow. I understand the prinicple of the 1 to many but how do I add it to the subform. I wanted the form (or subform) to be able to select multiple entries from a list control. It will take the qualification from table (c) and insert it into the Qual table (b) with the StaffID from...