Search results

I am working on a order management database, where I need to poll orders from various MySql internet databases. Should I connect directly to the database(s), or ftp download flat files or XML files. Whats the best way to approach this?

Dim sql as string sql = "SELECT..." Me.[subform].Form.RecordSource = sql

I'm creating a database where I have a customers and invoices table, obviously there is a relationship between the two tables using a customerID field where I have referential integrity enabled. However not all invoices require a customer account as some are cash sales where no customer details...

Hi, I wonder if anyone could help. I'm in the planning stages of creating a order manager in access for multiple ecommerce sites. Database will store data on Customers, Inventory, Invoices, Returns, Shipments, Credits, Quotes etc for all sites, and also custom reports. And the idea is to have...

Most spam seems to come from newly registered members, so perhaps new members should go on a probation period before they can post, or just disable new threads until the member reachs say 10 posts. Anyway keep up the good work, I have already learn't alot since joining, and its just a shame...

Best thing so far about access 07 is you can embed images and alternate background colours on continuous forms, scrollwheel has been disabled on normal forms! The new northwind looks great hence the reason I'm so frustrated... Also I need to create an order manager for work.

Thanks for the replies, I have installed a fresh copy of XP and office 07 on a spare computer, and I'm still getting the same problem... Sample databases can be downloaded here: http://office.microsoft.com/en-us/templates/CT101426161033.aspx I can download the template ok, but when it...

What windows version are you guys running?

I just purchased the full version of office pro 2007, I am still getting this error. Anyone else having this problem? Thanks

Hi, I have downloaded the access 2007 trial. Installed and registered it with the trial code. However when I try to install any of the free sample dbs from MS including the northwind db, Access crashes!! I was going to purchase the full version of office, but wanted to test access first. If...