Search results for query: *

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

Hi, I have code thats reading in from a file on my local drive. there are 1000 html pages there and what its doing is its reading them in one by one and then printing them out. I want to add the filepath to the end of each page that it prints so i know what file they are talking about. can...

Hi, I just deleted a record from my SQL table by accident and i was wondering if there is a way of undoing this?? Dee

Hi, Im looking for some kind of code that will read a table and write out records from the table for the last week... i have it working on a daily basis but i also want it to read all sets from sunday and every sunday start fresh. any ideas would be greatly appreciated. not even code just a step...

thanks golom, that worked perfectly!

hmm, that didnt work. let me show you my code dim CallLength As Date MsgBox CallLength, vnOKOnly <--- returned 00.33.30 CallLength = CInt(CallLength) MsgBox CallLength, vbOKOnly < --- returned 00.00.00