Search results

Hi all, this could well be a bit of a weird request so bare with me. I would like to view the table size (in KB, not records) and I would have thought the Detail view in the Table tab would take care of this for me (i'm sure it used to, i'm using Access XP now) but I cannot get that...

Thanks Nellie. Your suspicions are correct, stepping through the code it errors up when it calls the qry but opening the qry itself and manually adding the values works fine. The code is as follows:- SELECT tblTopServicersLOCAL.Rating, tblTopServicersLOCAL.Servicer...

Hi all, trying to run this code that should insert '1' into the first record then adds a value to that and then inserts that to the next record (value 2) and inserts that into the next field until it comes to the end of the recordset of the query but I am getting this error message:- Too...

Thanks for your answers guys. I myself cannot answer the 'Why' question since this is a decision made way up the line and therer is too much red tape involved in the changing of a process that has been set in stone years before I set foot in the Company ! I just wanted tio avoid creating these...

Hi all. I have been asked to develop two DB apps in Lotus Notes which filled me with despair since I would rather do this in Access 2003 but aparantly Notes can hold files. I know Access can link to files stored on a network but can Access match up to Notes in this feature and actually...

Hi all, trying to populate a unbound text field on a report using this code: Me.txtPrevLC = DLookup("loancount", "tblDeptStats", "ID=98") but I get this error message: Run-time error '-2147352567(80020009)': You can't assign a value to this object. I have used DLookups and Dcounts for unbound...

Thanks Bob. Aw, I see you are based in Portland, I was there just last month. Nice City.

Hi all, I am assisting a Dept. in enhancing their DB Application in Access 2002 and am reading through their procedure notes for using the mdb and they are instructed to Compact and Repair the MDB everytime they use it. I remember my old Access Guru years ago telling me that this is not...

Hi all, stumped on an issue I thought would be pretty straight forwards (again) so i'm hoping to find the answer here! I have a make table query which produces the table using fields from three other tables and it runs fine however I now want to insert a new field with the value...

Hi Rural. I've decided to use .addnew instead. I noticed that if I cleared the table down, opened the form, hit the button, i'd get the message that theer is no record to edit, then hit the prev record button, then hit the import button it would work, but only if it's the first record in the...

Hi again. Tried adding dbOpenDynaset but still no joy. I can't firgure out why it will not add the data to the fields ????? The table itself already has a lot of data, it was pulled in from an existing Excel sheet, i'm just tring to automate the process. The form opens and displays the last...

Cheers RuralGuy. The Not IsNull method won't work, it errors up on that line but it works fine using my method. It also worked using my method for .addnew, its only since changing it in favour of .edit Any ideas ? Mitch...

Hi all, I am trying with little success to update the fields of a table on a record that already exists. However, after running the code from a command button on the form the record's fields are still blank. Reason why I am doing it this way is because once the user has completed...

Thanks Wayne. I'm actually testing to see if the value is not null. Is that possible with DLookup ? Doh!! got it, its <> Null. Thanks again.

Hi all, trying to write a DLookup wher it pulls up the first record that has a value that is not Null. The code is as below: strValue = DLookup("[FieldName]", "MyQuery", "[FieldValue]=Is Not Null") but I am getting a syntax error message. I suspect I am coding this wrong, can anyone...

Thanks Jon, that worked perfectly. Mitch...........

Thanks Jon. Gave that a try but getting the same error message. I really can't figure out why pulling in the value from the form is giving the qry so much grief since it works if you were to paaste in the value, which, just so you know, is : #4/30/2007# Or #5/17/2007# Any ideas ? Cheers...

Hi all, I have a select query that pulls in two date values from a textbox on a form. SELECT DISTINCT Table01.SRV_NAME, Table01.IMP_CUTOFF_DT FROM Table02 INNER JOIN Table01 ON Table02.Servicer = Table01.SRV_NAME WHERE (((Table01.IMP_CUTOFF_DT)=[forms]![frmreport].[txtsqldate].[value])) ORDER...

Thank you Ian, that worked a treat !! Mitch.............

Hi all, i'm having problems exporting a table as a CSV file. Well, actually it works fine but the date field in the resulting CSV file is not formated as short date, instead it shows like so... 7/15/2007 0:00 The code is below. DoCmd.TransferText acExportDelim, , "tblMk15th"...