Recent content by deesheeha

Thanks :-D

Im having the weirdest problem!!!!!! I have some code that allows the user to choose a file to import and then it imports the file using TransferText.... but when my code reaches the TransferText line, it ends, it doesnt import the file and the file disappears off the hard drive!!! Anyone got...

Hiya! Im have a problem... I have a table called tbl_NoOfDuplicates and it holds a customer name, and a number showing the number of duplicates counted from a previous table... Customer NoOfDuplicates John Smith 10 Linda Kelly 3 What I want to do is add the customer name to another...

Hi, I wrote an Excel Macro in VBA which imports records into a SQL server database & an access database. The import went fine, however the users cannot edit or delete any of the rows imported because of a Write conflict error message. I have asked the users to restart their SQL server and the...

Grrrrr, no that didnt work either!!! Starting to pull my hair out... Any other ideas?? Thanks for all your help so far!!

Yeah, no luck!

Hello all! Hope you can help me out. I have the following line of code: DoCmd.Rename "rpt_RedLetter_Collection_IRL", acReport, "rpt_RedLetter_Collection_Active" Everytime the code hits this report i get the following error: Run-time error '29068' Microsoft Access cannot complete this...

Hello! Im currently coding a database and a form i have a textbox called AttachedFolder and a button called btnFolder... Basically, i know you can bring up the browse box using the DoCmd.RunCommand acCmdInsertHyperlink but that inserts a hyperlink.... Im looking to be able to attach a...

hahah, thats perfect!! thanks Dale!! And thanks again Skip! I hate being a newbie at a language i already know!!

It seems to be right. It spits an error but i can figure it out. Thanks for your help skip

Sorry Skip!! Im not being clear. I want it to be equal to the row number. so if its row 16 then the variable becomes equal to 16

hmmmm, basically ive put a button over the cell but as i feel there is nothing to really connect it to the cell its over. all i have done is a button over cell A1, A3, A5... All i want to do is when the button is clicked, a variable becomes equal to the row that its on Thanks again Skip Dee

Im so confused. I dont know what im doing to be honest. I thought because I could code Access VBA I'd be ok for Excel (obviously not :p) Thanks for the reply skip. Where do I put that line of code... is it in the macro for that button click?? is there any other code needed??

Hi, Im pretty new to Excel VBA but have a good knowledge of Access VBA. My problem is the following: On every second row i have added a button in the first cell of the row. When i click on it, i want it to equal the row that the button is on. How do i capture not the row of what cell is...

exactly what i needed! thanks a million