Search results for query: *

Hello All, I am currently a Microsoft Access Programmer. However, I need to create a program that resides in a USB ThumbDrive - 128mb. I understand that Microsoft Access can't do it and wondered if Borland Delphi can do it. What I need is two things: 1. Be able to create a...

Hello All, I am working on Access 2002. I am wondering if anyone or developer have tried using the "ThumbDrive" - a USB Drive connected on the USB port which acts as another drive. I would like to know if I create a database in Access 2002 and using the Access 2002 Developer's...

Hello All, I am using Access 2000. I am using the feature TransferSpreadsheet and if the path of the spreadsheet is present then the database works fine. If the spreadsheet path is not the same I get the VBA Run-time error as such: Run-time error '3011' the Microsoft Jet database engine...

Hello All, I am using Access 2002. I am in the beginning of a project and wanted to know how I can create what I called a "Cascading Combo-boxes". An example to this is of the following: 1. Product 2. Category 3. Type 4. Model The above is a list of Combo-boxes. What I mean is...

Hello All, I am currently using Access 2000. I have a mailing list database which I would like to add a simple audit trail to record when a user exports out the whole database into Excel. This is important to the Management to maintain security of the information of the clients in the...

Hello All, I am using Access 2000. I am working on a form where there is a bunch of combo-boxes. I am able to make one of the combo-box to drop down in the on enter event. Here is the code that I use to do this: Private Sub Combo72_Enter() Me.ActiveControl.Dropdown End Sub I know that I...

Hello All, I am currently using Microsoft Access 2000. I have a table named tblclient. In the table I have fields named: FirstName MiddleInitial LastName ETC.... I have a number of data sources that I would like to import into tblclient. The...

Hello All, I am currently working with Access 2000. I am trying to create a mailing label. The label is setup as: FirstName LastName, Title Organization Address City, State Zip The problem that I am having is the Organization character wraps down to the next line on the Address line. I...

Hello All, I am working on Access 2000. I have a table named tblclient. In this table I have a field named zip which is for zip code. I have originally defined the datatype for this field as text. I would now like to redefine the field as numeric and update the table accordingly. I have...

Hello All, I am using Access 2000. I am wondering how can I import data where the data is not formatted as comma delimited format. The data is space delimited as I understand it and each row contains data that I need to import into the database as comma delimited? Thanks for your...

Hello All, I am currently using Access 2000. I have a table called tblclient. In this table I have a field called zipcode and the data type was set as text. When I export out to Excel I get error at text instead of number. I have tried changing the field data type as number but it truncates the...

Hello All, I am currently using Access 2000. I have already created a "Query by Form" interface for the user to select from a series of unbound controls to build their query and output the report. I would like to save the user's selection and be able to recall the saved...

Hello All, I have a Asus P3V4X motherboard and I am currently using a Fujitsu 10gb 5400rpm hard drive. I would like to upgrade my hard drive to a Maxtor 7200rpm either 80gb or 120gb. Is this possible? If not what are my options? Thanks for your advice in advance.

Hello All, I am using Access 2000. I'm having a hard time to make the Query by Form to work, here is what has been done: Table = tblClient Query = qryLabel Form = frmReport Report = rptLabel As I understand it in the Query - criteria area for each field of the tblClient I insert for...

Hello All, I am using Access 2000. I would like to create something called "Query by Form" where I put a series of unbound controls such as combo boxes, listboxes, and text boxes then with a command button I can generate a label report. How can I make this happen? Thanks for...

Hello All, I am using Access 2000. I am wondering if it is possible to update data / import data into the database when the data is for both the one-side and the many-side of the database? If it is possible how can I do this? The tables are: tblClient - one side tblContactType...

Hello All, I am using Microsoft Access 2000. I am currently working on creating a Mailing List Database. My question is regarding Lookup Tables. Could someone explain alittle more about what it is and how it can be used. The current use that I have implemented is on comboboxes where the...

Hello All, I am using Access 2000 to create a mailing list database. I am wondering if the table fields and relationship is correct. Here are the fields for the table tblclient on the one side. Client_id FirstName LastName MiddleInitial Title ContactType Organization Alt1Address Alt2Address...

Hello All, I am using Microsoft Access 2000. I have created the report which is using the Avery Label using 5160. There are four rows for the label. The format is: Row 1: First Name Last Name, Title Row 2: Organization Row 3: AltAdddress1 Row 4: City, State Zip...

Hello All, I would like to know if there are any good/reliable backup utilities for Access 2000. The database is stored on the server and the user has shortcut to the front-end to run the database. I would like the utility to be able to backup and schedule backup. Thanks in advance for any...