Search results

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?

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

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

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

Using the TransferText function, I am exporting a table from access as a text file. What I would like to do is have a message box appear showing the number of records that have been exported. Can anybody help? Thanks

Hi there, I have a field of data that has been created by a query: 6.1 7.6 8.7 9.0 10.2 I want to round up any values with a decimal point between .1 and .4 to .5 and anything between .6 and .9 to the next full number (i.e. 8.1 = 8.5 8.8 = 9.0). I have searched here and the net and cannot...

I have a good knowledge of Access and VB, but no idea of how to create reports besides using the wizard, as I've never really had to use them that often! I have a report that shows all the names in the database. However, I want to get the user to select one name (using a combo box which shows...

This may be a silly question, but does anyone know the keyboard shortcut to Run a query when it is in Design view?

I'm probably missing something really obvious, but I can't see it!!! I have an email address field in a form. When the user exits the text box, I need an emailaddresscheck function to be run. Here is the function: Public Function EmailAddCheck() Dim blnValid As Boolean blnValid = True If...

I have the following code in a module: Private Sub Exprt_Click() Dim strFileName As String Dim tOutputPath As String strFileName = Format(Date, "ddmmyyyy") & ".xls" tOutputPath = "E:\Jemmo\BMK Classified\SamplesForBMK\" DoCmd.TransferText acExportDelim, , "This Week-Deduped", tOutputPath &...

I need to bring up the import/export wizard on the click of a button, or upon startup. I have looked in the help and on the net, but couldn't find anything. Can anyone help?! Jempie

I have a table named (say Table1), with two fields (say Field1 and Field2). I am trying to create a macro that will set both Field1 and Field2 to Text with Field Size of 10. Is this possible? Regards, Jempie