Thanks NeoPa!
I tried what you said and it works!
cephal0n
Last Activity: Jun 11 '08, 10:40 AM
Joined: Jan 30 '08
Location:
-
Hi guys! I apologize for the delayed reply. Anyway I'm still working on my database.
Hi Stewart thank you for the logical opinion on how I should work on my coding
and when to use a more effective and useful solution. to be honest I really don't
know what came over me and why I keep pursuing coding it in VBA instead of using
simple sql. anyway I decide to use the REPLACE and FORMAT in my queries to get the Max...Leave a comment:
-
Thanks Stewart!
I tried what you said about putting space between SELECT and the * and I encountered a new compile error: Expected: end of statement and when I debug the code it keeps pointing on the ("MyDate") field.
...Code:Dim cnn1 As ADODB.Connection Dim rst As ADODB.Recordset Dim SQl As String Dim newdate As Date Dim SAPstring As String Set cnn1 = New ADODB.Connection
Leave a comment:
-
Hi Stewart!
first of, thank you for the help. I copied your code as instructed and made some changes.
...Code:Public Sub ConvertDate() Dim cnn1 As ADODB.Connection Dim rst1 As ADODB.Recordset Dim sql As String Dim newdate As Date Dim SAPstring As String 'take the current date string from SAP and replace the '.' separator 'with the recognise '/' separators: 'newdate
Leave a comment:
-
Changing DATE Format HELP
I have a technical Date problem that's really difficult for me, I have a "custom made" Date format MM.DD.YY this is actually extracted from SAP and theirs no other format option offered such as ShortDate, LongDate etc. so now I making a sql query that must convert SAP date to a date Format that is recognizable to MS Access and I choose the ShortDate MM/DD/YY using ADO. I read about the Format() command using ADO online and experiment on...Last edited by Stewart Ross; Jun 3 '08, 08:59 AM. Reason: Please use code tags to delineate your code! -
Hi everyone!
I apologize for the delay I was still trying out INSERT INTO sql instead of SELECT UPDATE and still getting the same results. Before I go on I would like to thank you guys for replying to my question. I was hoping this will be a simple question with simple answer, but I guess not.
About the question
Do you enforce variable declaration in your code?
I really don’t want to make it complicated...Leave a comment:
-
I hope I get what you ask. this is where I assigned my txtClone.
thanks for replying!Code:Private Sub Form_Load() Me.txtToatl=DCount("[UnqID]","[tblClone]") End SubLeave a comment:
-
My Trial Switchboard problem
I have a main table with a unique id, name tblMain this is where I get my unqID, I also made another table named tblClone using the SELECT Update. I have two forms Form1,Form2, 1 command button and textbox named txtTotal. My Form1 is used as a switchboard for my Form2.
in my Form2 I put my textbox and set Me.txtTotal= DCount("[unqID]","[tblClone]") and
in my Command1 I put my command1 button and... -
thanks guys for the help.Leave a comment:
-
MS Access Run Time Environment TORTURE
I distributed my tblRental.mdb in my friends Ms Access runtime environment. It was successful when I configure Tools > Startup. I didn't change anything else in the startup, I just selected the form I want to view first in Display Form/Page.
so now my question is why is it that every time I run my table I don't see my "Allow Toolbar/Menu Changes" and others. can anyone pls. help me because I really want to fix this problem. What... -
that's a big shame, I was hoping for a possiblity, but I guess not.
Thanks Neopa.Leave a comment:
-
Locking My Module VBA
I have a function inside a module and i don't want it to be open by just anyone I was wondering can I lock a module itself without affecting my forms or others. I saw vb6 offers this option and produces an image of a padlock when created with password. can I put a padlock in vba?
is this possible? please help.
thanks in advance :) -
Make Automatic pass value to filter
Hi All!
I have two table tblHome1, contains all the unique PinNo and tblHome2 contains a duplicated PinNo and description. I put an automatic numbering (ProdID) and set it as my index. What I want to do is make an automatic filtering and labeling method for my table. The reason for this is because I m handling more than 500 records and labeling them would take me forever, so I started with what I can understand, which is seeking 5... -
hi Stewart!
Thank you very much for answering! everything seems to make sense now :)Leave a comment:
-
Does not contain ISSUE
Hi All!
I have a field named: Title,now I want to filter the data with a specific match.
In Excel when you set the whole sheet1 to data>filter>aut ofilter, excel offers an Custom AutoFilter window
where you can select various condition. I noticed that one of the choices is the does not contain option
I was wondering is this possible to use in sql, aside from LIKE and BETWEEN bec. I'm dealing with long titles... -
hi! thanks for replying, I have been looking into what you suggested.
I was wondering if this can be done using ADO (inserting index) in microsoft jet engine and can you help me pls.
thanks again!Leave a comment:
-
HELP Query and Index
Hi everyone!
I've been studying SELECT INTO in vba and made my own. I was successful in generating my own table,
now I came accross with a problem. I want to assign an index on my tblTemp49Code:strSql = "SELECT * INTO tblTemp49 FROM qryUnq49" conn.Execute strSql
but my data came from query (qryUnq49) and since query doesn't support this, its been impossible for me to create one.
... -
Hi Delerna!
I apologize for the delayed response and would like to thank you
ALOT for helping me. the sample code you provided really is a big help
and I immediately used it and light begins to shine on me once again. I tried
applying it on other controls like my command button, when clicked the
stored value displays. and it worked amazingly!
A HUGE thank you for helping me!Leave a comment:
-
thanks Fishval and Delerna for your questions and they make sense
What I want to achieve is that when I typed in 3 values in my txtInput
This values will be cached by my variable k and hoping that for each values
k receives it will be passed on my 3 control textbox (txtResult1, txtResult2, txtResult3)
And hopefully it will be displayed as well, but clearly Fishval said it clear that my k is not a variable and quite impossible....Leave a comment:
-
Thank you FishVal for reading this. the part where I input values in my txtInput textbox and store it all in k is my array,
then all my results are shown my by txtResult1, txtResult2 and txtResult3
I hope this clears it.
thanks in advance!Leave a comment:
No activity results to display
Leave a comment: