Search results

That was my first inclination as well, that there was a problem with the driver. As far as other products go, no other products are being used in conjunction with Sybase. Other than the driver listed, no of any place where I can get alternative drivers? Been scouring the net and have not had...

Greetings all. This is a wierd questions to classify so I figure this would be the best place for it. I'm currently setup with the following: Front End - MS Access 2003 on a PC running Win XP Back End - Sybase 10 residing on a Linux server I am connecting to the Sybase backend via ODBC...

Greetings all. I am charged with linking an existing Access2003 front end to a Sybase backend. I created my DSN and used ODBC to connect with no problem. However, when I link to the Sybase tables, I notice that I do not inherit the relationships which were created in Sybase. When I try to...

Greetings all, I am running a report with multiple text boxes (see attahcment). The text boxes that are highlighted in blue are linked to memo fields. All these text boxes on the report are set to "Can Grow" yet they will not grow. The Detail band has also been set to CanGrow as well...

well let me include the code so you can see what i'm doing here. The code is legitimate, all I want to know is how to code for the SAVEAS. Dim dbs As Database Dim obxls As Object Dim boolXL As Boolean Set dbs = CurrentDb If...

Greetings, I am having some trouble using the "save as" function in my code (below). obxls.saveas filename:="C:\Access_databases\Exports\NewRisks.csv" I am trying to automate the process of saving a xls file to a .csv file and everytime I get to this line of code I get an error message...

I was able to fix the problem using the HasData property, thank you for responding tho and lending a hand

Greetings, I am running a report that has a subreport embedded. What I am trying to do is the following. If the subreport has data, then I show the datarow associated with the main report data. If not, I want to show a text box that says "no data for this record". My problem is that I'm...

I am running a report where I need to repeat a header across each page. The report is hanging when I set the repeat property to "yes". If I turn it off, the header prints but obviously not on each page. I have no problems with the underlying query, so I'm baffled as to why this may be...

A solution??? Thanks for responding Doc, and no, the fields have been properly defined. That was my first check. From what I can tell, order does not make a difference but what did make a difference was this: when I broke the query down at rebuilt it from scratch (checking each time I added...

Hi all, I've seen this topic posted but haven't seen any answers that fit or work so I'll post again. I am desiging a database in Access2002. The database has approximately 15 memo fields across 5 tables. My issue is that when I write my query to pull in the memo fields for a report, the...

Greetings Wayne, That's the thing, there are no odd terminators located in the data. Here's a sample: IAD has informed the Manager of ICS Billing, Manager of New Accounts and mr. johnson of the issue and they are in agreement that they should possibly change the Policies and Procedures for...

Greetings all, I am currently bringing in multiple files (that all have various memo fields) into an Access 2002 db. The files are coming in as tab delimited and from all inspections that I have performed, everything looks ok. The problem that I'm having is that after performing the import...

ghudson: Just to understand what you are saying, I use the /decompile option on the command line upon opening the database, then select Compile from the Debug menu? What exactly will this do for me? never used it before and I want to understand a little bit more about what's actually goin on...

Greetings all, I have an existing Access 2002 db that is having issues that compact and repair just isn't fixing. So my thought was to create a new blank db and then import all my existing objects into the new database. Upon doing that , I open the new database and I find that all the code...

Control one access database from another Greetings all! I have a scenario where I need to have one Access db open another and do some editing. My question stems on which way to do this. My initial thought was to Shell from the "Parent" database to the other, open a module in the child...

:) That did it, tyvm Pono for your help!!

if I hard code the value, the query works fine

Greetings all, I am having some difficulties with my code and was wondering is someone could help. I'm basically writing a loop which will scroll thru each column in a record, check to quotes and strip them out. The code is as follows: Do Until y > z If Right("rst!Field"...

G'day gang, I have a query that I'd like to use in conjunction with a DAO recordset created via a procedure. I'm basically scrolling thru records in the procedure, obtaining an id number, setting it to a variable and then passing it along to the query. The variable has been set as "public"...