Hi I have a database that was set up very quickly a few years ago, it is for recording the booking out of equipment to staff at a college. The database now...

Hello I want to design my database for inserting records in 2 separate tables and after make search event for searching in both tables and retrieve...

My last two poses on the "Microsoft responds....." thread never showed up/

My last two posts (on the "microsoft responds...." thread never showed up.

Hi all, I got table in my database with name "tbldata" and i have two fields in that table with the name "Ticket_No" and "Amount". In "Ticket_No" filed column...

What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft forums. Why? As...

I am trying to run a scheduled task to run a macro with updates, but have to enter my Password as soon as Access opens, is there a way around this so it can...

I created 5 Tables: 1)Office with Primary Key as auto number named Office ID 2)Marketer with Primary Key as auto number named Marketer ID 3)Currency with...

Hi, I have a job list form with basic info on it. I want to be able to click on the job number text box which then opens up a more detailed form and applies...

Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of...

Dear All, In northwind database that comes with access 2003, how can I make a form for purchase / received inventory just like customer order, form for this...

I am a real Novice to MS Access 2003. I am trying to create a query to populate a form to be used as a subform in another form. I have created the form that...

I have what I believe to be a very simple problem for all of you who know Access better than me. I am using Access 2007 and have a field in my table where an...

Hi all, I have Subform "SubA" on another Subform "SubB". And "SubB" is on Form called "Main". On "SubB" I have button called "Add New Record" and I got macro...

Hi Karl, You’ve answered a bulk of my questions so a special thanks to you. I sure appreciate all the contributions you make. You’re always helping...

Sorry, I was assuming you knew how to write Access code. You will need to create a VB function to perform this task. I don't have much time now as I have to go...

There is an DB that was create well before my time at my job and I have very little experience with Access and need some help here. Access 2003, XP SP3. ...

project number in my data table will be truncated. I know that it will be impossible to establish referential integrity Use an Autonumber field as primary...

Write a query to do an insert into that column for each row... Update MyTable Set = "2009-10" Where IS NULL; By the way, I strongly advise against using...

Hi All. I have created a standard report as a type of template. Users can access this report in layout view and change label captions, positions of fields...