Has anyone had any luck with Access and the Treeview control, trying drag and drop, to get the "createdrageimage" to work? The following code compiles, but...

Hi. I am setting up a database of electronic parts I have laying around. What I would like to do is, when I'm entering data in forms, if I select Capaicitor...

Need help for write a VB code to calculate the age by year/month/days from birthday. If person is infant in days or month, and if person is over a year in year...

Hi everybody, I would like to do the following in Access 2000: We have a database of various people's preferences, experiences etc. I need to build a form...

Help - I am trying to get my head around choosing Primary and Foreign Keys. I understand Primary in that I have chosen the Retailer I.D as my primary in the...

Hello All, I am using Access 2002. I had the following problem: Example No. 1 Line 1) SubTotal : 480.52 Line 2) RoundOff : + 0.48 Line 3)...

Hello All, I keep getting the following error when I try to open a pop-up form from a sub-form: The expression On Click you entered as the event property...

Can anyone recommend a good Access book(s)? I am a fairly advanced VB, VBA, SQL Server developer and did some Access projects a few years ago. Just got a new...

Hi, This is my first time making a database with multiple tables. I am wondering how to get all the fields on these tables to one form. Here is the...

I'm in the process of setting up a new table and I designated one field to be a lookup using the wizard. I named the field 'business' to match the field name...

So I was told how to do what I wanted to know, and well I almost have it working. My utter lack of knowing what goes where is playing against me I think. ...

I always make combo boxes on my forms for look up lists because I know how g What is the best way to create a look up list, combo box or list box...

Hi There, I hope this isn't a dumb question, but I have made myself a nice form and the information that is in the first record, most of it needs to be carried...

I am designing a database for a client that needs the stock balance of items for a particular date. The items supplied minus items issued gives the the balance...

Hey all, I just moved from Access 2000 to 2003 and an application of mine doesn't work anymore. It's using VBA which is running vbscript which is running an...

I want to create a -form- in access that will be used for documenting material that has been recieved in through my department. It will need fields such as...

Can we pulish/enable MS Access Forms and Reports on the Web?

Hello, I'm using Access 2002, and trying to create a recordset object. I've Included the "Microsoft DAO" library in my references. I currently have a form,...

How do you set a switchboard to select different queries?

I'm trying to create a recordset based upon a query called QueryAv that is a SELECT so that I can then update the records. What are the declarations and...