Search results

check out http://www.it-trade.co.uk/Software/microsoft.htm it's the Office 2000 Developer your after, not sure if 97 is available. No one can remember where we got ours from.

we had the same problem we purchased the developers edition of MS Access, which allows you to install a 'run-time' version of MS access an any PC without a lisence cost. few things about the run-time version No help - unless you create your own run-time errors will shut down the application...

the problem being keeping the data on the as/400 there will be a very large amount of data on the as/400, but that will need to be deleted from the as/400 but kept on the database, that is why I wanted the info transferred to a table, i also need the user to be able to make entries for each of...

Thanx for the replies I'm gonna try an append query to copy to another table, I want to make this as simple as possible for the users. i.e. users dont have to do anything to get the data.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q125648

Hi I would like to set up an ODBC connection to an AS/400 to retrieve info, I know how to do this and have tested some links succesfully but... if any data is changed in the Access db, the change is reflected on the AS/400 file. Is there any way that I can copy the data to a seperate table? as...

forms aren't really used to be printed, instead, I would create a report and set the button to filter what record you would like reporting and then to print the report. The report is easier to format to print so this would cause you less hassle.

I didn't take the time to work out what the results should have been, this is the mail that was sent with the database to me

the table that has this information has the following fields Name - DateStart - DateFin - Hours the information that I typed earlier is one record, is there any way using a query that I can divide the hours entered by each month that is in the range between start and finish date?

Hi I have a table that stores start date, end date and hours is there any way that I can split the hours for the dates i.e. start date 01/01/2002, end date 01/04/02, hours 30 want to split so result would be Jan - 10.67, Feb - 8.71, Mar - 10.67. I have tried a crosstab query but this just...

create a shortcut to the db that looks at the correct security file C:\PROGRAM\Microsoft Office\MSACCESS.EXE "C:\whatever\whatever.mdb" /wrkgrp "C:\wherever\whatever.mdw"

I presume that you have already entered data previously, if so compact the database and start again, that may help, don't quote me though :p

change or re-do the mdw file naming it something else, and point to this file on the short cut

I was confusing myself the more I read it :p

try this table 1 zip and loc # - leave as is table 2 loc # and rep - leave as is table 3 rep and region, change to loc # and region set the joins as follows table 3 loc# to table 1 loc# 1 to many table 3 loc# to table 2 loc# 1 to many region is the central point here i.e. rep looks after a...

are region and zip stored in the same table? if not how are they linked?

ok try this create a blank form, and save it calling it frmHide create a form with 2 unbound fields UserName and Password, save it as frmLogin, take record selectors and nav buttins off, and for the afterupdate event for Password enter this code create a table and call it Open create 1 field...

the way I am reading it is if UnitNo is not equal to the word "Ward" then blah blah so does the UnitNo field contain the word Ward or is it a number?

does the ward field contain just a number? or does it contain letters also

do you want the user to log onto the whole database, or just 1 form?