Search results

I say the hotel closes, forwards all earned profits to me, and then I'll distribute them equally among all the people that answer questions when they are asked. For example: I've been working on this hotel DB for a little bit and they all have budgets. Those budgets are distributed amongst...

Don't do that at the table level. If I get a few minutes, I'll show you how to do this through a form. The user should never be able to touch the tables. You've also not attached the UserID fields to each other, meaning the UserID in the table "UserName" and the UserID in the table "Website"...

1) This has nothing to do with a checkbox. 2) You'll need to post some more detail. What are the queries, what is the code? If you can, strip most of the data (and any sensitive data) out of the DB, zip it, and post it.

You're making no sense here. How are you differentiating? How you you saying "This user gets this default" and "This other user gets this other default"? I'm not following.

As directed, set a form to open when the database opens (the invisible form). Set the startup form in Tools -> Startup form/page. From there, experiment with the timer control. Set it to 10 seconds (10000, since the timer works in milliseconds). Every time it reaches that, display a...

Explain a little more. The way I'm reading it, if it's user type A, then they get default Domain A. If it's user type B, then they get Domain B. And so on. Am I right on that?

In the table design for Website, enter the default value of "www.yourdomain.com". Now each time a new userID is entered, the field WebsiteURL will automatically be populated with "www.yourdomain.com" (without the quotes).

The timer is definitely the way to go. We use that here across the country to throw people out of the DB. Yes, we warn them (60 minutes, 30 minutes, and it 5 minutes before shutdown). After that, it saves any open records and closes the DB. A better trick would be to keep the users out of...

You can actually simplify that a little bit by declaring the functions as Boolean in the first place, thereby avoiding the conversion to Boolean (CBool). Public Declare Function IsZoomed Lib "User32" (ByVal hWnd As Long) As Boolean Public Declare Function IsIconic Lib "User32" (ByVal hWnd As...

Compact/Repair. Tools -> Database Utilities -> Compact and Repair Database. This "cleans up" the data as it were. It removes old, deleted records, cleans out temporary objects and values it's written, etc. Note the size of your DB, the do a compact/repair, and then look at the size of your...

Set a breakpoint in the code (click in the left margin and it will highlight the row in a maroon color). In your case, set your breakpoint on the line that starts If DCount(.... Now, when the code reaches that line, it will pause and bring up the code window. Press F8 it the code will move...

Does closing each report after opening each report solve it, as in: DoCmd.OpenReport "rptAthensQuestionnaire", AcViewNormal, , _ "ParticipantID = Forms!frmPrintAllReports!txtSearch" DoCmd.Close acReport,"rptAthensQuestionnaire" DoCmd.OpenReport "rptEdinburghQuestionnaire", AcViewNormal, , _...

It's very difficult to reach the 2GB limit, especially if you're just importing text into a table. How many records is it? What else is in the DB? When was the last time you did a compact/repair? Anyway, if it really is that much data, you'll have to upscale to SQL Server, MySQL, or the more...

There's not an automatic way, but the manual way would be to move the DB to a different location (different directory) and then run the programs that you think may be trying to access the DB. If they bomb, then yes, they want the DB.

I think he means selected items in the list, which is the ItemSelected property. Use listcount -1 (because a listbox index starts at zero) and loop through the listbox, as in it ListIndex(X) = listbox.ItemSelected = True? Change the X to listcount (for/next loop) and you can figure out what is...

Actually, Craig, I think this one is more user error than anything else (no offense meant to the user). He just took something over he's not familiar with, and doesn't know what he's doing in some aspects. Yes, the security is tighter, but it's not something an experienced developer would have...

David is right in that you just seem confused, but there's no question asked. Multiple keys (called a composite key) are normal and can be rather useful. I wouldn't expect the relationships to come through completely intact because that's going to be the thing most unique between the...

Don't let Access determine the primary key. It's looking for unique values there. You can let Access create a primary key for you (it will be an autonumber).

Set a minimum card number and a maximum card number textbox that you enter into. Then, write a simple update query to check the "CheckedOut" field (or whatever you called it) for you. CurrentDb.Execute "UPDATE YourTableName SET CheckedOut = True WHERE Card_ID >= " & MinValueTextboxValue & "...

Did you follow Craig's suggestion and digitally sign the DB? It's telling you that it cannot determine the authenticity of the DB, and therefore, it cannot be as close to 100% positive as possible that it won't harm the computer.