Search results for query: *

dhookom and PHV, thank you so much! I cannot beleive I spent a week on less than ten lines of code... It worked perfect! Thanks for your help.

How do I open it in VBA?

I guess this should be my last concern. With these lines: 'set the object "qd" to the pass-through query Set qd = db.QueryDefs("qsptYourPT") 'build the new sql string strSQL = "exec dbo.CDEPress_PointInTime @DistrictCode = '" _ & Me.cboDistrictCode & "', @Date = '2004-12-19'" If...

It blocks with DAO...

Ok, I will try this, but can you tell me about this: Set db = CurrentDb Set qd = db.QueryDefs("qsptYourPT") What does it mean? Thanx

I want it in a datasheet. Like a simple query would return a result table in data view.

Thank you so much. Now, I am running a stored procedure after clicking on the SUBMIT button of my Form. But the result doesn't show up on the screen. Is this because I hid the Access window that it prevents me from seing the data view (result of stored procedure)? Thanks.

It doesn't do anything new... OK, to summarize. I used your code behind the button "Submit" of my Form. This Form contains one textBox where you can put the District Code. Then behind "Submit", it runs your code and among others, executes cmdQ, right? Well, it DOES something, in the background...

Well When I am running my stored procedure through Pass Through Query: exec dbo.CDEPress_PointInTime @DistrictCode = '67439', @Date = '2004-12-19' I have the immediate result as a table like usually for a regular query, right? I though I would have the same when puting the part @DistrictCode =...

Well, Now, when running, it says nothing anymore about the connection, but right after execute, it is over. Do I need to do anything special to have the result showing up on the screen? The thing is that I put some code to have my form hidding the Access window so it looks like an independent...

Hey guys, I put this in the ActiveConnection String, and it doesn't work: .ActiveConnection = "ODBC;DSN=CDS;Description=CDS;DATABASE=CDS;Network=DBMSSOCN;Address=Enterprise,1433;Trusted_Connection=Yes" I used the code given by OnTheFly. This string is basically what I copied from the...

Hello, I built a Form through Access 2000. Now, when I run it (I created a shortcut on the Desktop), I would like to hide Access and only see the Form. Is this possible? Thanx!

Hello, I build a Form through Access 2000. Now, when I run it (I created a shortcut on the Desktop), I would like to hide Access and only see the Form. Is this possible? Thanx!

Hello, I have the following pass through query: exec dbo.CDEPress_PointInTime @DistrictCode = '67439', @Date = '2004-12-19' CDEPress_PointInTime is the name of the stored procedure. The users are not Access litterate and I would like to know if that would be possible to create a form so they...

Thanx traingamer, it worked perfect! And HitechUser, when I used the example "johnny", I used a longer word to make sure you would understand what I meant... sorry it upset you.

Guys, it doesn't work. In fact, I wanted to see all the records where you have all caps. So here is what I did to make sure: I selected the field, selected the UCase of the same field, and then I select the records where only the field and the expression are equal: SELECT A, B, UCase(B) FROM...

like jOHnnY...

Hello, I would like to know if there is a way to write a query that would select the records where a certain field CONTAINS upper cases? Thank you very much.