Search results

I am working on a database that someone else created and the following expression is being used in a query: TPT1Date: IIf(Mid([RECV_TPT1],3,1)="-",DateValue([RECV_TPT1]),IIf([RECV_TPT1]="null",Null,IIf(Mid([RECV_TPT1],5,1)="-",DateValue(Mid([RECV_TPT1],6,2) & "/" & Mid([RECV_TPT1],9,2) & "/" &...

Hey, I recently switched over to using SQL for the backend of my Access databases. The codes I have use to work, all I have just modified them a little to be able to use the SSRS easier. However since I made the changes I keep getting an error message stating: My code is basically the following...

Hey I have been searching the forms and other places online for the past few weeks and I am still stumped. :confused: I am trying to find a way to: 1) Send an e-mail of the current record displayed on the form/report. 2) Have the recipient of the e-mail be able to edit/add to the document and...

I am trying to send a report in the body of an e-mail rather then by attachment. Reason being too many complaints about the attachments; extra steps to view, looking distorted when viewed on small screens, etc..) The following are two codes I have modified to use however I get errors on both of...

I am working on making a sequence code for complaints based on plant and date. However I run into an issue when there are more then one entered for a date from the same plant. If there has already been a complaint for that day I would like the end sequence to go in order (-1, -2 , -3... etc)...

I have 3 tables that are connected in a query by an ID number. Everything works well except that I get back 3 duplicate records instead of just one record. I attempted to try to fix this error by adding a group by first to one of the unique fields. However since I have a parameter up to prompt...

I am trying to figure out how to apply a filter using a button on a report so that when someone clicks the arrow it filters the query populating the report to the previous month or the next month of the current month on the report. I have it so that the report opens up to the current month. I...

I am not sure if this should be under this or under queries. :confused: However I am trying to make a report that shows the person name down the side and across the top has the dates of the month. Next to the persons name under the date it would have why they are off that day. I have attached...

I have a report (in access 2007) that has labels on the bottom where certain people need to sign once the report is printed out. I am trying to figure out how to make it so that only the labels that have been checked for that record show (since not everyone will need to sign all the time). Right...

I am trying to figure out why on one of my forms when saving if the user doesn't click off of the last textbox it won't save the value they entered. this is the first time I have encountered this problem. I have made many different forms and never had this issue before.

On my main form I have two subforms which are invisible to the operator but are used to pull up the last two records from different tables. The operator enters in the new record on the main form. I am trying to make it so that after they click save it updates to last two records again. However I...

I have report page that pretty much brings up a summary of multiple records. It would be nice to be able to push a button next to the summary and have it pull up the full report of the record it is next to. I have the full record page asking for id number right now, but I was wondering if there...

So I know the answer is probably very obvious I just haven't found it yet. I have a report shooting off of the main table and other reports off of queries. They hold the same information so that part isn't really important. However I would like for when one of the reports is opened to ask for a...

Hi, I cannot figure out what I did but I assume it has something to do with an "if" "then" "elseif" statement I have on another part of the form. I get the Run time error '3061' Too few parameters. Expected 1. Set sn = db.OpenRecordset("SELECT * FROM TableName ORDER BY ID DESC"...

Welcome to the Access World Forums! So I'm supposed to state a little about myself I guess. I've been working with Access (mostly 2007) since September of 2011. I live in the United States. I don't really have any notable hobbies.