Search results

Would like help on creating an access database for my company which will record items delivered to our customers. I am attaching a report in pdf format that we want to print out. http://204.202.252.199/4/setup-report.pdf The MAKE Field(Product’s Company name) field will have items like...

Hi, Just wondering how can I make a form that shows only 5 months old records. I know it has to be through a query but don't know how to proceed. Thanks Rajput

Hi, I have this project where I need to scan the MRP zone on the passport to my form. Let me first explain what is MRP zone. MRP is know as Machine Readable Passport Zone which you usally find on the first page of US Passport right under the Photographs and it looks like this...

How to import data into the FORM from Machine Readabe Zone in the Passport Hi, I have this project where I need to scan the MRP zone on the passport to my form. Let me first explain what is MRP zone. MRP is know as Machine Readable Passport Zone which you usally find on the first page of US...

Sorry I am posting again since I am still stuck, but now I am posting it with an example. This might help what I want to accomplish. ALSO People have suggested me to make two tables and have one-to-many relationship, however the data is allready inputed, and it will be difficult to arrange all...

Hi, I would like to know how can i make machine readable text in access. Like the same text found on the US or Forigen Passports. Example:- P<COUNTRYLASTNAME<<FIRSTNAME<<<<<<<<<<<<<<<< PASSPORTNO<DATEOFBIRTH<<<<<<<<<<<<<<<<<<<<< I have the Fields but how should I make up the report so if...

Hello, How can I keep only 8 months old data and delete all old data automatically or thru a command button if it is not possible and compact it after it is done. And it should give a waring box saying that are your sure you want to delete records from and to dates. Thanks Rajput [This...

Hi, How do I embbed the Margins permentaly in the report so it will not change ever. Ravi

Hi, I have made a samll database using MSaccess 2000 that prints stickers. User enters info on a form and pushes the print button and preview report of that record is inisiated directly to the printer. Now I want to print a text when the "type" field Contains letter "T" and the date of...

Hi, I have two fields for dates one has a simple format that is "050401" ofcourse 05 is the date 04 is month and 01 is the year and it is a Text Data Type. Now I have a second field (Date Data Type) that also takes number just like this however when tab is pressed I have it changed to...

Hello, I have created a database that prints stickers. User enters in the information in the 12 fields in the form and they go to the last tab on that form that is the print button(linked to the preview report) and press enter and button sends the command to the printer and the printer prints...

Hi, here is what we are doing now I have 2 users who are inputing the data and 1 user updating the data that other two users entered. However, if the data has been entered before the update data user opens up his update form the data will be available for him to edit but if the input users...

Hi, is there a way we can disable the spacebar for one field. See we are scanning the tracking codes in that field but if by mistake a spacear is pressed and then the code is scanned. The person who is searching (via combo box) can not track it since there is one empty space from the start...

Hi, here is what I am doing now I have 2 users who are inputing the data and 1 user updating the data that other two have entered. Now every thing works fine, if the data has been entered before the update data user opens up the form. After the update user opens up the form the new data that is...

Hi, here is what I am doing now I have 2 users who are inputing the data and 1 user updating the data that other two have entered. Now every thing works fine, if the data has been entered before the update data user opens up the form. After the update user opens up the form the new data that is...

We enter partial records and then another person comes and Finds the record and enter rest of the information from the application form. For now we are just using the FIND button that is made by the command button, however it is working for now but it is kind of hard to move from the Find window...

We process Incoming/Outgoing Mail. On each incoming mail we have to put F150101 (the Break Down is like this F stands for Foreign Service, 15 is the date, 01 is the month, and the next 01 is the serial no. of course the next one is going to be F150102 and so on.) Now each day it changes like...

How can I dock the find window to the form, so one does not have to use the mouse to move from Find window to the form window. I am using Access 2000. Any help will be greatly apricated.

I have made a program for my office that process incoming/outgoing mail in ms access 2000. This is my first project, and I am very new at this. Now the data entry person have to enter city, state, zip code on each record. Is there any way person just enters zip code and city,state comes up...