Search results

I just noticed something. The Eula (attached) doesn't even say anything about restricting the software to non-business purposes. All it says is that "this is a Home-use Eula." So I guess I don't see where it restricts my usage. Apparently, as long as I only install the software at home, I'm...

It's true they don't much care about me personally, but I need to be above aboard here in case my employer asks me if I have violated the license. Microsoft Eulas indicate that student software is not for businesses. However, my situation isn't quite black and white - hence this thread.

Might I add that I am not in the IT dept. My job is only data-entry, not programming. I've never been hired as a programmer.

Suppose a student owns a student-version of Access. Excited about his latest class project, he decides to share his Access VBA code on the web. So he uploads an .mdb file or .accdb file to his website. As a result, numerous programmers download his project and use it in their business...

Thanks for the information. No, I haven't tested, as I am still in the early stages of developing a program to populate the database. I'm using it to index several thousands of textfiles for the sake of fast searching. But your post is very reassuring. The user will update the index weekly...

I have an Access 2003 db (.mdb file) that the users will connect to only on a read-only basis. I will compact it before installing it on their machines. If they only run Select queries on it, will the database expand?

Ok, I think I know what the problem was - there was a security banner which I didn't notice in my haste. When I clicked the banner and selected "enable this content" the query started working again.

Thanks for responding. BTW, a while back I created, in VB.Net, a little "SQL View" program for executing queries. When I run the query from my little window it executes fine. So yes, there are rows to be updated and they update fine using my own window. (Maybe I'll upload my little SQL view...

I'm fairly new to Access 2007. In SQL view when I hit F5 to run a query (as we did in Access 2003) it seems to ignore me. So on the menu I've been going to Design > Results > Run and clicking the red exclaimation point labled "Run". I had some luck doing this (as I recall) last week but...

If I write a query like this: UPDATE Customers SET FirstName = UCase(FirstName), LastName = UCase(LastName) and then save it in Access 2007, it prefixes the table name: UPDATE Customers SET Customers.FirstName = UCase(Customers.FirstName), Customers.LastName = UCase(Customers.LastName) I...

I can't import the "table" into Access because it isn't a table as yet (Access refuses to import it). The whole problem here is that I can't seem to create the table Customers manually. I even tried the Insert > Table thing (didn't work). Apparently the only way to create a "real" table in...

Excel 2007, .XLSX file. If I issue a Create Table sql command from VBA using an Excel connection string CREATE TABLE Customers I end up with a worksheet named "Customers" (instead of Sheet1). Perfect. However, the problem is that I now have a worksheet that I renamed manually (using my...

You want hot keys to trigger a report without setting up an event? I doubt there is a way to do so. Nor can I fathom the advantage of doing so. Then you said that the report prints instead of displaying? That's odd. Normally a report will display by default (DoCmd.OpenReport), and then extra...

I thought that was the code I gave you. In order to accomplish this, you will presumably need to detect those keys using keydown (or some other event) like I suggested. If you want to select a given item in the combobox, you can do it using the rownumber: For rowNo = 0 To lb.ListCount - 1...

Looking at my notes, I think you can detect the Shift key like this: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) If (Shift And acShiftMask) <> 0 Then MsgBox "Shift Key" End Sub You also need to know the keycodes for the F-keys (you can get this by testing). Hit the F2...

Actually I'm not sure what you mean by error. An error message? I proposed the Exit For to solve this problem: You confirmed that this problem is now resolved. You now mention another problem: If you are still asking me to get rid of extra strings at the end of the line, fine, but how will...

Solved - you have to put a limit on it TEXT (255)

I tried: ALTER TABLE groupids ADD COLUMN groupid TEXT But when I poll for the datatype I get "Memo". This datatype will cause me problems because Jet won't let me inner join on Memo fields. I need TEXT field. I tried "Alter Column GroupID Text" but it remains Memo (no error throws). I am...

My suggestion would be to add an Exit For. Just add that one line of code. In other words replace this: If IsSalutation Then rs("Salutation") = word Else: numCols = numCols + 1 rs("Other" & numCols) = word End If with this: If IsSalutation Then rs("Salutation") = word Exit For...

I think the revised version leaves Fullname intact - but be sure to fix that bug i mentioned.