Search results

Hi I haven't tried your code but as an observation, why set objSht when it isn't being used? Nidge

Hi Bob referred to your naming and suggested using an Integer type. For naming, it's good to try and use a familiar type- V or Var = Variant S or Str = String I or Int = Integer D or Dbl = Double Sng = Single And so fourth. In our case, using the VarTime would would cause omeone to think its...

no problem :) N

Hi Moto you need tolook into InternetOpen functions for ftp. I think i have an ftp model from ages ago becuase at the time, i was looking to work with application updates. if i find it, i'll post it. AJTrumpet posted an ftp sample on here too ;) cheers Nidge

I have always preferred- With rs1 If Not .EOF Or .BOF Then .MoveFirst End If End With cheers Nidge

Hi, in your ribbon XML, you might need to add in Size="Small" to make the mso image smaller. Im not sure if this can be done by code though. let me know how you get on cheers Nidge

Hey Nick, no hard feelings :) I never accused you of making a living taking other peoples credit. It was just the way you had described your problem which was a bit misleading. Anyway, all clear now and it doesnt hurt to highlight the importance of origination and effort. There are a lot of...

Hi, couple of things / observations 1. The Calendar you have made is distictively familiar to this forum so i would say you didnt 'create' it as such. you probably aquired it and changed the colours. (I will find the calendar and link back) 2. If you are able to create VBA to arrange the...

Hi, i cant see why this is difficult to be honest. You shouldnt be using this resetable number as an ID anyway so, it should be a field entry. There have been some good suggestions here already but this could be reset simply by using a settings table. For example- i use a table for storing...

Hi Not sure how you would do this. In order for it to work, the attachments would all need have it's name in a field so it can be found and even then, how would you manage duplicate names? Cheers Nidge

That doesn't fix the problem though does it? Doesn't that just admit defeat and settle for a work around? :D Chars Nidge

Hi I would guess that its a parameter pop up box. There must be either some code trying to set a date on a query or it's purposely meant to show for you to enter the date. Either way, I'd bet that the data source for the form is a query or there is a query data collection somewhere Cheers Nidge

Hi, can you post or send me a sample? i can only think that is something simple as i have combos that work fine. I'll have a look and compare it with mine to see where the problems are. you can email me nigel at acccis dot co dot uk :) cheers

Hi, just a quickie. i need to add a slider control to a tab on a form. all of the other controls that i add internally to access fit on the tab just fine but when i add the slider control, it is positioned outside of the tab and i cannot get it to be embedded. how do you do this? cheers nigel

Hi, i need to display an image from a web cam / connected camera for a work project. I have made a facility to take a snap shot of the form so i just need to display the video stream on a form. Can this be donr in Access through VBA? chers Nidge

Hi Guys, anybody here good or dealt with ebay customization in the past? currently, my wife has an eBay shop. i delved in css and found that i can overwrite the eBay css with my own to change the look and feel of the shop front and pages. This changes the headerm width, gallery style, side...

well, what have you tried already that doesnt work? In order to insert something onto a 'designed' form, you would need a container. here is what i would probably do on the form, have an image control and call it imgPicture get some code to allow you to browse for an image. this would get...

Found this in my stash. Not sure if it is the one i referred to earlier but Hey Ho lol Cheers Nidge

Hi, here is where i found information about this previously- http://ezinearticles.com/?How-to-Build-in-a-Simple-Distance-Checker-Between-Two-UK-Postcodes-Into-Your-Access-Database-in-VBA&id=2408262 what you need on your form text boxes txtPostCodeStart txtPostCodeEnd ( these are...

Maybe this might help http://gpgonaccess.blogspot.co.uk/2010/03/work-in-progress-and-64-bit-vba.html?m=1 From a few of the AWF natives. Cheers Nidge