Search results

Hey, thanks for your replies Just taken another look a it this morning and seems my prompt field "Survey ID" should have been "Project Number" - and is working fine now :) The blanks are in there as this data will be directly imported into another database, so this blanks account for the...

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

I went another way with this and decided to do the formatting in excel instead.

Point 4 on this page is what I'm after. However I see no where to specify where the export would be formatted or not? - BTW this query is exported using a VB program that unfortunately I do not have the source code for to recompile - so trying to do this best I can within the query its self.

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 GalaxiomAtHome, Thanks for your reply; Im not sure whether or not this will suit what I want to do. Basically I have a column say called column 1 and for example in column 1 some of the data would read: Chrysotile Crocidolite Amosite Amosite, Crocidolite No Asbestos Detected, Chrysotile...

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

Re: Expressions ah hang on my fault, the query was being changed, just not export, seems i created the expressions but didnt change the code for the export! School boy error ops :)

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 thanks for the reply ghudson, Yes I had taken a look at the forums for MKDir, have used the function previously, but wasnt sure howid use it in this context: Dim sDirectoryPath As String sDirectoryPath = "Y:\CPAMS\Quotes\" & "Q" & Format((Forms![frm_quote]![ID]), "#-00000") If...

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 vbaInet, yes im fine with the actual formatting part, its just the totalling part thats driving me nuts! tried a query but done something wrong there, as im getting #name? - Ill keep persevering Thanks Luke

Hi jzwp22, There are no 'relationships' as such but they are related in the sense that the hold information to query and report on. If I explain the dataflow that may help. A user creates a quote (table 2/subform2), once that quote is 'awarded' the quote details are copied to the Project table...

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

Ok thanks for your help guys, i went with vbaInet's solution instead, Although I still dont understand by what you mean Bob saying that the table does not store the data in the order it is entered. I always use a unique identifier on the tables with no duplicates so I would assume (proberbly...

I tried a different method instead: DoCmd.OpenForm "Projects", acNormal DoCmd.GoToRecord acDataForm, "Projects", acLast Works fine :) Thanks for your help!

OK thanks very much Bob and vbaInet for the information, I shall do what you suggested including date/time field at the point of record creation. tried DoCmd.OpenForm "Projects", , , "Project Number = " & DMax("Project Number", "Projects") but getting a syntax error when it runs (Syntax...

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

Thats excellent, sorry to have confused you at first; i had tried something like this but guess I was missing the # or something :) have also applied to that my document name: "Q" & Format((Forms![frm_quote]![ID]), "#-00000") Thanks for your time help and patience +rep Luke

Ok thanks for your suggestion, but unfortunately its not what I'm looking for, I think that's why I was getting confused! here is the code i already have: Private Sub Command85_Click() On Error GoTo cmdExportToWord_Err Set objWord = CreateObject("Word.Application") With objWord .Visible =...