Ok, i have formatted a time date field to short time, but i only want access to display the hours part, e.g. 2 or 3 hours. As i cant format access fields into...

Here it is, I am writing a database for my school where I work. It is an alternative school, so students are required to achieve a certain level of compliance....

Hi, I'm trying to do womething which I know is very simple, so please forgive my ignorance:-) I have a simple table detailing jobs assigned to staff members....

I'm trying to edit an Access report someone else wrote and I apparently don't understand how Access works. They have multiple tables with multiple reports. ...

Hello. I have a table that includes a yes/no column for whether or not we send mail to each record. I need to run a query that doesn't show those who have...

How to you convert a date to a integer? Example 6/14/2006 1:57:37 PM to 1150308000 I have seen it on other languages like PHP Thnks for your help Bre-x

I split my database (A2003) and followed all the instructions in the other posts. The back-end is stored in the server. There are only 2 front end users so...

1. How do I collapse the new ribbon? Can I change the icon size so that they are not so big? 2. Where did the startup options go? Two commnets: 1. the...

In most Windows Applications with combobox-like dialogs, you can start typing in the box and after a few letters use the keyboard up and down arrows to select...

I'm a relatively new developer, and I've written a neat little database in Access 2003. I'm starting to distribute it now, and it works great with Windows XP,...

Hi Everyone, I have this database and there are two fields, Start Date and End Date. I would like somehow to calculate how many working days are between End...

I need to retrieve data where SOMEDATE = TODAY'S DATE + 1 week. What's the correct way to form the expression? Thanks

I am trying to create a program using Access. I have learned all the basics about Access, but I still don't seem to know enough to make it do what I want. I...

How can I call IE6 from Access using VB and have it load a specified local file.htm ? Any help much appreciated

I am operating a database and I enter new information every day. However I must figure out how many new entries have been placed on the database for each...

Hello I have a report (to print the bill) In the header i have my company name and a smal picture (Jepeg) In the print preview i cam see the picture...

Hi, I am trying to run a query in access and the users of the system would really like to see a report with dates even though there are 0 values for the...

Anyone have any good links to info on how general accounting databases are set up ? I am putting something together in Access to link my inventory...

I am trying to create an Access Database from scratch and have never used Access before. I am using Access 2003. Could someone please help me in very simple...

Hello everybody, I am stuck with an append query and I need some advice from expert. I have a database with three tables. Table_Customers (PK...