To update some records I am calling following querry, which is working OK : UPDATE Microwave SET Far_RAUType = Forms!frmEditMicrowave!Near_RAUType WHERE...

I am a absolute Access novice and have set up a DB, have started entering data etc. After entering, deleting etc I am now having trouble with my Primary Key...

Hi Guys, I have been continuing to work on a my query to show the total hours worked in an area. Here is my expression, I used the expression builder for...

I am trying to create a power point presensation and i would like to play the same song continously for all the slides in the presensation. If anyone ...

Firstly, I apologise if I have posted this question in the wrong Excel category. I run a small chemical company which analyses various products for specific...

I have been told that, over time, data held in a db will degrade (either be lost or or unnoticed). Is this true, and if so to what extent? Also, is there a...

how do I close open ports

I'm looking for a good book on access do have does anybody have any recommdations and could you explain your reasoning

Hi - I am new to VBA so please bear with me. I am trying to update a table through a sub-form and am trying to use a sql statement to do this for me. When I...

How can I print an Access database structure? I need to print the Field names, field order and field data type. Thanks Chris

Hi I have a column call it WO (Text Field). the data on it looks like this: 4545-1 2323-500 11985-1

I am creating a database of artwork. I have photographs of all of the pieces. The photos were taken with a digital camera as jpeg images, then I reformated...

Hi How can I open subform on the main form to Enter new data? I have button which On_Click event reveals SubForm (Visible=True) and SubForm is prepared for...

This is probably a daft question but I've decided to post it. I'm need to design a form to ask the user two questions 1) If the user has a Car (check box) 2)...

What is the VBA format/code for looping through records. This is what I am trying to do. I have a table called appointments. A student can have as...

normally my settings are fine for every web site except Microsoft. Whenever I click on a link to, say for example, to download art clippings, I am met with a...

Hi, First of all, a big thanks to Kurt and Rob for helping me get this thing working. I have one more question regarding linked combo boxes. I'd like to...

I get an error when I tried to assign the value in a textbox to a variable . the error says "You can't reference a property or method for a control unless the...

Why am I unable to enter data in a field on the form section of an Access data base?