Search results for query: *

Hi all, One of our colleagues recently upgraded from Access 97 version to Access 2000 version. The numbers in queries and reports in the database disappear when we are in print preview, and is also gone when queries are actually printed out. The numbers are present when we run the queries...

Hi all, One of our colleagues recently upgraded from Access 97 version to Access 2000 version. The numbers in queries and reports in the database disappear when we are in print preview, and is also gone when queries are actually printed out. The numbers are present when we run the queries...

Hi, We are currently using Access 2000 database with 5 users over network. It has been working fine for many years until recently where corruption occurs 2 or 3 times a day. The error messages ranges from "Database is in an unrecognized format. The database does not exist" to jet...

Dear all, I am tasked to convert Access 2000 database to SQL Server. ( Access 2000 database in front end application and SQL Server database in Back end application) SQL Server is new to me and would appreciate some advice. I have been reading up some information on the web and is confused...

Hi all, When Access reports is exported, the drawing objects eg. rectangles and lines disappear. Only the text is exported. Do anyone has idea how the drawing objects can be exported as they are in Access reports? Many Thanks in advance.

Hi all, I am tasked to set up a Macro to send out reports at the end of the day. Does anyone has idea if the Access program (97 Version) can recognise the system time, and trigger the Macro to send automatically at a specified time? Any help will be appreciated. Thanks.

Hi all, I would like to instill user and group accounts such that only certain users can edit the table. Do I need to have to be an administrator to set up the accounts? I tried to do that but was prompt with a message that the object or database is read-only. We are sharing the database on...

Hi all, I am tasked to set up a database. We would like users to be able to edit in Forms view. However, is there a way where users would not be able to edit data in the Table view too? The users are new to the Access program and the data in the table form may be messed up accidentally...

Hi all, I am tasked put up an access database on intranet using ASP. However, I do not have access to our server and is unable to do debugging online. I am new to asp and VBscript programming and would really appreciate help to check the following code. Here are the functions that are to...

Hi all, I would like to put up a dynamic form on the intranet using asp method, where users can enter to that URL to do editing and adding on the form. The changes will be reflected and updated on the server database. How do I go about doing that? I am new to this area and would appreciate...

Hi all I am tasked to put up an entire database on the intranet with multiple queries and report. I am new to this topic. I understand that with the following commands, i can set up the database on the net where users can enter this ASP page to do editing: <% dim myconnection set...

Hi all I am trying to put up an entire database on the intranet with queries and report. I am new to this topic. I understand that with the following commands, i can set up the database on the net where users can enter this ASP page to do editing: <% dim myconnection set myconnection =...

Hi all, I am tasked to set up an Access 97 database on intranet such that users can update on the database. From microsoft website, I understand that I can access to database on line by saving access form as .asp or .idc or the Htx format. I am confused between using asp or idc. What is...

Hi all, I would like to create an ASP which will set an Access database onto the Web, where users can enter and add on records to the Access form. I am new to asp and SQL language and like to confirm if the following steps are correct to open the database on the website. - Open Notepad or...

Hi all, I would like to create an ASP which will set an Access database onto the Web, where users can enter and add on records to the Access form. I am new to asp and SQL language and like to confirm if the following steps are correct to open the database on the website. - Open Notepad or...

Hi, I tried installing Option pack from MS website but ran into problems. The error message is as below: &quot;Initialization of dynamic link library C:\Winnt\System32\KERNEL32.dll fail&quot; I think that the problem may be because I am not a system adminstrator and do not have access to the...

Hi all, I recently try to download IIS program on the www.microsoft.com website. I chose the version for NT Workstation 4.0 Option Pack for Alpha. Upon downloading all the files, I run the Install.exe program. However I was prompted with this error message: &quot;The image file...

Hi I need to put up an Access database on a web page so that people from other regions can enter to update on the database. I understand that we can use ASP to set up a web page. I am new to this topic. Does anyone know where can I install or find the ASP programme? I have about 27 MB of...

Hi all, I am given this task to put up Access database on to the Internet, such as people from different regions can enter to update on this database. I would like to create a web page first and putting the database up. I understand that I need to expoart the form to *.asp form but am stuck...

Hi all, I have an Access query. I would to show all records except records where the Field, Partner, contains the word &quot;cancel&quot;. The criteria which I entered in the criteria field is: Not Like &quot;*cancel*&quot;. However when I used this criteria to query, those records with...