Search results

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...

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...

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...

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...

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...

Hi, I've got 2 linked SQL tables, linked by an ID number, and am trying to write a query (not very successfully) that will update a series of Y/N flag fields in one table based on values entered in another. The relationship between flag fields table and the values table is one-many as there can...

Hi, Hopefully an easy little problem for someone to help me with. Have a table with multiple flag fields (initially populated with either Y, N or NULL). Basically I want to know a way of updating all the Nulls in all the fields with an 'N' value in one go, without having to individually...

Hi, I have a contacts table made up of records which are a sub-group of a larger parent table. There is a one-to-many relationship between the parent record (company) and the records in the contact table. The records are linked thru a record ID number. The contact table has a Y/N flag for each...

Hi, OK - the problem is this: Have a main form displaying record details (Company, name, address, etc). Upon clicking a command button, a popup form appears containing filtered records from the main form (just the company name is displayed though). Next to each company name on the popup is a...

Hi, Until recently I have been happily exporting 5 data tables from Access to .txt files. Now, for some unknown reason, I am getting an 'Invalid Argument' when I try to export any of these tables. I'm sure it's not a size issue as a couple of the tables are fairly small. The only workaround...

Hi, I need to extract the first area character(s) from a table of UK postcodes, i.e. B from B7 8TY for Birmingham LE from LE13 6PL for Leicester I know any query/code is probably going to consist of ‘IsNumeric’, ‘Mid’ and ‘Left’ – just can’t get it to work. Any help appreciated. Alex