Search results

Thank for all your comments ...alas, I corrected the issue earlier in the day yesterday, so it's gone (I can't examine whether it was a special character now) As I say, whatever she put at the end of the text, was not removed by a trim() when the data was appended from the table she entered the...

You are right...when I put a space at the end of the field, Access removed it...heaven knows how she managed it. In actual fact the table she added to is sort of a 'scratch' table, I then take data from that table to append to another table ....in the append query I had a trim() for that field...

This is a field with a lookup (user-selectable drop down list of product names)...or it can be entered manually ...I'm not sure how she managed it, but for sure there was a trailing space once she'd finished. Thanks but where does that go...in the validation rule?

Just has a situation today where my wife entered a product code into a field...but she had added a trailing space (which caused a few problems). How can I construct a field validation rule to disallow spaces? (either leading or trailing? Would it be something like this... Is Null OR Not Like...

Thanks Mark for excellent clear & useful explanation.

thanks for the code...no, I've not tried it yet (before deploying anything, I like to understand how it is used, the impact etc. - I;'m not really a programmer...more a kludger, so sometimes whats easy for most round these parts, takes me a little while!) But I'll certainly try to understand it...

To re-iterate ...I already have a NAS (installed with two HDs...mirroring one another), every few days (when I remember) I copy my Access database from my PC's hard drive over onto the NAS (I don't run my database on the NAS, because frankly it slows things up)...but the problematic bit from the...

Yes, I'd considered a shared drive ...but I'm still worried about "what if my PC's single drive fails & takes my access database with it" (hence considering moving the BE to a NAS) ....so, if I go with the (faster) 'shared drive' on the main PC approach, what's the best way to ensure that access...

I currently use a Access DB as a single user to help me run my small online home business. My wife helps me in the business now & then & carries out certain tasks using access ...this leads to contention for the seat at the PC where Access is running! I've read up a little & think the best way...

Many thanks!

What function/formula should I use to limit a number to TWO decimal places (I don't want to round), example 3.713 ...I only want 3.71 25.8576 ...I only want 25.85 thanks in advance

Many thanks for your input - very helpful.

That's very good of you....(having spent a reasonable while coding VBA in Access now, a lot of the syntax looks surprisingly foreign to me!) What changes would I need to pull the output of an Access query? (as ultimately that's what I'm exporting from Access)

Heres what I'm doing in Access (VBA)... DoCmd.RunSavedImportExport "Export-Paypal_Report" this exports to an excel file (with formatting) & also opens up excel straight away. I then want to be able to run some VBA on that Excel worksheet (that was opened via access) all this VBA does is...

So, I' pretty up to speed with Access VBA, but haven't really done a lot with Excel. What I'm trying to achieve is export a file from Access as an Excel file (this bit I know how to do), then be able to run an Excel Macro on that Excel file. Access only allows me to export as xls....but...

many thanks works a treat :-)

How do I set criteria of "show whole numbers only", so for example in this list 0.25 1 2.2 5 6.8 4 only the numbers 1 5 & 4 would be selected by the query? (with the rest being ignored) many thanks!

Indeed it was, the code below crops 200 pixels off the bottom of my gif... Public Sub CropPicture() Dim Img 'As ImageFile Dim IP 'As ImageProcess Set Img = CreateObject("WIA.ImageFile") Set IP = CreateObject("WIA.ImageProcess") Img.LoadFile "C:\AccessData\UPS\UPSShippingLabel.gif"...

That's the rotation sorted - thanks :-) But I've still not 100% put this to bed yet (already, I've spent about a day spent on this topic alone!) it transpires that - for some unexplained reason...the downloaded UPS gif resolution is 1400 x 800 ..bearing in mind the most thermal label...

Bingo :-) Found this... https://www.motobit.com/tips/detpg_base64/ got me a label now - chuffed to bits...thanks for your moral support & input! So I'm figuring the simplest way for me to get Access to print out a GIF file, would be to create a report with the GIF file embedded within...