Recent content by jempie

Hi All, I am trying to create a make-table query, with a new AutoNumber field. I know that if you are creating a new Text field you type FieldName: "" in Field and for a Number field you would type FieldName: [], but what do you type for an AutoNumber field?

is there no way of doing this in the query design? for example if you enter FieldName: "" It will create a Text field called FieldName. FieldName: [] It will create a Number field called FieldName. Thanks

I cannot design the report - unless someone know's a sneaky way of doing it! Has anyone been able to do this?

did you manage to do this? i'd be interested in hearing your thoughts as this would help save me a lot of time!:D .

does anyone have an answer to this?

Hi all, I have some records containing the following data ABC (UK) ABC (UK) Ltd ABC UK) Ltd ABC UK) I need to pull out all the data with a ) but not a ( and add a ( to the start of the word before the ). So for example, the four examples above would change to: ABC (UK) ABC (UK) Ltd ABC (UK)...

I feared there would be no definitive way of checking. Thanks for all that info though Neil, it will help me.

All, I have a Postcode field in my table and I want to be able to check the data to make sure that it is a correct UK postcode. Is there away that I can find out the format of the data, to be able to run a query against it, or is there a better way of doing it? I need to account for all types...

All, I have trawled boards and sites, but cannot find the answer! I have a make-table query, and I wish to create an AutoNumber field. Now I know that if you put fieldname: "" , a Text field will be created and if enter fieldname: [] then a Binary field will be created. Is there a code I can...

All, I am using an Make-Table query to add many new fields to a Table using Fieldname: "". However, when I use this, it sets the Allow Zero Length to No. Is there code that I can use to stop this happening? I am using this method for multiple fields and across multiple tables. Your help...

not to worry David - using strconv instead. Thanks.

David, Just tried to use your function in an update query and got a syntax error on line: If c$ >= "a" And c$ <= "z" And (OldC$ < "a" Or OldC$ > "z") Then Help?! Paul

jgc31/ all, I am trying to use this input mask as a validation rule against some data in another table. I want to create an append query that will append the records that meet the input mask. Can anyone help? Jempie

Yes, i'm afraid so. I've been given a flat file and the data needs to stay in the same field. I'm sure someone on here told me how to do it before, but I've slept since then! :rolleyes:

Hi all, I've tried searching the forum, but no luck. I have a Field say Field1, with data like this: AB, AC AB AC AB, AD AA, AB Where the field contains "AB", I want to replace the data with say "AB - Alpha Beta". But I do not want to change any of the other data. So the outcome should look...