Search results

Hello, I am having an issue with my vba while following Dev Ashish's site http://access.mvps.org/access/general/gen0018.htm My Dlookup works correctly, from what I have tested. The issue comes from when I run the update query after, it updates every record instead of the current record. Can...

Thank you!

Hello, I am having an issue with some vba for a change password screen. Below, my Employee ID is a text field and it keeps producing the following error: The expression you entered as a query parameter produced this error: 'Steve' The error pops a msgbox, and doesn't highlight any vba. I...

Thank you for the response.... The new table has DateQ has a date field, not text. The original issue I was having was a 3rd party machine was spiting out data to a usb via a csv/xls file. Of the 45 data fields (dates, times, weights, etc.), each was stored as a text field. So my prebuilt...

Thanks for the quick responses! I ended up putting it together this way to cycle through the hundreds of excel records. Combined: Format(CDate(Replace([DateQ],".","/")),"Short Date") Galaxiom - I tried using DateSerial but couldn't get it to work. I was following this logic...

I am importing an excel text field into a table. I am then appending the data to another table. I am having a hard time with the Cdate function Excel Date Field: YYYY.MM.DD HH:MM:SS Example Value: 2014.04.21 18:24:30 My Query Code: NewDate...

the purchase order can have 50 lines, but the previous person only wanted to display the first 10 and not print out pages 1-5, just page 1. is there an easy fix to this? if I were to modify the line If i >= 11 Then Exit Do to say If i >= 21 Then Exit Do it'll just kick errors saying...

Issue: the code below opens another form (not report) that displays details of a purchase order. The form was created to mirror a gov form that we use, and the 10 line items are hard coded. when the code is run, it will display the first 10 items. If the original form, where I am entering the...

I have having an issue with determining how to use a customized fiscal year with a DCount function. My Code: ThisYear: DCount("*","Open Issues","year([RequestDate]) = " & Year(DateAdd("y",-1,Date()))) The code only does from Jan 1, YYYY TO Dec 31, YYYY I'd like the code to read from Oct 1...

For anyone looking for something similar, I changed my thought process and removed the attachment field all together. I added a button the form that created a folder to set location that I could store my info and have the folder open when I send my email so I can attach whatever files I wish...

So I basically figured out what I needed. I am getting an error on the attachment part saying it cannot attach the folder to the email. Is there a way around this or a way to grab all the files in that folder and automatically attach them in the email generated? Private Sub...

Pr2...any suggestions?

Its the data type in the table, instead of using a text field, I'm using the attachment field type. This is only temporary (6 months) until the database is built in SharePoint.

From the attachment field labeled [my attachment].value That field can have multiple attachment. Wondering how I could attach all attachments associated to the record ID.

On the below I get a run-time error '-214735256 Cannot add the attachment; no data source was provided. How or where do I reference the underlined area to pull the attachment field's data? Private Sub Command6311_Click() Dim objOL As New Outlook.Application Dim objMail As MailItem...

Using outlook!

I have a small/simple database, using the attachment field to actually store attachments rather than hyperlinking to a shared location. I know I'll get some slack for that, but the database itself will remain rather small until we move the database to a sharepoint server. In the mean time, my...

Great responses, thank you all!

I got it to work by fixing the strPath below. Not sure if this is the best solution but it is working. Private Sub Command234_Click() Dim strFile As String 'Filename Dim strFileList() As String 'File Array Dim intFile As Integer 'File Number Dim strPath As String ' Path to file folder Dim f...

In theory it would be this, but I want the user to select the file and folder, not hard code it. strPath = "Z:\Data\Import\" strFile = Dir(strPath & "savfile*.XML")