Getting Started

Populate field from data in another table
Hi, and thanks in advance, this seems so simple I am embarrased to admit I can't figure it out...Oh well, here is what I have (fields ommited for saving space) And feel free to correct me if I am going about this the wrong way are there is an easier method: 2 Tables - Assets and Service 1 Form - Service Entry (... 19 Jun 2008 17:50

query datasheet view on data access page?
How can i show complete result of a query on a web page. ... 19 Jun 2008 08:33

Add date parameter to query
I am using a database which is used to track call types and volume. I need to run the report at the beginning of each month for the prior month. Is there an simple way to run a query or a report which will only give me the information for the prior month? ... 19 Jun 2008 08:33

Access 2003 cannot open .mde made by Access 2007?
I have Access 2003 application and plan to install Access 2007 on my computer. Before doing that, I want to make sure if I use Access 2007 to open my Access 2003 .mdb file, make .mde using 2007 and people with Access 2003 still can open it. I got message "this database is in a unrecognized format" when use Acc... 19 Jun 2008 11:39

external use of an Access Table
I have a a table in Access that holds some information that I need to use in EXcell for the time being. Is it possible to have Excell work directly with information held in an Access Table. I currently resolve the problem by exporting the Table to Excell and then using Vlookup to access the data. This means I h... 19 Jun 2008 11:39

Column Not showing after pick in combo box
I have a combo box with the following 3 fields: Job ID, Customer Name, Job Name The Column Count is 3 The widths are set to: 0";1.5";1" The list width is set to: 2.5" The Width is set to 3.2813" The first column correctly does not show and the value is stored where I want it. When viewing the list in... 18 Jun 2008 23:02

how can I insert a "$' to print before my price label?
how can I insert a "$' to print before my price label? ... 18 Jun 2008 23:02

Query won't report
I have 4 tables and each record is specific to a task with a start time, finish time, location, equipment number, and other various data specific to that task. I also have equipment table and department table linked from another database. Relationships were created to join the unit number from task tables to ... 20 Jun 2008 10:11

Importing Excel into an Access Form
I have a fairly large Excel file I need to import into an Access Form. The columns align with the exception of the first. How can this be done? -- sunsolar ... 20 Jun 2008 08:08

code between date range
In my report "rSchedule" I have 2 text box-tbEmpStDt and tbEmpEnDt. The data type is binary, comes from a make table query. I need to compare those dates with text box startdate and enddate in my open form "frmDates". This form will always have Sun thru Sat as a date range. In the report I have a text box fo... 19 Jun 2008 19:53