Hi, I have the SelectOject macro attached to a command button that opens up the database window. But because I have the DW hidden by clearing "Display Database...

Hi, I'm trying to save few hours of manual typing by generating an Access DB from a visio UML static structure (classes). I've tried using the visio XMI export...

I have a report that is based on a query. I want the user to be able to enter information in a form that will select a unique record for the report. There...

Transistion from paper to electronic forms is going very slowly. I am trying to bridge gaps. Requisition forms are triple copy pads with sequential numbers. I...

I have one table with company information, linked to another table with application information received from said company based on a RFP. We are creating a...

I tried to add an AutoNumber column using a Macro, but it did not work. The SQL I used was: ALTER TABLE 12 ADD COLUMN ID AutoNumber Can anybody please help...

""Database or project contains a missing or broken reference to the file msflxgrd.ocx ver 1.0 ""... i use to be working with.. Access 2000 on windows'98 .....

In Access 2003, I have a data field into which I enter a hyperlink to a PDF document. The hyperlink shows as a network path to drive G on Server1, which is the...

My OS is Win2000, version 5.0, SP3. I'm using Access 2000, and it seems that there are only two options for sorting a field - Sort Asending, or Sort...

Hi, I am currently using the following code in my form: Private Sub Form_Load() Set dbs = CurrentDb Set doc =...

I am trying to design a db to hold: Patients Name, general Patient info and diagnosis information. I am fairly new at the db thing and just needed someone to...

I posted a request for advice on table design and received a reply from "Henry" who kindly suggested I should attach a copy of my db to him. I realise no-one...

what is the best field type for a zip code? Thanks,

I am attempting to put our paper daily log book into Access. I have twenty beds that have guests checking out and checking in and I need to keep track of the...

Hi, I'm have atable with various columns containing information in euros. For some reason it will not let me use cents because it always rounds them up or...

I would like to keep track of the transfers of assets between employees. tblEmployee (one to many with tblHistory) EmployeeID FirstName LastName tblAsset (one...

Ok..I've taken three classes on Access now and not one has addressed those lovely pop up switchboards. I would LOVE to know how to make one..any help out...

How do I programatically change the field type from Date/Time to "Short Date" using DAO code. Also, how do I assign "programatically" to a table date field an...

Dinfinition of Claim system : A system whereby it will automatic calculate the amount of claim allows and determine whether the claimant qualify for the claim...

Hello there I want to write a code as follows for the table : CheckCriteria = Forms!! .Form!IM_Name I have a checkcriteria function which refrences to...