i have enclosed a small jpg with two warnings i get when opening access just getting my feet wet how do i suppress this thanks to all

I am working on a access table which is link with some external software (3rd party software). Everything works fine but the date/time field is appearing as a...

I have a form with 3 fields that have "yes/no" answers (checkbox). If any of the questions is answered "yes" a set of questions appear, and if the answer is...

goodevening i have 2 retated tables, one query will amost all fields and a form comes from that query(main form the data from the first table and subform all...

I have one Listbox where I need to change the content from a command button. On the first command button I have... Private Sub Command0_Click() With...

Hi all, Access 97 I want to permit duplicate entries in a field but only if Null. Simply indexing the field with duplicates not permitted does not seem...

Function STJ(ndt As Date, kdt As Date, vid As Integer) As String Dim ndden, ndmes, ndgod, kdden, kdmes, kdgod, dni, mes, god As Integer ' vid ñå âÃ*äè ...

Hi all Access 97 I find from trial and error (mainly error) that changing a field name in a table in a "mature" database (ie one riddled with queries and...

I've been using a Word Merge file to print a Lease. It has worked fine in the past and I've made no changes to it. The only thing I've have done clean up the...

Is there a way to have a control on a form always show the current time. What I'd like to have is when a dispatcher has a blank form ready to input...

I have two tables. Table1: Transactions and Table2: Customers There are many transactions per customers. There is a unique identifier "Customer ID" column in...

To All, I am trying to display some data on a report. The control source is as follows: =Format("Total downtime: " & Sum(*60/1440),"Short Time") In...

how can i download data

We are looking for a system to manage work requests and placements The intention of the system is three-fold: Firstly, to keep a profile of each client and...

I'm trying to come up with a single table to add to my database to track credits, balance due and refunds. Credits and balance due amounts would be associated...

Hi there Here is my problem..... =IIf( Between "1" And "100000","£240",IIf( Between "100001" And "150000","£280",IIf( Between "150001"...

Hi all - Access 97 Rather late in the day I have discovered (not surprisingly) a flaw in the table design of my first database (probably not the only...

I'm not sure what I need. I am building an inventory data base and also with it is a salemen list (tblsalesmen) and the shows (auto adds a unique number to tbl...

I built a Database in Access XP 2002, File Format 2000. I installed it on a machne running Access 2000 and I keep getting Access generating Errors, creating a...