Search results

Got it figured out... Ok, well, for the record, I got the answer. Around non-numeric variables, there must be single quotes. This can lead to some really crazy quote battles (sometimes requiring something like: "... WHERE table.date = '"&tempdate&"'" Here's a helpful tutorial to which I owe...

I'm trying to run a query with ASP.NET of my Access DB. So far all of my queries have worked fine - at least, until I tried using a date as one of my WHERE conditions. When I remove the date requirement in the code below, the query works fine. However, when I add the date back, it yields no...

While I'm pretty sure some Access veteran will yell at me for this, I was never trained in Access and thus came up with my own methods for things. For making new records based on text boxes, I created a set of "buffer" text boxes that were bound to the fields you were modifying. I then either...

I'm trying to make an Access DB accessible (no pun intended...) online for people to make quick changes to. The database is very small - it really just allows people to check out equipment at a school. The problem is that the online page needs to have a lot of error-checking to make sure the...

Suggested references? Ok, even if you don't have an answer, do you have any suggestions of where I might look? I've been trying to find some migration tools online, but at the moment I'm really running out of steam and am not sure where to look next. Or, if I'm just being dumb and need to...

Hidden data access online... Ok, I'm operating on a very basic level here (fair amount of programming experience with C++, but none in VB, SQL, or ASP, and have only seen one database before ever...oi...). However, I've been given the job of creating a database to reserve equipment. The catch...