Search results

works a treat brian. I used an update query and works fine many thanks gaz

I have a table that I need to update. The field is alphanumeric and goes like Dc0001 Dc0002 Dc0003 Dc0004 I want to add an extra 0 onto them so would be Dc00001 Dc00002 Dc00003 Dc00004 As there are a few thousand records like this I don't want to do it manually and just wandered how would...

My company are wanting to go down the SAP route. Basically how do this work and how do you design a database ? Do you create a user interface somehow (does SAP have it's own interface like an Access frontend ?) and then have the data stored separate like in SQL server ? Do you need any...

I have a RemoveAlphas function that strips any unwanted characters from a phone number and just leaves the numeric. Function RemoveAlphas (ByVal AlphaNum as Variant) Dim Clean As String Dim Pos, A_Char$ Pos = 1 If IsNull(AlphaNum) Then Exit...

Thanks for the posts guys. I have been looking into this a bit. Problem was i had REF0001,REF0002,REF0003 e.t.c. Then someone typed in REF999 instead of REF0999. I didn't know about this problem until i entered REF10000 and thought i had lost the record but as you say it puts it after REF100...

I wrote a database in Access 2003 which is shared between about 15 to 20 users. i.e they have similar front ends but all access the same back end mdb Now my company are wanting to move the back end to sql server but have the front end in VB.NET and not Access. I guess you cannot do a simple...

I have an alphanumeric primary key that goes REF0001 REF0002 REF0003 e.t.c. When i get to REF9999 and enter REF10000 it does not store it after REF9999 but stores it after REF100. Why is this ? Is there a quick way that i can add leading 0's onto my records so it will read REF000001...

The database is on 4 computers at work, i.e the same front end on each machine. Three of the machines cause flickering whilst the fourth machine does not flicker. I don't understand. Is exactly same front end. Normally when i open the form i see calculating at the bottom left of the screen...

The calculated fields were put on the form so the operator didn't have to work everything out by calculator. So magnesium to magnesium oxide. Sodium to sodium chloride e.t.c Just had =sodium*2.5422 for example. Operator would type sodium in and it would work out sodium chloride I.e NaCl this...

I have a form where the record source is a table. The form has about 5 calculated fields on it. The screen flickers quite badly and at the bottom says calculating. Sometimes the database locks up. To stop this flickering i created a query so that the calculations are done in the query. Then i...

After inputting data into a text box on a form i want to click on a command button which will open an email program and then put the text there so i can send it.

My database is in 2003 and the back end is currently being converted to run on SQl server by I.T department. I am using Access 2003 at present with a normal mdb back end. When it is converted to SQL server if i want to modify the back end such as add or modify tables is it easy to do. Is it...

Can you have Microsoft Access 2003 and 2010 running on the same machine. My company has converted one database to 2010 and linked to SQL Server. The other database which is a totally separate database is still in 2003 and has yet to be migrated to 2010 / SQL server. They still want to use both...

Can i do that myself from PC or do i have to get IT involved ?. How do i check it myself if i can. IT department gave me local access rights as before i was unable to join the Workgroup Information File but now i can. It said "Access is denied" before i had local access but is ok now. I...

Cannot open back end database. There are no other users logged on Tried opening it in open exclusive mode but still error message. Front end on number of desktop PC's. Back End on server. I need to get in design mode on back end but won't let me. I get logon screen but when try to log on get...