Search results

It might have just meant "separate" semantically, but in reality it meant "separate and absolutely unequal". Is the USA better off after it came out of British colonisation?

I have a report of a standard form. I use an image of the form as me.picture. The format is as follows: Picture type: linked Picture size mode: stretch Picture alignment: center Picture tiling: no Picture pages: first page I want the fields that I place on the report to line up with the...

I transferred all the tables in a database be from the mdb to a mysql database. When I linked the "fe" to the mysql database most of the fairly simple modules worked perfectly but my main module ran into a "run time error 2448: you can't assign a value to this object" in a bit of code which ran...

Great! Thanks a million for your prompt response. That worked for that particular table. I will have to go through the other 50 tables. Groan! Geoff

I have recently tried to create a MySQL back end to my Access database. In one table, when I look at the key in the MySQL admin, I see that it is type bigint(20) and when I look at it in the design view in Access the same field shows up as type Text size 255. I am not allowed to correct a linked...

That worked brilliantly, thanks a million

Thanks. I appreciate your help

They do have some relationships, but that is not too important, as they can be deleted and recreated

By the prefix I mean onto the name of the new table (eg. if the table is "tblBill" call the new table "atblBill". I want to be able to delete all the original tables by using the "tbl" prefix.

no. It is the last field.

I have a database of about 80 tables, each of which has a "GUID" field. I want to delete these fields, but this is not permitted by Access. The alternative seems to be to run a "make table" query on each table leaving out this field. I want to automate this somehow, as the manual version would...

Poor ol' Ricky. He will be looking for another job soon, blindfolded or not. Can't you really empathise with the Aussies, like they do when they beat someone else.

I actually decided that I was having too much hassle with the mileage field so went with checking the date and time created, and that worked successfully.

I have attached a zipped copy of the mdb

Hi Darbid, I eventually got around to testing this again after amending some errors in the code. I went thru the 3 points as suggested. My table has an "ID", the debug.print shows 4 values going into the 4 records I am testing (my id's are autonumbers and go up by 1). I run the test a 2nd time...

also the code TempRst.FindFirst strSQL & "9" is wrong it should be TempRst.FindFirst strSQL sorry! I introduced that because on the 2nd run sentid was "" but I was getting an error on the FindFirst which showed the strSQL to be "[Id] = " without anything on the right of the = sign. I...

It is possible that I am using the wrong field type for sentid which I have as String.

The code you quote is just seeing whether there is a pre-existing value, implying that that item had already been included in the temporary table. Further on in the code it has the line: Mailobject.Mileage = TempRst("Id") This is where I am trying to update the...

Hi darbid, here is the link to the thread I mentioned below (is this how you do forum links?) http://www.access-programmers.co.uk/forums/showthread.php?t=199959

I am trying to save emails to an access database. I advice has been given as follows in the forum (I would suggest that you then get the ID number of this DB record and add this ID to the "mileage" field of the email item. Then you will always be able to find this email in outlook again (unless...