Search results

Ok, so I need help figuring out a DateDiff/DateAdd solution. I have been searching the forum but havent come across exactly what I need. I have 3 main variables that I want to use in my calculation: 1)Today's date 2)ApprovalDate 3)ExpirationDate I know how to calculate 90 days prior to the...

Ok, I have searched the thread on how to print the contents of a listbox, but not found a viable solution. The solutions I found do something totally different than what i want. I am a newbie to access, but I know this can be done with a simple solution. I have a form that has a start and end...

Ok, I have another newbie checkbox ? I have a checkbox that once its clicked or unclicked, I want to do 2 things. For Table #1: I want to update the Yes/No Field and text to flash to a label (This part I know how to do) For Table #2: I want to insert the date EACH time the checkbox is...

Ok, lets see if I can explain my issue clearly. I need some guidance in the right direction. I'm a newbie to Access, using v2003. I have a table named ActionSteps with 2 fields: ActionID & ActionDescrip I have another table named ClientActions tied to the ActionSteps table. I want to create...

Ok, so I have a login form in which has username and password fields. I am wanting to collect the logintime and the logout time for each user. Initially before I added the password code field, it was tracking the login/logout just fine. However, now its not. I am not sure where I went wrong and...

I have a form that contains a subform. Basically it is setup as a Waiting List. So I have a list of id's on the subform with some other information. What I need to know is the following: 1) When I no longer want an id on the waiting list (but I dont want to delete it from the database), how do...

If I have a combo box that lists, servicetype - and i want the user to select the servicetype and then three blank text fields appear for data entry. I want to save all this info into 1 table. How do I do this? :confused: Ex: Servicetype = Service1 TxtboxA: _____ TxtboxB: _____ TxtboxC: _____...

Lets say I have an Excel file that has SSN, Name, and DOB. And I have 2 tables. Table A & Table B. How do I import the SSN into Table A and at the same time import SSN, Name, and DOB into Table B? Is this even possible? :confused: Thanks in advance :)

I have an excel spreadsheet and a text file that I want to import into a table. So, how do I count the number of records in the spreadsheet or text file and display that into the table as well? :confused: Thanks!

Ok, so I am a little up in the air about where to start. *I have a database with a list of assessments, attached to each patient. I have a form for each patient with a button on it. When the button is clicked, I want the user to be directed to an 'Assessment Status' form (that much I know how...

Hi All, I am new to the forum and new to Access as well. I have been lurking around and found this site to be a great assest so far so I decided to join. :D Ok, so I was hoping someone could help me out here. I have 2 issues: ***Forgot to add I am using Access 2003 if that makes a...