Search results

Hi Qwerty, While there is some "backwards" compatability from Access 2003 to Access2002, when it comes to references, you need to have the references available for that particular version of office. How far back are you going when you say "older versions"? Prior to Office 2002?

G'day folks, I have a piece of code that I use for one of my Msgboxes that uses the "chr(13)" for line breaks. It works fine. When I try this same approach for text in a memo field on a form, it doesn't. Does anyone know if this is possible? I've included my code below to give you an idea...

Greetings all, I did some searching on this but did not see anything that answered my question. My supervisor is requesting (demanding actually) that I switch our Access app from an mdb file to an adp file. The app is standard fare(FE and BE, the latter residing on a server on our network)...

Greetings all. I'm posting this question here as it pertains to my form but it could go in tables section as well. I developed a prototype app in Access and have just finished upscaling it to Sybase 12.5. When I open up the associated form to add records, I am unable to do so. The built in...

Hi MStef First off, ty for responding! :) Yes, what you suggested is already part of my code, however, what I am asking is how I can refer to a specific record on subform that is using continuous forms.

Greetings all, I have a question regarding subforms that are set to show continuous forms and how they can relate to each other. I have attached a jpg of what i'm trying to do, you may want to open it so you can follow along with what I will now explain. I have 3 subforms on a main form. The...

Greetings, I have two recordsets. One is based off a table that represents existing data, the other a table is based off an update file. I have DAO code that goes thru each record set and matches the recs on unique id. Once that is done I want to to compare the dates per record , per table...

Not sure if you can do this within the confines of the pivot query , but you can use the "top values" property of the query and then do a sum. I've had problems in the past with aggregate functions in a Pivot query, so you may want to use the Pivot query as a source and then a seperate query to...

That's exactly what I did do here... the query as its written in my original post was copied and pasted right from Access and created via the graphic u/i. I have also written the query with "hard" dates (as opposed to references from the input form). When I did that, the query produced correct...

good morning all, I am currently going buggy :eek: in trying to get a piece of SQL code to work. To me this seems pretty straight forward but no matter how I code this, I am getting no results. The date range on the form is #1/1/1900# and Now(). I've also substituted #5/10/2006# for Now()...

Hi Chimp, Yes it is possible to do this. You will have to use ODBC drivers to connect to the Sybase backend. Sybase does come with its own native drivers but I've had better success with DataDirect ver 4.2 HTH

Wow.. that's a new one.. it worked, ty for the tip Matthew :)

Hi Kor, Have you tried using the MAX function? That should get you the desired result you need. Tim

Recently I've been having a problem with Access (2003) that I can't seem to get around. If I click on "NEW" to create a new query, do some editing, then go to close, it prompts me as to whether or not I want to save, which would be ok, if it would let me choose NO!! I only get OK or Cancel...

Hey Ian, Did you ever come across a fix for this? I'm coming up against the EXACT same problem and its driving me nuts!

G'day all, In my Access 2003 FE, I'm using VBA to call/execute a stored procedure in Sybase (ver 12.5). The procedure gets & returns the max date from a table, which I need to use to pass along to another stored procedure. The code I use is below: Sub ADO_Connect() Dim SybaseCONN As...

Greetings all, I am using Access 2003 to connect via ADO to a Sybase db on our server. My problem lies in the connection string. Since I can connect via ODBC I figured I'd just copy the string that pops up for the tables (holding the mouse cursor over a table reveals the connections...

The query DOES make sense and as I stated , it DOES work. It just hangs as I explained above and that does not make sense. I'm looking for an opinion here as to why this occurs, I'm not looking to make whole sale changes to the query or the report. Anyone else?

Greetings all, I am running a query (see attached) that runs fine on its own. However, as soon as I make it a recordsource for my report. It hangs and locks up Access. I've tried to get around this problem by making this query into a "make table" or "append" query but with the same results...

Yes, I am able to connect and import successfully using Excel. I don't have Visio so I can't test with that.