Search results

Here was their response "Dear Peter , Thank you for your email regarding MYOB ODBC. The MYOB ODBC Driver offers Read Only Access to the MYOB datatables. This level of access is unchanged whether you are an ODBC Driver Customer, or an ODBC Developer Pack Customer. If you wish to incorporate...

Hey, thanks for all your time m8. It doesn't look good does it. I have emailed Both MYOB Australia and MYOB USA asking about whether it I can write to the MYOB datafile in anyway. I am awaiting their replies now. I must say that I am very disapointed that MYOB ODBC is Read-only. I really...

Essendon I forgot to ask, Did you set up link tables, or did you connect to datafile in code (which I assume is possible). If your answer is the latter, could you give me some hints as to the syntax involved. Thanks again, Peter

I installed the ODBC drivers ok. Sorry to hear about your troubles, I am not sure why that would have happened. After I installed the drivers and configured it, I created a blank database and went to File->Get External Data->Link Tables selected ODBC Database from the File Type list, and...

1 more question Hey Brad. I just had a look at those urls. I am excited by what I read there. I was just wondering what you can do with your limited access with the ODBC driver? What sort of things do you do with it? Also, I am planning on developing this application that integrates with...

Thanks m8 Thanks heaps for the reply, it is much appretiated. I can't wait to have a go at it. See the Bombers fly up, up to win the premiership flag Our boys who play this grand old game will always......oops I forgot, we lost. catch ya Peter

Hi, I am working on a database system that I want to integrate with the MYOB accounting package. I would love to be able to generate an invoice in Myob from VBA code run from within my database, with all the relevent information for the invoice being sent from my code. Also, when a customer...

I have just discovered that it crashes when I try to open any of the tables. Link tables or normal tables! Please help!

Hi, I have recently split my database. I am just testing my frontend out on my pc and it all works from within the form views, but I go into project manager and click on one of the link tables to open it, the database crashes without any error message! Does anybody know what this could be...

Hi, I recently split a database for the first time. I have 3 workstations running Access 2002 (XP), and 2 running 97. The backend was created in Access 2002. The 2 Access 97 front ends won't work with the back end. Should I just convert the backend to Access97 format and all will be ok? Or...

Skippy is on 7:30pm weeknights over here. They just started making a new series as well! I am excited about that because I really love the show. Its the second biggest tv show in OZ at the moment. In the new series, skippy starts getting into trouble with the law and goes into drug rehab after...

I don't know what your toilets are like, but here our toilets are bolted to the floor, so they don't spin at all. (hehe) One more question regarding my db. At the moment I am using currentProject.Path to obtain the path of the db to link pictures into my database. Now that I have split my...

ta Wasn't much of a challenge for you was it... Thanks for your reply, I have looked into splitting databases and that is definitely the way to go...

Hi, I have a form with 2 list boxes. In one box is a list of all motels (the left box). The user can then select any or all of the motels in the left text box and include them in the second list box (the right one). The motels in the second list box will then be used to filter a report. To...

Autocorrect for what? How do I turn it off? thanks for your reply

Hi, I have a report, and every time I open it for preview it is set to print out black and White instead of color, no matter how many times I change it to color. It won't save the color setting. Why is this so? Is there a setting and/or code that I can use so that the user doesn't have to...

I am trying to export the form in which my code has been lost...I can't export it, even to a blank database. It keeps saying: "Name conflicts with existing module, project or object Library". Any Ideas?

Tried both of these things....no good. I moved it to a Office XP machine. Now I can at least get into the code window for my form, but there is no code in there at all. All of the buttons and on controls have the event procedures assigned, but all code has simply vanished. I find this highly...

Hi, I have been working on the coding of a form all day, and all of a sudden none of the code behind my form works at all, and it now won't let me view the code in the code window. I tried going into the code window from another view and switching to this form but the form is no longer listed...

That's how I have it at the moment. But I need to be able to multi select because the listbox's purpose is to allow the user to select a random amount of records to filter a report.... thanks for your reply.