Search results

Okay that kinda worked, but now it's saying "You don't have the license required to use this ActiveX Control" :( EDIT: I figure it has something to do with the .lic file, so I tried copying it into the system directory and re-registering it, but still no luck

When I try to install it, it says "Not enough disk space on the destination drive for installation" when I have 202 gb free o_O EDIT: Suspecting the file system size, I installed it to my flash drive. I then copied the files over to the appropriate directory C:\OLYMPUS Copied the dll files...

I also would be interested in said ocx file (I've also looked everywhere and couldn't find the above-mentioned file). The rest of what I've found is shareware that wants to do everything for you and charge you an arm and a leg for it, when I (much like the OP I'd assume) just need the basics...

Just to update everyone, the code I used for the button (in case this can help someone else in the future), is as follows: CurrentDb.Execute "Delete * from List WHERE FIELDONE = " & Me.txtText1 & " AND FIELDTWO = " & Me.txtText2 & " " This takes the txtText1 and txtText2 boxes and goes...

This is a dumb question, I suppose, but when you say "numeric" do you mean numeric as the table datatype (single/double) or numeric as in just a number? And I see what you mean now, I'll test and post the revised code just in case someone else has a question about something similiar (I can see...

Do I need to apply that to the other fields I'm testing as well (txtSite, txtAmount), or is that just because it's at the end (and to avoid the double ")?

Sorry for the double post, but from what I took of it it's something like this: CurrentDb.Execute "Delete * From List WHERE SITE = " & Me.txtSite & " AND PAMOUNT = " & Me.txtAmount & " AND DESC = " & Me.txtDesc"" It searches the List table and deletes the entry that matches all of the...

What would be the best way, do you think? I assumed that was about the only way short of opening the actual table and manually removing the entry (which I read somewhere that directly opening a back end table was a bad idea). Thanks for the link though, I'll be looking into that as well.

Well, the idea is how to structure the SQL query in VBA code. I want to have text boxes for those respective fields, then have a button to click that will execute the query to match ALL of the fields and delete the applicable (will only occur once) record.

Haha... there are actually about 8 reasons that an operation would require a check number; it's a bit of a long story. Even so, it's not just for checks, it does a lot more involving charges, credits, etc for generating reports and interfacing with an old dBase III file. The code snippets are...

Oh that makes sense. Thank you very much, I'm a bit new at all of this :)

It's working as it is. Is it a bad thing to write it like I did? Will it hurt anything?

I'm looking to structure a query that would match ALL of the following critera: SITE PAMOUNT DateAdded Initial Then delete it; these are going to be text boxes on a form with a button to search in case of accidental/erraneous entry. I would use a unique ID to do it, but I've already...

Sorry for the double post, but I narrowed it down. I have an option for a custom reason, and if so I just wanted it to put that reason in the concatenated box. The code is as follows If Me.Explanation.Value = Null Then Me.Concatenated.Value = " " Else Me.Concatenated.Value =...

I've read similiar articles, and tried solutions on each, but for some reason none of it is working I have three boxes 1) Explanation 2) chknum (check number) 3) ditm (date item) It's usually either chknum or ditm, but it can be neither. I have an if statement changing the visibility of...

The following code worked perfectly for me: Private Sub Command0_Click() Dim myAppendQuery As String Dim myDeleteQuery As String myAppendQuery = "INSERT INTO CHARGES ( SITE, PDATE, PAMOUNT, [DESC], DESC1, ACHGROUP) " myAppendQuery = myAppendQuery & " SELECT List.SITE, List.PDATE, List.PAMOUNT...

Thanks! I'll be messing with this today, so I'll try to get somewhere with it and let everyone know how it goes. Thanks!

Ah that's what I've been hearing... do you know of anywhere that has some decent information that someone newer to coding VBA and SQL might be able to follow?

I've searched through a lot of places, but I can't seem to find the correct solution for my problem (probably because I'm almost a complete VBA newbie, and even then not so well-versed in Access). Anyways, I'm trying to make a button on a form in Access 2007 (which serves at the input form -...