Search results

Hi, Jason, welcome to the forum. To start with your last question: yes, this is possible in MS Access. First of all, I want to know what happens with the serial numbers once they are created. Will be there further processing in your system? And if so, how? Please explain the meaning of "user...

I would like to help but I still have some understanding problems: 1. How do you "upload" the UPS data into "tblNewTracking"? 2. How do you make the .csv file for KWM? 3. ".csv records from UPS overlap". Does this mean you get some records twice? According to the fields of "tblNewTracking" I...

Hi, access user, why do you want to save the "subtotal" value? I don't see the need. A "total" is, and should always be, the result of a calculation. Imagine, you have to change one of the usual values, let's say the quantity. Then - naturally - you have to recalculate the "subtotal", but not...

@ Alex: don't mention it. @ Jamie: I'm sure a lot of forum visitors will benefit from your code. Well explained! Only one thing: if you don't allow multiselect in your file dialog you don't need a "For Each...Next" loop. You can retrieve the user's selection by "f.SelectedItems(1)". Try to...

Sorry Alex for jumping in but... was it too late for you, too? You have certainly meant: Dim strFileName as String strFileName = FSO.GetFileName(Me.txtOriginalFile) Why is that? Because "FileName" is a VBA-reserved expression which confuses the interpreter, and... "GetFileName" is a method...

Glad to help. However, reviewing the code once more, I found some LOC missing regarding the reset of "mBlnNewRecord". Therefore I've attached the updated file. - Sorry for that. StarGrabber

The "trick" is to use a second recordset, which contains the attachments. With the built-in functionality you need 7 (in words: seven!) clicks to add a new attachment. With some code (see attached file) you need only 3. :)

You're welcome. Good luck with your project!

If you don't need a log file, try this: DBEngine.CompactDatabase PathAndNameOfSourceFile, PathAndNameOfDestinationFile, , , ";pwd=YourPassword"

I'm not experienced in charts. After playing around a bit I think you should replace the function by: Public Function AggregateQry() As String On Error GoTo ErrHandler If Len(mStrFunction) = 0 Then Exit Function End If AggregateQry = vbNullString Dim strQry As...

Sure! 1. Create a new module. 2. Declare a private variable for your combobox value in the module header. 3. Add a Public Sub to the module with the combobox value as parameter in order to fill the variable. 4. Put the code of post # 3 into a new function and adapt it as suitable. It...

You're absolutely right, pbaldy! Dim strFunction As String Select Case yourComboBox.Value Case "Count", "Sum" strFunction = yourComboBox.Value Case "Average" strFunction = "Avg" End Select Dim strQry As String strQry = "SELECT " & strFunction &...

Before uploading I've tested the procedure successfully with files of jpg format, so I cannot comprehend that "pictures are not moving into the image field." But if you say you are not able to use the moved 'long binary data', i.e. display the corresponding pictures in a control, then you are...

The function the way I put it returns one single value, every time from the first recordset field ( --> index 0). The recordset should be the recordsource of the form which contains the control referenced by the variable 'ctl'. As the record number is determined by 'intIndex', for this no loop...

Me.Filter = "StartTime=" & mdlUtilities.ISODate(Date) ;)

I beg your pardon, wrweaver, I forgot to remove the VBA reference to the Outlook Library which I set for testing purposes. Please replace 'olFolderCalendar' by '9'.

Sure! You are right, there should be a verification which prevents from adding duplicates. You'll find it in attached file. Please note at this point I had to make some major code modifications. In order to not to bloat the module of 'ScheduleF' to much, I moved some code into the class module...

You are welcome! Thanks for the feedback. There are some forum members who don't care to answer, regardless of whether the post was useful or not!

Hi Michael, I've tested the function and it works fine, however, with the lineSet rstAppVal = ctl.Parent.Recordset(ctl.ControlSource).Value replaced bySet rstAppVal = ctl.Parent.Recordset With the original line I get error 424, "Object required". Frankly, I've never seen code like this before...

Ok, this time there are some data, but the application is still incomplete. "ReviewWorkOrderF" is missing. Anyway - I tried to get things running. When I opened 'ScheduleF' I got a VBA syntax error at the last line of the procedure 'RequeryForm()' due to a different date format in my country...