Code:
select empno from mytable where empname=[enter employee name];
almaroc
Last Activity: Mar 21 '12, 03:47 PM
Joined: Nov 8 '11
Location: dallas, TX
-
What is the syntax for parameter query in mysql
my question is basically how to pass a parameter to a query in mysql. lets say i have a table with empno and empname and i want to select the empno based on the empname entered by the user. something like
i know this will work in access but in mysql it give me syntax error. -
thanks Rabbit. Good idea. -
Removing leading zeros in an address field
I am trying to remove the leading zeros from an address field. i.e
data: 00123 Elm st
result: 123 elm st. -
Thanks NeoPa. it worked perfectly.Leave a comment:
-
Problem combining multiple rows into one
i am using access 2007 and i am trying to combine multiple rows into one. i am using the code from this site but i continue to get this error:
Compile error in query expression. last(concat(dat a1.company,data 1.esi))
i tried using max instead of last same error however.
...Code:Public Function Concat(strCOMPANY As String, _ strESI As String) As String Static strLastCOMPANY As String Static strESI -
Is there a fix to the Timeout bug
I am running Mysql Workbench 5.2.32 I keep getting this error while running queries that a little more than 600 sec.
Error Code: 2013. Lost connection to MySQL server during query -
Thanks. I will try that in access and see what i can figure out. I appreciate your helpLeave a comment:
-
i would like to do the same if the company has more than two phone numbers. if i figure out how to solve the problem with two numbers. I think i might be able to make it work regardless of the number of phone numbers.Leave a comment:
-
this data is used for an automated dialer. the way the program is set up. it require the data to be formatted in one row to be mapped correctly. the original table were remain the same. however i would a query that generate the one row per companyLeave a comment:
-
How to combine two data rows into one
I am trying to find a way to combine two rows of data into one. the data is as follows
Fields: Company Phone
XYZ 801.222.3333
XYZ 712.444.5555
I want to achieve the following result:
Fields: Company Phone1 Phone2
XYZ 801.222.3333 712.444.5555 -
Thanks Rabbit that took care of it. i really appreciate it.Leave a comment:
-
How to declare a variable as an excel worksheet in vba
i am using access 2007 and i am trying to read data directly from a spreadsheet. i am running into this error User defined object not defined. i am declaring the variable as follow
dim Mywb as workbook
dim Myws as worksheet -
Sorry about that. I have edited the post and the code is now completeLeave a comment:
-
Reading data directly from a spreadsheet
I am trying to read the data directly from an Excel file into a text box. i keep getting this error OBJECT REQUIRED
here is my code:
...Code:Private Sub CboMS_AfterUpdate() With worksheets = ("C:\todays\Small Pricing.xls") If Me.CboMS.ListIndex <> -1 Then 'MsgBox ("[" & Me.CboMonth & "]") MsgBox ("[" & .range("D16").Value -
thanks. that took care of that however i get this error FIELD F1 DOES NOT EXIST IN DESTINATION TABLE. I made sure the field names are the same so i so not know what's causing this. any ideas?Leave a comment:
-
I tried the Dir() but i still get the error. what i don't understand is that somehow it's omitting the subfolder. the error says COULD NOT FIND THE OBJECT 'Z:\Mach.xls' even though the path is actually 'Z:\Todays\'
here is my code
...Code:Private Sub Upload_Click() Dim MyFile MyFile = Dir("Z:\Todays\*.xls") Do While MyFile <> "" On Error GoTo Err_Upload_Click DoCmd.TransferSpreadsheetLeave a comment:
-
is there a function that counts the number of files in a folderLeave a comment:
-
What i am trying to do is load all the files in the folder at once not one at a time. all the files are of the same type. Excel files.Leave a comment:
-
TransferSpreadsheet ERROR
I have a command button that is supposed to automatically upload all the excel files to a table in Access 2007. but i get this error " could not find the Object 'c:\todays\*.xl s'". the directory is correct so i don't know what hte problem is. here is my code
...Code:Private Sub Upload_Click() On Error GoTo Err_Upload_Click DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Usage", "C:\Todays\*.xls"
-
Thanks Johny. it worked just fine.Leave a comment:
No activity results to display
Leave a comment: