Recent content by garyholc

Hi Bob Yes I agree, ive never had to do it either but the user is demanding a way of exporting all the comments into one cell in Excel, which in my eyes kinda defeats the point of having the database in the first place! Anyway, thank you for your help! Gary

You could create a query, which would then create or append to a new table. In the txtType field put "=left([txtproductnumber],1) to return "A" Then txtPart field put "=mid([txtproductnumber],3,2) to return the "01" And txtRev would be "=right([txtproductnumber],3) to return the "002"...

Hi Yeah I tried this and still get the same result, it truncates the text. The comments field in the comments table is of Memo type, but im thinking that Access is truncating after 255 characters which seems to be documented all over the place. Ive tried removing the "string" from the...

Hi Bob No, I want every comment that relates to the record number of the main table to be concatenated into the one field. So for example: Main table: Rec Num ====== 1 2 3 4 5 Comments Table Links to rec num Date Comment =========================== 1 - 10/10/2010 - Change...

Hi Bob Thanks for that reply. Ok I have used a LEFT JOIN linking the main data to the comments table, and I removed the WHERE statement from the Concatenate in the query. However, I now get multiple rows, because one record in the main table may have 20-30 rows in the comments table.

Hi Im trying to use Duane's concatenate function in a query. Basically I have two tables, one contains all the main records, the other table contains all the comments people have added relating to that table. The comment field in the comments table is a memo field. In the query, im simply...

Sorry, was being thick! Found it straight away! lol. Anyway, much appreciated for your help. :) Gary

Hi Many thanks, yes this works great . Quick question if I may .... the form I will be using is the fFindOpenImportFile. When i click browse, this goes straight to the C:\Windows folder - is there a way to specify an alternative default location? Many thanks Gary

Hi I'm trying to store the location of a file chosen by the user using the file chooser dialogue box. This code is taken from Microsoft. However, the MS code shows it for a list box. I just want it to store 1 file location in 1 field, called FileList. Here is the code: The bit is red is...

Here is my problem. I have a "main form" on which I have some fields. For one of the fields, I want to say that if the date field is blank, it is to use the date field (for the same building) from another table. Ive built a query which shows the date from the other table, depending on the...

I tend to use the Docmd.runSql Try googling this command with the update statement and you should find some examples.

I would do an UPDATE statement when the form is saved which updates the value in the other table. Ideally the name of the person has a unique number (such as an auto increment number) as its primary key, so you can tell it to UPDATE the value where the persons ID number on the questionnaire...

Yeah i found the same. I locked the field so when they clicked in it, the zoom box appeared and they could do what they wanted in the zoom box, but when it was closed, none of the changes had been saved in the field :)

Is there any way to set the docmd.runcommand acCmdZoomBox so that when the expanded text window appears it is read only? Just I have a memo field on a form I want people to be able to click on and read everything in it, but not edit it.....

Thanks both , got it to work with your help. Point taken about field names, will look to change them.