Search results

You can't differentiate the password without handling it in a custom manner (as in writing your own routine to do it). You'd use Workgroup security and then each user gets their own name and password, each with various rights (the admin has everything, store managers get certain things, etc.)...

Whew! English really is your second language! ;) Seriously, post what you have already and then tell us specifically what you need done. Yes, you want the selection in one combobox to affect the available selections in other comboboxes (easy enough), but there's no detail. Do a...

RG may be right on that. I didn't test it as a string is a string, but Access has its quirks. Test it both ways and let us know what happens. If RG is right, then you take the txtRecords from the form and do as he suggested: strSQL = "SELECT TOP " & txtRecords & " * FROM TableName"...

The code raskew pointed to was way overkill (as he mentioned). All you're trying to do is get record 1 to record X. The TOP command does just that. It will get record 1 to record X, and X is your variable. SELECT TOP 10 * FROM TableName -- Gets first 10 records SELECT TOP 14 * FROM...

Have them highlight the word, and then in double-click event (called DblClick in code), perform the copy to the clipboard (a SendKeys "^C" will do that) and then your code.

Form has a control called txtRecords. The user enters the number of records that they want into that textbox. You execute this: DoCmd.RunSQL "SELECT TOP " & txtRecords & " * FROM YourTableName"

There are not three fields. There are three values that are stored in one field. For example, you store the field "CustomerResponse" like this: No Opinion = 0 Not Satisfied = 1 Satisfied = 2 Then, you end up with one field that looks like this: CustomerResponse 1 2 2 0 1 2 0 That is...

In the AfterUpdate event of the combobox, put a Me.Refresh (where the Me keyword is the form). That will force it to display correctly. I'm not sure

I have no problem helping anyone. That's not the issue. The issue is that you provided no detail and showed no work on what you are trying to do. It was, "I want this, I want that, and I want the other thing. How do I do it?" It wasn't, "I have this done and I think it's right, but I'm...

All it is: SELECT TOP X * FROM TableName Replace X with the number of records you want.

No problem with a language barrier. I've helped lots of people that speak various languages (English, Spanish, French, etc.). The language barrier is this sense means that you don't understand the programming language more than anything else. Looking up "DLookup" in Access Help will show you...

So, someone clicks a button on the main form. This opens a new form where the user enters some value into a field. That value is used as a parameter in a pair of reports, and then you want to close that update form. Is there some reason we need a new form to open for the reports? Can the...

Did you Google "Installing Multiple Versions of Office"? You may have come up with this article. Fun little tidbits from that article: Your neighbor will probably want to buy Office Professional 2007 for his computer, or uninstall 2007 and use 2000. Note that Office 2007 is a huge leap...

How are they different values? What am I not getting? As best as I can tell from the description, you have a percentage, a number, and a number. 1) Satisfied, Not Satisfied, No Opinion -- a percentage of each out of the total. 2) Number of days 3) Difference between budget and actual dollars...

OK, I can't recreate this issue. Have you tried putting the code in another event? I seem to remember something about the Exit event not handling closes correctly, but I could be remembering entirely wrong. That seems to be the issue though.

OK. It's not done printing the reports when it tries to close itself. I'm guessing these might be fairly large reports, or they might just take a little time to do calculations, formatting, etc. Before the DoCmd.Close, have you tried putting a DoEvents? That should force it to complete...

The OpenForm will have to go before the close. It will never be run otherwise. What error, if any, is it giving you? To make sure I have the issue straight, you're opening a form of some sort, printing a pair of reports, and then trying to close the form. Correct? Also, have you put in a...

You answered your own question. You cannot edit or delete without exclusive access to the DB. What you can do is emulate the code the module is doing. What is it you're trying to put in the query?

Where did you put the close code?

You opened two reports and then didn't specify what you want to close. DoCmd.Close acReport, "ReportName" Also (and holy crap, it happened again), using acViewNormal on a report opens it, prints it, and then closes it. There's nothing to close. Use acViewPreview if you want to see the report...