Search results

What’s up with this exact post under a different name here? If Statement with multiple veribals https://r.tapatalk.com/shareLink?share_fid=51301&share_tid=306160&url=https%3A%2F%2Faccess-programmers%2Eco%2Euk%2Fforums%2Fshowthread%2Ephp%3Ft%3D306160&share_type=t Sent from my iPhone using...

Any luck? Sent from my iPhone using Tapatalk

Ok. So I have just tried this on my computer and it works, I had to make some changes to fldrPath: fldrPath = "C:\Users\" & strusername & "\Desktop\" 'folder path where pdf file will be saved * so your might need to be: fldrPath = "C:\documents and settings\" & strusername & "\Desktop\"...

I believe where you have a space in filePath it is creating the issue. Try to add quotation marks at front and end? Sent from my iPhone using Tapatalk

Before I learnt about debug.print I always used a msgbox so you could try that. Msgbox filePath Sent from my iPhone using Tapatalk

You should see something. Do you have the immediate window showing at the bottom? Sent from my iPhone using Tapatalk

After your line: filepath = fldrPath & “” & fileName etc... Try putting in: Debug.Print filepath Then when you run your code the value of filepath will be printed in the Immediate Window for you to check Sent from my iPhone using Tapatalk

Did you sort your issue? We use Xero for processing invoices from our Access Database. Your invoice numbers in Xero do not need to be sequential and you can set them to whatever you want, with whatever complexity you want. You definitely don’t need to find the next one in the list in Xero...

I don’t know whether this will help as I haven’t personally tried it myself, my “splash” form normally gets hidden on startup and runs all my timer code I.e. timing out etc but... See the below link about daisy/chaining forms...

Whoops sorry didn’t see control source.., Sent from my iPhone using Tapatalk

There are other special addons and tools that allow you to do things like this among other things. However the easiest way is to use Find & Replace. It should be under the Edit menu in the VBA editor. Or you can use Ctrl + F to access the Find pop up and then click the Replace tab. Set the...

Other people may have other ideas, but also try getting rid of the lines: On Error Resume Next On Error Goto 0 This might help identifying what lines are creating issues. Sent from my iPhone using Tapatalk

No problem. I’ve received so much assistance on this forum over the years so just happy I could help someone else out. Nick Sent from my iPhone using Tapatalk

Usually a form doesn’t display multiple records of the same type. If you want to display all the records (names) of a particular type it is best IMHO to use a listbox. Or use a subform. Nick Sent from my iPhone using Tapatalk

Hi Cedartree, Just wondering whether that resolved your issue? Sent from my iPhone using Tapatalk

Agree with Colin. Need an actual question. Sent from my iPhone using Tapatalk

That looks like a continuous form anyway.... Its doesn't look like a datasheet to me although I could be mistaken. Stacked headers and fields, with conditional formatting and images...seems like its a continuous form. I've recreated this and have the same issue. The reason is that even when...

Are you able to post the code you are using on the double click event? Everything including the Private Sub / End Sub pieces? Possibly even a screenshot showing the form/subform. Might just help me picture exactly what you’re trying to do and replicate it Sent from my iPhone using Tapatalk

You don't want to put the code on the subform event. You want to put this code on the field double click event on your actual subform. Which in your case would be your image field. See my IMG1.jpg file, showing in Design View. Then the IMG2.jpg file contains what the form looks like in Form...

Is the double click event on the subform? If so, it will only work on the selected record. I’m away from computer at the moment so can’t tell, but if there is a double click event on the actual field in the datasheet form then add the code to that event rather than the subform double click...