Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by davetek
-
Removing spaces from string
using access97 and replace function isn't there unfortunately.- davetek
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Removing spaces from string
Hi, I have a string in the format '001 555 2391'. I want to convert this to 0015552391. Any suggestions? Thanks.- davetek
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Remove spaces from string
The database i'm using actually does not allow replace function.- davetek
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Remove spaces from string
Hi, I have a string in the format '001 555 2391'. I want to convert this to 0015552391. Any suggestions? Thanks.- davetek
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Executing stored procedure from vba
Sorry, I don't understand what you mean?- davetek
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Executing stored procedure from vba
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...- davetek
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Finding a character in a string
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.- davetek
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Defult Value of Text Box
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...- davetek
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
LostFocus/Setfocus Problem
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...- davetek
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
-
-
97 vs 2000 question
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...- davetek
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
-
Timer +Event
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...- davetek
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Delete Record +DAO
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)...- davetek
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
Filling Combo Box in Excel
cheers guys- davetek
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
