Search results

is there a way to get access to automatically assign a folder or link a folder to an index field (primary key). The reason I am asking is because there is a form with hyperlinks these hyperlinks lead to a pdf document which I create manually and is incased in a folder. Each folder is named...

Hi everyone I have 3 tables (SQL table) one is the employees table and the other two are link tables for documents the tables have a one to many relationship. everything is running smoothly accept in my in my access form (which is the gui for my users) I can get the field names to look like a...

Hi everyone I have 3 tables (SQL table) one is the employees table and the other two are link tables for documents the tables have a one to many relationship. everything is running smoothly accept in my in my access form (which is the gui for my users) I can get the field names to look like a...

I have this in a query so it will calculate ("=DateSerial(Year([FIRSTRENEWALDATE])+2,Month([FIRSTRENEWALDATE]),Day([FIRSTRENEWALDATE]))" its there to calculate the dates for me so I know when to renew. The only problem is its an expression so if its null on the form I cant edit it, just shows...

Thank you Pat I really appreciate your help :)

Thank you the only thing is the renewal dates are suppose to be always at the end of the month and the year is should be 2yrs from the final date. it should look like this Final= 2/02/2000 Renewal = 02/28/2002 secondrenewal= 02/28/2004 etc... Thats what I am trying to have the database do...

Renewals I am aware that I should not have more than one date, repeating values rule I think (validates database rules) but please understand I am still learning about databases and I didnt really know how to create the query for the renewal dates. I did some reasearch and I ws thinking i...

I have a form that has a subform that has dates in each field each date is in correlation to the Final Date if the final date says 1/31/2000 then the renewal dates should say 1/31/2002 then the second one should say 1/31/2004. What this means is that an employee must renew every 2 years. what...

My users are wanting me to create a form that they can scan documents to and store in the database. I was wonder how I can scan them in pdf format and how to make the scanner scan the documents to the form. I dont have alot of experience with VB took some classes but I am by no means an expert...

Hello all I was wondering if it is possible to make Electronic receipts clients had to acknowledge fill out online and send back. See I have a user in my department who works with vendors. What he does is he mails out vendor licensing packages and renewal packages he sends them certified...

Sample Yes Dan if you could post a sample or email one to destevenson@viejas.com or desireemm@cox.net I would really appreciate it. Because as you know access will be able to hold just so much s example Dan. I need to do a simmilar thing except I have a number of word documents, photos and...

I am trying to get my scanner to automatically scan to my form in my database called documents, I was trying through a macro by run application, that gets me to the scanner but the scanner wont scan to the form when I hit the scan to button. HELP PLEASE????????/

I am trying to get my scanner to automatically scan to my form in my database called documents, I was trying through a macro by run application, that gets me to the scanner but the scanner wont scan to the form when I hit the scan to button. HELP PLEASE????????/ :confused:

Thank you Thank you so much for the info, those links help alot I'm just trying to find out how to create a query that returns values from what the user chooses. What exactly is that called can someone tell me please that would help alot. I find that in my search for answers in Access help...

I want to create my own filter, I was thinking I would create a query and then put the query in a form that users can type in the Id # or the lastname and the results would pop up in another form. But I'm not sure how to do it. Can you help me

Never MInd Never Mind I figured it out...WOOHOOO

Running total (HELP) I need to make a running total query for when people make payments I need to keep track of what kind of payment date of payment and how much along with the total amount due based on payments. I need to make a query that will give me a break down of payments and balances...

Helllo all I have a question on documents in databases. I have a database that I am going to show scanned legal documents on and I was wondering how might one link the scanner to the database? Then store the document in a document folder within the datase (linked to a record)? how would i create...

I have a form that alot of users use and some of them forget to use the search button I have provided for them, instead they type the number in the primary key field there by deleting the or overwritting the primary number (TM# as in Team Member number) how do I stop them from doing this?? Is...

well I finally figured out why my query with the two tables (active and inactive) were not working. so now I need to figure out how create a form with an unbound list box that says Active and Inactive, so when yoiu choose inactive or acitive you see alll the data from those tables which is now...