Search results

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

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

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

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