Search results for query: *

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

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

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

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

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

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

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

hi, i have a column (A) with a list of data. the number of rows contained in column A varies from day to day. i need to use the number of the last row as a variable. is there a function that will return an integer with the last row number of data for the column. thanks

hi, i recored a macro that multiplies a column by 1. this macro simply copies a cell containing the digit 1 and uses the multiply option in the paste special tool. however i want to hard code the digit 1 to vba code so as to avoid the selection.copy any ideas... below is the code i am...

Hi, this is my first time attempting to write from Excel to an Access database..can anyone give me the basic syntax of writing data from a cell to a table. Cheers

Hi, I have an access database which is giving me problems when i run it on a network. It will run fine whilst on my desktop, but when run from the network, it constantly stalls and crashes. I am using maketbl queries and am also appending to and deleting from tables.....any ideas why this would...

Hi, I have a query in Access that returns the results that i need..however i now need to show this data in Excel. Can anyone briefly explain (sample code even), how i can launch this query through a button in Excel. Thanks.

Is it possible to pick up the NT username in an access form? i can do this by setting up workgroups, but i want to avoid this if possible.... any ideas?

Hi, I'm trying to run an unmatched query using Access 97. I have successfully run one before, however this time i am getting an error : "ODBC -- call failed" this link to the table is ok, as other queries work fine! i have used the wizard as well so the code should be ok. does anyone...