Search results

RECV_TPT1 is set as a text field at the moment. The data in it is a date format of DD/MON/YY. plog - I am going to try that now and see what shows up, thank you. I am rusty at this and am trying to help out someone else with a database they inherited. update: they all seem to work on their...

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) & "/" &...

Well I haven't had any issues with it without using them. So thank you for making me wish I never bothered putting anything up on here.

It would only need the [] if there was a space or / or in the name. Also I made those a bit generic they aren't labeled the same in my actual form. BigHappyDaddy, you are right that was my issue. I was just getting back on to say I'm an idiot lol. I went through and fixed it so that the "End...

Yes I changed, Dim db As Database to Dim db As DAO.Database I am not sure how to add a break in the code. I forget how to force the debug to show something, when it doesn't automatically do it. It seems that the vba code no longer likes my IF code If Not IsNull(Me.dp1) Or Me.dp1 <> "" Then...

I added DAO. before the database and record set and changed everywhere I had sn to rst. I still get an error stating that After reading through those sites that was the only difference I could find in terms of what they are talking about. I am still relatively new to all of this, so I may be...

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...

I hadn't thought of that. I will check it out and get back you. Thanks :) ::edit:: I can't find a way to format that, to look like a professional document that can be filed. Right now it is being edited in word and sent out that way. I am creating a database to make this process more streamline.

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 would suggest attaching the file to the database. Then sending it as an attachment through the database. Unless there is a reason you need the files to be pulled from other locations.

Hey try: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.lblUPSINVNAFTASTMT.Visible = Nz(Me.FUELTYPE, "Diesel") End Sub It will still show up in report view, but it will not print it.

Thank you so much! I knew it had to be something little.

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 think it had to do with there not being an unique identifier in one of the views I was given to use. I am not sure for certain though. The guy made another view for me and it now seems to be working fine, I had him add in a few more fields including an identifier field.

Well thank you for your lovely help.

Because the complaint number is set up by using the Plant code, Complaint Code, by date (mmddyy), and the number of complaints that day. Instead of having to make the operator input this on their own I was asked to make it automatic for ease of use. I am just having an issue with the last digit...

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)...

Thank you guys. dylan - Not quiet, the only table that has more then one input sometimes is the Heights. vbaInet - I am exporting the data to a chart program that we have. It does not allow me to use more then one table/query/view etc at a time. I think my issue is with the measurements, so I...

I am not able to change any of the table designs, they are from a SQL database that I only have permission to link to and create queries from.

The joint fields are not labeled the same in the 3 tables, but they are the same value. SELECT Table1.longWheelNumber, Table1.HeatId, Table1.splitTime, Table1.Diff, Table1.name, Table1.maxSignalTreadGate2dB, Table2.LTemp, Table3.Height, Table3.Weight FROM (Table1 LEFT JOIN Table3 ON...