Search results

Thanks Peter, Seems to have done the trick! cheers...Alex

Hi, Simple question really (if you know your VBA)... Have a field which contains records of strings of alphabetic characters i.e. ADGHJLP BCEFHIJKLMOPST etc Need to be able to separate these characters with a '/' so that the field reads A/D/G/H/J/L/P B/C/E/F/H/I/J/K/L/M/O/P/S/T etc I know...

Rich, I'm storing the value to update related information (Name, address) in another table. cheers, Alex

Hi Wayne, Thanks for that. I am trying to do this as an update query not via a form - but I'll have a little play with dmax and see what happens. If anyone else has any suggestions, I'm all ears. thanks, Alex

Hi all, Simple question (I hope)... Need to devise a way of updating a field with an ascending sequential number within a group of records of similar type. e.g. Say I have records which consists of numerous IDs and various job descriptions within the each ID 13000...

Guys - thanks for your responses. It is a flat table, unfortunately this was a neccessity for processing requirements. The data is basic names/address/tel nos with each record having a URN ID. There are 93 key codes identifying the 93 different different groups or records. llkhoutx - not quite...

Hi, To avoid the mind-numbing tedium of have to use make-table queries loads of times, is there a quick (probably VBA-related) way to split a large Access table, of about 350000 records, down into 93 smaller tables, based on a key code field that identifies each group of records e.g. GBW102...

Kevin, The little 'If ... Left' code works perfectly! Superb...thanks again. Alex

Kevin, Got it to work...but not as you might have thought. Rather naively, I thought that Access could resolve "www.whatever.com" - after all, the web browsers have no problem with this format, but after seeing your MSN.com example, it occured to me that maybe I might need http:// in front of...

Access 2000

Kevin, Problem with changing the field type within the table is that it is a SQL table and does not have a hyperlink property... and it is already a text field anyway (or 'varchar' in SQL). Changed the name of the field to 'Web', that didn't work either as you guessed. Yeah, realise that...

OK chaps, still not working - maybe I've missed out something in my explanation that could be important. The form is called 'Meeting List' The text box on the form is called 'www' and the source field containing the web addresses is also called 'www' (the field source is from a query called...

Thanks Kevin, but it's still returning the same runtime error. Running the pointer over the strhyperlink variable gives strhyperlink = "www.nameofwebsite.com" So it's picking up the site address, but it just can't open it. Although it's works OK when you have an explicit hyperlink on the...

Thanks ... seems to be putting me on the right track. I've put 'Application.FollowHyperlink Me![www]' behind the OnClick event of the text box (www is the name of the field with the web addresses) Problem now is that when click on the address on the form, I'm getting a "runtime error 490 -...

I have a form whose source is a SQL Server linked table which consists of company details including a web address. On the form is a control box that displays the web address - and I have turned this into a hyperlink so that the relevant company site can be opened - however it refuses to open...

Thanks Pat, Put me on the right path. If anyone's interested for future reference, just set the relationship between the 2 tables in SQL Enterprise Manager (by right-clicking the Primary Key column). You can then delete as normal in Access and this will cascade delete all associated records...

Chaps, thanks for that although I'm still having the same problem with the greyed out boxes. As a test I did a make-table on the links to create the 2 tables in Access format, and found it then allowed me to enforce integrity. So maybe Access has an problem forcing integrity with linked tables?

Mile, 'Enforce Referential Integrity' along with 'Cascade Delete Related Records' check boxes are greyed-out. Do you know if there is any reason for this?

Hi, I currently have 2 SQL tables linked in Access 2K. It is a one-many relationship, a main company details table linked to a multiple contacts table. Have created a form that looks at both tables and can alter details and delete individual contacts. However, now I'm trying to implement a...

Hi, After much fiddling about I was able to adapt some Microsoft automation code that allowed me to add a calendar reminder in Outlook 2000 after clicking a button on a form in Access 2000. At the moment this sets a reminder on my own PCs Outlook calendar. What I want to do is set up a...