Say my table as Date, Year, Month fields and a user form has a Date Textbox with Cs set to Date in table Is there a way for the table to add the year and...

I want to have a field that simply allows for the year, with no month or day. I can't figure out how make the field a Date data type. Basically, I've made a...

Hello, I have table that stores a "year" value. Is it better to have this field's data type as a Text or Number value. There is no dates, just a year...

Hello, I could use a bit of help in this. While it seems simple, maybe it is not the correct way. In a new table, I want to have a field for the YEAR. ...

I know how to extract the year from a date field in a form or query using the Year function. But how would I do that in a table? I need to keep the year as a...

G'day ppl What do think is the best way to setup/structure a work/task scheduler. Eg, if Mr. Smith wants his grass cut on Wednesday of every week, Mrs....

Hello, I have been challenged with making a yes/no field either stay on or off based and contract end date field in my table. I am using Access 2003. So for...

What I've got; An excel spread sheet that contains all employee travel criteria, with the headings: - Travelers; Travel Date(s); Cost Centre; Division;...

I'm trying to store a 1 or 0 in the field but don't seem to understand how. I made a filler feedback linked table with input form. I'm want to grade several...

I need to clear about 200,000 checkmarks in my database, does anyone know how I can do this? I have tried REPLACE with (-1 with 0) and (Yes with No) but...

I have defined a Yes/No data type field with a Default Value of nothing (neither Yes nor No). However, when records are created without indicating Yes or No...

I have two tables: customer and employee. Each has a field , formatted as Yes/No, Indexed (dupes ok). When viewing table data, why does one show checkbox...

Hello- I'm creating a Book database and im having some trouble. I have one table that stores the book's information called tblBooks. One field in this...

I am creating a database in Access 2007 that needs to be backwards compatible with Access 2003. I have a yes/no field in a table that needs to be required. ...

Hello, I have a table that has the user answer yes/no to several questions. I'm using a combo box w/value list to do this for each of the fields. When I test...

Hello, I have a table that has the user answer yes/no to several questions. I'm using a combo box w/value list to do this for each of the fields. When I test...

System: Access 2003 running on Windows XP SP3, Server 2003 domain When one user of mine starts Access and logs into it, he gets the message "You do not have...

At the moment i have three tables with the following columns: Supplier table: Vendor number (primary key) Name Address 1 Address 2 Town Postcode Phone

I have 6 activities; I want to keep a record of the Quality, Duration, Consistency of each using a database and I am looking for input and help planning this...

I'll try to describe the situation pretty thoroughly and then I have a pretty specific question. For an Inventory database, we are trying to keep track of 2...