When I try to insert a photo into a table, I get a message: "Close the OLE server and restart it outside of Microsoft Access. The try the original operation...

Hi, Can anyone tell me how I can view Import and Export Specifications? Thanks in advance David K

Hello Everyone, Would appreciate if anyone could advise how to use expression in access 2000 to do the following: I have 3 fields Begin Date (Day,Month Year...

I would like to save a 'fresh' version of my database as a template: First, I must clear all records. How? And secondly, is it possible to make this a...

Hello all I have 3 tables; tblstaff (staffID (pk), FName, SName) ' Stores Staff names tblTeam (TeamID (pk), TeamName) ' Stores Team names tblTeamStaff...

I have created an input form with several text input boxes, and need to prevent the user from moving to the next texbox without entering a data into the...

I am entering hours and fractions of hours using a form to enter data into a table in access. Both the form and the table are formatted to show two digits to...

Hello, I'm hoping someone can assist me with a problem I have. I have a form that imports a picture into it....here's the code. strStockNum = Me.StockNum &...

Can a marcro in access be trigged by a future date which is stored in the same database?

I need to replace some question marks in a number of records, but the find/replace tool uses that character as a wildcard. How can I search and replace...

Hi, I have three tables: Family Students Meetings FamilyID PK is FK in Meetings FamilyID PK is also FK in the Students table (for other uses)

Hi all, My new job requires me to become a much more advanced user of MS Access than I currently am. However, I will be teaching myself and on that basis I...

I have a database that multiple users enter information. Because there's no prompt when one user is using the database another may be using it and information...

I have about seven people going to use my database. Is there a way to determine which user placed new entries into the database

I'm trying to set up a simple database in Access 2000 that allows me to record and list bird observations. I have two tables. The first table is of bird...

hi, i need help with a formula please. i have a list of user names in my table, for example bills henryp lee-annew

Hi, Using VBA how can i change a text field to a currencdy field type Thank,

I have a form that generates a Pop up. After some data entry on the popup it is closed(Close form on Close event) and returns to the original form( Because...

I have a "value list" value that can be null, accept or reject but I can't get it to show up as anything more than a black box on a report... any...

Hi I've written a macro to export a table to Excel format, and then email it. When it is opened in Excel, 'Wrap text' is automatically set to ON, which means...