Search results

Ahh, thats excellent, thanks to you both !

Cheers Rural. No, i'm actually trying to take the first four characters away from that value so the rest of the value is dispalyed. I thougth I would have to work out the length of value then minus 4 from that number and use the value of that as the value to use the function RIGHT with. But...

Hi all, I have a textBox on a form which pulls in the value of a field from a query that the form is based on but I would like to truncate it. Using =Left([]myfield)-4 does'nt work as you can imagine so I have to use the LEN function but how do I do so in the control property of a...

Hi all, I have this select query that pulls out the last 13 distinct values in in descending order from a table. However in order for me to play with these values I need an ID number and ideally i'd like to do this on the fly rather then do a make table and then use that. Is there any...

Thanks for ther reply Mr Larson. Yeah i'm quite particular with the naming of fields but thats not the problem I am currently facing, its the value of a field. I want to use the + sign in the value. If, however that's not possible i'll have to go without but the reason I want it in the value is...

Hi all, I am trying to update the value of a field from say, "Word" to "Test120+". I am using the SQL code as below.... UPDATE tblTable SET tblTable.Field = "Test120+" WHERE (((tblTable .Field)="120") AND ((tblCurrent.Field02)="TT")); But the end results are that the value has been...

Hi all, i'm having a strange problem right now with an update query that I hope someone here can point out my error ! I am trying to run this in Access 2002 on a Win 2000 machine. I have pasted the SQL code below but everytime I run it I get the error mesage "Operation must use an...

Thanks guys.

Hi all, I am just wondering why Modules have the name of bas at the start of the name. frmForm and rptReport makes sense but why bas for Modules ? Thanks in advance, Mitch.....:confused:

So many options !! Thanks Guys, I now have it working a treat !! Mitch........

Hi all, I am tring to loop through a recordset based on a query and each loop keeps showing the same value. The query itself has 5 records, but my loop keeps displaying the first record (5 times however). Can anyone please point out where I am going wrong in my code. Thanks in advance...

Hi all, I am trying to get the value of a field that is displayed on a sub report. The dlookup field I am using is on the main report and the value I want to pull from is on a subreport. The code I am using in the field is as follows:-...

Thanks for your replies. I have the data importing in as text however the values that are numbers in that column, such as 2111122945 come into Access as 2.11112e+009 ! I don't believe that Access can't handle number data in a text field like this. Any ideas please advise. Thanks, Mitch...

Hi all, I have been using Excel data in Access either by importing the sheet as a table or directly linking to the sheet with no problems in the past but today I cannot seem to get the data to import in the right way. The column on the Excel sheet is mainly populated by numbers but...

Hi all, wonder if anyone can assist me with this the SQL Server security/write (?) issue. The SQL Server Admin has created a table for our Dept. to use and via SQL Server I can get access to it using the username and password she supplied to me. I can also link to this table in Access...

OK, I have this formula in an excel cell that works out the change in percentage of two cells, the formula is as follows. IF(B3=0,O3,((+B3-O3)/B3)) The cells used are B3 and 03 and the results are stored in the AA3 cell. I am trying to write this in a text field on a report which does the...

Hi all, I am trying to format three fields to write to a table. For reasons unknow they are created as text so I tried using Cint, Clng and cdbl to export thee fields as numbers so when they are exported to an excel spreadsheet they are as number fields. This actually works for exactly...

Thanks Brian, that makes more sense. Mitch.........

Hello. I am trying to convert the current date now() to day month ( 5-Oct) using this code: Me.txtNow = FormatDateTime(now(), d - mmm) but as I step through the code the value is still long date. Have I missed a step or is my code incorrect ? Thanks in advance, Mitch...........

Thanks Bvan. I have now added new fields to both tables, an Autonumber ID field that is now the primary key. Treid to run the delete query but i'm getting the same message. This is weird !!! Found it !! For anyone else who encounters this I found the solution here...