Search results

Could you give me an example of looping through the recordset? I'm also trying to extract data from my query to excel.

Ray Create another form and then insert it into the tab as a subform/subreport. This will allow you to add/edit data for a another table.

Thanks for the tip on lookups.

whats an easy way to package up the front-end/back-end for a user to distrubute? or should I create to separate zip files and tell a superuser to run the one with a back-end and any normal users to extract the other that has the front-end. Also what about updates to the DB both front/back...

Ok, so carry on as I'm doing, then split it. How do i package this up for easy setup for the end user? This may need to be installed on other branches network. whats the difference between .mdb/.accdb? and _be? I take it thats short for back-end. Sorry I'm new to this forum so just try to...

So each user should have a mdb file(not a shortcut to the main mdb thats sitting on the shared drive) which uses a linked table that sitts on the shared network?

Hi I've been asked to develop an access database that multiple users will have access to. It will sit on a shared network. There will at the extreme most be 20 users. Where should I start? I've heard of splitting the database and let the user have a local front-end though I dont quiet...

Thanks Cameron, What you said makes perfect sense. Is there maybe a option like somehow setting a condition to the query. I.e if I had a query say select * from tbl_stores Is there a way I could some how pass a condition (i.e where clause) to the query to restricted it. If txtSales_id...

Hi, As I'm new to this forum I will briefly describe my experience, I have extensive Excel and Excel VBA knowledge and have been working with ORACLE products for the past 3 years. I need some help with a combo box (It maybe a design fault from my part) but here goes I got two tables...