Search results

Erm... slightly embarrassed at having worked out what the solution was. The first entry in [BusinessKnownName] had an apostrophe in it (e.g. HG's) which was of course was causing problems in the way the data was returned. :o Delete the apostrophe out of the field and it worked. How do I allow...

HI I've found a couple of similar posts but no matter what I try I can't figure out what's going wrong with my code and it's doing my head in! :banghead: I have a form (frmInactiveBusiness) which lists old businesses. I want the user to be able to select the business and when clicking a...

OK, now I'm struggling I've created a SQLDate function as allen brown suggested but I can't call it without a datatype mismatch - I'm missing something basic, please help! prepdue = SQLDate([prepdue])

Thanks Brian I've read Allen Browns article but was hoping that there was something else that might have been causing the problem. Any thoughts as to why my current code works for one of my forms but not on this particular one?

Hi there I hope you can help me out, I've been going crazy trying to work out this problem. I'm using Access 2010 and have a SQL INSERT INTO statement to automatically create a new record in a table. I have another form where I have successfully forced the date to be inserted in the...

That was perfect THANK YOU! :D Unfortunately I am at the finishing touches and am trying to perform an excel function which seems to run fine but no results are being placed into the target cell. What am I missing THIS time? 'convert the spreadsheet data to a readable format...

BY JOVE I GOT IT! I used wr1.Activate sh1.Activate sh1.Range("a9").Select Range(Range("a9").End(xlDown), Range("a9").End(xlToRight)).Select to get it working :) messy but it works OK I'm ALMOST there Only problem is when I go to save the workbook it tells me the document with the name...

*bangs head on desk* missing that keyword of ADD just isn't forgivable Am I missing something equally as stupid for why I can't copy or paste any data? at the moment I'm getting a blank workbook saved

Thanks for that Roy, I appreciate it. I still seem to be missing something unfortunately. What is wrong with this code? I can't see that anything is being copied let alone pasted or saved in the new workbook Private Sub Test() Dim xl As Object, sh1 As Object, sh2 As Object, wr As...

At the moment I am not trying to populate the area, merely select the data from A9 down to the bottom of the populated area -1 row but unfortunately I can't get the active cell to move anywhere I have tried it without the variable name XLS without any success From what I have seen of other...

Hi There Unfortunately a link is not appropriate as I need to retrieve data from a pivot table within Excel - hence the copying the data and using paste special into a new file I have started hard coding the module I need but for some reason it won't work Private Sub matData()...

Hi there I am trying to create a module for a client and have run into a wall. They have an existing spreadsheet with data in the form of 12345 ABC Location | 203049 | Small I need to copy the three columns of data and perform a PASTE SPECIAL into a new workbook then save it as data.xls into...

That would have been the optimum outcome but sometimes something is better than nothing :o Thanks for that, a slightly neater outcome than the one i found :D

Thanks for all of your help, just thought I would let you know I worked it out :cool: Here's the code I used Sub paraText_Click() Dim pos As Integer pos = Len(Me.SectionText) SectionText.SetFocus SectionText.SelStart = pos SectionText.SelText =...

mmmmmmmm What about giving the textbox the focus, determining the number of characters currently in the text box and returning that value? All I would need to do then would be to add one or two to the current number of characters to make everything easy to read hmmmmmm

um... OK At the current cursor location I want the text of "<p></p>" to be inserted and then for the cursor to move to inbetween the two tags :o

Nevermind Stupid Object Names :eek: Now lets see how i go with the rest of it

Thanks for that but i'm getting an error of "Method or Data Member Not Found" and access is highlighting the .SelStart portion of text I'm using Access 2003 any thoughts???

String Length Thanks for the reply Sorry, I should have explained myself better, I am talking about the current cursor location. I tried the Len property but didn't really get very far I tried using Dim pos as integer pos = len(textboxname) but all i got was compile errors :(

Hi all I am desperately trying to work out the code I would use if I wanted to determine the length of the string currently in a text box I need a command button, when it is pressed, to insert some constant text at the current location. I assumed that this would be done by determining the...