Search results

Thanks for the code, still struggling. Here is my updated code. Private Sub btlPrint_Click() Dim var As Variant If Me.lstselection > -1 Then Me.Visible = False WaitOn "Creating Print Job(s) ..." For Each var In Me.lstselection.ItemsSelected Me.tbJobID =...

i have some code (Below) that is on my main form, so i can print out individual jobs. If i need to print out 10 jobs, i have to go into them all individually, and press the button. (I currently have to do this for 66 jobs outstanding) I would like to do this by being able to select from a list...

It did work that way until recently, (Task scheduler). I have a slave pc under my desk, but the slave fails quite regularly, loss of network, switched off etc. The solution was to pass over to our it team for them to carry out the imports etc. Which leads me to where I am today.. Sent from my...

I agree with what you are saying, but... We have automated tasks that run every night, these could be on any of plus 70 machines (this is outside my control) if these tasks looked at the front end of the database, they would fail because they would need to logon to the database. So the...

OK, my database is split into front and back end, In the back end overnight from various sources I import 10 tables that the front end needs to pull data from. The code i use to do this works like a dream with no issues.. Function GetLatestData() Dim Index As Recordset Dim i As Integer Dim...

Thanks mate this worked.. I always struggle with the apostrophe and the speech marks..

I need to add additional criteria to my Code below =Nz(DSum("Qty","tblunpickable_data", "Option='" & [tbOption] & "' "),"") the additional field i need to add is Status <> "PK" but when i have amended and i now get the #Name? error. =DSum("Qty","tblunpickable_data","option='" & [tbOption] &...

Unfortunately i wont be able to log onto the pc that is running 2016 until next week. I have had a look in the locals window on my pc (Access 2013) but to be honest i am not really sure what i am looking for here. I can see the olApp, ObjRems and ObjRem, but since i dont know what i am...

i have a user whose pc has been upgraded to access 2016 and they are the only person out of a group of 300 users who i beleive have now been upgrading and they have started experiencing this error. I have tracked the error down to some code that i have for snoozing reminders, when access is...

Currently it locks the comments field on the after update event. What I want to do Is give them some additional time before it locks, so they can check spelling etc, so they don't need to add a additional comments field. Sent from my SM-T715 using Tapatalk

I have a comments field that becomes disabled after a Afterupdate event. Sometimes users need to go back into the same comments field, so i would like to allow them 1 hour (or something similar) to go back into the same comments field and amend the detail. Code is similar to the below. I have...

Thanks for the above, I would of never been able to write that code without the sample you provided for me. Just trying to think where else i can use that now...

it certainly upsets them, it updates the comments into a different table, using the Update Code below. mysql = "UPDATE tblQCCharges SET Comments = '" & tbComments & "', Delivery_Reference = '" & tbReference & "' " & _ "WHERE tblQCCharges.Job_ID=" & Nz(Forms!frmmain.tbJobID, 0)...

I have apostrophies disabled on my form, but ihave a few instancies now where spell check is putting the apostrohy in the feild. I have used the following code to disable the apostrophy. Private Sub tbComments_KeyPress(KeyAscii As Integer) If KeyAscii = 39 Then...

Correct.. Sent from my SM-T715 using Tapatalk

This is the code in question. Private Sub btnQuit_Click() On Error GoTo Handler Dim LResponse As Integer AttemptSave If IsNull(tbJobID) Or tbJobID = "" Then DoCmd.Close acForm, "frmMain" ''' Exit Sub Else If (Nz(tbCatNo, "") = "") Then...

Today we have had over 100 people in and out of the database and only 2 have had error from my main page.. error code 2585. This action can't be carried out whilst processing a form or event. The error has been triggered by the quit button on my main page, somi can only assume that during the...

I frequently get a error logged when people try to exit a particular form, when the form events are still processing. What is the easiest way to stop this, Is it something simple like disable the exit button until form event has finished ?

Re did my import specification today and the new import works fine.. my problem now is the old data..how to convert this to the correct date format. I tried to export into .txt file but this did not look correct. I need to export the old data, then create a new import specification for this...

Re imported my data, setting the fields to Date & Time, and changing the format. This worked. Thanks...