Search results for query: *

using access97 and replace function isn't there unfortunately.

Hi, I have a string in the format '001 555 2391'. I want to convert this to 0015552391. Any suggestions? Thanks.

The database i'm using actually does not allow replace function.

Hi, I have a string in the format '001 555 2391'. I want to convert this to 0015552391. Any suggestions? Thanks.

Sorry, I don't understand what you mean?

hi, i am trying to execute a stored procedure from excel(vba)...this works fine when i pass one parameter. however when i pass the second to the SP it does not work. Cmd.ActiveConnection = cnt Cmd.CommandType = adCmdStoredProc Cmd.CommandText = "SP_CreateTest" Cmd.Parameters.Append...

Hi, I have a string "ABC;DC" and I only want to see ABC. However the number of characters prefixing the ";" will change. Can someone tell me of a way do this using a view? Many Thanks.

hey, I want to put the default value of a text box equal to the result of a query... in the default value of the text field i have =[Query1]![Name1] it keeps returning #Name? however.... anyone...

hey, i have a form with multiple text boxes and combo boxes. one of the conditions is that when you enter data in combo box A, text field B is automatically filled in. i have this working by using the LostFocus function on the combo box event. this works fine. the problem i have is when i error...

thanks guys...

cheers foolio....

I have a MS Access 97 database with 5 users.. my first question is: are there any multi-user issues i should be aware of (i.e. can all users read and write to the database at the same time.?) my second question is: one of the users has Access 2000...will it be possible for him to use the same...

Hey, I have a form, which displays data from tables...multiple users input data to these tables.... what i need to do is have this form refresh every 30 secs or so..... i have a refresh button which does the trick: Sub refresh() Form_ViewData.Refresh End Sub however, what i want, is to...

Hey, I'm trying to do a basic delete query using DAO.... can anyone see where i'm going wrong... Dim dbs As Database, rst As Recordset Dim ssql As String Set dbs = CurrentDb ssql = "delete * from Tbl where key = '1';" Set rst = dbs.OpenRecordset(ssql)...

cheers guys

hey, is it possible to manually fill a combo box with values in excel (i.e. through properties)...the only way i can see is to use a range which i'd rather not use... cheers

hi, i am trying to import data from ms access into an excel file. however i have a linked excel file in the access database and any query built from this file will not import! anyone encountered similar problems? plus dont want to make temp table of excel file! cheers

cheers paul...

what i actually want to say is the max of field1 and zero..... i think using an if clause is the only way around it.... max(field1,0)

hey, i am trying to replicate the excel max function.... is it possible in SQl to mimic this...with excel you can say max(field1,field2)...this will give the highest value of the 2 fields.....is there a similar sql function or do you have to use the if function cheers