Search results

**Solved**Query Problem Hi All, Okay, so I had this query working quite fine a little while ago, I added in another field with some expressions and started getting this warning/error: This expression is typed incorrectly, or is too complex to be evaluated. For example, a numeric expression...

Solved** Hyper link from query Hi all, The problem: I have a query that populates an excel sheet. Each item in the query has its own unique id, and a photo to go along with that. The photos are kept in the same folder where the document is created/saved, and are named with the unique id it...

Hi all, have an expression in a query that renames some text in a field, but I want certain terms to remain the same, can I use an else function? I have the following; Expr1: Iff([Field1]="Term1","Term2",IIf([Field1]="Term3","Term4")) Its actually much larger than that, but I want "Term5" to...

Hi All, Ive come accross a problem and for the life of me have no idea why its not working the way it should. I have a query, within that query there is a field called 'Identification'. I created an expression, like I have done so many other times to change the wording of some things. In...

Hi all, having a problem getting my .ActiveDocument.SaveAs code to create a new folder as well as saving the document. It works fine if its saved into a folder that already exists but just generates and doesnt save when i try and specify a new folder based on a filed name in the form. My...

Hi all, have never had to do anything like this before so im a little confused how im supposed to go about it. Basically I have a form for a project (on table 1), with in the form i have a subform on a tab that has the financial information which is from original quote details (table 2) I have...

I have a set of commands in vba to copy a recordset into another table and to open up a form that reads from the new table - It works fine - however it always goes to the first record. As the last record would be the one i just created (99% of the time) is there some code to put with the...

SOLVED - Export to word with text mask? Hi all, I have a table with an ID column that is masked with "Q-"00000 - the number recorded for example is just 124 but looks like Q-00124 on forms and within the table. Im working on an export to word and want to keep the same format mask. Is this...

I'm not sure whether i should be looking dlookup for this but this is what i have done so far basically its all from one table, i have two forms, one tabular and one a single record form. What i want to be able to do is to click the id field on the form to open up the the records individual...

Hi all, I'm by no means an expert in access but I'm trying to expand my knowledge by creating a call logging database. an exchange inbox is linked into the database. This will be where the support calls come from, i have setup a form with a button, the idea being to review the mails in the inbox...