Search results for query: *

Thanks DaZZleD! I managed to get something working not long after I posted the thread! Typical!!! :-S However, it doesn't appear to be reading the values of some of my strings properly! Dim dataArea As String Dim dataWell As String Dim dataTask As String Dim...

Hi, This is probably a really silyy question, but I just can't figure out why this isn't working! Maybe casting a fresh pair of eyes across it might help?! What I'm trying to do is take the data, entered into a form, for there and pass it into a table in my Access 2000 database. I thought...

Thanks for your reply DaZZleD. Unfortunately I get the same error message! Any more ideas? :-)

Hi, I'm hoping that somebody can help me!?!?! It's a bit strange really because I don't understand why I'm getting the following error: Name 'txtAttach' is not declared I've tried just having the FileBrowser in the 2nd declaration (line of coding), because it's actually in <input...

Hi mbcruella! Thank you for your help! I'm just wondering but I take it that the strDates only refers to 1 string (comboBox) rather than several? Another question is: how does the SQL know which field is meant to be compared to the strDates? The answers to these are probably easy and it's...

Hi, I'm sorry if people think that this is in the wrong forum but as it's got SQL in it and that's the main problem I'm hoping that somebody can help me? PLEASE!!! :-) Ok, a quick explanation of what I'm attempting. I've got an ASP.net web page with VB.net coding, but I want to generate a...

Hi jamato, I know it was almost a year ago since you posted this thread but I was wondering if you eventually managed to sort your problem, and if so how you managed it (if you can remember)? I'm wanting to creating the same sort of SQL statement, but to generate a report and your help would...

Yeah, I've restarted my computer several times, just incase! I also ran the Installation but I still get the error message saying that version 2.5 is installed. I take it I can get the Jet updates off the Microsoft site?! Thanks :0)

Hi, I'm hoping that somebody that's had this problem and solved it before can help me out? PLEASE!!! At the beginning of last week everything seemed to be working fine but by the end of the week...! When trying to open the connection to my Access database I get the following message: The...

Hi! I was wondering if anybody could help me out?! I've got the background of my web page set to an image, I also have a table on the page. Unfortunately the table creates a big white box when the page is viewed and instead of this I'd like to set the table to be transparent, or the...

Morning PHV, thank you for your reply! Unfortunately it does not! I've looked in the Properties window on the Excel spreadsheet, and also within the coding on the VBA side but nothing appears! Any one got any ideas? Thanks again Jane

Hi, I'm probably being really silly as it's Monday morning, but I'm having real problems binding an array to a comboBox in Excel 2000! I've declared the array as: Dim Div As Variant Dim i As Integer Div = Array("Value 1", "Value 2", etc) For i = LBound(arDivision) To UBound(arDivision)...

Hmm, thanks. I'll see what I can find out about that. It's not my spreadsheet, it belongs to another division within my company. The division manager just copied, pasted and changed the name yesterday and it worked fine for him. I'm beginning to think that it's my computer! Thanks Jane

Oh well! Thanks for your help. I'll get something sorted eventually. Thanks again Jane :-)

Hmm, coming up against a brick wall! I can't find any .xlb files, do you know of any other things that could be causing problems. I don't think that it's the toolbar, as it's just the defualt one. Also, it's not really possible to delete the files in the TEMP folder because I share this...

Thanks for your replies! Yeah it is Excel 2000. Err, I've tried setting security to LOW so that it opens the macros, it was previously set to HIGH, but Excel still freezes. As it won't open the file, how can I add the source to my trusted sources? Or is there another way to go about all of...

Hi, Would anybody know why, when I try to open an Excel spreadsheet that is 6.63MB in size Excel would freeze? The spreadsheet contains several macros, as well as several seperate sheets. Any ideas, and/or solutions would be greatly appreciated. Thanks in advanced Jane

Thanks for the advise, but this is for my own use, so it won't be public as I said. I'm in Scotland, so yeah I've got access Computer Weekley, must check that magazine out. The following is the majority of my coding for what I'm attempting to do. It's a cryptic crossword solver if anybody's...

Hi Jennifer, I've managed to solve the object reference problem, but now I'm getting nothing returned. It loads up the page but doesn't pull any solutions from the database, even though I know that there should be 2! Would you still like some of my coding? Jane

Thanks for your replies! The web page that this coding is on, is not for a public site, so the hacking bit really doesn't matter! I've tried pattern.text before but it didn't make any difference. Also, I executed my code in Access and it worked in there, but it won't on my .net page?! I'm...